https://bugs.documentfoundation.org/show_bug.cgi?id=96475
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
CC| |[email protected]
Ever confirmed|0 |1
--- Comment #14 from Eike Rathke <[email protected]> ---
Actually this is a combination of several problems..
1) pasting formula error results as values creates an internal formula
cell to preserve the error value (as can be seen by the "highlight"
green value)
1a) this does not have a leading '=' though
2) such error values seem to be not treated correctly during sort;
actually they should be sorted before other values, just as when
sorting the original formula range
3) when saved, due to 1a the formula is stored without the leading '='
but cell type string, extended type error, which so far is correct
4) when loaded, this combination results in a string being set at the
cell, which is not an error value and thus sorts differently
5) VLOOKUP may return empty cells *for display only*, but these when
pasting as values will be pasted as 0 values and if formatted as date
result in the null date 1899-12-30
6) similar, they are stored as an empty but 0 formatted value thus when
reloading in this case display as null date
--
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
