Two columns in TextBox

Aspose.Cells Product Family
1

Hi there, we are using a TextBox formatted with two columns, but Aspose.Cells seems to ignore this property and saves it again with only one (see picture, original on the left, Aspose-saved version on the right). Is there a possibility to achieve this?
2022-07-12 11_40_46-testasposezweispalter.xlsx - Excel.png (65.7 KB)

2

@fpre_lehner,

Thanks for the screenshot.

Please zip and attach your input Excel file and output Excel file via Aspose.Cells APIs, we will evaluate your issue soon. Moreover please try using latest version of the APIs (if you are not already using it).

3

Hello Amjad
Thank you for your quick reply. Attached you’ll find the Input and Output files.

TwoColumnsExample.zip (15.2 KB)

4

@fpre_lehner,

Thanks for the template file.

Please notice, I am able to reproduce the issue as you mentioned by re-saving your template file via Aspose.Cells APIs. I found, if a TextBox is formatted with two columns, Aspose.Cells ignored this property and re-saved it but with only one column as per your attached screenshot:
e.g.
Sample code:

Workbook workbook = new Workbook("e:\\test2\\Input.xlsx");
workbook.Save("e:\\test2\\out1.xlsx");

I have logged a ticket with an id “CELLSNET-51574” for your issue. We will look into it soon.

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

1 Like
5

@Amjad_Sahi Thank you very much! If possible, could you make sure that the two columns are also persistent while converting to PDF? Thanks in advance.

6

@fpre_lehner,

Please spare us little time to first analyze the issue in details. We will also consider to incorporate the fix in Excel to PDF rendering.

1 Like
7

@fpre_lehner,

This is to inform you that your issue has been resolved. The fix will be included in the next official release (Aspose.Cells v22.8) which is scheduled to be published in the second week of August 2022. You will also be notified when the next version is released.

1 Like
8

Thank you for your support, which is very much appreciated!

9

@fpre_lehner,

You are welcome.

To evaluate and manage issues accurately, we decided to log a separate ticket for it. The ticket is logged as following:
CELLSNET-51578 - A textbox having two columns in it is rendered with one column only in Excel to PDF rendering

We will look into it soon. Once we have an update on it, we will let you know.

1 Like
10

@fpre_lehner Hi,
It’s a bit difficult to fix this( CELLSNET-51578) without affecting other functionality. We may not be able to fix this issue anytime soon. We’re still working on it and will let you know as soon as we make progress.

11

Thank you for your reply and for investigating this issue. That’s a pity. We hope that you will find a solution in a timely manner anyway, since we are dependent on the PDF conversion. We would appreciate it if you could follow up on this problem.

12

@fpre_lehner,

Sure, we will keep you posted on latest updates once available on it.

1 Like
13

The issues you have found earlier (filed as CELLSNET-51574) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi