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

English
#1

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:

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 :slight_smile: Thanks ahead of time.

#2

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

1 Like
#3

Use the middle-click clipboard.

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

#4

@Villeroy

Use the middle-click clipboard.

  1. The middle click of what?

  2. I cannot middle-click the clipboard if that is what you mean - that is impossible

  3. If you mean I should paste, I already stated that pasting is the issue I am having - read my original post

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

Telling someone that you do not have the same issue as someone else, is of no help to that person whatsoever. I am having this issue, Telling me that you do not, does not help at all.

#5

although, it could be understood as an encouraging wake-up call to follow this recommendation, which you seem not to acknowledge …

In the same idea : Ask/Guide - How to use the Ask site - The Document Foundation Wiki
#More_details

#6

Maybe you must fiddle with Default cell style - Alignment tab?

This will apply formatting until the last column and last row with data. Blank Cells Don't Change Font Size After Resizing Font? - #8 by LeroyG

#7

It may not help you directly, but it places the problem in “configuration/settings” instead of “not possible”. Next not helping step would usually testing in safe mode.

Use context-menu of the cell when pasting or try to paste in the top formula bar after activating the cell.

#8

@fpy:

wake-up call to follow this recommendation, which you seem not to acknowledge

I dont appreciate the tone imlying that I need to wake up. It is not helpful and just adds to the lack of support.

Which recommendation? You mean

“Use the middle-click clipboard”?

I dont have a middle clikc on my laptop if this is what this means. This is a good example of a suggestion that cannot be done by the OP.

Secondly “clipboard” is a piece of memory and cannot be clicked. There is NO “Clipboard” selection if one right clicks on a cell so this is impossible to do. This is a good example of a suggestion that is impossibe to carry out. IF they mean middle clic on a CELL, which they also do not explain.

In the same idea : Ask/Guide - How to use the Ask site - The Document Foundation Wiki 1

Telling someone:

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

Is like a person posting on a Toyota Corolla forum that his car wont start when he turns the On key, and they someone replying that his car does start when he turns the On key. It is completely not helpful. As a matter of fact it can be a little frustrating when one has a problem, that another person does not have this problem.

Also note that other people are taking the time to provide suggestions written in full sentences in a helpful and polite tone. “Use the middle-click clipboard” and “wake-up” are are not in this category.

Possibly you and @Villeroy should follow a “How to reply on this site” guidelines, if there are any.

Also note that if someone provides helpful suggestions, I do acknowledge them and thank them for their help.

I reserve the right to say when something is not helpful, so that the quality of future responses may be improved.

#9

@LeroyG - Thank you for your suggestions - I will try them :slight_smile:

#10

@Wanderer - I appreciate you taking the time to post - I will try the things you suggest.

#11

Any Linux distribution I have used so far, has a second clipboard which copies selected text only. When you middle-click anywhere in some text window, the last selected text is pasted without formatting. If your mouse has a scroll wheel, the wheel may include a push button. If there are only two buttons, a simultaneous click of both buttons should perform a middle-click.

#12

Answering that something is not reproduced using some specific configuration is highly helpful - both for other potential helpers (who already appreciated that above, because this information helps to narrow down the problem - it could be a configuration problem, an OS problem, a regression or resolved bug, etc.), and to most questioners (at least to people who don’t consider everything they don’t understand as something personally offensive).

The only issue in @Villeroy’s reply is the lack of the said configuration details.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.