Description: LibreOffice version: 7.4.3.2 (see Screenshot 5) Cell content gets modified without user intervention while saving a spreadsheet to XLSX format. My spreadsheet contains "lib_list_dwc_6gmp_x1_ns" word, which then becomes "lib_list_dwc_6gmpns". Note that "_x1_" gets removed from the word. Steps to Reproduce: 1. Importing a CSV file that contains "lib_list_dwc_6gmp_x1_ns" word. (see Screenshot 1-3) 2. Saving this new spreadsheet as XLSX. 3. Opening the spreadsheet. (see Screenshot 4) Actual Results: CSV file contains "lib_list_dwc_6gmp_x1_ns" word. This word is changed to "lib_list_dwc_6gmpns" after saving to XLSX. Note that "_x1_" gets removed from the word. Expected Results: CSV file contains "lib_list_dwc_6gmp_x1_ns" word. This word is stays unchanged "lib_list_dwc_6gmp_x1_ns" after saving to XLSX. Reproducible: Always User Profile Reset: No Additional Info: The screenshots can be found at: http://www.blnl-http.dnsalias.org/images/Fedora/LibreOffice/
Created attachment 184593 [details] this is the imported CSV file
Created attachment 184594 [details] this is the resulting XLSX file
Please don't set up as new, someone must do it after verify the issue. Reproducible Version: 7.4.4.1 (x64) / LibreOffice Community Build ID: 988f4a351a6fa8cf4bdf2bdc873ca12cf8cbe625 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 12e8d57e791bb1befc0716d4d02af7d1d1ccb4ae CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo
Czeber László Ádám committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/96965871f4cd2e4afbdf3bcae9dc0c43d1543e1d tdf#152980 CSV import: Fix control character length in XLSX save It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Czeber László Ádám committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/47b30728db3ad47f1b4d0d8b027ba0a55607ac1e tdf#152980 CSV import: Fix control character length in XLSX save It will be available in 7.5.4. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 99a88c9e55872214ce01d89447d18708e47e956b CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL threaded