https://bugs.documentfoundation.org/show_bug.cgi?id=157464
Bug ID: 157464
Summary: Cells formatted as percentage no longer function as
numbers, and cannot even be reverted to numbers
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
If one converts a cell format into % its contents no longer functions as a
number, which is a disaster to the data I just input and then reformated.
Example, if one had one row of three cells like:
1.0; 0.5; 0.1;
and one formats them into % they are correctly displayed as:
100%; 50%; 10%;
But now they are no longer numbers, they are strings or something! One can no
longer perform things like: math functions referencing them from other cells,
numerical conditional formatting like "Color Scale..." nor can one select them
and make a chart. Worse, one cannot select them and change the cell formatting
back to a number to get back the original set of three cells 1.0; 0.5; 0.1 back
to do any of the aforementioned operations because those cells are no longer
considered numbers at all let alone ones possible to reformat! (really
"deformat" as I just want my numbers back!)
Its like the percent reformat option in cell formatting multiplies the number
by 100 and then permanently converts it into a string and appends a % onto the
back end -- this is terrible behavior as it "de-numbers" your numbers
permanently! The appropriate behavior is similar to treating it like a
function with the real unconverted number still there. I.e., while it
shouldn't be displayed to the user in the following way, Calc should think of
the cells 1.0; 0.5; 0.1; when formatted to % as being akin to
=Percent(1.0); =Percent(0.5); =Percent(0.1), with anything accessing those
cells externally (such as: conditional formatting, charts, or equations in
other cells) as ignoring the Percent() function and just referencing the input
of the function.
--
You are receiving this mail because:
You are the assignee for the bug.
