Bug#749847: libreoffice-calc: Chained Calculations aren't updated correctly after deleting a Row or Column
tag 749847 + upstream
forwarded 749847 https://bugs.freedesktop.org/show_bug.cgi?id=78903
tag 749847 + fixed-upstream
thanks
Hi,
On Fri, May 30, 2014 at 10:11:45AM +0200, Matthias Schniedermeyer wrote:
> Steps to reproduce that work for me.
> Opening a new Spreadsheet.
> Entering:
> A1: 1
> A2: 2
> A3: 3
> A4: =SUM(A1:A3)
> A5: =A4
>
> I see:
> 1
> 2
> 3
> 6
> 6
>
> Then i click on Row 2 and select "Delete Selected Row" from the context-menu
> I see:
> 1
> 3
> 4
> 6
>
> The last 6 is wrong and should also be 4.
>
>
> The same happens when fill in the number/formulas horizontally and delete a column.
>
>
> Bonus:
> 'Undo'ing the Row-Delete and then 'Redo'ing it (Ctrl-Z, Ctrl-Y)
> i see what i would expect:
> 1
> 3
> 4
> 4
Thanks for the report; according to upstream it's already fixed:
17:20 <@kohei> _rene_, I fixed that one just recently, backported to 4.2 etc.
[...]
17:33 <@kohei> _rene_, this commit http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-2&id=9d8f8074edbb63db467cc451c0596585e2f0422c
17:33 < IZBot> core - fdo#78903: Don't broadcast prematurely during cell deletion.
17:33 <@kohei> and tha'ts the number.
That one is even in libreoffice-4-2-5 so this will be fixed with 4.2.5
(actually in 4.2.5 rc1, but..) and in libreoffice-4-3 so it'll be fixed in
4.3.0 beta2, too.
Regards,
Rene
Reply to: