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.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
(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.
Created attachment 160782 [details]
test csv file
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.
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
Created attachment 161559 [details]
Created attachment 161560 [details]
Created attachment 161561 [details]
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 ***
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.
I don't reproduce this, so it might be solved (or I'm doing something different)
Version: 18.104.22.168.alpha0+ (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
Note: I do have to change the 'String Delimiter" default is " other option '