Free Support Forum - aspose.com

Aspose cells 17.11 compatibility with excel version 2010

Hi Team,

We are tried to implementing the excel Report Layout feature using aspose cells 17.11
Repeat All Item Labels & Do Not Repeat Item Labels

The issue is, This option working fine for aspose cells 17.11 and excel 2016 not working for 2010 !

Please let us know the supported excel versions for aspose cells 17.11 ?

@prasad4aspose

Thanks for using Aspose APIs.

Aspose.Cells 17.11 is compatible for

  • Excel 2003
  • Excel 2007
  • Excel 2010
  • Excel 2013
  • Excel 2016 and later.

It seems, you are facing some issue or bug that occurs in 17.11 only. You can try previous versions e.g. 17.10, 17.9 etc. or later versions e.g. 17.12, 18.1, 18.2 etc. to confirm this. If the issue is occurring only in 17.11, then it is because of some bug.

You may share your sample code, input and output Excel files for our investigation. We will replicate the issue and look into it and then update you further. Thanks for your cooperation in this regard and have a good day.

Hi @shakeel.faiz ,

As you suggested tried previous release 17.10 (as we have license subscription up to 17.11) and it’s working fine in excel 2010 and above.

Sharing you the sample code to test in 17.11

if(pivotTableRepeatItem.containsKey(“Pivot Report Item Lables”)){

String reportItemLabel = pivotTableRepeatItem.get(“Pivot Report Item Lables”) != null ? pivotTableRepeatItem.get(“Pivot Report Item Lables”).toString() : “”;

if(reportItemLabel.equals(“1”) && (reportLayout.equals(“1”) || reportLayout.equals(“2”))){

pivotField.setRepeatItemLabels(true);
}
}

Please help out ! :neutral_face:Excel Output.zip (1.3 MB)

@prasad4aspose

Thanks for using Aspose APIs.

Repeat Item Labels option is not present in MS-Excel 2007 and it is present in later versions e.g. MS-Excel 2016.

Please see this screenshot that shows that this option is not present in Excel 2007 but available in Excel 2016.

Hi @shakeel.faiz,

We are getting issue in 2010 with aspose cells 17.11

aspose cells 17.10 working fine for excel 2010 and above.

please provide the fix if bug present in 17.11 version.

Thank you,
Prasad Digajarla.

@prasad4aspose

We are afraid, we only fix issue in most recent version. If the issue exists in some older version but it does not exist in the most recent version, we will not fix it.

The most recent version is 18.4. If the issue exists in 17.11 but does not exist in 18.4. we cannot fix it. And if issue exists in 18.4, then we will fix it in next releases e.g. 18.5 and in that case, you will have to renew your license subscription as well.

In any case, you will have to renew your license subscription because we only fixes issues in most recent version. Besides, this is a technical forum, it deals with technical issues of Aspose.Cells. For license related questions, you should post issues in Aspose.Purchase forum.