Bug 106671 - Macro function returns initially #NULL! which is wrong value
Summary: Macro function returns initially #NULL! which is wrong value
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: x86-64 (AMD64) All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro
  Show dependency treegraph
 
Reported: 2017-03-21 08:25 UTC by Harri T.
Modified: 2019-08-11 11:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Calc sheet for reproducing the issue (8.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-03-21 08:25 UTC, Harri T.
Details
Calc sheet for reproducing the issue (8.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-03-21 15:06 UTC, Harri T.
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Harri T. 2017-03-21 08:25:36 UTC
Created attachment 132040 [details]
Calc sheet for reproducing the issue

Steps to reproduce the problem:
1. Open the attached spreadsheet with macros enabled.
2. The values of cells A1 and B1 are #NULL!
3. Edit the macro function MySum (e.g. add dummy space at the end) and save it.
4. Edit the formulas in cells A1 and B1 (e.g. add dummy space at the end).
5. The values change from #NULL! to numeric.

Test enviroments:
- Debian Linux 9.0, 64-bit, LibreOffice 5.2.5.1
- MS Windows 8.1, 64-bit, LibreOffice 5.1.6.2
Comment 1 Harri T. 2017-03-21 15:06:05 UTC
Created attachment 132048 [details]
Calc sheet for reproducing the issue
Comment 2 Buovjaga 2017-03-26 17:31:13 UTC
Repro.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: 54f9a81a1c041c18d209d7eb4659ac18a3ca76dd
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 25th 2016
Comment 3 QA Administrators 2018-03-27 02:28:46 UTC Comment hidden (obsolete)
Comment 4 Buovjaga 2019-08-11 11:52:58 UTC
No problem anymore: A1 and B1 display 2 instead of #NULL!

Arch Linux 64-bit
Version: 6.4.0.0.alpha0+
Build ID: 37fc9f51a8de11d40632e8cda17ccf1fa4b1f503
CPU threads: 8; OS: Linux 5.2; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 6 August 2019