Description: The file at the attach is converted from .xlsx and simplified. Cells are intertwined while print preview mode and when printed. Steps to Reproduce: 1.Open the file at the attachment. 2.Click print preview Actual Results: A1 and A2 cells intertwined Expected Results: It should show true margin values. (Default 0,35mm from all sides) Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:51.0) Gecko/20100101 Firefox/51.0
Created attachment 131180 [details] The file, has main problem
Created attachment 131186 [details] How I see it I can't reproduce it in Version: 5.4.0.0.alpha0+ Build ID: a25b1ff25a3be97d688d66b12353b4217fd239a5 CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group
Created attachment 131187 [details] Problematic seem Strange. I've added problematic seem. Can anyone test it again
I can't reproduce it in Version: 5.4.0.0.alpha0+ Build ID: a296a69c984b17cfbcd249cf6bdc191d08dff2a6 CPU Threads: 1; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2017-02-06_00:00:55 Locale: es-ES (es_ES); Calc: group To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test?
Created attachment 131201 [details] Thats is last problematic file. The first problematic file was wrong file, sorry. All cells must be optimal height. I've add last problematic file. By the way user profile reseted. Problem is going on. Lang: tr-TR
Microsoft Office 2010 has same issue.
(In reply to Gülşah Köse from comment #6) > Microsoft Office 2010 has same issue. should we consider this as a bug then ?
Yes, i think. Cell seen and print seen different in any case.
Confirmed in Version: 5.4.0.0.alpha0+ Build ID: 880033edde516fc30225005245253293a6a58ba4 CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) but not in LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Hm, I'm gettin this in 3.3.0 / Windows 7 as well.
I found new reproducement steps without excel 1. Open calc 2. Expand A column till B column with mouse 3. Type one line XXXXXXXXXXXXXXXXX to A1 4. Type one line YYYYYYYYYYYYYYYYY TO A2 5. Select all cells with Ctrl+A and click "Wrap text" 6. Now copy the YYYYYYYYYY line and paste 20 times. (to same cell) 7. See print preview Actual Results: A1 and A2 cells intertwined Expected Results: It should show true margin values. (Default 0,35mm from all sides)
(In reply to Gülşah Köse from comment #11) > I found new reproducement steps without excel > > 1. Open calc > 2. Expand A column till B column with mouse > 3. Type one line XXXXXXXXXXXXXXXXX to A1 > 4. Type one line YYYYYYYYYYYYYYYYY TO A2 > 5. Select all cells with Ctrl+A and click "Wrap text" > 6. Now copy the YYYYYYYYYY line and paste 20 times. (to same cell) > 7. See print preview > > Actual Results: > A1 and A2 cells intertwined > > Expected Results: > It should show true margin values. (Default 0,35mm from all sides) So sorry second step should be: 2. Expand A column till C column with mouse
Created attachment 131380 [details] Some detections about bug *Cells colorized for easy to see if cells or text intertwined. (Text) *Row count is different on tab view an preview view. *Right margin of cell is different on tab view an preview view.
Also seeing it in 3.3.0 / Ubuntu 16.04. Not a regression I think.
Created attachment 131421 [details] New detection about line spacing There is no option in calc increase/decrease line spacing of the paragraph but Tab view and print preview view has different line spacing as you see attach. Print preview view has looser line spacing Although it has fewer rows. I think the cell overflow can be caused by this.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Since I repro with 5.4.1 beta and not with 5.4.3 and 6.0.1 in Windows, I'll close as WFM. Gülşah, just revert if you still see it.
It seems resolved. Thanks for testing.