Bug 85895 - FILESAVE, FILEOPEN, FORMATTING: Conditional formatting lost after copying sheet, then saving/reopening file
Summary: FILESAVE, FILEOPEN, FORMATTING: Conditional formatting lost after copying she...
Status: REOPENED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.2.6.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium critical
Assignee: Umar
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-05 07:21 UTC by smkbot
Modified: 2015-01-19 22:23 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:

Attachments
Small example spreadsheet that can be used to reproduce this bug. (17.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-11-05 07:21 UTC, smkbot 		Details
Mark list (95.26 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-01-19 22:23 UTC, Umar 		Details
View All

Description smkbot 2014-11-05 07:21:10 UTC 
Created attachment 108928 [details]
Small example spreadsheet that can be used to reproduce this bug.

I'm using LibreOffice version 4.2.6.3 on Linux Mint 17 "Qiana" MATE. I do not know if this bug reproduces in the current version of LibreOffice but it should not be difficult to check.

Steps to reproduce this bug:

1. Create a LibreOffice Calc sheet with conditional formatting.
2. Duplicate the sheet in the workbook, placing the copied sheet before the sheet to be copied.
3. Save the spreadsheet to a file.
4. Re-open the spreadsheet in LibreOffice Calc.
5. Observe the conditional formatting is lost for the duplicated sheet.

The attached spreadsheet is a simple example that can be used to reproduce the above bug, but any spreadsheet with conditional formatting should work (as far as I've observed).

Interestingly, conditional formatting does *not* seem to be lost if the destination for the copied sheet is placed after the source sheet (step 2 in the repro steps above).

I'm setting the severity to critical because this causes loss of data. Please adjust as necessary.
Comment 1 smkbot 2014-11-05 07:22:47 UTC 
Hm, the attachment says it's text/plain, but it's an OpenDocument spreadsheet. If you want to use it, save it as a file with an .ods extension before opening it.
Comment 2 Cor Nouws 2014-11-05 08:43:59 UTC 
Comment on attachment 108928 [details]
Small example spreadsheet that can be used to reproduce this bug.

corrected mime type
Comment 3 Cor Nouws 2014-11-05 08:48:48 UTC 
Hi smkkbot,
THanks for the report.
It works fine for me in 4.3.3.2 - the latest version.
Did not try in other versions, but this looks as fixed since the 4.2.6.3 that you used.
Could you check that please?
Best
Cor
Comment 4 smkbot 2014-11-05 21:17:33 UTC 
I just tried with version 4.3.3.2 (Build ID: 430m0(Build:2)) and I cannot reproduce the bug, so it seems fixed in the latest version.
Comment 5 Cor Nouws 2014-11-05 21:35:33 UTC 
Thanks for checking indeed.
Usually we then set 'WorksForMe' (and fixed when we know the specific commit, or mark as Duplicate when we know which issue.. But that's not necessary and consumes time ;) )
Comment 6 Umar 2015-01-19 22:23:58 UTC 
Created attachment 112502 [details]
Mark list

Conditional foramtting is changed after reopening the file.
In TAR sheet, i used condional formatting for AH4:AH7. It works. But when i reopen the same file after saving, it changes to some other condition that i used for some other cells.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.