[Solved] Runtime error in UNO af file 257

[alan_m6]

hi All,
I have a piece of code that is used to analyse text files produced from an oracle database. the files have exactly the same format and layout.

whilst using MS excel i can load thousands of files however i hit a limit of 257 files when using calc.
the reported error is as follows

ERROR: com.sun.star.uno.RuntimeException:

Does anyone have any idea what this error indicates?

regards

Alan

[RoryOF]

There are "magic numbers" in computing, all powers of 2. One of these is 256, so an error at 257 suggests you have hit an inbuilt limit to the number of files.

[alan_m6]

There are "magic numbers" in computing, all powers of 2. One of these is 256, so an error at 257 suggests you have hit an inbuilt limit to the number of files.

Thanks for the reply. I hope that this is not the case. if so it seems to limit the functionality of calc severely.

regards

Alan

[John_Ha]

You may find LibreOffice has a higher limit.

[Hagar Delest]

You may be limited by the max number of sheets that is 256 in AOO IIRC.
In LibreOffice, it's 10000.

[alan_m6]

You may be limited by the max number of sheets that is 256 in AOO IIRC.
In LibreOffice, it's 10000.

ok, possibly that is the issue. Excel has more or less unlimited sheets.

ok then its a sad day for the venture away from MS office.

thanks for the help.

[RoryOF]

It may be that a spreadsheet is not the optimum tool to do your task. It might perhaps be better handled using customised reports from the originating database.

[alan_m6]

It may be that a spreadsheet is not the optimum tool to do your task. It might perhaps be better handled using customised reports from the originating database.

Oracle has 2 types of reporting tools, a free option or a high cost option which also requires a high cost version of the database. we talk in terms off £30k per core license for the database and then £11k per core option to report. the numbers dont add up.

looks like its excel for now then

thanks for the replies.

[Hagar Delest]

Have you tried LO?
Don't you know what does your code exactly? To check if it's a number of sheets issue or something else?

[alan_m6]

OK have installed LO and that works a treat, so it's bye bye OpenOffice

Regards

Alan