Bug 162222 - Wrap text automatically always deactivated for field with CONCATENATE
Summary: Wrap text automatically always deactivated for field with CONCATENATE
Status: RESOLVED DUPLICATE of bug 161453
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.5.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-07-27 07:11 UTC by Ralf
Modified: 2024-10-02 15:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
xlsx format example - the failure happens here (10.67 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-07-28 08:37 UTC, Ralf 		Details
ods format example - the failure doesn't happen (20.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-07-28 08:39 UTC, Ralf 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Ralf 2024-07-27 07:11:59 UTC 
Description:
A field is using an equation with CONCATENATE function merging the content of multiple other fields. The "wrap text automatically" feature is activated, the text is wrapped.
When closing and opening the file again, the "wrap text automatically" feature is always deactivated and the text is not wrapped.

Steps to Reproduce:
1. Open file using the CONCATENATE function for some fields to calculate a longer text content
2. Go to the field with CONCATENATE function (assume as example field B2)
3. Enable the feature "wrap text automatically" in this field (B2)
4. Close the file
5. Open the file again
6. Go to the previously mentioned field B2
7. Check the feature "wrap text automatically". It will be disabled, but should be enabled.
8. Check the feature "wrap text automatically"

Actual Results:
Feature "wrap text automatically" of affected field is disabled

Expected Results:
Feature "wrap text automatically" of affected field is enabled


Reproducible: Always


User Profile Reset: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2024-07-27 08:10:02 UTC 
Please attach a sample file(s), reduce the size as much as possible without private information.
Comment 2 Ralf 2024-07-28 08:37:55 UTC 
Created attachment 195561 [details]
xlsx format example - the failure happens here

Thanks for taking it!
I've realized that it happens only for files stored in xlsx format. Open the file and check the "wrap text automatically" feature for fields B2 and B3. It's disabled.
If you enable it, save and close the file, and then re-open it, the feature will be reset to disabled again.
Comment 3 Ralf 2024-07-28 08:39:42 UTC 
Created attachment 195562 [details]
ods format example - the failure doesn't happen

It doesn't happen when the file is stored in ods format. Check fields B2 and B3. The "wrap text automatically" feature remains enabled after re-opening the file.
Comment 4 ady 2024-07-28 10:01:57 UTC 

*** This bug has been marked as a duplicate of bug 161453 ***
Comment 5 Justin L 2024-10-02 15:58:12 UTC 
WrapTextExample.xlsx stopped exporting wrap b/c
 || rItemSet.Get( ATTR_LINEBREAK ).GetValue()
was removed from sc/source/filter/excel/xestyle.cxx