https://bugs.documentfoundation.org/show_bug.cgi?id=143183
Olivier Hallot <olivier.hal...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Blocks| |80430
Ever confirmed|0 |1
--- Comment #3 from Olivier Hallot <olivier.hal...@libreoffice.org> ---
The printfmtstr extra codes for strings may return unexpected values if not
carefully coded in Basic
msgbox Format("FooBar", "!!abc") '=> "F" (everything after initial "1" is
discarded)
msgbox Format("123.456", "!") '=> return !
msgbox Format("123.456", "!!abc") '=> return !!abc
msgbox Format("123.abc456", "!!abc") '=> return 1
So, if the string contents is a valid number, the '!' format string return the
format string itself.
otherwise, return the first character of the input string.
Also the "&" format code seems to return the format string itself.
msgbox Format("ADCDEFGHIJKLMNOPQRSTUVWXYZ1234567890", "&abc")
msgbox Format(123.456, "&abc")
msgbox Format("123.456", "&abc")
all return &abc.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=80430
[Bug 80430] [META] Documentation gap for new features
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs