https://bugs.freedesktop.org/show_bug.cgi?id=72487

--- Comment #12 from mariosv <mari...@miguelangel.mobi> ---
Hi Joe not a work around, when you sort relative cells formulas, the cell
formula is adapted to the new position.

If:
B14: =A14*2
and after a sort B14 is moved to B3 then:
B3: =A3*2
what is fine, because this retain the formula between cells in the row

if you don't want this change you need to have an absolute row reference.
B14: =A$14*2
and after a sort B14 is moved to B3 then:
B3: =A$14*2

I think maybe is easy, not use formulas, but fill down as you need dragging the
date with the mouse.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to