Formulas are translated according to Region format

Formulas are translated according to Region format

Posted by: petri.rasanen on 6 June 2019, 7:30 pm EST

• 

  petri.rasanen

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 June 2019, 7:30 pm EST

  Hi,

  I updated Spread.NET 12 to SP1. Now the formulas are translated according to Region format. This happens also in Spread Designer. You can test this changing the region format setting to Finnish (Finland). Is there anyway to prevent this, some property maybe?

  Br,
  
  Petri

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 10 June 2019, 9:44 pm EST

  Hello Petri,

  Could you please share a screenshot of the issue? Also, what is your system culture set to?

  Thanks,
  
  Ruchir

• 

  petri.rasanen

  • Post Options:
  • Link
    Copy

  Posted 10 June 2019, 11:18 pm EST - Updated 30 September 2022, 4:50 am EST

  Hi,

  Screenshot is from Spread Designer (also happens in spread component).

  Br,
  
  Petri

  

  1536×953 47.8 KB

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 13 June 2019, 12:21 am EST

  Thank you Petri.
  
  This behavior seems to be consistent with the behavior mentioned in Spread12 documentation. For reference, please refer following documentation page:
  
  https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#spwin-useregional.html
  
  Thanks,
  
  Ruchr

• 

  petri.rasanen

  • Post Options:
  • Link
    Copy

  Posted 13 June 2019, 7:21 pm EST

  Hi,

  This will be an issue on our tests that checks formulas are correct, because this now depends on region format. Hope there will be some kind of property for these translations in future version.

  Br,
  
  Petri

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 16 June 2019, 11:17 pm EST

  Hi,

  We’re discussing this with the developers [Internal Tracking ID: 273360].
  
  I’ll update this thread once we have more information.

  Thanks,
  
  Jitender

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 19 June 2019, 9:59 pm EST

  Hi Petri,

  You can explicitly specify a Language using this code:
  
  fpSpread1.AsWorkbook().WorkbookSet.LanguagePackage = GrapeCity.Spreadsheet.Localization.LanguagePackage.English;

  Note that you will need to specify this before setting any formulas in cells.

  Also, if you’re loading your data from an excel file, you would need to specify the Language pack again (this would be fixed in future so that Spread remembers the previously set Language when opening an Excel file).

  Regards,
  
  Jitender