https://bugs.documentfoundation.org/show_bug.cgi?id=157464
--- Comment #3 from [email protected] --- (In reply to m.a.riosv from comment #1) > Format doesn't change the values in the cell, only how they are visualizing. In playing around now, you seem to be right, but in the attached file in the top left table where I initially experienced this, that still doesn't seem to be the case The top left table is a copy of the top table on the right, but I selected the data and told format cells to format them as percent. Now when you click on those cells it shows them as a string starting with a ' and terminated with "%" which means formatting *DID* change those cells. Also if they are still the same cells, then they are still numbers, so try selecting those ones and do: conditional formatting, make a chart, or even perform a calculation on them from other cells. You can't, LibreOffice no longer considers them numbers so they can't be treated like numbers any more without retyping them. Playing with the other tables now it does look like I can convert back and forth for some reason, so you are right, maybe it isn't a bug something just went terribly wrong with that first table. But that first table in the upper left of the file, when I converted it to % with format cells, it permanently changed those to strings going from say "0.5" to "'50%" Why did it do that there but nowhere else? Is this maybe an issue with the .xlsx format the file is saved in? I know I didn't type in the ' and change those to strings when I did the formatting on that top left table, I just used the format cells feature. -- You are receiving this mail because: You are the assignee for the bug.
