search

telerik / kendo-ui-core

An HTML5, jQuery-based widget library for building modern web apps.
http://www.telerik.com/kendo-ui
Other
2.54k stars 1.91k forks source link

Ceiling.Math formula is not imported correctly in Spreadsheet from Excel #5930

Open nelito987 opened 4 years ago

nelito987 commented 4 years ago

Bug report

When CEILING.MATH formula is used and the file is imported from Excel, the imported formula has '_xlfn' in front and the result is not correct (it is #NAME?).

Reproduction of the problem

  1. Open the Spreadsheet Demos
  2. Import the following file TestCeiling.xlsx

Current behavior

The value in the B1 cell is '#NAME?' and the formula for the B1 cell has a redundant prefix "=_xlfn.CEILING.MATH(A4)"

Expected/desired behavior

The formula should not have a prefix and should return the correct result.

Environment

mishoo commented 3 years ago

Apparently the problem here is that you imported the file in a version of Excel that doesn't have the CEILING.MATH function, so it automatically added the _xlfn prefix; then if you saved it from Excel, the prefix gets into the XLSX (so it's not something that our spreadsheet added). See here: https://www.myspreadsheetlab.com/i-see-xlfn-what-is-happening-2/

nelito987 commented 2 years ago

@mishoo I am reopening the issue as it is also replicated with DAYS function if I create a new file in Excel 2016 (which supports the DAYS function). Then when the file is imported in the Spreadsheet '_xlfn' is added in the formula. TestDays.xlsx