mike@RPI4b3:~> uname -a
Linux MikesPI 6.1.0-rpi7-rpi-v8 #1 SMP PREEMPT Debian 1:6.1.63-1+rpt1 (2023-11-24) aarch64 GNU/Linux
Version: 7.4.7.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: x11
Locale: en-US (C); UI: en-US
Raspbian package version: 4:7.4.7-1+rpi1+deb12u8
Calc: threaded
When used as the formula in assigning to a named range in a Calc basic macro these three functions all fail with Err:508 which suggests a missing bracket or paren.
All three give no problem when pasted into a cell in the UI.
Before turning in a bug report I thought to run it by you guys thinking a newer version may have fixed it.
These are the failing formulas:
If((EY5-EX5)>0,10*(EM5-EX5)/(EY5-EX5),0)
If((EY5>EX5),10*(EM5-EX5)/(EY5-EX5),0)
If(EY5>EX5,10*(EM5-EX5)/(EY5-EX5),0)
All nearly the same as I tried to get a working named range.
Thanks,
Mike
Sorry for the omission, this is what Iām using.
Dim oRanges as Object
oRanges = ThisComponent.NamedRanges
If NOT oRanges.hasByName(fnName) Then
oCellAddress = oCell.getCellAddress()
ā addNewByName( aName as string, aContent as string, aPosition as struct, nType as long )
oRanges.addNewByName(fnName, fnStr, oCellAddress, 0)
End If
Where fnStr is one of the above formulas.
And the instruction to make the assignment to the cell is:
Cell.formula = ā=rangeNamedā
Iāve made many named range assignments and this is the only formula that is giving problems.
The Calc UI is not at all involved.
Mike