Public bug reported:
If a cell has a conditional format string (e.g. "negative numbers red" is
ticked, which corresponds to format string "0;[RED]-0"), this format is applied
upon calculation of a cell.
However, the resulting format is not saved with the document:
WHAT HAPPENS:
- If I close and reopen the document, calculated cells appear unformatted.
- If I force recalculation (by changing a referenced value), format is applied.
- If I select "Always recalculate on load" for ODF files in the preferences,
cells appear correctly formatted on reload.
WHAT I EXPECT:
The calculated format gets saved with the document, so that calculated cells
keep their formatting during close/open of the document.
I attach an example calc file containing two columns of numbers. They
all have conditional formatting (red or red/green). Columns A and D
contain fixed numbers. Columns B and E contain calculated numbers. Note
how the red/green formatting of the calculated numbers is lost during
close/reopen of the document. It is restored only upon recalculation.
ProblemType: Bug
DistroRelease: Ubuntu 13.04
Package: libreoffice-calc 1:4.0.2-0ubuntu1
ProcVersionSignature: Ubuntu 3.8.0-27.40-generic 3.8.13.4
Uname: Linux 3.8.0-27-generic x86_64
ApportVersion: 2.9.2-0ubuntu8.1
Architecture: amd64
Date: Thu Aug 1 15:11:02 2013
InstallationDate: Installed on 2013-04-12 (110 days ago)
InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5)
MarkForUpload: True
SourcePackage: libreoffice
UpgradeStatus: Upgraded to raring on 2013-04-25 (97 days ago)
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug raring
** Attachment added: "Calc file deomstrating loss of calculated formats"
https://bugs.launchpad.net/bugs/1207357/+attachment/3757045/+files/conditional-format-of-calculated-cells-is-lost.ods
--
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/1207357
Title:
Conditional format of calculated cells is lost on reload
Status in “libreoffice” package in Ubuntu:
New
Bug description:
If a cell has a conditional format string (e.g. "negative numbers red" is
ticked, which corresponds to format string "0;[RED]-0"), this format is applied
upon calculation of a cell.
However, the resulting format is not saved with the document:
WHAT HAPPENS:
- If I close and reopen the document, calculated cells appear unformatted.
- If I force recalculation (by changing a referenced value), format is
applied.
- If I select "Always recalculate on load" for ODF files in the preferences,
cells appear correctly formatted on reload.
WHAT I EXPECT:
The calculated format gets saved with the document, so that calculated cells
keep their formatting during close/open of the document.
I attach an example calc file containing two columns of numbers. They
all have conditional formatting (red or red/green). Columns A and D
contain fixed numbers. Columns B and E contain calculated numbers.
Note how the red/green formatting of the calculated numbers is lost
during close/reopen of the document. It is restored only upon
recalculation.
ProblemType: Bug
DistroRelease: Ubuntu 13.04
Package: libreoffice-calc 1:4.0.2-0ubuntu1
ProcVersionSignature: Ubuntu 3.8.0-27.40-generic 3.8.13.4
Uname: Linux 3.8.0-27-generic x86_64
ApportVersion: 2.9.2-0ubuntu8.1
Architecture: amd64
Date: Thu Aug 1 15:11:02 2013
InstallationDate: Installed on 2013-04-12 (110 days ago)
InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5)
MarkForUpload: True
SourcePackage: libreoffice
UpgradeStatus: Upgraded to raring on 2013-04-25 (97 days ago)
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1207357/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
