https://bugs.freedesktop.org/show_bug.cgi?id=62361
Priority: medium
Bug ID: 62361
CC: [email protected]
Assignee: [email protected]
Summary: FILEOPEN without optimum row hight calculation
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 76545
--> https://bugs.freedesktop.org/attachment.cgi?id=76545&action=edit
Test Kit for easy reproducing Step 20
I found this one during my tests for "Bug 62268 - FILEOPEN: Optimum row height
should be recalculated with "style:use-optimal-row-height='true'"". The core of
the problem is that for an existing document (created with 3.3.3) the row
height will not be calculated.
I think that a lot of aspects might have influence whether row height should be
adapted. So I contribute all steps including creation of the sample document.
Steps with Server Installation of "LibreOffice 3.3.3 English UI/ German Locale
[OOO330m19 (Build:301) tag libreoffice-3.3.3.1] on German WIN7 Home Premium
(64bit) (creating sample document)
1. New spreadsheet from LibO Start Center
2. On Sheet2 Cell A1 Type "This is a pretty long text "
3. Increase column A width dragging border between Column headings A-B to
app. double size (so that it's a little more than text length)
4. A2: "=A1"
5. fill A2 to A3 .... A20
> All cells A1:A20 show same text as A1
6. Sheet1.A1: "=CONCATENATE(Sheet2.A1;Sheet2.A2;Sheet2.A3;Sheet2.A4;Sheet2.A5;
Sheet2.A6;Sheet2.A7;Sheet2.A8;Sheet2.A9;Sheet2.A10)"
> Shows long text in Sheet1.A1 exceeding Cell size
7. Menu 'Format -> Cells -> Alignment -> Wrap Text Automatically' <ok>
> Text wrapped into cell with increased row height (20 text lines or so).
8. Save document as "sample_333_01.ods", close, reopen
> Still shows text wrapped correctly in Sheet1.A1
9. Double click Sheet2.A1 (Cel Edig mode)
10. <control+a> to select all cell contents
11. <control+c> to copy all cell contents
12. click into cell behind trailing blank
> caret flashes behind text
13. <control+c> to copy text
> Text now with double length in All cells
14. Check Sheet1.A1
Row height has NOT been increased (I haven't a clue whether that is
intended or not)
15. Save document as "sample_333_02.ods", close,
16. reopen "sample_333_02.ods: Now row height HAS been increased,
showing approximately 40 text lines in cell for all text
17. Close document without saving
20. Now tests with other versions:
Do only Step 16, until 3.5.6 always will show increased row height for
Sheet1.A1
showing app. 40 text lines with all text.
Still [Reproducible] with parallel Dev-installation of "Version
4.1.0.0.alpha0+ (Build ID: 61add5c77de1ff963b839020c77f67f14ef07de) TinderBox:
Win-x86@6, Branch:master, Pull Time: 2013-03-05_00:20:08" ENGLISH UI / German
Locale on German WIN7 Home Premium (64bit) with LODev/4 Masters User Profile
Bug:
----
Starting with server installation of "LibreOffice 3.5.7.2 German UI/Locale
[Build-ID: 3215f89-f603614-ab984f2-7348103-1225a5b] on German WIN7 Home Premium
(64bit) you will only see the 20 text lines as in step 14, text is truncated in
Sheet1.A1.
I believe that this is at least a part of the problem in Bug 62268, But because
there might be involved various effects I decided to submit a separate bug.
@Bernhard Dippold:
I believe this test kit reproduces more or less your problem, what do you
think? Can you reproduce my observations?
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
