https://bugs.documentfoundation.org/show_bug.cgi?id=105323
--- Comment #3 from Aprax <[email protected]> ---
Thank you for your prompt response.
I made an error where I said "Cell N5 now had a value of "1.049"."
I should have said "Cell M5 now had a value of "1.049" because the contents of
column N moved to column M when column G was deleted.
Later I did correctly note that the value originally in N5 was now in M5 after
column G was deleted when I said "When column G is deleted, the formula, now in
cell M5".
In your comparison you chose row 4 which has different values but essentially
supports my request.
I see that you've changed this to an "Enhancement", possibly because both Excel
and LO contain the same incorrect logic. My premise is that if the "H5" is
changed to "G5" then so should "14" be changed to "13" and, since it doesn't
change, this is a bug/error, it's not an enhancement. Microsoft should also
change Excel, should they not? Possibly LO is this way because the current code
copies what MS does in Excel "for compatability" i.e. copy the errors.
At least I've identified the error even though it may never be fixed because it
would then be incompatable with Excel.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
