FpSpread doesn't load correctly excel generated file from Spread.Services

FpSpread doesn't load correctly excel generated file from Spread.Services

Posted by: ivan.dimitrov on 10 June 2021, 1:59 am EST

• 

  ivan.dimitrov

  • Post Options:
  • Link
    Copy

  Posted 10 June 2021, 1:59 am EST

  Hi,
  
  I’m facing a issue with trying to load Spread.Services generated excel file with cells that have NumberFormat = “#,##0.0” in FpSpread. The control doesn’t show the thousands separators for the cells with NumberFormat = “#,##0.0”. If the format is different “#,##0” or “#,##0.00” the cells are correctly loaded with their thousands separators.
  
  Best Regards,
  
  Ivan Dimitrov

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 13 June 2021, 8:17 pm EST

  Hi Ivan,

  Can you please mention if this happens in a specific culture and attach a sample excel file so that we can investigate it?

  Thanks,
  
  Jitender

• 

  ivan.dimitrov

  • Post Options:
  • Link
    Copy

  Posted 13 June 2021, 11:09 pm EST

  Hi,
  
  I’m not using specific culture.
  
  The attached file is the result of the following example code and it gets opened after saving from Spread.Services.

  
        var workbook = new GrapeCity.Documents.Spread.Workbook();
        var worksheet = workbook.Worksheets[0];
        worksheet.Range[2, 2].Value = 2333.2;
        worksheet.Range[2, 2].NumberFormat = "#,###0.0";
        workbook.Save(path);
        fpSpread.Open(path);
  
  

  The expected value in the 2,2 cell would be 2,333.2test.zip

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 14 June 2021, 11:05 pm EST

  Hi,

  Thanks for the sample Excel file. We can reproduce the issue and we’ve asked the developers to take a look at this [SPNET-17779].
  
  We’ll update this thread once we get more information on this.

  Regards,
  
  Jitender