First time here? Check out the FAQ!
asked 2012-08-01 00:47:12 +0200Tech.CG
Hi there, My business uses LibreOffice quite extensively, especially Calc. Recently we have started using conditional formatting to make using the sheets more friendly for our less computer-savvy users. However, when we apply the conditional format and SAVE the file, we can reopen the file right afterwards and the conditional formatting is gone. Has anyone else had this problem?
Thank you in advance!
Conditions "duplicated values" and "non duplicated values" created for validate existing data only. This works only in the current session and not saved in a file. If you need to store these conditional formats in your workbook, use classical equivalents:
"duplicated values" => COUNTIF (<absolute address of range checked>;<relative address of the current cell>) > 1 "non duplicated values" => COUNTIF (<absolute address of range checked>;<relative address of the current cell>) = 1
You can also use the function STYLE(), either alone or in combination with conditional formatting.
Small example - Show how many times duplicated.ods
Example of alternative solution - Combination of conditional format and STYLE.ods
answered 2012-11-23 01:12:06 +0200France
I have same problem with conditional formating. I use it to automatic color the weekends in a month. It's all working good until I copy the sheet and save the file. After I open the file again the sheet that is a copy, it doesn't have conditional formating anymore. Is there a bug? The copy sheet have all the conditional formating until I reopen the file.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-01 00:47:12 +0200
Seen: 803 times
Last updated: Dec 17 '12