https://bugs.freedesktop.org/show_bug.cgi?id=88042
--- Comment #7 from [email protected] --- I lodged the following possibly similar bug report yesterday [including an attachment]. It seems not to have got through. The text of my report was: I run a little calender worksheet. I had set up an alert for jumbled or missing days by setting the Conditional Formatting for the Days Time column to “Formula is: IF(f2-f1<>1,1,0) – Apply style [Redfont]”. Since the 4.2.6 debacle if I cut [Ctrl+X] say rows 2&3 to paste them elsewhere & then delete [Ctrl+-] the empty rows 2&3 the Conditional Formatting is scrambled to “Formula is: IF(f#REF!-f#REF!<>1,1,0) – Apply style [Redfont]”. This bug still applies to 4.2.7. Sorry if this is a duplication: I can resend the example ssht if requested. I might add that referring data from one sheet to another can also be inconsistent [eg, in say cell A1 of workbka entering "=", then going to D4 of workdkb.ods gives "=workdkb.ods'#$b.D4" but does not always report the data in cell D4 of workdkb.ods] -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
