Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Autocorrect issues when importing a file | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | simonbr | ||||
Component: | code | Assignee: | oc | ||||
Status: | CLOSED NOT_AN_OOO_ISSUE | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 1.1 Beta | ||||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Windows XP | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
simonbr
2003-04-08 11:37:16 UTC
Created attachment 5524 [details]
CSV .txt file
Hi Simon, just click into the displayed column. As you've done this, you can choose US-English as column type. The complete different numbers are located in the decimal value of the dates, so reformatting them just show the this value and therefore this is not a bug. Your suggestion about the preview is not possible, as the preview is just plain text and the resulting import is interpreted depending on your settings made in the dialog. So I've to close this as Invalid Best regards Frank closed invalid If no "auto formatting", better "interpreting", would be performed, you are only able to import text. Remeber - you have a text file. So Calc HAS to interpret the texts and to calculate reasonable values. How Calc does this, can be set in the dialog. The dialog itself is more a file viewer than a preview. It always shows the real contents of the text file. It cannot show how Calc interprets the text. I have looked at your file, and tried it to import using "US-English", and it shows the correct values here. You may need to adjust the displayed precision. You can do this in the cell format dialog, tabpage Numbers. Hi Frank, Daniel, Thanks for the explanation. It had not occurred to me that I could click on the preview, therefore the column type selection box did not offer any choices. Sorry for the inconvenience! DR->FST: Would it be better to pre-select the first column? Would save one required click in all cases where only one column of data is present. And in other cases, you have to click at a column anyway. Hi Daniel, no it should be as it is. Frank |