Description: Since upgrading to 7.2.5. versions, Text Import has not been functioning as expected. I have now upgraded to 7.2.6.2 and the problem has not been corrected. The Text Import function is not outputting the column selected for output. Steps to Reproduce: 1.Create file outside Libre Office using a .bat file which includes a DOS 'dir' command line to produce a text file (with .xls extension) 2.Use 'Open file' in Libre Office to open this file. This calls up the 'Text Import' facility which displays the file correctly. 3.Select 'Fixed width' option and adjust the column markers as necessary. 4.Use 'Hide' to exclude the unwanted information, and apply 'Text' to the column to be extracted. 5. Click OK Actual Results: The output .xls file window displays a single column of the same width as the selection but the text is the initials characters of the lines of text as shown in the Text Import window. For example, rom a line in the original file which reads: 26/03/2022 10:44 276,443 20220325_003_P.jpg with the group of characters '003' selected, the output shows the characters '26/' Expected Results: As described in 'Actual Results' Reproducible: Always User Profile Reset: No Additional Info: There has been no change in my operating system.
Created attachment 179138 [details] Screen dump to illustrate problem
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
Created attachment 179173 [details] text format file for test
Created attachment 179174 [details] Sample batch file - see comments
The specific file that was used for the example is photos.xls attached. Please note that this is not a spreadsheet file in its unimported form; the .xls file suffix is created through a file named dirgeo.bat which is a simple set of DOS commands to create a printable directory listing of a specific folder. This is attached but simply renamed with a .txt suffix as gmail will not send a .bat file. You should be able to edit this to create a different file from any directory you are working with. (In its form as attached, photos.xls can be open as a simple text file in any text editing software to show it in unimported format). I have been using this procedure successfully in Libre Office for a number of years through several upgrades and without any change to my operating system (Windows 10). I also have W10 installed on a laptop which at this moment is still running Libre Office 7.1.5.2 and the problem is not occurring. Kind regards Alan Murray-Rust
It works fine for me both with 7.2 and the latest. Do you still see this with 7.4? Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away. Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 8389048cb41291917449e87b2901d6133bce3373 CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 21 December 2022
Has been working OK since the first new download after the problem was reported. Many thanks.
*** Bug 148385 has been marked as a duplicate of this bug. ***