Bug 73658 - VIEWING: Page zoom, page preview and correct cell wrapping
Summary: VIEWING: Page zoom, page preview and correct cell wrapping
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.1.0.4 release
Hardware: Other Windows (All)
: low trivial
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-15 10:23 UTC by me
Modified: 2014-10-31 13:09 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments

Description me 2014-01-15 10:23:09 UTC
As far as I know this has always been a problem which I have manually managed but would be good if could be sorted.

Current Version: 4.1.4.2
Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72

Problem description: When wrapping is applied to cells different results are given at different page zoom whilst editing. I work at 75% for ease of seeing all data, I want to see what is in cells (text strings). When going to page preview and export as pdf/print cells have often over wrapped leaving unnecessary spaces around text. Have to clear and reapply direct formatting to entire sheet at 100% zoom to get something close then use page preview again to identify individual rows that need height adjusting manually - those that have one word that just tips the cell into an extra line on the edit will often not form a new line in page preview and/or export pdf/print.

I see this as a problem with the way the text and cells scale at different rates. If it is a limitation some how on set font sizes to display perhaps the zoomable steps should only move in sync with this to preserve document fidelity. This isn't a problem when zooming in page preview as the 'image' scales proportionally.

Steps to reproduce:
1. Apply text wrapping to cells.
2. Add text/data longer than is visible in cell so it wraps with one word just pushing it over into new line.
3. Zoom in and out of edit view and use page preview.

Current behavior: Wrapping changes at different zooms and when flicking to page preview or straight to export pdf/print. Have to do all above to identify rows that haven't wrapped correctly to then manually edit row height for final version. Sometimes to get it right for export pdf/print will mean it won't wrap correctly in edit view or page preview.

Expected behavior: Once wrapped at any zoom in edit view I'd expect it to remain the same at all other zooms, page preview, export pdf & print.
***I'd also expect it to 'backwards wrap' - reduce the cell size if text/data is removed.

              
Operating System: Windows 7
Version: 4.1.0.4 release
Comment 1 Dominique Boutry 2014-01-16 09:52:07 UTC
Excel 97 also shows this behaviour.

For as long as I used a spreadsheet software, I experimented this trouble. That doesn't mean that we must not search for a solution. However, I'm afraid that such a solution implies managing the layout of a spreadsheet with floating points coordinates (the same probably for bug 72912) : rather heavy and ressource consuming.
Comment 2 me 2014-01-17 20:05:34 UTC
If I remember rightly this wasn't an issue with MS Office 2004 which I used prior to Openoffice then Libreoffice. The reason I say this is that this is one of the problems that has irked me from the outset of me using Open/Libreoffice.
Comment 3 Tom Colley 2014-04-02 00:36:35 UTC
I have experienced the same bug for many years. I can add that the "Optimal Row Height..." function is dependent on the zoom value. If this function is applied at a particular zoom, all wrapped text becomes visible on-screen. However, changing the zoom after that is likely to create a rendering of cells where some of the wrapped text is NOT visible.
Comment 4 Tom Colley 2014-04-02 00:38:56 UTC
PS. My previous comment reflects my current situation running LibreOffice 4.1.3.2 on Ubuntu 13.10.
Comment 5 me 2014-04-04 11:04:06 UTC
Optimal row height is dependant on zoom level and changes in zoom alter rendering after....

Yes I have discovered this and experimented. Using optimal row height at zoom level 75% represents accurately what is seen in the page preview and gives the best result when exporting to PDF.
Comment 6 Beluga 2014-10-31 13:09:46 UTC
I confirm.

Win 7 64-bit Version: 4.4.0.0.alpha1+
Build ID: 56019dcb79475606952a954fe732a3109441ffec
TinderBox: Win-x86@39, Branch:master, Time: 2014-10-30_07:27:11


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.