| Summary: | Fileopen CSV as fixed width: Textimport doesn't work correct | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Rolf <rolf.kuehlwein> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | ilmari.lauhakangas, miguelangelrv, raal, xiscofauli |
| Priority: | medium | ||
| Version: | 7.0.6.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Testfile for Textimport
Korrect Text Import wrong Text import Filter attitude |
||
|
Description
Rolf
2022-04-05 08:30:43 UTC
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. [Automated Action] NeedInfo-To-Unconfirmed 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
[Automated Action] NeedInfo-To-Unconfirmed 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 *** |