Page 1 of 1
Inadmissible value or data type. Index out of defined range.
Posted: Fri Jun 11, 2021 8:25 am
by jarkky
- error_range2
- Screenshot from 2021-06-11 14-19-13.png (9.74 KiB) Viewed 3564 times
I get this message if I try to write cells beyond AMJ, for example AMK1...
Can I increase the 'defined range' to larger somehow?
Below is ok:
Sheet.Columns(1023).width=500
Then fail:
Sheet.Columns(1024).width=500
- error_range
Below is ok:
Sheet.getCellRangeByName("A7:AMJ9").clearContents(Flags)
Then fail:
Sheet.getCellRangeByName("A7:AMK9").clearContents(Flags)
--
Jari
Re: Inadmissible value or data type. Index out of defined ra
Posted: Fri Jun 11, 2021 10:10 am
by robleyd
Calc only has 1024 columns; A to AMJ
Re: Inadmissible value or data type. Index out of defined ra
Posted: Sat Jun 12, 2021 12:40 pm
by keme
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.