Format function's format string takes up to four sections separated by semicolons. The fourth section is for Null values.
This is defined in SbxValue::Format, which handles SbxNULL values explicitly, calling SbxBasicFormater::BasicFormatNull. However, calling
> Format(Null, ";;;""NNN""")
results in "Inadmissible value or data type. Data type mismatch" error.
This works in VBA : the former call returns "", and the latter returns "NNN".
Version: 126.96.36.199.alpha0+ (x64) / LibreOffice Community
Build ID: 0aea0cee58fe77a9058217dfdfc3d6a02b29ee2a
CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (de_DE); UI: en-US
I am trying to work on tdf#143193. Is Null supposed to be a correct data type? It doesn't seem to recognize it as one.