1) Paste as text issue 2) Automatic row height adjustment issue

[JLLibre]

Version: 24.8.6.2 (X86_64)
Build ID: 480(Build:1)
CPU threads: 8; OS: Linux 6.13; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Hi, I recently switched Linux distributions and used to have a Linux distro that had an older version of Calc which worked just fine.

With the current version I have the following issues:

1
Calc not saving in originating folder when doing Save as - I have made separate post for this:

Calc not saving in originating folder when doing Save as

Version: 24.8.6.1 (X86_64) Build ID: 480(Build:1) CPU threads: 8; OS: Linux 6.13; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Hello, I have been happily using Calc for many years, and when I open an existing Calc file, and do a Save as, Calc saves the file in the folder from which the file was opened. For the first time yesterday, when I did a Save as, Calc started initially to save files in the Documents folder. After noticing this, I then manually…

2
In the old version of Calc, if I pasted text copied from a website into a cell, by first double clicking on that cell, so that there is a cursor in that cell, then the paste would be text only. Which is what I liked. Now, if I do the same, Calc keeps the html formatting of the paste, which I do not want. How do I get it to paste text only again?

3
In the old version of Calc, row height would automatically adjust for the text being pasted into it. In this new version, row height stays the same. I found out I can select a row and right click > Optimal Height and unselect Default value and then the row height does automatically adjust.

I then also selected the whole worksheet, and right click > Optimal Height and unselect Default value BUT when I select the worksheet again, and right click > Optimal Height Default value is reselected, ie is checked on, even if I have unchecked it previoulsy.

Furthermore, I cant even seem to find what this Optimal Height does or means - I cant seem to find any up to date info about it (only posts that are say 10 years old).

I sometimes have worksheets with 2000 rows, and having to double click now on each row border in order for it to resize the row height is a lot of extra work.

4
In the old version, if I did Insert row above, a row with the height of a single line of text would be inserted. Which I liked. With the new version, sometime the height of the new row is multiple lines high and I have to adjust the row height manually. How can I set Calc to always insert a row of 1 line high?

Any help with the above issues is much appreciated Thanks ahead of time.

[Wanderer]

@JLLibre

Any help with the above issues

My recommendation would be 3 different topics or this thread will soon be a bit “messy”.

[Villeroy]

@JLLibre

How do I get it to paste text only again?

Use the middle-click clipboard.

@JLLibre

In the old version of Calc, row height would automatically adjust for the text being pasted into it. In this new version, row height stays the same.

I can’t reproduce this issue. Cell height adjusts to the formatted text pasted.