https://bugs.documentfoundation.org/show_bug.cgi?id=167036
Bug ID: 167036
Summary: Err:508 when macro inserts REGEX function into a cell
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Macro sets the formula of a cell to the REGEX function.
After running the macro, the cell shows "Err:508". After saving the document
and reloading, the cell displays the calculated formula successfully.
Steps to Reproduce:
1. Create this macro:
sub InsertFormula
ThisComponent.Sheets(0).getCellRangeByName("A1").Formula = "=REGEX(""Foo"",
""o"", ""b"")"
end sub
2. Open a worksheet and run the macro on it.
Actual Results:
cell A1 shows "Err:508"
Expected Results:
cell A1 shows "Fbo"
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 24.2.5.2 (AARCH64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 8; OS: macOS 14.7.4; UI render: Skia/Raster; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
