https://bugs.documentfoundation.org/show_bug.cgi?id=167321
Bug ID: 167321
Summary: Pasting decimal numbers with commas splits them into
multiple columns due to incorrect delimiter detection
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
When pasting a list of decimal numbers using a comma as the decimal separator
(e.g. 0,325), LibreOffice Calc incorrectly splits the value into multiple
columns, as if the comma were a field delimiter. This happens even if each line
only contains a single value.
This behavior is especially disruptive when pasting into a column formatted as
percentage or number, where the user expects the pasted values to remain
intact.
Steps to reproduce:
Copy the following text into the clipboard
0,235
0,3253
0,5121
In LibreOffice Calc, select a cell in a column formatted as % or Number.
Paste using mouse.
Actual result:
If you do not notice that auto detection is selected then each value is split
into two columns (e.g. 0 in one cell, 235 in the next).
Expected result:
The pasted values should remain intact as 0,235, 0,3253, etc., and occupy only
one column each.
Suggested solutions:
Add an option to disable automatic delimiter detection in the "Text Import"
dialog when pasting.
Or apply a safer heuristic: if there's only one comma and no other delimiters,
treat it as a decimal separator rather than a field separator.
Or at least provide a global preference to control this behavior.
--
You are receiving this mail because:
You are the assignee for the bug.
