Bug 152543 - TRANSPOSE: error when the number of array elements exceeds 16384
Summary: TRANSPOSE: error when the number of array elements exceeds 16384
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.2.3 release
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste-Special
  Show dependency tree / graph
 
Reported: 2022-12-16 11:58 UTC by Vladimir Sokolinskiy
Modified: 2023-05-12 05:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Vladimir Sokolinskiy 2022-12-16 11:58:56 UTC 
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.
Comment 1 Eike Rathke 2022-12-16 17:08:09 UTC 
Yes of course. sheet::FunctionAccess uses a temporary spreadsheet to do its calculations. The maximum number of columns is 16384.
Comment 2 Werner Tietz 2022-12-19 19:12:23 UTC 
ot:
With python you would not need such »css.sheet.FunctionAccess« workaround!

```python
b = tuple(zip(range(100000)))
```