Bug 91251 - FILESAVE: XLSX TextBox overflow property is not getting preserved after Roundtrip
Summary: FILESAVE: XLSX TextBox overflow property is not getting preserved after Round...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) Master
Hardware: All All
: medium normal
Assignee: Balázs Regényi
Whiteboard: target:7.1.0
Keywords: filter:xlsx
Depends on:
Blocks: Textbox XLSX-Shapes
  Show dependency treegraph
Reported: 2015-05-13 06:01 UTC by darshan.gandhi
Modified: 2020-09-29 12:04 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Original File (9.38 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-05-13 06:01 UTC, darshan.gandhi
After Roundtrip File (7.72 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-05-13 07:38 UTC, darshan.gandhi
Difference in Original and RT files (224.77 KB, image/png)
2015-05-13 08:11 UTC, darshan.gandhi
Screenshot of the original file in current Calc and Excel (127.13 KB, image/png)
2020-09-14 07:04 UTC, NISZ LibreOffice Team

Note You need to log in before you can comment on or make changes to this bug.
Description darshan.gandhi 2015-05-13 06:01:24 UTC
Created attachment 115538 [details]
Original File

Steps to Reproduce:
1. Create on calc file in Office and insert text into textbox.
2. Verify that text Autofit property "Allow text to overflow shape" is uncheked.
3. Save file in as .xlsx in office.
4. Roundtrip same file in LO
5. After roundtrip verify that Text box text Autofit property "Allow text to overflow shape" is uncheked.

Actual Result
"Allow text to overflow shape" is checked and because of which text from text box pushed on second line.
Expected Result:
"Allow text to overflow shape" is unchecked and text from text box pushed should not be pushed on second line.
Comment 1 darshan.gandhi 2015-05-13 07:38:47 UTC
Created attachment 115544 [details]
After Roundtrip File
Comment 2 darshan.gandhi 2015-05-13 08:11:45 UTC
Created attachment 115545 [details]
Difference in Original and RT files
Comment 3 Jorendc 2015-05-17 09:13:19 UTC
Reproducible, tested using Windows 7.

LibreOffice Version: (x64)
Build ID: 9d0c51daea67104349cac26de9839afa8baeb099
TinderBox: Win-x86_64@42, Branch:master, Time: 2015-05-15_23:59:35
Locale: nl-BE (nl_BE)

Opened using Word 2010.
Comment 4 Ravindra Vidhate 2015-05-27 08:32:20 UTC
The text from Text Box is not pushed because of the AutoFit propert. But LO writes the default column width around (8.42 or 8.67) for all columns in x:Cols data. 

Because of this, the columns are displayed with the custom width and Text box width is also shrinker also.
Comment 5 Xisco Faulí 2016-09-14 22:42:24 UTC
Hi Ravindra,
I'm setting this ticket back to NEW as it has been inactive for more than 3
Feel free to assign it back to you if you're still working on this.
Comment 6 QA Administrators 2017-10-24 07:00:06 UTC Comment hidden (obsolete)
Comment 7 Dennis Roczek 2018-04-03 11:30:59 UTC
still repro with

Version: (x64)
Build-ID: 60bfb1526849283ce2491346ed2aa51c465abfe6
CPU-Threads: 4; BS: Windows 10.0; UI-Render: GL; 
Gebietsschema: de-DE (de_DE); Calc: CL
Comment 8 Regina Henschel 2019-09-15 20:52:48 UTC
Overflow is not yet implemented, see commented out lines
Comment 9 NISZ LibreOffice Team 2020-09-14 07:04:42 UTC
Created attachment 165472 [details]
Screenshot of the original file in current Calc and Excel

The original file has "Word wrap text in shape" property turned OFF in Excel but it opens still as turned ON in Calc.

Version: (x64)
Build ID: bcf1917a0934417226d2357b514df398129a7fab
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL
Comment 10 NISZ LibreOffice Team 2020-09-14 07:23:03 UTC
Erm, wrong highlighting.
There is no equivalent in Calc UI for the "Allow text to overflow shape" property.
Comment 11 Commit Notification 2020-09-29 10:27:31 UTC
Regényi Balázs committed a patch related to this issue.
It has been pushed to "master":


tdf#91251 XLSX textbox export: fix missing overflow properties

It will be available in 7.1.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:

Affected users are encouraged to test the fix and report feedback.