Spreadsheet - Formula is not parsed correctly when Spanish culture is applied

Juan Campos 1

created 9 years ago

[DevExpress Support Team: CLONED FROM T320595: Problem SpreadSheet MVC culture]
Hi,
I'm using Devexpress v15.1 MVC

I have problem with SpreadSheet culture, i'm using cultures "es-ES".
spreadsheet1.Document.Options.Culture = new System.Globalization.CultureInfo("es-ES");

In culture "es-ES" the following formula =TEXTO(D4;"0,00E+00") don't work show #VALOR and value cell D4 is 10000
but in culture "en" the following formula =TEXT(D4, "0.00E+00") work.

I'm using default Riboon
settings.RibbonMode = SpreadsheetRibbonMode.Ribbon;
This Ribbon have option "Protect Sheet"

Thanks.

Answers approved by DevExpress Support

DevExpress Support Team

created 9 years ago

We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

Comments (2)

hao pham 8 years ago

It seems that you only fix bugs for Spanish culture. Please fix formula error when changing NumberDecimalSeparator:
SpreadsheetControl.Document.Options.Culture.NumberFormat.NumberDecimalSeparator = ",";

DevExpress Support Team 8 years ago

Hello,

When you change the CultureInfo.NumberFormat.NumberDecimalSeparator property value, a SpreadsheetControl does not receive a notification that culture settings have been changed. So, if you change the number separator settings after formulas are entered, they will not be updated.

If you wish to change culture settings after the formulas are entered (a document is loaded), change the SpreadsheetControl.Document.Options.Culture property value. See the code below for clarification:

C#
CultureInfo culture = (CultureInfo)spreadsheetControl.Document.Options.Culture.Clone();  
culture.NumberFormat.NumberDecimalSeparator = ",";  
spreadsheetControl.Document.Options.Culture = culture;

If your scenario is different, please send us a small sample that shows it. We will research your project on our side.

Spreadsheet - Formula is not parsed correctly when Spanish culture is applied

Answers approved by DevExpress Support

Recently viewed tickets