[Bug 255734] Re: OO calc adds spurious columns to Office 2003 XML files
** Changed in: openoffice.org (Ubuntu) Status: Incomplete => Invalid -- OO calc adds spurious columns to Office 2003 XML files https://bugs.launchpad.net/bugs/255734 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 255734] Re: OO calc adds spurious columns to Office 2003 XML files
** Tags added: ooo-calc -- OO calc adds spurious columns to Office 2003 XML files https://bugs.launchpad.net/bugs/255734 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 255734] Re: OO calc adds spurious columns to Office 2003 XML files
Enabling "tab" as the delimiter has nothing to do with the problem. The file isn't CSV or tab-separated-variable; it's XML conforming to the "SpreadsheetML" schema. When I rename it to ".xml" and open it with OpenOffice, I don't see any option in the interface to enable or disable "tab" as a delimiter. One difference I notice between the BIRT-produced file and a file re- saved from Excel is that BIRT puts whitespace between the and tags. OOo produces a file without any whitespace at all. However, whitespace there shouldn't matter; Excel doesn't care about it. ** Changed in: openoffice.org (Ubuntu) Status: Invalid => Incomplete -- OO calc adds spurious columns to Office 2003 XML files https://bugs.launchpad.net/bugs/255734 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 255734] Re: OO calc adds spurious columns to Office 2003 XML files
As from your report, the Office 2003 file is created by BIRT's "save as XLS" feature. So, it can't be a bug on OpenOffice as the way in which BIRT created the XLS file might be the reason for the problem. Closing this as invalid, as there is a way to open the file as you expect it to be (similar to second file attached) by disabling the "tab" as the delimiter when opening the file in OpenOffice. Feel free to reopen the bug if you can confirm otherwise. ** Changed in: openoffice.org (Ubuntu) Status: New => Invalid -- OO calc adds spurious columns to Office 2003 XML files https://bugs.launchpad.net/bugs/255734 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 255734] Re: OO calc adds spurious columns to Office 2003 XML files
As far as I checked with both the files, the placement of lines in different columns happens with the Office 2003 file only when the file is opened in Open Office as tab separated. If the same file is opened without being considered as tab separated (neither by any other delimiter), it shows up similar to how your second file edited with Excel shows up. I suspect a change in how your file is delimited between the two files and I very much doubt whether this can be considered a bug as it might be a cause of file format change between the two. -- OO calc adds spurious columns to Office 2003 XML files https://bugs.launchpad.net/bugs/255734 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 255734] Re: OO calc adds spurious columns to Office 2003 XML files
** Attachment added: "demo1.xls" http://launchpadlibrarian.net/16616317/demo1.xls -- OO calc adds spurious columns to Office 2003 XML files https://bugs.launchpad.net/bugs/255734 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 255734] Re: OO calc adds spurious columns to Office 2003 XML files
** Attachment added: "Same file, trivially edited and saved with Excel" http://launchpadlibrarian.net/16616330/demo1_fixed.xls -- OO calc adds spurious columns to Office 2003 XML files https://bugs.launchpad.net/bugs/255734 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs