Public bug reported:

Binary package hint: openoffice.org

OOo refers to a cell on a sheet as sheet1.$A$1 fo example, whereas Excel
does it this way: sheet1!$A$1.

When saving a sheet in OOo in xls format, the conversion is not done and
all cells with the OOo reference are reported as errors in Excel.  The
inverse is true as well.  When Excel sheets are opened in OOo the
sheet1!$A$1 reference is not converted to the . notation.

ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 9.04
NonfreeKernelModules: ath_hal
Package: openoffice.org-core 1:3.0.1-9ubuntu3
ProcEnviron:
 PATH=(custom, no user)
 LANG=en_ZA.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-14-generic i686

** Affects: openoffice.org (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug i386

-- 
OpenOffice.org 3 does not save sheet reference correctly for Excel format
https://bugs.launchpad.net/bugs/402752
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

Reply via email to