https://issues.apache.org/ooo/show_bug.cgi?id=122023
Bug ID: 122023
Issue Type: DEFECT
Summary: Fixed width text import results in numbers as labels
Classification: Application
Product: Calc
Version: AOO 3.4.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 80512
--> https://issues.apache.org/ooo/attachment.cgi?id=80512&action=edit
Test import file containing fixed column width data
When attempting to import fixed width text files (or from pasting into a
spreadsheet), the resulting import treats numbers as labels/text not numbers.
Attached to this bug report is a sample test.csv file that contains two columns
as following:
john 265345.23
sally 5623.51
sue 10.32
Open the file in Calc 3.4.1 and in the import dialog choose "Fixed width" and
place the column separator between the two columns and click on "OK" (screen
shot attached). The result will be two columns imported into a spreadsheet.
Both columns are text. Each number will have an apostrophe (') and a few
spaces, then the text representation of the number (screen shot attached and an
ODS file attached).
This is a SEVERE regression bug. The problem does not occur in OpenOffice
3.2.1 nor in LibreOffice 4.0.0. (And it doesn't matter if there are commas in
the numbers or spaces after the numbers, it still works correctly in older
OpenOffices and in Libreoffice 4).
>From what I can tell, there is no possible workaround and it leaves us unable
to upgrade to 3.4.1 because we would no longer be able to import and parse any
of our fixed-width reports (which we do a lot).
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
