SOLVED: [libreoffice-users] optimal width always

2023-07-13 Thread hw
On Wed, 2023-07-12 at 08:25 -0400, James wrote: > You need to turn on macros in the settings (google how, I forgot) and > the > setting is enabled to record it (google where :-)). I think you can > assign the macro to a key. Thank you very much! I have enabled macro recording, recorded a macro

Re: [libreoffice-users] optimal width always

2023-07-13 Thread hw
On Wed, 2023-07-12 at 11:41 +0100, Brad Rogers wrote: > On Wed, 12 Jul 2023 12:09:29 +0200 > hw wrote: > > Hello hw, > > > Why can't that happen automatically when loading a file, or at > > least > > IME 'optimal width' results in a cell that is too wide. Then don't use this function. >  

Re: [libreoffice-users] optimal width always

2023-07-13 Thread Brad Rogers
hw, Do NOT Cc me. *Especially* in a thread I have already said I'm no longer interested in. -- Regards _ "Valid sig separator is {dash}{dash}{space}" / ) "The blindingly obvious is never immediately apparent" / _)rad "Is it only me that has a working delete

Re: [libreoffice-users] optimal width always

2023-07-13 Thread hw
On Wed, 2023-07-12 at 07:51 -0500, Michael H wrote: > "function" here would mean an action somewhat related to the > advertisement > in the menu name. The empty field does not have a menu, or does it? Function would mean that something happens when you right or middle click the empty field.

Re: [libreoffice-users] optimal width always

2023-07-12 Thread Brad Rogers
On Wed, 12 Jul 2023 07:51:53 -0500 Michael H wrote: Hello Michael, Don't Cc me; I'm subbed so will see your messages on list. >From outside the discussion, it seems like you're confusing "function" >with "bug". Seems normal for LibreOffice these days. I'm most not confusing the two. If you

Re: [libreoffice-users] optimal width always

2023-07-12 Thread Michael H
"function" here would mean an action somewhat related to the advertisement in the menu name. What exactly does "select the entire sheet" have to do with "optimal width"? From outside the discussion, it seems like you're confusing "function" with "bug". Seems normal for LibreOffice these days.

Re: [libreoffice-users] optimal width always

2023-07-12 Thread James
You need to turn on macros in the settings (google how, I forgot) and the setting is enabled to record it (google where :-)). I think you can assign the macro to a key. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] optimal width always

2023-07-12 Thread Brad Rogers
On Wed, 12 Jul 2023 12:05:49 +0100 Dave Howorth wrote: Hello Dave, >thread. I just tested the feature and it gave a completely unusable >spreadsheet layout as a result, so I'll now forget it exists :) :-) I'm sure that many people find the feature useful. hw is obviously one of them. "One

Re: [libreoffice-users] optimal width always

2023-07-12 Thread Dave Howorth
On Wed, 12 Jul 2023 11:41:16 +0100 Brad Rogers wrote: > On Wed, 12 Jul 2023 12:09:29 +0200 > hw wrote: > >It is actually the most-used functionality when working with > > By you. I never use it. It's something that's usually done once per > sheet, IME, if at all. "Fit and forget", if

Re: [libreoffice-users] optimal width always

2023-07-12 Thread Brad Rogers
On Wed, 12 Jul 2023 12:09:29 +0200 hw wrote: Hello hw, >Why can't that happen automatically when loading a file, or at least IME 'optimal width' results in a cell that is too wide. Consequently, for my use case, a sheet that could otherwise be printed on one piece of paper ends up requiring

Re: [libreoffice-users] optimal width always

2023-07-12 Thread hw
On Wed, 2023-07-12 at 10:35 +0100, Brad Rogers wrote: > On Wed, 12 Jul 2023 11:13:41 +0200 > hw wrote: > > Hello hw, > > And adding to my previous; > > If you select the entire sheet, then right click on a column and select > "Optimal Width...", guess what happens (rhetorical question). Why

Re: [libreoffice-users] optimal width always

2023-07-12 Thread hw
On Wed, 2023-07-12 at 10:18 +0100, Brad Rogers wrote: > On Wed, 12 Jul 2023 11:13:41 +0200 > hw wrote: > > Hello hw, > > > field at the top left sets all columns to optimal width. That field > > currently has no function at all. > > It selects the entire sheet. Of little use, perhaps, but

Re: [libreoffice-users] optimal width always

2023-07-12 Thread Brad Rogers
On Wed, 12 Jul 2023 11:13:41 +0200 hw wrote: Hello hw, And adding to my previous; If you select the entire sheet, then right click on a column and select "Optimal Width...", guess what happens (rhetorical question). -- Regards _ "Valid sig separator is {dash}{dash}{space}" /

Re: [libreoffice-users] optimal width always

2023-07-12 Thread Brad Rogers
On Wed, 12 Jul 2023 11:13:41 +0200 hw wrote: Hello hw, >field at the top left sets all columns to optimal width. That field >currently has no function at all. It selects the entire sheet. Of little use, perhaps, but that certainly isn't 'no function at all.' -- Regards _ "Valid

Re: [libreoffice-users] optimal width always

2023-07-12 Thread hw
On Tue, 2023-07-11 at 15:07 -0400, James wrote: > It's a great idea for a feature. > > I don't know how hard it would be to add a checkbox beside column type > to make the column the automatic width. No checkbox needed, just make it so that a right click on the empty field at the top left sets

Re: [libreoffice-users] optimal width always

2023-07-11 Thread James
It's a great idea for a feature. I don't know how hard it would be to add a checkbox beside column type to make the column the automatic width. You can record a macro and see if that works but it is probably easier to manually do it each time. -- To unsubscribe e-mail to:

Re: [libreoffice-users] optimal width always

2023-07-11 Thread hw
Nobody has an idea? It should be possible using a macro, shouldn't it? On Sun, 2023-07-09 at 11:50 +0200, hw wrote: > Hi, > > how can make it so that when opening files, especially CSVs, with calc, > the whole sheet is automatically being set to optimal column width? > > I have to do that

Re: [libreoffice-users] optimal width always

2023-07-09 Thread jean-francois
Hi, Le 09/07/2023 à 11:50, hw a écrit : Hi, how can make it so that when opening files, especially CSVs, with calc, the whole sheet is automatically being set to optimal column width? I don't know of any *automatic* way to do so. But... I have to do that manually every time and that's

[libreoffice-users] optimal width always

2023-07-09 Thread hw
Hi, how can make it so that when opening files, especially CSVs, with calc, the whole sheet is automatically being set to optimal column width? I have to do that manually every time and that's really annoying, especially since there's no easy way to do that, like right-clicking on the top left