Using libreoffice-calc 1:4.3.2-1~bpo70+1 amd64 on Debian 7.7 as updated
(wheezy).
See the attached test case. If you open this as is, you will see
conditional formatting in portions of rows 4 and 6. It should be in all
used rows and columns except rows 1, 2, and 3.
The following should give you an idea where the problem is:
Select a cell where the conditional formatting shows up, e.g. A4.
Examine the conditions (Format-> Conditional Formatting->
Condition... It should show "Formula is $K4=0; Apply Style
ConditionalStyle_1".
Select a cell where the conditional formatting should be and
isn't, e.g. A5. It shows "Cell value is equal to ; apply Style
ConditionalStyle_1".
To duplicate the problem: apply only the conditional style to the
other cells that should have it.
* Select A4. Capture its contents with CTL-C.
* Select a range of cells, and hit CTL-SHIFT-V. Select Formats,
deselect everything else. Hit OK. The conditional formatting should
show up.
* Save, then exit Libreoffice.
* Re-open Libreoffice, select the test file and open it. The
conditional formatting will be absent from the cells to which you
applied it.
Regression information: Running the above experiments on
libreoffice-calc 1:4.1.4-2~bpo70+1 i386, also on Debian 7.7 as updated
(wheezy), I was unable to reproduce the error. Whether this is due to
the older version or the different processor I cannot say.
Version 4.2.6.2 on Windows 7 SP 1, 64 bit, preserved the conditional
formatting.
--
The right of the people to be secure in their persons, houses, papers,
and effects, against unreasonable searches and seizures, shall not be
violated, and no Warrants shall issue, but upon probable cause,
supported by Oath or affirmation, and particularly describing the
place to be searched, and the persons or things to be seized.
-- U.S. Const. Amendment IV
Key fingerprint = CE5C 6645 A45A 64E4 94C0 809C FFF6 4C48 4ECD DFDB
Attachment:
63rd.legislature.ods
Description: application/vnd.oasis.opendocument.spreadsheet