Hello, I do this manually in a calc-Sheet:
*select cellrange A1:A5 (A5 is the active cell) *insert a conditional Format with Formula is: A5=0 When mark only cell A5 and i read the conditional Format by Code: MsgBox ThisComponent.getCurrentSelection.ConditionalFormatLocal(0).Formula1 then i get: "A5=0" - OK, fine. But, when i mark cell A3 and use the same code then i get "A5=0" too. The problem ist that the formula "A5=0" (in the conditional format) ist relative and i need in cell A3 the return "A3=0" from my macro. (i get the correct formula "A3=0" for example in the dialog, format-conditional format, in the menu) I think it is possible to get "A3=0" by code, when i convert "A5=0" with the aid of .SourcePosition - but is there a straighter way? Please note that the formula "A5=0" is very small, and in this case it is not so difficult to convert this - but it could be that the formula ist very long, and i think in this case it is very complicated to isolate all cell-coordinates from the formula-string before i can convert this cell-coordinates. Any suggestions? greetings Jörg --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
