https://bugs.documentfoundation.org/show_bug.cgi?id=167886
Patrick Traill <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Patrick Traill <[email protected]> --- I have indeed sometimes observed that the proposed method would have solved a problem I had. It is certainly a lot cleaner than inserting a formula in an arbitrary cell and querying the value of that cell. I do wonder if there are any issues with possible side-effects, though perhaps they are only possible via user-defined functions. Would this function evaluate a formula as if it were the formula of the cell object used to evaluate it? Could that counterfactual assumption cause any problems? Without that assumption, it is not clear how this function should evaluate "ROW()". This proposal appears to be, at least in part, a response to the Forum question https://ask.libreoffice.org/t/how-can-a-macro-get-the-hyperlink-specified-in-a-hyperlink-function/125278/18 (where it is mentioned), and would make it feasible to solve that problem, but only somewhat indirectly. A more direct solution would be a method to obtain the hyperlink(s), if any, associated with a cell, whether those links were created by the HYPERLINK formula function or any other means. The referenced documentation of the function Evaluate in Excel is a little unclear, as it says that it evaluates “names” rather than formulae, but gives the example of evaluating "SIN(45)"! I also see that the Excel function can return an object, otherwise the example bolding Sheet1.A1 would not work « Application.Evaluate("A1").Font.Bold = True », but the proposal suggests return a double, a string or void. It might be better to throw an exception if the formula is invalid, if it is conceivable that a formula now or in the future could successfully return void. -- You are receiving this mail because: You are the assignee for the bug.
