https://bugs.documentfoundation.org/show_bug.cgi?id=101225
--- Comment #8 from Colin <[email protected]> ---
The text accompanying that last upload got "dropped" by the system.
The new spreadsheet is simply the original downloaded and modified to ensure we
are all on the same sheet :)
the document was created from my original large multi page spreadsheet where
the error originally occurred.
I erased all but a few sample cells to demonstrate.
The erasure would undoubtedly have left formatting in the "undo/redo" buffer
and the column widths remained the same. All the recommended re-formatting
options suggested had already been performed and I even saved and restarted the
document to ensure all buffers were cleared.
As can be seen from this later submission:-
retyping the formulae cell by cell along line one produced the erroneous
results even after almost the entire sheet was formatted as Number--General.
Selecting and dragging the formulae from line one to line two produced
"identical" results.
Selecting the entire line two and dragging to replicate line three produced the
anticipated copy of line two.
selecting the first "text formula" on line three and dragging to the right
produced the entire line of "text formulae".
Perhaps you would care to satisfy yourself as to what happens if "valid"
formulae are copied to line three as appropriate.
I selected the appropriate cells and even changed the decimal values in the
hope that might "force" the recognition of a change. Not much luck there!
I accept it's probably not a VALUE() function error but it is a major flaw in
the formatting of repurposed cells where all user attempts are generally
ignored in favour of something that may once have been.
The original sheet was four pages of 300+ rows 100+ columns with web links,
typed text, copied text, calculated substring text, typed values, calculated
values, accumulations and inter page references. The document is regularly
updated, sorted, resorted with special sort orders and five graphic charts
produced. I imagine the buffering to retain all the possible undo and redo
states is potentially overwhelming the ability to accurately reset all cells
when something is repurposed.
Should a new bug report be raised?
--
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
