https://bz.apache.org/ooo/show_bug.cgi?id=112771
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Issue Type|FEATURE |ENHANCEMENT CC| |[email protected] --- Comment #3 from orcmid <[email protected]> --- (In reply to kaplalwani from comment #0) > i need the RTD like functionality with open office which is available in MS > office.MS office has its own formulas (RTD formulas) to provide this > kind of feature but its still not available with OO. So i wish to implement > some similar functionality To be specific, the functionality requested is as described here: <https://support.office.com/en-us/article/RTD-function-E0CC001A-56F0-470A-9B19-9455DC0EB593>. This function is *not* part of the ODF 1.2 OpenFormula specification, one that was produced with the participation of Microsoft. I do not know why this function was omitted. Perhaps because it was not implemented/known in Excel at the time the set of functions was defined for OpenFormula. Perhaps it was thought that other database-access provisions covered the use case. ANALYSIS It seems that the biggest difference is that changes in values provided by the service are into the spreadsheet as they are made available, providing a form of real-time tracking. (That is, a recalculate happens automatically, if automatic recalculation on changes is enabled.) It is not clear whether there is a way to produce the equivalent behavior using a script and available database functions within OpenOffice Calc. In particular, notice that this involves access to a COM Automation service registered on the local COM-supporting platform (usually Microsoft Windows). If you could get that to work in DDE in Microsoft Excel, there is the possibility that it could be done in a similar way using OpenOffice Calc. That might be the first way to see if one can work without RTD. According to the OpenFormula specification, there is no automatic recalculation or detection of changes in the DDE source. If relying on some existing COM Automation service is not essential, there may be more flexibility, but that is going to be a custom implementation beyond what OpenOffice Calc provides. For the time-being, one should assume that the RTD function is not going to be added to OpenOffice Calc in any currently-planned updates. This issue is changed to an Enhancement request. It is not about a defined feature for OpenOffice Calc or for ODF 1.2 OpenFormula. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
