[mdlug] Fwd: LibreOffice Calc - auto-adjust column width

[Bob]

next time you can use the Right mouse context menu to Paste without 
Formatting.

Bob

On 2/10/23 2:32PM, Rick Hall wrote:
> FYI:
> I was able to get the desired behavior... at-will; but I'm still not 
> exactly sure what specifically was causing the problem - I just know 
> (now) how to fix it.
>
> A brief back-story:
> I downloaded some 1099's from my investment firm as an Excel sheet 
> (could've opted for .csv, but chose .xls). I opened them in LO Calc, 
> then copied the relevant cells from the various files into an actual 
> (new) LO file. Some of the column headers in the new sheet were giving 
> me this problem.
>
> To 'solve' it, I deleted (Ctl-X) the data in the column 
> (column-header, and the corresponding data-values), then pasted into 
> an editor that strips all formatting (Notepad, in this case), then 
> copied THAT from Notepad back into the worksheet (Ctl-X/Ctl-V). So 
> there must have been something funky about the original text. This 
> even works 'correctly' in text that has a Ctl-LF/CR to force a line 
> break within the cell.
>
> Thx
> -R
>
> -------- Forwarded Message --------
> Subject:     Re: [mdlug] LibreOffice Calc - auto-adjust column width
> Date:     Fri, 10 Feb 2023 14:56:06 -0500
> From:     Rick Hall <email5000 at usa.com>
> To:     Dennis <dark58star at gmail.com>
>
>
>
> Thanks for your response, Dennis, but that does not solve the problem 
> I'm having. It SOUNDS like it would work, but it doesn't (not in this 
> instance.)
>
> However, as I mentioned in the OP, "Optimal" width asks you to select 
> a width from a pop-up -- I can simply set a column width from right 
> click on the column header and select "column width" -- without 
> selecting Optimal anywhere. "Optimal" simply sets a width (at least in 
> my instance).
>
> I just double-clicked on a right border of a column in the column 
> header row and it set the column to 1 character wide, in spite of all 
> the text in the first cell.  WTH?!?!?   Even if I set the optimal 
> width from the context menu to something very large, then d-c on the 
> right column border, it STILL sets the width to 1 char wide !!!
>
> However,  I do have another sheet where it adjusts as expected 
> (expanding the column, then double-clicking on the right 
> column-divider in the column header), without needing to select 
> Optimal Width anywhere.
>
> Random, behavior is NOT a desired behavior !!
>
> There's something else going on here, and I can't find it !!
>
> Thx anyway.
> -R
>
>
> On 2/10/2023 14:33, Dennis wrote:
>> I think this is what your looking for.
>>
>>
>> https://ask.libreoffice.org/t/how-to-autosize-column-widths-in-calc/64319 
>>
>>
>>
>> Dennis
>>
>> _______________________________________________
>> mdlug mailing list
>> mdlug at mdlug.org
>> http://mdlug.org/mailman/listinfo/mdlug
> _______________________________________________
> mdlug mailing list
> mdlug at mdlug.org
> http://mdlug.org/mailman/listinfo/mdlug