After some deliberation I decided to open a request for enhancement which can be found here
If you can close it, you should be able to open it.
It is a trivial matter but I feel that this could be easily corrected.

I am really fighting it tonight. Among other things I accidentally undocked the watch window and couldn't get it to dock again. I closed it now and it is gone an I cant find anywhere to reshow it. How do I get the watch window back? And now I have undocked the call stack window and it too will not d...

Stupid Basic where a variable can be empty, missing, null, nothing in addition to the regular types: # Online Python compiler (interpreter) to run Python online. # Write Python 3 code in this online editor and run it. def foo(s): print(type(s)) foo(12) foo("foo") foo(None) # foo() obvious...

Yes I could have used a dialog.
I already implemented your other suggestion, an array/collection of objects.
Thanks, I will keep that in mind for future reference.

Villeroy, you are guessing and you shouldn't guess. This form is simply for getting data into the tables. The format of the source data is beyond my control The data comes from the clipboard as unformatted text that has to be cleaned up and delimited. The labels are simply to display what was delimi...

For me it is a lack of a grid control that started this. So instead of a grid I have 80+ label controls but they didn't get added with consecutive indexes. In order to use them in processing I have to either access them by name or by index. I see no possibility of changing the indexes of existing co...

Final edit: Ratslinger has found the (simple) solution to the control positioning and you can find it here The anchor type property needs to be changed to 'At Page'. Edit: A flaw has been discovered and it renders the method shown here as useless (at this point). A control that has been dynamically ...

Excellent answers, thank you very much.

Thank you all.

I had a crash and the restoring did not recover a bunch of code I had in a couple of libraries.
Luckily I found it elsewhere.
Backing up a LibreCalc sheet doesn't seem to include Library files.
I would like to backup library files. Is it possible?

I am just trying to reduce a big block of code where 8 sets of row and column titles are repeated over non-contiguous blocks.

Is it possible to use non contiguous ranges in some calls such as in this example?

Ok, I see.
Thank you very much.

For some reason the code below does not remove the conditional formats on a range of cells. option compatible option explicit public sub testt() dim oSheet as object dim oC as object dim n as integer, x as integer oSheet = ThisComponent.sheets.getByName("Sheet1") for n = 0 to 9 oC =oSheet....

My eyes are the problem. I have used class_initiate instead class_initialize. Yikes. Sorry. But sadly it still doesn't seem to work after correcting that mistake. I get 'object variable not set on the n.item(1) line. As to why care; the only real reason would be to add a 'known issue' to documentati...

It wouldn't let me put LibreOffice as a signature. I am a newbie to this forum and don't get the necessity of a signature. I will remove it if possible. Edit: it is changed. I can see how the different package may change the answers given. I posted the question to the suggested intermediate site rat...

It is not only possible in VB6 it is also possible in VBA From https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/property-let-statement [ Public | Private | Friend ] [ Static ] Property Letname ( [ arglist ], value ) [ statements ] [ Exit Property ] [ statements ] En...

You honestly believe that ignoring the second parameter may have been intentional?
You are generous.

Yes, JeJe that is a workaround.
It seems to me however that, since everything I have read says property indexing should work, that this is a bug.
But thanks to both responders.

Why does this not work as expected? I have this class (CTest) with an array member that I want to set using an indexed property let statement option Compatible option ClassModule option Explicit private _n() as integer private sub class_initiate() redim _n(1 to 10) end sub public property let item(b...

Expanding on what ZiZi64 said:
I note this because it may not be obvious or easy to find how to create the criterion where the cell is anything but empty.
That seems to be done with the "=".

Hello, I have been looking at this and I really don't think you need a programming solution. At least not yet. Start by making a Team List page that includes a list of all the teams and their corresponding pitching stat. Add a Matchups page that uses two columns; Column A is the team name and Column...