Bug 148705 - [FILEOPEN] SpreadsheetML 2003 parser missing text wrap setting
Summary: [FILEOPEN] SpreadsheetML 2003 parser missing text wrap setting
Status: RESOLVED DUPLICATE of bug 147620
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-04-21 08:43 UTC by SheetJS
Modified: 2022-04-23 07:49 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot excel vs calc (22.63 KB, image/png)
2022-04-22 23:21 UTC, m_a_riosv 		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 SheetJS 2022-04-21 08:43:23 UTC 
Description:
SpreadsheetML 2003 supports text wrap but LO is not applying the setting.

Steps to Reproduce:
https://raw.githubusercontent.com/SheetJS/test_files/master/crlf/crlf.xml (download and open)

Actual Results:
Cell B1 wrap text not enabled, text `abcdef` rendered in one line

Expected Results:
Cell B1 wrap text enabled, text `abc
def` rendered in two lines


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Cell style has wrap text enabled:

```xml
  <Style ss:ID="s16">
   <Alignment ss:Vertical="Bottom" ss:WrapText="1"/>
  </Style>
```

Cell data includes "\n" encoded in the decimal form:

```xml
    <Cell ss:StyleID="s16"><Data ss:Type="String">abc&#10;def</Data></Cell>
```
Comment 1 m_a_riosv 2022-04-22 23:21:06 UTC 
Created attachment 179737 [details]
Screenshot excel vs calc

How it looks excel vs calc.
Excel doesn't apply the split, calc only doesn't recalculate the row height.

Microsoft® Excel® for Microsoft 365 MSO (Version 2203 Build 16.0.15028.20178) 64-bit
Version: 7.2.6.2 (x64) / LibreOffice Community
Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 2 SheetJS 2022-04-22 23:51:10 UTC 
https://i.imgur.com/0wmcEHT.png

Top: LibreOffice about screen.  Version 7.3.2.2 just downloaded from the website

Bottom-Left: Excel for Mac Version 16.55 (21111400)

Bottom-Right: LibreOffice

Curiously both B1 and B2 are incorrect: Excel has text wrap enabled on B1 but not B2.  LO has neither cell set to wrap, but in practice it displays B2 as if it were wrapped.
Comment 3 Timur 2022-04-23 07:49:35 UTC 
seems duplicate.

*** This bug has been marked as a duplicate of bug 147620 ***