Arch Linux

siriusb

Member

From: Hungary

Registered: 2010-01-01

Posts: 422

openoffice 3.2 calc doesn't save row height in xls

Hi All,

I have upgraded to ooo 3.2 recently. I work with excels spreadsheets so  I have to save files into xls. Suddenly I realized that Calc doesn't save custom row height, when I open the file all rows are displayed with default height. It worked in the previous version, pacman log: upgraded go-openoffice (3.1.1.5-1 -> 3.2.0.4-1)
I searched ooo forums, but didn't find anything.

update:
in case someone is interested, I have found a kind of work-around. Select sheet, Format / Rows / Optimal height -> increase value at least one step, in my case from 0.0 mm to 0.1 mm, then save. Reopen xls, rows will be displayed with the custom heights. Unfortunately one has to apply this workaround on every singe sheet in the workbook. :-/ No way I would do this with all my workbooks.

Last edited by siriusb (2010-02-03 09:52:39)

southerncross

Member

Registered: 2010-02-03

Posts: 41

Re: openoffice 3.2 calc doesn't save row height in xls

Hi,

Although this does not presume anything from your experience, you should perhaps know that OpenOffice.org 3.2 is still not final. Today its RC 5 was released. So perhaps what you have is a beta, I remember testing that a few weeks ago and it was somewhat unstable.

siriusb

Member

From: Hungary

Registered: 2010-01-01

Posts: 422

Re: openoffice 3.2 calc doesn't save row height in xls

Oh, I wasn't aware of this. Thanks. Now I have a reason to learn how to downgrade

siriusb

Member

From: Hungary

Registered: 2010-01-01

Posts: 422

Re: openoffice 3.2 calc doesn't save row height in xls

Workaround with downgrade: If someone successfully downgraded to 3.1.1 it wont start because depends on libjpeg.so.7.

1. Create a script somewhere in your PATH and make it executable:

#!/bin/bash
LD_PRELOAD=/var/tmp/libjpeg.so.7.0.0 soffice -calc "$1"

2. copy libjpeg.so.7.0.0 to the directory mentioned in the script (in this case /var/tmp)
3. in your file manager e.g. nautilus right click on the xls, choose properties / Open with / custom command, and use the script's name.