attached project you can find code to read PowerQueryFormulaItem value and name. As those are only getter I would like to ask you to extend them to be setter also as I’ll need to change content of those 2 fields.
Btw. it is more important to get setter for value field but both would be perfect.
P.S. I believe that same is already described in bug:
CELLSNET-46924 – Access to link paths contained in DataMashups
@dr.doc,
Thank you for providing more details.
We have understood the requirements but we need to look into it more. We have logged the issue in our database for investigation and for a fix(if possible). Once, we will have some news for you, we will update you in this topic.
This issue has been logged as
CELLSNET-47091 – Option to update PowerQueryFormulaItems
thanks for opening ticket. Can you please check with developers how long it will need to get this functionality? If needed to accelerate I can create paid support ticket.
@dr.doc,
As we just logged the ticket, so could you spare us a little time (3-5 days or so) for complete evaluation and investigation for your issue. If it is not much complex, you should be receiving the fix before the end of next week or even before it. If the issue is complex, it might take a couple of weeks. We will let you know if paid support can accelerate the fix.
@dr.doc,
Could you explain more about updating PowerQueryFormula?
Which parts do you want to update?
We find it’s hard to update attached Metadata XML because there is relationship between this Metadata and querytable.
At the end, it is about getting option to change value of Source field as when we move documents from one location to the other none of PowerQueryFormulas will work due to this change and we have to update value here to be able to point to new document location.
According to what we saw in Excel file I would say that we will need to update only Source field as it contains path to source file but might happen that in other fields there might be also some references to source files.
Let us say that you can start with Source field and if we notice, later, that we might need something else we will let you know. Would that work for you?
The issues you have found earlier (filed as CELLSNET-47091) have been fixed in Aspose.Cells for .NET v20.4. This message was posted using Bugs notification tool by Amjad_Sahi