[Issue 127539] New: "split to coumns" also changes numerical data to dates

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127539

          Issue ID: 127539
        Issue Type: DEFECT
           Summary: "split to coumns" also changes numerical data to dates
           Product: Calc
           Version: 4.1.2
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: Critical
          Priority: P5 (lowest)
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: jedi.yannis@gmail.com
  Target Milestone: ---

I try to bring cordinate data from a text to calc for editing. As I copy them
over, when I split the data to columns, calc tries to "find out" if some of
them are dates. Calc is currently unable to "understand" that data imported via
copy-paste, split to columns and other non-typing ways are meant to stay as
they are.
Also Calc cannot understand other number types except dates. Even if format a
cell to a specific type of numerical data, it changes back to date data.
Basically calc doesn't recognise data types other than dates or text.
Why name the program calc if you cannot accept data that can be used in
calculations by default?

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127539] "split to coumns" also changes numerical data to dates

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127539

mroe <mr...@gmx.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|Critical                    |Normal
                 OS|Windows 7                   |All
           Hardware|PC                          |All
         Resolution|---                         |NOT_AN_OOO_ISSUE
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #1 from mroe <mr...@gmx.net> ---
If you import text (files) to Calc as .csv or via clipboard, Calc opens an
import dialogue. If you don't want any change then select "Text" for all
columns. Otherwise the recognition of numbers depends on the locale setting of
AOO. Especially whether "." or "," is used as a decimal separator.

Please discuss this behaviour in a user forum – and if the discussion results
in an unsolvable problem, please come back and reopen this issue with a step by
step description.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127539] "split to coumns" also changes numerical data to dates

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127539

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
You are receiving this mail because:
You are the assignee for the issue.