Free Support Forum - aspose.com

Wrong Culture Custom Format gets returned (Germany, Spain, French, and Italy)


#21

@ibmlittleton,

Thanks for providing further details.

We have logged your findings against your issue into our database for investigation. We will look into it thoroughly and get back to you with more details once there is some new information/update to be shared.


#22

@ibmlittleton,

You do not need to traverse all cells in the workbook. For MS Excel’s built-in number formats, the count of them is less than 60, so you just need to cache an array (whose length can be about 60 and index of it corresponds to built-in number) of the built-in formatting patterns corresponding one specific locale. The code like:

Workbook workbook = new Workbook();                
workbook.Settings.Region = CountryCode.USA;                
Style s = workbook.CreateStyle();                
string[] res = new string[60];                
for (int i = 1; i < res.Length; i++)
{                    
    s.Number = i;                    
    res[i] = s.InvariantCustom;                
}

Then, you can use this array to get the custom string for cells in your workbook by checking cell’s style.Number. Please note, if style.Number is 0, then the number format may has not been specified or has been set as custom string.


#23

We would like to understand why the CultureCustom property was changed between versions 17.6.3 and 18.7. We would like Aspose to understand that this is a breaking change for us, and now requires us to write additional code and cache arrays and hope that there are no edge cases requiring the real CultureCustom. Why was this changed and where is the documentation to support this? Frankly, our upper management is questioning our use of Aspose because time and again we take in new jars and get breaking changes like this with no way of using older functions as replacements. This is not how new software should be released, by breaking consumers. Please give me the contact information of a Product Manager as per our enterprise license because we would like to escalate this issue further. Right now, we are highly dissatisfied with this solution and lack of reasoning.


#24

@ibmlittleton,

We are analyzing your comments and will provide our feedback soon.


#25

@ibmlittleton,

The reason is just as we have replied you here: Wrong Culture Custom Format gets returned (Germany, Spain, French, and Italy)
There are too many different settings for different locales so we cannot support all of them at a time. For example, the formatting patterns for Italy, it was not supported in older versions. For unsupported locales, the CultureCustom will give the result same with en_US locale. It is a feature in evolution and will be enhanced by supporting more and more locales according to users’ requirements. And, it is just what happened for locales like Italy/German, the built-in formatting for this locale was required by our customers later, so we supported it in newer versions.

For such kind of change, we usually declare it in the release notes and the change is only attached to corresponding (specific) issue ids which may be posted as a bug (e.g users find the formatted results for the specific locale where their need is not the same with what is shown in MS Excel, then they will report it as a bug) or an enhancement (users inquire whether we can format some cells correctly for some specific locales and we find those locales have not been supported yet, then we will create one ticket as new feature or enhancement to support users’ requirements).

Thanks for your understanding!


#26

Hi Amjad,
Please post a link to the documentation and release notes on this change so that my team can read it and fully understand it. Thank you.


#27

@ibmlittleton,

We will check if we could find and provide you some issue ids/title in the release notes or thread urls (if these are not private). But as we told you that such a change is posted as a bug (e.g users find the formatted results for the specific locale where their need is not the same with what is shown in MS Excel, then they will report it as a bug) or an enhancement (users inquire whether we can format some cells correctly for some specific locales and we find those locales have not been supported yet, then we will create one ticket as new feature or enhancement to support users’ requirements).


#28

We evaluated the option you suggested using Excel’s built-in number formats but this doesn’t work for us.

The entire number format code we currently provide to our customers in the product is based on the culture formats you provided in the version of 17.6.3 and prior,

For instance, following are the formats that are returned (for excel build-in number #38)

Locale code Culture formats returned in version of 17.6.3
IT #,##0_);Red
FR #,##0;[Red]-#,##0
DE #,##0;[Red]-#,##0
ES #,##0_);Red
JA #,##0;[Red]-#,##0
EN #,##0_);Red

formats_returned_in_17.6.3_we_use_in_the_product.png (3.6 KB)

As they are shown above, those formats vary according to locales, which our product has been written based on.

After we upgraded to the version of 18.7/18.10, the entire thing broke.There is no way for us to get these same formats back from new versions. It breaks all of our foreign language customers.

Is there any way you can bring back or retain the same functionalities in new versions of releases?

Will you please help us with this?

I appreciate your support.


#29

@ibmlittleton,

Thanks for providing us further details with screenshot.

I have logged your details with screenshot against your issue into our database. We will evaluate your issue thoroughly and get back to you soon.

We are sorry for any inconvenience caused!