To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92272
Issue #|92272
Summary|Calc does not correctly import referenced cells from E
|xcel 2007 (xlsx)
Component|Spreadsheet
Version|OOo 3.0 Beta 2
Platform|Opteron/x86_64
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|open-import
Assigned to|spreadsheet
Reported by|bigbreath
------- Additional comments from [EMAIL PROTECTED] Wed Jul 30 08:19:42 +0000
2008 -------
When opening an .xlsx file created with Excel 2007, Calc (beta 2) does not
correctly display referenced cell values.
If the referenced cell calls upon another worksheet, the formula used in Excel
fails in Calc.
For example, on one worksheet I use the formula ='Skin Pain'!H65/AVERAGE('Skin
Pain'!$H$4:$H$23)*100 in this case the formula refers to another worksheet
called "Skin Pain". The cell then displays: "Err:509".
I have worked out that simply by changing the "!" characters to "." the formula
now works correctly and displays the correct value.
Is there a way to fix the importing filters so that xlsx files correctly display
automatically?
Cheers!
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
