Public bug reported:
It has come to my attention that .xlsx format does not support the
=sheet() function. I did not find out until after migrating a large
number of formulas to use this function and after closing and re-opening
the file. When I reopened the file I just have a bunch of #NAME? errors
and it took me some time to figure out that this is because of the file
format.
Some sort of notification upon saving would be pretty sweet to say that the
SHEET() function doesn't work in the format you're trying to save to.
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: libreoffice-calc 1:3.5.3-0ubuntu1
ProcVersionSignature: Ubuntu 3.2.0-24.38-generic 3.2.16
Uname: Linux 3.2.0-24-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu7
Architecture: amd64
Date: Sun May 20 20:14:18 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64 (20111012)
SourcePackage: libreoffice
UpgradeStatus: Upgraded to precise on 2012-05-03 (17 days ago)
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug precise
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1002097
Title:
Sheet() function does not work upon opening .xlsx file
Status in “libreoffice” package in Ubuntu:
New
Bug description:
It has come to my attention that .xlsx format does not support the
=sheet() function. I did not find out until after migrating a large
number of formulas to use this function and after closing and re-
opening the file. When I reopened the file I just have a bunch of
#NAME? errors and it took me some time to figure out that this is
because of the file format.
Some sort of notification upon saving would be pretty sweet to say that the
SHEET() function doesn't work in the format you're trying to save to.
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: libreoffice-calc 1:3.5.3-0ubuntu1
ProcVersionSignature: Ubuntu 3.2.0-24.38-generic 3.2.16
Uname: Linux 3.2.0-24-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu7
Architecture: amd64
Date: Sun May 20 20:14:18 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64 (20111012)
SourcePackage: libreoffice
UpgradeStatus: Upgraded to precise on 2012-05-03 (17 days ago)
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1002097/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
