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]
