Ask Your Question

conditional format disappear [closed]

asked 2013-01-16 23:17:13 +0200

gurxs gravatar image

updated 2020-08-07 23:08:31 +0200

Alex Kemp gravatar image

hi all, i'm new to this forum.

i'm using LibreOfficePortable program.

i'm creating a calc document and i'm using a macro.

On a sheet i've set a conditional format. 5 conditional formats on each cell.

It's all ok until i save and load the sheet.

But when a macro do a change, they disappear.

The macro start from another sheet.

The macro don't change all the cells, but only someone of them. Result, the conditional format disappear from all of them.

can someone help me ? thanks a lot.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-30 17:35:53.178737


Can you post your operating system and your LibreOffice version? Do you save in the native file type .ods?, Can you also post the part of the macro changing the cells?. This can do easier get help.

m.a.riosv gravatar imagem.a.riosv ( 2013-01-17 00:19:54 +0200 )edit

My operating system is WINDOWS XP HOME EDITION SP3. LibreOffice (Portable) Version Yes is in the native file type. every sheet use the same macro put on sheet events SheetContentChange.

gurxs gravatar imagegurxs ( 2013-01-19 17:53:35 +0200 )edit

This is an example of instruction that i use in the macro wSheet.getCellByPosition(wSheet.getCellRangeByName("ActivitiesID").getRangeAddress().StartColumn, row).Value = oCallingCell.Value

gurxs gravatar imagegurxs ( 2013-01-19 18:09:00 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-04-17 03:09:17 +0200

Mark12547 gravatar image

Conditional formatting in the Calc application of LibreOffice 4.0.2 on Windows 7 64bit that I copy from one sheet to another sheet also disappears on save when I reload the spreadsheet.

Likewise, when I copy a sheet with the conditional formatting, after a save and reload, the conditional formatting is not there, but the formulas and values are.

I have tried using the format painter, but that won't copy conditional formatting across sheets (it did in 3). I have tried Copy, then Paste Special with only Formatting selected, and the formatting is copied, as verified by looking in Format | Conditional Formatting | Manage... But on a save, close, reopen, that conditional formatting is gone.

However, if I make the formatting from scratch on the page for a cell, and then use the format brush to fill a partial column, and then save, when I reload the sheet the formatting sticks.

Fortunately, the conditional formatting isn't too complicated to recreate, but it sure is a nuisance when you think you got the conditional formatting correct and the next day you update the file it is gone. :(

edit flag offensive delete link more


Looks like the bug I encountered is already listed: (which I updated to show that it also exists in on Windows 7 Home Premium SP1 64bit).

Mark12547 gravatar imageMark12547 ( 2013-04-17 07:17:26 +0200 )edit

I have the same issue with OSX- that I cannot copy/past conditional formatting. I have a fairly large document with color scales applied to several columns, and need to extend that formatting to newly added rows. Looks like I would need to start over selecting all the cells in a column and redefine the color scales.

icerabbit gravatar imageicerabbit ( 2013-08-14 01:50:07 +0200 )edit

Question Tools


Asked: 2013-01-16 23:17:13 +0200

Seen: 2,496 times

Last updated: Apr 17 '13