Bug 38933 - python add-in cannot return array in calc in-cell function
Summary: python add-in cannot return array in calc in-cell function
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected)
3.5.0 Beta2
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Extension-Manager Macro-Python
  Show dependency treegraph
Reported: 2011-07-03 11:40 UTC by kurt forrester
Modified: 2022-11-21 07:48 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

the project that fails to return an array in the spreadsheet (6.29 KB, application/zip)
2011-07-03 11:40 UTC, kurt forrester
No numpy (52.81 KB, image/jpeg)
2011-07-03 13:52 UTC, noname
a version of the addin without numpy (3.02 KB, application/vnd.openofficeorg.extension)
2011-07-03 13:56 UTC, kurt forrester

Note You need to log in before you can comment on or make changes to this bug.
Description kurt forrester 2011-07-03 11:40:28 UTC
Created attachment 48712 [details]
the project that fails to return an array in the spreadsheet

the project that fails to return an array in the spreadsheet

I have been developing LO add-in for Calc using python. I can successfully
create a in-cell function returning a single value, however, when I try and
convert it to an array function I continually get a value error

I fear there is a bug within the python machinery preventing the correct
returning of the array to the spreadsheet cells. I have attached the package of
the project as I use it. I do hope someone can diagnose and potentially fix
this bug.
Comment 1 noname 2011-07-03 13:51:08 UTC
I can't even install your extension. That's because -by default- numpy isn't installed, at least not under windows [Win2K LibreOffice 3.4.1 OOO340m1 (Build:103)].
Comment 2 noname 2011-07-03 13:52:00 UTC
Created attachment 48713 [details]
No numpy
Comment 3 kurt forrester 2011-07-03 13:56:06 UTC
Created attachment 48714 [details]
a version of the addin without numpy

this is a version of the add-in removing the numpy requirement.
Comment 4 Björn Michaelsen 2011-12-23 12:25:25 UTC Comment hidden (obsolete)
Comment 5 kurt forrester 2011-12-30 14:58:48 UTC
This bug is still present. Tested on Windows 7 and still receive the same error.
Comment 6 QA Administrators 2014-06-25 17:38:03 UTC Comment hidden (obsolete)
Comment 7 Julien Nabet 2014-12-05 18:15:02 UTC
Kurt: any update with last stable LO version 4.3.4 (which uses Python 3.3)
Comment 8 kurt forrester 2014-12-06 09:43:10 UTC
the problem still exists (Windows 8.1 Libreoffice
Comment 9 Julien Nabet 2014-12-06 11:35:56 UTC
Thank you Kurt for your feedback, I put it back to NEW.
Comment 10 QA Administrators 2015-12-20 16:21:37 UTC Comment hidden (obsolete)
Comment 11 QA Administrators 2017-01-03 19:51:17 UTC Comment hidden (obsolete)
Comment 12 nobu 2022-11-21 07:48:53 UTC
Version 7.1.2 or later
It has been confirmed that if you write a code that returns the array, you will return the array as expected.