Inadmissible value or data type. Index out of defined range.
Inadmissible value or data type. Index out of defined range.
Can I increase the 'defined range' to larger somehow?
Below is ok:
Sheet.Columns(1023).width=500
Then fail:
Sheet.Columns(1024).width=500
Below is ok:
Sheet.getCellRangeByName("A7:AMJ9").clearContents(Flags)
Then fail:
Sheet.getCellRangeByName("A7:AMK9").clearContents(Flags)
--
Jari
OpenOffice 3.1 on CentOS Linux release 8.0.1905 (Core)
Re: Inadmissible value or data type. Index out of defined ra
Calc only has 1024 columns; A to AMJ
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Re: Inadmissible value or data type. Index out of defined ra
LibreOffice Calc offers the extended grid (matching Excel's space provision) as an experimental feature, if I'm not terribly mistaken. LibreOffice is built on the same foundation as OpenOffice, so you will easily find your way around it.
"Experimental" means that you need to enable it in some settings dialog, and it may not be available in the "still" (more thoroughly tested, or "previous") version, I dont know. Posting from my phone, so I can't test it right now, nor give you the exact path to the setting.
If you explain your reason for needing all those columns, someone may be able to suggest a better approach. That is a lot of columns. Certainly, there are cases when utilizing all those columns is the sensible choice, but more often than not there is a better way.
"Experimental" means that you need to enable it in some settings dialog, and it may not be available in the "still" (more thoroughly tested, or "previous") version, I dont know. Posting from my phone, so I can't test it right now, nor give you the exact path to the setting.
If you explain your reason for needing all those columns, someone may be able to suggest a better approach. That is a lot of columns. Certainly, there are cases when utilizing all those columns is the sensible choice, but more often than not there is a better way.