[Libreoffice-bugs] [Bug 157464] Cells formatted as percentage no longer function as numbers, and cannot even be reverted to numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=157464 m.a.riosv changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #5 from m.a.riosv --- I think the issue is that you have formatted those cells with percents as text, and could be mixed with a wrong decimal separator. If the decimal separator it's fine, try: Clear the cells format [Ctrl+M] Select the range, do a search and replace: Search for: .+ Replace with: & Mark regular expression, then replace all. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157464] Cells formatted as percentage no longer function as numbers, and cannot even be reverted to numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=157464 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157464] Cells formatted as percentage no longer function as numbers, and cannot even be reverted to numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=157464 --- Comment #4 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157464] Cells formatted as percentage no longer function as numbers, and cannot even be reverted to numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=157464 --- Comment #3 from nats@gmail.com --- (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.
[Libreoffice-bugs] [Bug 157464] Cells formatted as percentage no longer function as numbers, and cannot even be reverted to numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=157464 --- Comment #2 from nats@gmail.com --- Created attachment 189847 --> https://bugs.documentfoundation.org/attachment.cgi?id=189847&action=edit File showing the % formating issue A file showing the issue with formatting as % -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157464] Cells formatted as percentage no longer function as numbers, and cannot even be reverted to numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=157464 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #1 from m.a.riosv --- Format doesn't change the values in the cell, only how they are visualizing. It fine that 1.0 becomes 100% it is what it is, but contained of the keep being 1. Please attach a sample file where to reproduce the issue. No issue with Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5e9c8d21874eea8cb5adf2ecab1905295af2308f CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo -- You are receiving this mail because: You are the assignee for the bug.
