Hi Chris, I've attached a couple of documents to the launchpad bug and to this email:
"usg2010 before save.xls" : original excel before being touched by openoffice "usg2010 after save.xls" : excel after being touched by openoffice "usg2010 after save screenshot.jpg" : screenshot displaying result after save "usg2010 before save screenshot formatting.jpg": shows original conditional formatting formula in ms excel before being touched by openoffice "usg2010 after save screenshot formatting.jpg" : shows changed conditional formatting formula in ms excel after document was saved in openoffice The issue is only visible when viewing in ms excel. Not in open office. Davy 2010/6/4 Chris Cheney <cche...@ubuntu.com> > Please attach an example document exhibiting this issue. > > ** Changed in: openoffice.org (Ubuntu) > Status: New => Incomplete > > -- > openoffice messes up excel 2003 conditional formatting > https://bugs.launchpad.net/bugs/587988 > You received this bug notification because you are a direct subscriber > of the bug. > > Status in “openoffice.org” package in Ubuntu: Incomplete > > Bug description: > Binary package hint: openoffice.org > > I've got an excel 2003 with conditional formatting applied to each cell. In > excel, conditional formatting was set on the entire row 4 and this was > copied to all other rows. Row references in the formule should reference the > applicable row. See attached excel. > > I can edit the excel file in openoffice. When I save it and re-open it in > openoffice, there is no issue. > > But when I re-open the file in excel 2003, the conditional formatting is > totally messed up. Openoffice changed the conditional formatting by adding a > reference to the sheet... which is not supported by excel. And the > conditional formatting of each row refers back to row 1 instead of the > current row. > > Example before openoffice save: > OR(WEEKDAY($A133)=7;WEEKDAY($A133)=1) > > After openoffice save and re-open in excel: > OR(WEEKDAY(timesheet!$A1)=7;WEEKDAY(timesheet!$A1)=1) > > ProblemType: Bug > DistroRelease: Ubuntu 10.04 > Package: openoffice.org-core 1:3.2.0-7ubuntu4 > ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2 > Uname: Linux 2.6.32-22-generic x86_64 > Architecture: amd64 > Date: Mon May 31 19:29:16 2010 > ExecutablePath: /usr/lib/openoffice/program/soffice.bin > InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release amd64 (20100429) > ProcEnviron: > PATH=(custom, no user) > LANG=en_US.UTF-8 > SHELL=/bin/bash > SourcePackage: openoffice.org > > To unsubscribe from this bug, go to: > > https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/587988/+subscribe > ** Attachment added: "usg2010 after save screenshot formatting.jpg" http://launchpadlibrarian.net/49648374/usg2010%20after%20save%20screenshot%20formatting.jpg ** Attachment added: "usg2010 after save screenshot.jpg" http://launchpadlibrarian.net/49648375/usg2010%20after%20save%20screenshot.jpg ** Attachment added: "usg2010 before save screenshot formatting.jpg" http://launchpadlibrarian.net/49648376/usg2010%20before%20save%20screenshot%20formatting.jpg ** Attachment added: "usg2010 after save.xls" http://launchpadlibrarian.net/49648377/usg2010%20after%20save.xls ** Attachment added: "usg2010 before save.xls" http://launchpadlibrarian.net/49648378/usg2010%20before%20save.xls -- openoffice messes up excel 2003 conditional formatting https://bugs.launchpad.net/bugs/587988 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
