Bug 132980 - Preview wrong in opening CSV files when options remain the same
Summary: Preview wrong in opening CSV files when options remain the same
Status: RESOLVED DUPLICATE of bug 69207
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: low minor
Assignee: Not Assigned
Depends on:
Reported: 2020-05-12 13:01 UTC by gmarco
Modified: 2020-06-11 14:56 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

demo with screenshots (181.87 KB, application/pdf)
2020-05-12 13:01 UTC, gmarco
test csv file (697 bytes, text/plain)
2020-05-13 20:14 UTC, gmarco
correct preview (103.85 KB, image/jpeg)
2020-06-03 09:01 UTC, gmarco
correct sheet (131.61 KB, image/jpeg)
2020-06-03 09:02 UTC, gmarco
non-compliant preview (101.51 KB, image/jpeg)
2020-06-03 09:03 UTC, gmarco

Note You need to log in before you can comment on or make changes to this bug.
Description gmarco 2020-05-12 13:01:54 UTC
Created attachment 160726 [details]
demo with screenshots

Hi, opening with Calc a file.csv I notice a confusing behavior in data conversion.
The last options used remain evident but are not applied: see attached pdf.
Comment 1 Xisco Faulí 2020-05-13 12:22:11 UTC Comment hidden (obsolete)
Comment 2 gmarco 2020-05-13 20:12:48 UTC

(In reply to Xisco Faulí from comment #1)
> Thank you for reporting the bug. Please attach a sample document, as this
> makes it easier for us to verify the bug. 

Hi, I seem to have already documented the problem with the attached pdf.
The substance is: by opening a csv file, Calc already displays the setted options of the last previous use, these could also be correct but they are not applied!
In the hypothesis that they are correct, you are led to click OK, while instead, to actually apply them, you need to deselect at least one of them and then re-select it.
It would be more logical not to propose them already set or, if setted, apply them.
I think the problem is in Calc, not in the input file.
However, if it can be useful, I attach the same test csv used for the pdf.
Comment 3 gmarco 2020-05-13 20:14:07 UTC
Created attachment 160782 [details]
test csv file
Comment 4 gmarco 2020-05-13 20:19:05 UTC
The problem is common to any input, it does not depend on the specific file I used to demonstrate it, it happens with any csv file.
Comment 5 gmarco 2020-06-03 09:00:40 UTC
Update: the defect is only apparent but it exists and I believe it must be corrected!
As said, opening the csv file the previous options appear but a non-compliant preview of the result (you must de-select and re-select an option in order to preview the desired result).
Nonetheless, even if you do not do this and click OK on the initial display, the resulting sheet is correct and compliant with the options.

scr1  correct preview
scr2  correct sheet
scr3  non-compliant preview
Comment 6 gmarco 2020-06-03 09:01:46 UTC
Created attachment 161559 [details]
correct preview
Comment 7 gmarco 2020-06-03 09:02:26 UTC
Created attachment 161560 [details]
correct sheet
Comment 8 gmarco 2020-06-03 09:03:06 UTC
Created attachment 161561 [details]
non-compliant preview
Comment 9 Timur 2020-06-11 11:02:48 UTC
Looks like a duplicate. If not, explain. If yes but you can add value, do in bug 69207. 
Rule of thumb: search before reporting.

*** This bug has been marked as a duplicate of bug 69207 ***
Comment 10 gmarco 2020-06-11 14:37:25 UTC
It may be trivial in low priority but it is so since 2013.
Furthermore, bug 69207 refers to the case of single/double quote text delimiter, but the defect of the preview not corresponding to the options presetted or already present when opening a file occurs with any delimiter.
Comment 11 Telesto 2020-06-11 14:56:23 UTC
I don't reproduce this, so it might be solved (or I'm doing something different)
Version: (x64)
Build ID: a201ab6f47c2d5a7ba4c5f998b0aa231cae82010
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL

Note: I do have to change the 'String Delimiter" default is " other option '