Issue 115929 - Do not display multiple lines merged with many cells in xls format
Summary: Do not display multiple lines merged with many cells in xls format
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 3.3 RC7
Hardware: Unknown All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2010-12-05 09:50 UTC by quancayda
Modified: 2017-05-20 09:55 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Do not display multiple lines merged in xls format (8.00 KB, text/plain)
2010-12-05 09:53 UTC, quancayda 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description quancayda 2010-12-05 09:50:17 UTC 
I input multiple lines (by Ctrl + Enter) in A1 and merge A1 and B1 into one cell , 
then save file as *.xls format. If I reopen this file, this cell (A1) will only 
display one line, not multiple lines as expected.

I try saving this with *.ods format, it does not happen. 

Also, Microsoft office does not stick this case.
Comment 1 quancayda 2010-12-05 09:53:28 UTC 
Created attachment 75238 [details]
Do not display multiple lines merged in xls format
Comment 2 daniel.rentz 2010-12-06 09:41:53 UTC 
This is not a problem of OpenOffice.org. Excel does not use merged cells when it
calculates automatic row heights.

You will see the effect too when you do the same directly in Excel:
- Insert multi-line text into cell A1 -> Excel expads row 1.
- Merge A1 with B1 -> Excel shrinks row 1 to one line of text, ignoring the
multi-line contents.

The XLS export filter writes the automatic height flag for row 1, thus Excel
recalculates the height of row 1 after reading the file.
Comment 3 Shan Zhu 2012-09-06 09:37:12 UTC 
(In reply to comment #2)
> This is not a problem of OpenOffice.org. Excel does not use merged cells
> when it
> calculates automatic row heights.
> 
> You will see the effect too when you do the same directly in Excel:
> - Insert multi-line text into cell A1 -> Excel expads row 1.
> - Merge A1 with B1 -> Excel shrinks row 1 to one line of text, ignoring the
> multi-line contents.
> 
> The XLS export filter writes the automatic height flag for row 1, thus Excel
> recalculates the height of row 1 after reading the file.

Hi, Daniel
I've tried this scenario in MS Excel 2003 and 2010.
I find the Excel doesn't ignore the multiple -lines contents.
I wanna confirm with you, and propose to reopen this bug.