Ask Your Question

How to apply optimal row and column width when opening a Calc document? [closed]

asked 2016-11-11 17:50:06 +0200

Zilk gravatar image

We generate reports as spreadsheets (by directly modifying the content.xml of a template document). Some of the cells can have multiple lines, and the cell contents vary in width as well. All columns and rows are set to use the optimal width/height, and I would like the display to adjust automatically when the user opens the document.

The content.xml styles contain

<style:style style:name="ro1" style:family="table-row">
   <style:table-row-properties fo:break-before="auto" style:use-optimal-row-height="true"/>

(I have removed the style:row-height attribute.)

Whatever I try, I cannot get LO to recalculate the optimal row heights when the document is opened. I'm not even sure if this is possible; I've seen a few related bugs: #62268, #62361.

The only thing I can think of is to create a macro that sets optimal widths/heights and bind it to a keyboard shortcut. Is there any other way to achieve this?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-15 12:58:52.580142

1 Answer

Sort by » oldest newest most voted

answered 2016-11-11 23:09:43 +0200

m.a.riosv gravatar image

Have you tested with the option Menu/Tools/Options/Load+Save/Formula - Recalculation on File Load for ODF?

edit flag offensive delete link more


I have now; there's no change in the col/row display.

Zilk gravatar imageZilk ( 2016-11-12 13:42:55 +0200 )edit

Question Tools

1 follower


Asked: 2016-11-11 17:50:06 +0200

Seen: 768 times

Last updated: Nov 11 '16