TimePeriod Filtr removed after re-save

Aspose.Cells Product Family
1

Load attached file to Aspose.Cells.Workbook save it. Time Period Filtrs will be removed on 2,3,4 pages.

2
Hi Aleksey,

Thank you for providing your sample spreadsheet for our review.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for .NET 8.1.2.3. We are unable to detect a problem with the resultant spreadsheet as attached, therefore, we would request you to please give the latest version a try on your end. In case the problem persists, please provide us the snapshot(s) highlighting the issue(s).

C#
var book = new Workbook(myDir + "Упрощённый+Шаблон+Отчётов+29+и+30+и+38+и+40+--+2014-08-05.xlsx"); book.Save(myDir + "output.xlsx", SaveFormat.Xlsx);

3

Hi,
compare original with output.xlsx
and attached screenshot. You see that filtr removed.

4

Hi Aleksey,


Thank you for providing the snapshots for our reference.

We are able to observe the difference by loading the original & resultant spreadsheets in Excel 2013. The probable reason for this difference is because the Time Period Filters are not yet supported by Aspose.Cells API. We have logged the problem in our bug tracking system for further investigation & correction purposes. The ticket Id for your future reference is CELLSNET-42907. Please spare us little time to properly analyze the problem cause on our end. In the meanwhile, we will keep you posted with updates in this regard.
5

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.1.2.4 (attached).

We have fixed your issue now.

Let us know your feedback.

Thank you.
6

Without any changes it’s OK!
If you change values in table on first page that filtrs will removed.

Try this code and see 3 page:

Dim l As New Aspose.Cells.License
l.SetLicense(“Aspose.Total.lic”)

Dim doc As New Aspose.Cells.Workbook(“Упрощённый Шаблон Отчётов 29 и 30 и 38 и 40 – 2014-08-05.xlsx”)

doc.Worksheets(0).Cells.DeleteRows(7, 15, True)

doc.Save(“e:\temp\output.xlsx”, Aspose.Cells.SaveFormat.Xlsx)

7

Hi,


We noticed the issue as you mentioned. If we remove some rows in the first worksheet of the template file, the contents and charts are affected in other sheets.
e.g
Sample code:

Workbook workbook = new Workbook(fileName);
workbook.Worksheets[0].Cells.DeleteRows(7, 15, true);
workbook.Save(outputFileName);

I have reopened your issue “CELLSNET-42907” now. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.
8

Hi,

Thanks for using Aspose.Cells.

Please delete rows in MS Excel, save the file and reopen the saved file, you will find TimePeriod Filter are removed too.

So it is not actually a bug. Aspose.Cells behaves same like MS-Excel.

9

The issues you have found earlier (filed as CELLSNET-42907) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.