https://bugs.freedesktop.org/show_bug.cgi?id=72487
--- Comment #13 from Joe Huard <joe.hu...@primus.ca> --- I do drag the date down with the mouse. That is how I did it from the beginning. Joe On 09/12/2013 6:09 PM, bugzilla-dae...@freedesktop.org wrote: > > *Comment # 12 <https://bugs.freedesktop.org/show_bug.cgi?id=72487#c12> > on bug 72487 <https://bugs.freedesktop.org/show_bug.cgi?id=72487> from > mariosv <mailto: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 reported the bug. > -- 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