Bug 88528 - the 'conditional formatting' is changed by COPY/PASTE action
Summary: the 'conditional formatting' is changed by COPY/PASTE action
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.7.1 rc
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-17 10:10 UTC by baknox
Modified: 2015-01-17 20:48 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
sample 2 sheet workbook illustrating data & formats (27.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-17 10:10 UTC, baknox 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description baknox 2015-01-17 10:10:07 UTC 
Created attachment 112379 [details]
sample 2 sheet workbook illustrating data & formats

This bug is posted here as a new bug on request by moderator of bug 88042: same moderator requested a test on 4.3.5 but Ubuntu warns not to install anything above 4.2.7, so, sorry, not done - I am a low-level user. Bug is posted without testing on 4.3.5 on suggestion of Raal.

I run a little calender worksheet [attached]. 
I had set up an alert for jumbled or missing days by setting the Conditional Formatting for the Days Time column to 
“Formula is: IF(f2-f1<>1,1,0) – Apply style [Redfont]”. 
Since the 4.2.6 debacle if I cut [Ctrl+X] say rows 2&3 to paste them elsewhere & then delete [Ctrl+-] the  empty rows 2&3 the Conditional Formatting is scrambled to 
“Formula is: IF(f#REF!-f#REF!<>1,1,0) – Apply style [Redfont]”.
Comment 1 raal 2015-01-17 12:57:24 UTC 
I can not confirm with Version: 4.5.0.0.alpha0+
Build ID: a272f5b7b30f356418ecf28eb95d066f081d1624
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-09_09:50:59

I can not confirm with Version: 4.3.6.0.0+
Build ID: 1b9bcc2e7f31e880e71c8d2a2aaf1b2839d4d32a
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-12-14_15:56:02

This bug is fixed in newer version, setting as worksforme. If you'll have problem with newer version set bug again as Unconfirmed.

For installing LO 4.3.x you can use PPA https://launchpad.net/~libreoffice/+archive/ubuntu/ppa. Ubuntu 14.10 have actualy 4.3.3 version.
Comment 2 baknox 2015-01-17 20:48:30 UTC 
Thanks - I'll take 4.3.3 as soon as Ubuntu 10.04 make it available in Update Manager.
Glad the bug got sorted.