[Libreoffice-bugs] [Bug 119057] ADDRESS function >> syntax of formula is changed after saving, if "ABS" argument is empty (hand input)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Aug 2 11:02:47 UTC 2018


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

--- Comment #1 from kompilainenn <79045_79045 at mail.ru> ---
(In reply to Andrey from comment #0)
> Description:
> Result of formula calculation doe not changed. Changes only syntax (text) of
> formula
> 
> Steps to Reproduce:
> 1. Run LibreOffice calc
> 2. Enter following formulas to A1 cell:
> =ADDRESS(1,1,)
> 3. Enter following formulas to A2 cell:
> =FORMULA(A1)
> 4. Save and close the file, and reopen it
> 5. Observe result in A2 cell
> 
> Actual Results:
> =ADDRESS(1,1,1)
> 
> Expected Results:
> =ADDRESS(1,1,)

Why do you use "," for separation of arguments? You should use ";" for that

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180802/05eb365c/attachment.html>


More information about the Libreoffice-bugs mailing list