Bug 136647 - Number entered with comma is converted to 100s
Summary: Number entered with comma is converted to 100s
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-09-10 12:48 UTC by Lionel Landwerlin
Modified: 2020-09-11 08:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Test sheet (7.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-09-10 12:48 UTC, Lionel Landwerlin 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Lionel Landwerlin 2020-09-10 12:48:20 UTC 
Created attachment 165364 [details]
Test sheet

In the attached sheet, I entered 2 percentage number.
In column E, I entered "33.19".
In column F, I entered "33.19" and no matter what I does, it gets converted to "3319.00%"

I can't make sense of what is happening here so assuming this is some kind of bug.
Comment 1 m_a_riosv 2020-09-11 06:45:10 UTC 
Because you have the cell formatted as %. Use [Ctrl+1] (Numbers) tab to see what is the cell format.
Go to F, use [Ctrl+M] to reset the cell format.
Try again to introduce the value.
Comment 2 Lionel Landwerlin 2020-09-11 06:48:32 UTC 
Thanks, that works. What I don't understand is how this cell/column was selected to be formatted as %. I started with a fresh sheet and started putting numbers. The previous column doesn't behave like that.
Comment 3 m_a_riosv 2020-09-11 08:04:24 UTC 
Maybe inadvertently you have been introducing a percent, so the cell got the format. Deleting the value doesn't change cell format.

Please if you have similar questions, try first on our forum https://ask.libreoffice.org/en/questions/