https://bugs.documentfoundation.org/show_bug.cgi?id=101565
--- Comment #2 from Tor Lillqvist <[email protected]> ---
I can't reproduce in a fresh build from the 5.2 branch.
I follow your steps:
1. Load the first attached document. M7:R250 are all zero. (I.e. the values
present in the document file.)
2. Delete M250:R250 (Select that range, press the "Delete" key, keep the
default tick boxes selected, i.e. Text, Date&Time, Numbers, and Formulas),
press OK.
3. Hard recalc, i.e. press Ctrl+Shift+F9. Non-zero numbers appear here and
there in M7:R249. Also some #VALUE! errors. This is apparently as expected? At
least it matches what I get if I turn off OpenCL.
4. Copy M249:R249 to M250(:R250). M250:R250 also shows zeros, like M249:R249.
5. Hard recalc. ==> Nothing changes. <== This is different from what you claim.
In fact, I don't see what impact the deletion and copying would have on this;
all that is needed to get correct results is a hard recalc after loading the
document, as the values stored in the document are incorrect.
I did not look at comment #1 yet.
--
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
