Description: If I import a text file and set the columns as fixed, they are not adopted as the text filter was set. Steps to Reproduce: 1.Sheet 2.Sheet out of File 3.Textfile 4.fixd columns wiht hidden columns Actual Results: Not the right columns are imported Expected Results: Textfile import with more than 2 columns but expected are only 2 columns. Reproducible: Always User Profile Reset: No Additional Info: Imports some columns that are not defined
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.)
Created attachment 179323 [details] Testfile for Textimport Try to import this Textfile(Test.csv). Example Line : *$S0002 $L12$F001$T001$B00000212$I001$G00101$R00000600$O01$N.V BASISWINKEL WIPPENSCHALTER ROTOMAT $H05 $H06 $H07 $H08 $ Attitude : *$S = Hidden (ausgeblendet in German) column 0002 = Text column $L12 till $N = Hidden column .V BASISWINKEL WIPPENSCHALTER ROTOMAT = Text column $H05 till $ = Hidden column
[Automated Action] NeedInfo-To-Unconfirmed
Maybe I'm wrong, but it not looks as normalized csv file format. https://en.wikipedia.org/wiki/Comma-separated_values
(In reply to m.a.riosv from comment #4) > Maybe I'm wrong, but it not looks as normalized csv file format. > https://en.wikipedia.org/wiki/Comma-separated_values I used such a file many times befor, it works, but in the currend Office it doesn't work.
(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. > 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.) Thanks , i have uploaded a file and a description.
Do you remember the last version working?
(In reply to m.a.riosv from comment #7) > Do you remember the last version working? I tried 7.06 portable in this version it worked.
V7.2.6.2 also doesn't work.
I can't see any difference with Version: 7.0.5.2 (x64) Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); Interfaz: es-ES Calc: CL
(In reply to Rolf from comment #8) > (In reply to m.a.riosv from comment #7) > > Do you remember the last version working? > > I tried 7.06 portable in this version it worked. Could you please attach a screenshot of the correct behaviour ?
Created attachment 179452 [details] Korrect Text Import Right Text Import
Created attachment 179453 [details] wrong Text import
Created attachment 179454 [details] Filter attitude
I cannot reproduce with Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: ab8d141967111ca81f4607db3618bb09214e42db CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo
Hi @raal, pls what are your options at import to get that? I can't get it with Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d34d1db55978bdcff082af1e0f75b18fa6fc94f4 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: threaded
(In reply to m.a.riosv from comment #18) > Hi @raal, pls what are your options at import to get that? > > I can't get it with > Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community > Build ID: d34d1db55978bdcff082af1e0f75b18fa6fc94f4 > CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: > win > Locale: es-ES (es_ES); UI: es-ES Calc: threaded Use the files which I uploaded, the error occurs on 7.3.2.2(X64).
There was a bug from 7.0 to 7.2 but this seems OK with 7.3 and daily master 7.4+. In Fixed width, just click where you want column. https://help.libreoffice.org/7.4/en-US/text/shared/00/00000208.html "Fixed width Separates fixed-width data (equal number of characters) into columns. Click on the ruler in the preview window to set the width."
*** This bug has been marked as a duplicate of bug 148217 ***