https://bugs.documentfoundation.org/show_bug.cgi?id=95808
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #2 from m.a.riosv <[email protected]> --- Created attachment 120530 --> https://bugs.documentfoundation.org/attachment.cgi?id=120530&action=edit Sample stable formula and conditional format verification Hi Heiko, I think you can solve the issue avoiding the wrong formula. I don't know what version you are using, from LibreOffice 5 there is the option to use entire column references https://wiki.documentfoundation.org/ReleaseNotes/5.0/es#A:A_.2F_1:1_entire_column.2Frow_references A formula like: =INDEX(A:A;ROW();0)*1,19 or =INDEX($A:$A;ROW();0)*1,19 always produce the right result, use the absolute reference as you need. With previous versions define the rows numbers: =INDEX(A$1:A$1000;ROW();0)*1,19 or =INDEX($A$1:$A$5000;ROW();0)*1,19 It can be done similar with OFFSET() or INDIRECT(), but they are volatile functions, more expensive on calculation time, specially if they are a lot of them. Also you can define a Named formula with it so you can use directly their name. Find attached a sample file. This can be done also with Labels but actually there is a problem with their calculation after copy, so better avoid it. Another way to mark it could be with a conditional format -- 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
