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

            Bug ID: 170437
           Summary: Document how LibreOffice treats non-integer values for
                    function parameters, that expect integer values
           Product: LibreOffice
           Version: 26.8.0.0 alpha0+ master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected]

The ODF standard has in section 'Convert to Integer' (6.3.6 in part 4, ODF 1.4)
the sentence,
"If the function or operator does not specify any particular conversion
operation, then the conversion from a non-integer Number into an integer is
implementation-defined."

"implementation-defined" means, that LibreOffice has to document its behavior.

A specification is missing in
https://wiki.documentfoundation.org/Development/ODF_Implementer_Notes/List_of_LibreOffice_ODF_implementation-defined_items#Conversion_to_Integer

I suggest to add a general remark there:
"Non-integer values are truncated to integer. If a function has a special
behavior in regard to a parameter, that requires data type Integer, its
behavior is described in the online help of that function."

I have not yet collected all functions that expect data type Integer for a
parameter. Several financial functions and ADDRESS are affected, for example.

Thus besides the general remark in the Wiki, the task here is to collect the
affected functions, and look, whether they behave different than truncating.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to