conditional format disappear [closed]
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.
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.
My operating system is WINDOWS XP HOME EDITION SP3. LibreOffice (Portable) Version 3.6.4.3 Yes is in the native file type. every sheet use the same macro put on sheet events SheetContentChange.
This is an example of instruction that i use in the macro wSheet.getCellByPosition(wSheet.getCellRangeByName("ActivitiesID").getRangeAddress().StartColumn, row).Value = oCallingCell.Value