DataTable Refresh

Aspose.Cells Product Family
1

Hi,

There are two features in microsoft interop excel that do not exist in aspose, but we need these features in aspose.

One feature in microsoft interop excel is workbook.RefreshAll() - which should refresh datatables.

Also, workbook.RunAutoMacros() - we need to be able to run the macros in a workbook before recalculation of the workbook.

We would appreciate greatly these features being made available to aspose users, so that aspose offers the ability to manipulate workbooks without resorting to microsoft interop.

Thanks

Daniel
2

Hi Daniel,

Thanks for your posting and using Aspose.Cells.

We are afraid, we could not provide you any mechanism or API to execute macros. However, for refreshing data tables, we could look into this feature if we could implement it or not.

Could you provide us your sample xls/xlsx files containing sample data tables, you can create such a file manually in MS-Excel and attach here. Also, let us know how you could refresh these data tables using MS-Excel. It will help us look into your issue more precisely and we will be able to help you asap.

3

Thanks Shakeel.


Here is a sample file, attached.

If you open it, and go to the “output” tab and change the log base value, and then switch to the “input” tab you will see the values in the table have not changed. If you hit F9, you will see the values update. It is this action of hitting F9 that I need to replicate, and I have verified that Aspose’s “CalculateFormula” method does not do it.

Thanks!

Donny
4

Hi Donny,

Thanks for your sample file and considering Aspose.Cells.

We have logged a New Feature request in our database to support data table refresh using Aspose.Cells APIs. We will look into it and implement this feature if possible. Once, there is some fix or some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42422.

5

Hi,

Do you have any update on this issue?
Thanks

Daniel
6

Hi Daniel,


I am afraid, we haven’t yet received any updates regarding the ticket (CELLSNET-42422). We have requested the concerned development team member to share the insight of this ticket, as well as an ETA if possible. We will post here as soon as some news comes in.

Please accept our apologies for the inconvenience caused.
7
Hi,

Thanks for using Aspose.Cells.

After investigation we found this issue is complicated and cannot be fixed soon. To solve this issue we need to rebuild the logic of calculating formulas (especially the formula calculation chain for such kind of issue). It is a complicated task for us and currently we plan to implement it in Q3. Sorry for the inconvenience and we will update you when we solve it.
8

Hi

Was this issue fixed in later releases? Is it fixed now?

Also, can I now run macros from aspose?

Thanks

Donny
9

Hi Donny,


Thank you for contacting Aspose support.

I am afraid, the ticket (CELLSNET-42422) attached to this thread is not resolved yet. I would suggest you to create a new thread providing your requirements so we could attach the appropriate ticket from our database to your thread for automated notifications regarding the fix.
10

Why do you want me to create a new thread? Please just use this one, as it contains all necessary information and attachments - for you to use.


Please inform us when this request (fulfillment was promised in Q3 of 2014, ie, 7 months ago) will actually be fulfilled.

Thanks very much!

Daniel
11

Hi Daniel,

Thanks for your posting and considering Aspose.Cells.

We have logged your comment in our database against this issue i.e CELLSNET-42422. Once there is some news for you, we will let you know asap.

Aspose.Cells cannot execute Macros but it can be used to Access and Modify Macro Codes. Please see the following documentation article for your reference.

( Manage VBA codes of Excel Macro-Enabled workbook.|Documentation )