We were able to observe this issue after executing your sample code with your sample Excel file using the latest version: Aspose.Cells
for .NET v8.3.0.3. Writing data to table row does not copy formula to the column of that row.
Could you please let us know how did you create such a table?
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
CELLSNET-43217 - Writing data to table row does not copy formula to the column of that row
Please note, we have split your thread. The previous thread has gone very lengthy so it is not a good thing to post any newer issues inside it. Whenever, you find any new issue, please create new threads for it. It will help us log your issues in our database in more manageable way.
Can you look at adding a method on a Table object that will initialize it and tell it to copy all formula and settings on columns defined on the table.
This is only needed if the table has no data in it. Just the column headers.
That way a program can tell the table to initialize itself when you first start writing data into the table.
Otherwise there is no way of writing data into a table and have the columns setup with the columns default settings as defined in the table.
Thanks for your suggestion and using Aspose.Cells.
We have logged your comment in our database against this issue. We will look into your requirements and see if it is achievable. Once, there is some news for you, we will let you know asap.
I am assuming I would only need to call that method for a table that does not have any data in it. The ListObject.PutValue() would initialize all the column formula, styling, validation etc defined on the table to the table columns.
Once there is at least 1 row of data, calling lo.Resize() will copy the column definitions to the new rows.
We have logged your comment in our database against this issue for consideration. We will look into it and provide you such a method to fulfill your requirements if possible. Please spare us some time. Once, there is some news for you, we will let you know asap.
We were able to observe this issue after executing your sample code with your provided Excel file using the latest version: Aspose.Cells
for .NET v8.3.1.4. ListObject.PutCellValue() does not initialize the VLookup formula inside the Table.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
CELLSNET-43286 - ListObject.PutCellValue() does not initialize the VLookup formula inside the Table
I have also attached the output Excel file generated by your code for a reference.
We were able to observe this issue in your output Excel file. However, in order to replicate this issue at our end, we need your source Excel file and the runnable sample code reproducing this issue with the latest version: Aspose.Cells for .NET 8.3.2. It will help us look into your issue more precisely and fix it.
Thanks for your sample code, sample Excel file and using Aspose.Cells.
We were able to observe this issue after executing your sample code with your sample Excel file using the latest version. ListObject.Resize() method sets the wrong formula in newly added rows.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
CELLSNET-43364 - ListObject.Resize() method sets the wrong formula in newly added rows
I have also attached the output Excel file for a reference.
I downloaded the new v8.3.2.3 version of the Aspose.Cells dll and tested it with the sample code. The PutCellValue() and lo.Resize() methods now work as expected.
Thank you for fixing the issues and providing an updated dll.
Good to know that it figures out your issue now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.