Bug 152980

Summary:	LibreOffice is modifying a cell entry (text) after saving to XLSX format
Product:	LibreOffice	Reporter:	Boris Ljevar <boris.ljevar>
Component:	Calc	Assignee:	Czeber László Ádám (NISZ) <czeber.laszloadam>
Status:	VERIFIED FIXED
Severity:	normal	CC:	aron.budea, boris.ljevar, miguelangelrv
Priority:	medium
Version:	7.4.3.2 release
Hardware:	x86-64 (AMD64)
OS:	All
Whiteboard:	target:7.6.0 target:7.5.4
Crash report or crash signature:		Regression By:
Attachments:	this is the imported CSV file this is the resulting XLSX file

Description Boris Ljevar 2023-01-11 13:40:05 UTC

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/

Comment 1 Boris Ljevar 2023-01-11 13:44:04 UTC

Created attachment 184593 [details]
this is the imported CSV file

Comment 2 Boris Ljevar 2023-01-11 13:45:22 UTC

Created attachment 184594 [details]
this is the resulting XLSX file

Comment 3 m_a_riosv 2023-01-12 00:18:53 UTC

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

Comment 4 Commit Notification 2023-05-08 22:06:23 UTC

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.

Comment 5 Commit Notification 2023-05-09 10:29:36 UTC

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.

Comment 6 NISZ LibreOffice Team 2023-05-15 06:45:36 UTC

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