https://bugs.documentfoundation.org/show_bug.cgi?id=173905

--- Comment #2 from [email protected] ---
Created attachment 209084
  --> https://bugs.documentfoundation.org/attachment.cgi?id=209084&action=edit
Err:514 for MY_FACTORIAL(5), (1), (2); Err:511 for SQ_TEST(4)

Reproduced with the same build as the reporter (70e6dd0e).

1. Sheet > Named Ranges and Expressions > Define: name MY_FACTORIAL, expression
=LAMBDA(n;IF(n>1;n*MY_FACTORIAL(n-1);1)), Add.
2. Sheet > Named Ranges and Expressions > Manage showed
LAMBDA(N,IF(N>1,N*my_factorial(N-1),1)) (the lower-casing from bug 173904). I
corrected it to MY_FACTORIAL and pressed OK.
3. B1: =MY_FACTORIAL(5) -> Err:514; the status bar shows "Internal overflow".

=MY_FACTORIAL(1) and =MY_FACTORIAL(2) also return Err:514, although n=1 should
not need any recursion.

Side note: in the same document a non-recursive named expression SQ_TEST =
LAMBDA(x;x*x) returned Err:511 for =SQ_TEST(4), so I could not establish a
working non-recursive baseline. I have not investigated that further.

The test document is attached above (dev-27.2-173905.ods).

LibreOfficeDev:
Version: 27.2.0.0.alpha0+ (X86_64)
Build ID: 70e6dd0eb1874f0c5e260948b2c8b9e192841372
CPU threads: 20; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: CL threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to