Hello,
We are creating excel file with suitescript having dynamic formulae column and it is shown properly like given below but when it is converted from xml to excel then it changes to different version and formulae does not work.
We need this to work when excel is downloaded and values to shown as per given formulae when opened.
Issue Observed
After:
- Converting the SpreadsheetML XML to Base64 using N/encode
- Creating the .xls file using N/file
- Opening the generated Excel file in Microsoft Excel
the displayed formula becomes: =SUM('B3':'B14')
Quick help is appreciated!!