| Summary: | TRANSPOSE: error when the number of array elements exceeds 16384 | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Vladimir Sokolinskiy <sokol> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | minor | CC: | buzea.bogdan |
| Priority: | low | ||
| Version: | 7.4.2.3 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 108479 | ||
Yes of course. sheet::FunctionAccess uses a temporary spreadsheet to do its calculations. The maximum number of columns is 16384. ot: With python you would not need such »css.sheet.FunctionAccess« workaround! ```python b = tuple(zip(range(100000))) ``` |
Run Basic script: Sub Test Dim oFA, arr(16384), arr2 oFA=createUnoService("com.sun.star.sheet.FunctionAccess") arr2=oFA.callFunction("TRANSPOSE", Array(Array(arr))) End Sub An error occurs. If you replace 16384 with a smaller number, then there is no error.