[Libreoffice-bugs] [Bug 119057] New: 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 08:03:20 UTC 2018


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

            Bug ID: 119057
           Summary: ADDRESS function >> syntax of formula is changed after
                    saving, if "ABS" argument is empty (hand input)
           Product: LibreOffice
           Version: 6.0.6.1 rc
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dp060593daa at gmail.com

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,)



Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Additional Info:
Version: 6.0.6.1 (x64)
Build ID: dc68ad6c5cde3c62874b96422f2e5e8252499bad
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: en-US (en_US); Calc: CL

-- 
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/7a87d76f/attachment-0001.html>


More information about the Libreoffice-bugs mailing list