[sc-issues] [Issue 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from mechti...@openoffice.org Sat May 22 08:21:15 + 2010 --- invalid - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 --- Additional comments from jmich...@openoffice.org Tue May 18 08:09:53 + 2010 --- Created an attachment (id=69504) can-i-open-this-excel-in-ooo3.xml simple ms excel 2003 xml file - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 User jmichae3 changed the following: What|Old value |New value Summary|can't open Excel files in |can't open Excel 2003 xml |OOO, can't open OOO files |files in OOO, can't open O |in Excel |OO excel 2003 xml files in | | Excel --- Additional comments from jmich...@openoffice.org Tue May 18 08:07:42 + 2010 --- main issue: steps to reproduce: 1.create spreadsheet with calc with cell references. do sheet boundaries. 2.save as Excel 2003 xml format file. 3. close OOo so file is not locked. 4. optional: open xml file in programmer's editor, edit XML file and put in carriage returns so it's readable. compare OOo version with MS version and look at differences. xml files definitely ignore all whitespace (spaces, carriage returns, tabs) and should ignore standard XML !-- -- comments. close file. 5. open the document in MS Excel 2003. results: you get an excel error complaining about the cell references whern trying to open the OOo Excel 2003 format xml file with MS Excel 2003. expected: should open and parse the XML file and convert the formulas into OpenOffice.org compatible format (they ARE different, such as IF). for example, the argument separator is a semicolon instead of a comma: Excel: IF(condition,truevalue,falsevalue) OOo: IF(condition;truevalue;falsevalue) to be honest, I didn't discover the underlying problems I talked about in these posts until I dug deeper into the xml file itself and started reading the outputs of both programs. changed the bug title (added the word XML) to reflect the problem more exactly (more clarity). problem #1: excel only uses RC-relative cell references (at least in its 2003 xml format). OOo uses A1-type references. RC-relative references are a royal pain. but it's the only thing Excel 2003 will accept. given the log information from a recent very small 3-entry sheet (2 numbers and an AVERAGE() in OOo, an attempt to open in Excel reveals this log file: XML Spreadsheet Warning in Table REASON: Bad Value FILE: C:\Documents and Settings\Jim\My Documents\average-can-i-open-this-ooo3-in-excel.xml GROUP: Row TAG:Cell ATTRIB: Formula VALUE: of:=AVERAGE([.A1:.A2]) excel output: Cell ss:Formula==AVERAGE(R[-2]C:R[-1]C) OOo3.0 xml output: Cell ss:Formula=of:=AVERAGE([.A1:.A2]) the only way I could fix up the XML file so it would import into Excel 2003 was to put it in some sort of RC format, which I know nothing about. Cell ss:Formula==AVERAGE(R1C1:R2C1) which made the formula absolutely absolute, but at least it imported. problem #2: Issue 111666 3.2.0 (the new version) can't save budget.xls calc file as Excel 2003 xml, export is now broken (or trying my budget spreadsheet is a new problem I've discovered). complicated 1-sheet spreadsheets don't export either. simpler spreadsheets with only 4 entries do export. 32-bit 2GB limit problem I think. problem #3: OOo 3.2.0 currently inserts about 7-15+ cell Index datum per formula cell, if I am understanding what I am seeing correctly. Row ss:Height=12.8376Cell ss:Index=11//Row (the index number changes) in the file, which is not necessary. it is the equivalent of doing a double for loops across the rows and columns of (I can't tell what) and outputting the data for the entire matrix, filling in all the empty spaces of the sparse matrix, rather than walking the sparse matrix and outputting the list of items you find. this issue alone may be causing the gigantic file issue with my budget spreadsheet, which has about 20 tabs and not a lot of data on most tabs. I think it is this excessive cell style data is what is causing my larger 500-line spresdsheets to fail to save as XML files. http://en.wikipedia.org/wiki/Sparse_matrix This is generally how spreadsheets are represented in memory to save LOTS of memory. with that you can handle HUGE spreadsheets. Something is wrong with the OOo 2003 Excel XML file. I think you are using sparse matrices, but something is going wrong with the walk algorithm when it comes to handling those cell Index items. each of them has its own surrounding Row ... /Row elements. so as you can imagine, with 7-15 of these for every formula cell something is VERY wrong with the OOo algorithm for handling Index. The real Excel file is much more sparse. compare them. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments.
[sc-issues] [Issue 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 --- Additional comments from jmich...@openoffice.org Tue May 18 08:18:39 + 2010 --- Created an attachment (id=69505) budget.xml - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 --- Additional comments from jmich...@openoffice.org Tue May 18 08:21:16 + 2010 --- Created an attachment (id=69506) budget-ruined.ods ods file after importing MS Excel 2003 xml spreadsheet, sheet references with spaces mangled - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 --- Additional comments from jmich...@openoffice.org Tue May 18 09:42:44 + 2010 --- there is one more issue related to this bug that I just found with 3.2.0 with regards to importing MS Excel 2003 xml files: problem #4: excel uses ! instead of the OOo's . after the sheet name. this is wrong. problem #5. when importing Excel 2003 XML files, cross-sheet references are imported wrong as Err:509 when they contain a space. this is a special case that is being handled wrong where single quotes are used to handle the special case of having the space, for example, in Excel, the standard reference should be ='this sheet name has spaces'!A1 but in OOo this gets converted to ='this sheet name has spaces'A1, but in OOo a valid reference is =Restaurant.A1 or ='this sheet name has spaces'.A1 when you type in or click in an address. but in excel =Sheet1!A1 or Sheet1!R1C1 (latter is useful for XML files if you want absolute cell references) is a valid cell reference. until you get into xml files. then things get dicey. A1 type references are not valid in Excel 2003 XML files. only R C and RC references are valid in Excel 2003 XML files. and they are very messy unless you are doing absolute references. programmatically RC (for example, R1C1 or R208C31 is VERY convenient for doing file exports if you are doing absolute references - it's as easy as doing a printf with the row and column number. after entering a correct spreadsheet into OOo with simple cross-sheet references, OOo outputs as Excel 2003 XML the following incorrect format (herein called the cross-sheet references example): Row ss:Height=12.8376 Cell ss:StyleID=Normal ss:Formula=of:=['this sheet name has spaces'.A1]Data ss:Type=Number1/Data/Cell Cell ss:StyleID=Normal ss:Formula=of:=[Sheet1.A1]Data ss:Type=Number1/Data/Cell /Row Row ss:Height=12.8376Cell ss:Index=2 ss:StyleID=Normal//Row MS Excel outputs the following for the same spreadsheet: Row Cell ss:Formula=='this sheet name has spaces'!RCData ss:Type=Number1/Data/Cell Cell ss:Formula==Sheet1!RC[-1]Data ss:Type=Number1/Data/Cell /Row problem #6. excel usesthe formula format =formula while OOo uses of:=[formula] this is wrong. see example above. here is another example. Cell ss:Formula=of:=[Sheet1.C1]+12*[Sheet1.D2]Data ss:Type=Number26/Data/Cell and I take something back that I said in the last post. in a simple xml file where the data is clustered together, OOo generated more than 299 Index entries for a total of 4 formula entries across 3 sheets, all on rows 1 and maybe 2. this is REALLY out of control. I don't know what is causing this. please fix. thanks. - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 --- Additional comments from jmich...@openoffice.org Tue May 18 09:44:30 + 2010 --- Created an attachment (id=69508) ms-excel-2003-xml-cross-sheet-references.xml Excel 2003 xml cross sheet references example - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 --- Additional comments from jmich...@openoffice.org Tue May 18 09:45:49 + 2010 --- Created an attachment (id=69509) ooo-excel-2003-xml-cross-sheet-references-after-correction.xml OOo excel 2003 xml output file of cross sheet references example - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 --- Additional comments from jmich...@openoffice.org Tue May 18 10:00:40 + 2010 --- problem #7. OOo won't properly import its own outputted OOo excel 2003 xml file. it chokes on the of: that it incorrectly exports into the formulas. (and so it should). I discovered this after some experimentation with XML files. situation: user saves file in Excel 2003 xml format in OOo and only in that format, fully expects to keep his data. gets a surprise when his formulas are garbled. to reproduce, 1. open the Tue May 18 09:45:00 + 2010: ooo-excel-2003-xml-cross-sheet-references-after-correction.xml in OOo, this is a OOo file which was correctly formula'd in OOo. results: it neither properly opens MS Excel 2003 xml files, nor does it open OOo excel 2003 xml files. it's broken. formulas contain garbage with of: in them. expected: proper sheet reference formulas. I'm sorry I haven't been going the reproduce-results-expected format as much as I should have. I am getting back into the groove of things after not touching bugs for a few weeks. got sloppy. - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 --- Additional comments from jmich...@openoffice.org Tue May 18 10:05:23 + 2010 --- Created an attachment (id=69510) ooo-excel-2003-xml-cross-sheet-references-after-correction.ods OOo cross sheet references example in ods format - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 User rainerbielefeld changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from rainerbielef...@openoffice.org Wed May 19 05:10:11 + 2010 --- This issue collection never will be fixed, so I close it INVALID. @jmichae3 such a report is without any chance, because you do not accept the guidelines. The most important one is: only one problem per issue! No one (or at least: I) will read and sort all this prose to find out what the problems might be, what samples belong to what of the problems, and whether there might be a chance that that will be repaired. As you know from other issues, Office 2003 XML compatibility has low priority for OOo development. Some of the listed problems (for example those concerning spaces in sheet name) might be known and DUP of other issue. Please feel free to post new separate issues for all your observations, but please mention that you waste your and our time if you do not accept the guidelines and if you do not try to make your reports idiot proof; I have more than 1000 issues waiting for a confirmation, and so I will ignore issues with reports with insufficient bug description. - 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 95045] can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml fi les in Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045 --- Additional comments from jmich...@openoffice.org Wed May 19 05:19:45 + 2010 --- this is a lose-lose situation here. everybody loses - the customer loses because the product doesn't work. I lose because my bug gets dissed for providing details about the original issue, which, if I am not mistaken, is can't open Excel 2003 xml files in OOO, can't open OOO excel 2003 xml files in Excel. I get punished for providing details by breaking the original problem down into minutia. what kind of a deal is this? I am a programmer. most programmers want details as to what exactly is wrong. So I provided the details. I realize that was a big mistake. I am not sure I would want to deal with 20 bugs for one issue, but if that's the way you want it, so be it. please reopen the issue or tell me to create separate issues if you really feel that separate issues for such minutia warrants separate bugs. - 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
