[Hpr] Different width in same column on one LO Calc sheet?

Mike Ray mike at raspberryvi.org
Thu Sep 21 13:41:16 PDT 2017


I'm tearing my hair out here.

I think there is a bug in LibreOffice Calc when merging cells.

I want to merge several cells horizontally. I get the option to either
merge and centre, or just merge, when I would think the text should be
left justified unless I've specifically said right justify it.

But if I select merge rather than centre and merge, when I go back into
the menu centre and merge is ticked.

And, because I can't see, I convert the sheet to pdf and then:

pdftotext -layout -htmlmeta sheet.pdf

And looking at the resulting html file, all the texts in merged groups
start in different columns, suggesting it is definitely centred.

Is there a way to have different column widths in the same column in
different parts of the sheet?

I want the A column ten centimetres wide in the first 10 rows, and then
I want column A 4 centimetres wide, and column B 10 centimetres wide
from the eleventh row.

Anybody got any ideas?

The accessibility of LibreOffice is getting worse.


Michael A. Ray
Witley, Surrey, South-east UK

Disclaimer: It wasn't me, you didn't see me, you can't prove a thing.


More information about the Hpr mailing list