jimjag opened a new pull request, #523:
URL: https://github.com/apache/openoffice/pull/523

   This brings the OpenFormula work on the openformula branch: Pedro's audit 
and milestone work, and the fixes and additions on top of it.
   
   - New functions IFNA, SKEWP and IFERROR, each with a help topic linked from 
the function lists.
   - Formulas can hold 2048 tokens (was 512), a function takes up to 255 
arguments, and a string literal can be 32767 characters long.
   - BITAND, BITOR, BITXOR, BITLSHIFT and BITRSHIFT give Err:502 for an operand 
of 2^48 or more. COUNTBLANK counts a formula returning "" as blank. DCOUNT and 
DCOUNTA without a field count every matching record.
   - xls and xlsx: IFNA, IFERROR, SKEW.P and the bit functions use Excel's 
`_xlfn.` names, so Excel calculates them from an xls we write and they load 
from xlsx.
   
   The details and the known limitations are in 
`odf_docs/openformula-release-notes.md`, the audit notes in `odf_docs/`, the 
test cases in `test/odf-validate/`.
   
   Tested with the calcval cases and the formula checks on Linux aarch64 and 
macOS, and with Excel 16 reading the xls files Calc writes. The branch is 
behind trunk but merges into it without conflicts.
   
   Based primarily on Pedro's work with Jim adding stuff hither and yon.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to