[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 User dr changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from d...@openoffice.org Mon Dec 15 09:35:22 + 2008 --- closed - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 --- Additional comments from [EMAIL PROTECTED] Mon Nov 24 12:16:45 + 2008 --- no response... then the issue is going to be closed - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 --- Additional comments from [EMAIL PROTECTED] Tue Aug 5 09:57:23 + 2008 --- Excel 2007 rejects the document as invalid, therefore I cannot fix the import filter because I do not know how the charts should look like. Please try if your Excel can load your file. If yes, we can look for a solution, e.g. you could attach a screenshot of one of the charts. - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 --- Additional comments from [EMAIL PROTECTED] Mon Aug 4 08:05:49 + 2008 --- May I ask for the source of this attached document? Excel 2007 SP1 complains about unreadable contents and tries to repair it. All contained charts are removed. Also Calc finds invalid charts during import. Anyway, I can confirm that the import of references with quoted sheet names works now. - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 --- Additional comments from [EMAIL PROTECTED] Mon Aug 4 23:14:35 + 2008 --- Originally, I believe that the document was created with Excel 2007 and saved as an *.xlsx file. I'm not sure of the exact service pack when the document was created, however I always kept up to date with patches etc. when on windows. I made the transition to Ubuntu/Linux about 10 months ago, so whatever was the service pack (if there was a service pack 10 months ago) for Excel 2007, I would have had it applied. I have always noticed that when opening Excel 2007 *.xlsx files in OpenOffice calc versions 2.4 or 3.0 beta2, the majority of charts/graphs created in Excel fail to open in the spreadsheet supplied with this bug (92272). Until now, I have assumed that it was because those charts were based on referenced values that didn't import correctly (! instead of .) Consequently, I assumed when the import filters were fixed the charts should have been fixed. Is there a way the importing of charts can be fixed? Can you reopen this bug as a new bug? I.e. can the importing of charts from xlsx files be fixed? Cheers, Alexander - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 --- Additional comments from [EMAIL PROTECTED] Thu Jul 31 14:12:38 + 2008 --- comment: in Calc ! is used as intersection operator (different from Excel) eg. =SUM(C5:H19!F12:K26) equals =SUM(F12:H19) - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 --- Additional comments from [EMAIL PROTECTED] Thu Jul 31 14:38:11 + 2008 --- ja: Ah, another formula trick I wasn't aware of. Am I right in saying that Excel uses a whitespace for intersection? It seems to. But when importing an xlsx file, the formula is compiled into tokens using Excel's convention during import. So, I think somewhere there lies the problem. (I hope I didn't break it with my variable formula work...) - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 User kohei changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Thu Jul 31 19:15:16 + 2008 --- Actually this appears to be already fixed in m28. The offending formulas are properly imported with a '.' as the sheet separator. So I'm going to mark this as fixed. - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
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 +
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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 --- Additional comments from [EMAIL PROTECTED] Wed Jul 30 16:14:03 + 2008 --- Do you have a test document we can test? - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 User kohei changed the following: What|Old value |New value CC|''|'kohei' - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 --- Additional comments from [EMAIL PROTECTED] Thu Jul 31 01:21:36 + 2008 --- Created an attachment (id=55460) Excel 2007 Spreadsheet (.xlsx) - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 --- Additional comments from [EMAIL PROTECTED] Thu Jul 31 01:25:15 + 2008 --- Here is the spreadsheet in question; You'll see that by changing the ! symbols to . that the problem is resolved. Perhaps modification is needed for importing filters? 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 User kohei changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Thu Jul 31 02:15:25 + 2008 --- Yes, I can confirm this. Those '!' are supposed to be '.' when imported, but they aren't. - 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]
[sc-issues] [Issue 92272] Calc does not correctly im port referenced cells from Excel 2007 (xlsx)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92272 User kohei changed the following: What|Old value |New value Assigned to|spreadsheet |dr --- Additional comments from [EMAIL PROTECTED] Thu Jul 31 02:18:01 + 2008 --- Let me assign this to Daniel since this is his area. - 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]
