Re: [libreoffice-users] optimal width always
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. > Consequently, > for my use case, a sheet that could otherwise be printed on one piece > of > paper ends up requiring two, or more. Who still prints stuff? :) > Point is; Uses for all of us differ. Your use case differs from > mine. right > Satisfying your itch may well upset other users' work methodology. How would it break someones methodology to right or middle click on the empty field which currently does nothing? If someone feels the need to do that without something happening I can as well argue that nothing must happen no matter where they click because something happening could interrupt them when they click. As to setting optimal width when opening a file, it would of course have to be an option that needs to be enabled first (for different types of files). Nothing of I suggest would upset or break or interrupt anything. > In any case, the 'box' at top left corner of each sheet isn't, in > fact, > a box at all - it's an artifact of the column and row markers. > Nothing > more. That's not true, it selects the whole sheet when you left click it. If were merely an artifact, it would do nothing. > > 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 you will. Yes, by me and probably by a lot of other users. You would never need to use it. However, my original question is how I could accomplish such functionality, like writing a macro to do it. Are there commands or functions or something in libreoffice BASIC (or python) that select the whole sheet and set the optimal column width? I haven't found anything like that yet. Yet it's basically all that needs to happen, so how hard can it be? Perhaps someone more knowledgeable about this kind of programming could give some hints. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 key?" What the hell has this place done for me? Selfish Rubbish - Public Image Ltd -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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. Currently nothing happens. But I wouldn't mind if it had a menu with items like 'Clear Direct Formatting', 'Set Optimal Width', 'Auto Filter', 'Sort ...' and whatever else would be appropriate which all operate on the whole sheet without having to select it first. > What exactly does "select the entire sheet" have to do > with "optimal width"? When setting the optimal column width, it's almost always much easier to select the whole sheet before doing so, instead of painstakingly selecting each of the columns the width of which is not optimal (by going through the whole sheet to find them). If right or middle clicking the empty field would simply set all columns to their optimal widths, it won't even be necessary to select the whole sheet before setting the optimal width. Of course, in case you want to set the width of a single column, it's easier to make the particular column wider and it doesn't always need to be optimal. And you can still do that. > From outside the discussion, it seems like you're confusing > "function" with > "bug". Seems normal for LibreOffice these days. Dunno, it's probably not a bug that the functionality isn't there; only it hasn't been implemented yet. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 think I am, then you've misread or misunderstood something. Anyhow, I've already wasted far more time on this than I intended, so I'll leave it here. -- 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 key?" I'm doubling the rent 'coz the building's condemned Let's Lynch The Landlord - Dead Kennedys -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
"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. On Wed, Jul 12, 2023 at 4:19 AM 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 that certainly > isn't 'no function at all.' > > -- > 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 key?" > Just stop and take a second > U & Ur Hand - P!nk > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 man's meat" and all that... -- 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 key?" Hey there, Mr Average, you don't exist, you never did Persons Unknown - Poison Girls -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 you will. Indeed, I wasn't even aware that the concept existed until I read this thread. I just tested the feature and it gave a completely unusable spreadsheet layout as a result, so I'll now forget it exists :) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 two, or more. Point is; Uses for all of us differ. Your use case differs from mine. Satisfying your itch may well upset other users' work methodology. In any case, the 'box' at top left corner of each sheet isn't, in fact, a box at all - it's an artifact of the column and row markers. Nothing more. >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 you will. -- 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 key?" Junk floats on polluted water Hong Kong Garden - Siouxsie & The Banshees -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 can't that happen automatically when loading a file, or at least with a single right click on the empty field. Having to click and to find and select the desired function from a more or less long list after making another click is the opposite of user friendly. Not only every time I open a spreadsheet I have to do that --- except for the rare cases where I previously opened one and adjusted the column width and saved it in a format that remembers it --- I also have to do it after altering some of the columns and changing their contents so they require a different width. It is actually the most-used functionality when working with spreadsheets, followed by copying and pasting. Why is there no key binding for it? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 that certainly > isn't 'no function at all.' Ah yes, right --- still that leaves two mouse buttons that don't have any function at all on this field. That's the majority of buttons ;) Why not use them. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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}" / ) "The blindingly obvious is never immediately apparent" / _)rad "Is it only me that has a working delete key?" Chose to play the fool in a six piece band What A Waste - Ian Dury And The Blockheads -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 sig separator is {dash}{dash}{space}" / ) "The blindingly obvious is never immediately apparent" / _)rad "Is it only me that has a working delete key?" Just stop and take a second U & Ur Hand - P!nk -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 all columns to optimal width. That field currently has no function at all. > You can record a macro and see if that works but it is probably easier > to manually do it each time. How do I record a macro? There doesn't seem to be an option for that? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 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 empty square every sheet has. > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
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 really annoying, especially since there's no easy way to do that, like right-clicking on the top left empty square every sheet has. you aren't that far: 1. click the top left empty square so that the whole sheet is selected, 2. double-click any column boundary. This causes *all* column widths to adjust to their contents. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy