Conditional formatting. Compatibility problems with *.xls. Formula issue in Excel 2010

Aspose.Cells Product Family
1

Hi,


This theme is a continuation of problem #2 in this issue: <a href=".
Type - ColorScale (Excel: Format all cells based on their values - 2 - Color Scale).
Type - Number
Value:
*.xlsx - ‘=$A$2’
*.xls - ‘=Sheet1!$A$2’
Such type of value has the same incompatibilities in the other rules.
I checked conversion in Excel 2007 and it has no problem, so this problem appearing only in Excel 2010.

Thank you,
Alex Shloma
2
Hi,

#2. Formula issue of "=Sheet1!$A$2" and "=$A$2"
Those formulas are both read from corresponding template file. In fact it is strange to us that the formula in your given xls is "=Sheet1!$A$2". We don't know how did you create this XLS file, at our end when we save the XLSX as XLS by excel2007, in the saved XLS file the formula was "=$A$2"(same with the formula in XLSX file), not "=Sheet1!$A$2". Anyways, because MS Excel does not allow reference to other worksheet than the sheet where the format condition is in, so "=$A$2" is always equals to "=Sheet1!$A$2" for the conditional formattings in Sheet1.

Thank you.
3

Thanks for quick response.


You said: ‘We don’t know how did you create this XLS file, at our end when we save the XLSX as XLS by excel2007’, but this problem appears only in Excel 2010. Try to convert my *.xlsx document via Excel 2010.

Thank you,
Alex Shloma
4

Hi,

I have logged your comments in our database. Development team will look into your issues and give you advice on these issues.

  1. 374848

  2. 374861

The comments have been logged against the issue id: CELLSNET-40526