Bug 1304896
| Summary: | Calc fails import 'special characters' correctly | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | morgan read <mstuff> |
| Component: | libreoffice | Assignee: | Eike Rathke <erack> |
| Status: | CLOSED NOTABUG | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 22 | CC: | caolanm, dtardon, erack, ltinkl, mstahl, sbergman |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2016-02-05 12:00:51 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Attachments: | |||
Created attachment 1121230 [details]
first pass with 'detect special numbers' flag
Created attachment 1121231 [details]
second pass without 'detect special numbers' flag
Created attachment 1121246 [details]
third pass with 'detect special numbers' again with quotation marks
Created attachment 1121247 [details]
first pass again with 'detect special numbers' flag _after restart_
Created attachment 1121248 [details]
resulting Calc speadsheet with quotation marks
Note that in the screen shots the "Text delimiter" field is empty, it should have selected the " quote character instead then it works. Oh bottom, missed something obvious again! But why are these things showing up now? I've just gone to f22, been using lo (and before that oo, and before that so) for the past 15 years - have all the defaults been reset from lo4-5/ f20-22? |
Created attachment 1121229 [details] original text file Description of problem: Calc doesn't interpret 'quoted field as text' / 'detect special numbers' properly - quotation marks are detected on first run but then not detected on a second run - also, they are not imported properly - quotation marks for text detected in the Text Import tool are not striped in the resulting Calc sheet - see attached images (taking note of the 'detect special numbers' check box and the time sequence of the images) Version-Release number of selected component (if applicable): $ rpm -qa libreoffice libreoffice-4.4.7.2-1.fc22.x86_64 How reproducible: seems reproducible, restarting libreoffice seems to 're-set' so that quotes are detected - then importing a second time, they're not detected Steps to Reproduce: 1. import text file with quotation marks defining text fields 2. see above and attached images 3. Actual results: intermittent detection of quotation marks for text fields and failure to reflect them in resulting Calc sheets Expected results: consistent interpretation of quotation marks for text fields properly reflected in Calc sheets Additional info: see attached original text files and images images