Problems with formulas and zeros

Problems with formulas and zeros

Posted by: brooksby on 6 December 2017, 9:31 am EST

• 

  brooksby

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 December 2017, 9:31 am EST

  If I load the attached spreadsheet into either of the Spread.Sheets demo programs I can find online, it appears correctly. This is true on Windows and iOS. However, if I build an iOS app using Cordova and load this same sheet into spread.sheets, some of the formula results do not display and those cells with zeros do not display zeros. Can you tell me of anything that would prevent zeros or formula results from displaying?

  Template_rev1-out - Gutted.zip

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 8 December 2017, 1:51 am EST

  Hello,

  It must be an HTML page where you are using Spread.Sheets to load the Excel file in you iOS page.
  
  Could you please provide me the sample page you created with Cordova to test at my end?
  
  I have aslo asked our dev team(tracking id #251322) if there are any known issues like that?

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 16 January 2018, 1:25 am EST

  Hello,

  We have tested this case with the Cordova 7.1.0 in IPad Air2 and ios is 11.2. Devs could not reproduce this issues.
  
  Steps we followed to replicate the issue:

  1. Load the excel file in pc and generate the json and save the json to a .js file.
  2. Using Cordova to build the app and load the json from this js file.

  Please refer to the attached video and project.

  Thanks,
  
  Deepak SharmaCalcTest.zip

• 

  brooksby

  • Post Options:
  • Link
    Copy

  Posted 3 May 2018, 2:40 am EST

  We have downloaded your CalcTest.zip file and created an example Cordova app from it that runs on an iPad. We used the SpreadJS ExcelIO function to produce JSON from a different spreadsheet. That spreadsheet is in the attached zip file (ca-formula-test.xlsx). When we substitute this JSON for the JSON in your example, we get errors in the outputs for the formulas. You can swap in our JSON by using the included file tjson-grc.js in place of your tjson.js.

  When the application runs you will see errors in the formulas. You can see these errors by comparing the two image files.

  Files in this zip file:
  
  ca-formula-test.xlsx: Excel file that generated the included JSON.
  
  tjson-grc.js: JSON file from the attached Excel (.xlsx) file.
  
  Excel_Screenshot.png: Results of loading the file in Excel.
  
  iPad_Screenshot.PNG: Results of loading the file in a Cordova app, using SpreadJS.

  Test.zip

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 3 May 2018, 9:50 pm EST

  Hello,

  I have provided the JS file to developer for further testing. I will let you know as soon as I get an update on this.

  Thanks,
  
  Deepak Sharma

• 

  brooksby

  • Post Options:
  • Link
    Copy

  Posted 14 May 2018, 4:35 am EST

  Has there been any further progress on this issue yet?

  Thanks,
  
  Glen

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 14 May 2018, 4:52 pm EST

  Hello,
  
  This issue will be fixed in our upcoming biweekly build of SpreadJS. I will provide you the link once it is released.

  Thanks,
  
  Deepak Sharma

• 

  brooksby

  • Post Options:
  • Link
    Copy

  Posted 21 May 2018, 7:26 am EST

  I see there was a version out on 17 May. Is that the build to which you were referring or will it be two weeks from that date?

  Glen

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 May 2018, 4:18 pm EST

  Hi Glen,

  You can download the biweekly build from the link below:
  
  http://cdn.grapecity.com/spreadjs/11.1.1/Files/SpreadJS.Release.11.1.1.zip

  Thanks,
  
  Deepak Sharma