We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

ted.w's profile - activity

2016-03-28 11:40:31 +0200 commented answer Calc Restore Row Heights to "Automatic" ("to max content height")?

With version 5.1.1.3 the row height goes auto only if Default value is checked, or the value is set to zero. Anything above zero will prevent the row's height from self-adjusting. If one needs to increase the default height for all rows, the proper way is to make use of styles: F11 -> Right Click on Default -> Modify -> Borders -> Spacing to Contents.

2014-10-23 23:15:01 +0200 received badge  Nice Answer (source)
2014-10-05 02:23:08 +0200 received badge  Teacher (source)
2014-10-05 02:23:08 +0200 received badge  Necromancer (source)
2014-10-04 13:34:38 +0200 answered a question Why does conditional formatting blow up when I move around cells?

The associated bug report is fdo#57486

A comment from a LibreOffice dev states that it won't be fixed:

This will not be fixed.

Copying conditional formats will create new conditional formats to prevent increasing the range in case they are not overlapping. This is important for conditional formats that are not only based on the current cell value but calculate based on the cond format range.

In my experience, this happens when pasting or moving rows/columns.

One trick is to first insert an empty row/column then special-paste the source without formatting:

  1. Select the source row/column, cut it, then delete it
  2. Insert an empty row/column at the destination and paste special (Ctrl+Shift+V)
  3. In the Selection region, uncheck Paste all and select everything else except Formats, OK

Also, if you frequently move stuff to the very end of the conditionally formatted area, another trick is to include an extra row/column in the area's range definition. This way, you'll be inserting inside the area, which will expand automatically.