Cells .Net: Textbox shape on Chart is gone after saving

Aspose.Cells Product Family
1

Our .net C# application worked fine with Cells.Net 17.6, but does not work with 17.9.
To recreate:
Open an excel file that contains a chart with a textbox shape on it that references a cell in the worksheet for its content.
Change the value of a cell (which recalculates the referenced cell).
Save the file. The textbox shapes on the chart are now gone completely.

If the shape on the chart in the excel file does not reference a cell for its content, all works fine and the textbox shapes are retained when the file is saved. Also, shapes on the worksheet rather than on the chart seem to work fine.

Attached is .zip of the C# solution, input template file and results:
17.6 - excel template contains shape which references a cell for its content - works
17.6 - excel template contains shape with no reference to cells for its content - works
17.9 - excel template contains shape which references a cell for its content - DOES NOT WORK
17.9 - excel template contains shape with no reference to cells for its content - works

AsposeChartShapeProblem.zip (85.5 KB)

We are using Cells.Net version 17.6.0.0 and 17.9.0.0

2

@CEgleston

Thanks for using Aspose APIs.

Please download and try the most recent version. It works fine as we have tested it.

We have tested it with the following sample code and attached the output Excel file generated by the code for your reference.

Download Link:
Cells-output-17.12.3.zip (14.2 KB)

C#

//Open the sample Excel file
Workbook wb = new Workbook("templateWithCellRef.xlsx");

//Access the worksheet containing chart and data
Worksheet ws = wb.Worksheets["data"];

//Add some number to cell A4
ws.Cells["A4"].PutValue(27);

//Save the output Excel file
wb.Save("output-" + CellsHelper.GetVersion() +".xlsx");
3

Thank you. However, I am unable to download 17.12.3. I am unable to use Dropbox. And the “Direct Download” option fails. Can you email me the 17.12.3 file?
aspose.dowload.failure.png (50.6 KB)

4

@CEgleston

Thanks for using Aspose APIs.

I have attached the 17.12.3 in parts. There are two parts. Links are given below.

Please download both parts and remove .zip extension from them and place them in some empty folder and then extract the 17.12.3 out of it using WinRAR tool.

Download Links:
Cells - In Parts.part1.rar.zip (2 MB)
Cells - In Parts.part2.rar.zip (1.7 MB)

Screenshot:
The following screenshot explains how to extract the contents.

5

I appreciate your response. Unfortunately, I do not have WinRAR and am not allowed to download it to our secured environment. Can you send the .zips? Or, do you have an estimate on when version 17.12.3 will be available for regular download from your website?

6

@CEgleston

I need your email address to send the fix via email. For that matter, I have sent you a Private Message. Please provide your email id by replying the message.

You will have to wait till 20-Jan-2018 to get the official release which will include this fix.

However, you can download the following zip files (i.e. P1.zip and P2.zip) and extract them in some empty folder, then you run the Joiner Exe i.e. Create_Aspose.Cells17.12.3 For .Net4.0.exe and it will then provide you final zip file. i.e. Aspose.Cells17.12.3 For .Net4.0.Zip which contains the fix. I have also attached the screenshot for more help.

Download Links:
P1.zip (2.0 MB)
P2.zip (1.7 MB)

Screenshot:

7

17.12.3 Fixed my problem. Thank you.

8

@CEgleston

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.