Red Hat Bugzilla – Bug 132074
calc now improperly imports xls spreadsheets
Last modified: 2007-11-30 17:07:04 EST
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.3)
Description of problem:
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. start oo calc
2. open xls spreadsheet
3. see that number formats/values and graphs clobbered (10^-29)
Actual Results: Numbers reported as '0' and '' instead of actual values.
Graph line no longer displayed
Expected Results: Numbers displayed correctly and calculations based
on these numbers performed correctly.
Graphs imported correctly
Previous version on U2: openoffice.org-1.1.0-16.7.EL.i386 did work
correctly!! See attached spreadsheets completed on Aug 30/31 just
before upgrade to .13. The .sxc version was a correct import of the
.xls spreadsheet! Now, the new version doesn't read it correctly.
Created attachment 103589 [details]
original xls spreadsheet
Created attachment 103590 [details]
correctly imported spreadsheet in oo 16.7
I can verify this bug. All numbers and dates are imported incorrectly
from Excel in version 16.13.
Workaround: downgrade back to v16.7.
Can you try v16.14.EL when it comes out Real Soon Now?
Fixed in openoffice.org-1.1.0-16.14.EL, now available through RHN.