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 Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1002097
Title:
Sheet() function does not work upon opening .xlsx file
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1002097/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
