You know a lot more about functions in LibreOffice than I do. So, I’ll ask whether it might be worthwhile to add another function to the more than 500 that we already have. Could we add a function, TYPEIN(), to compliment the action of FORMULA()?
What is a complimentary function? It may be defined as one which reverses the action of another function. The compliment of addition is subtraction and division of multiplication. People use this type of operator to return to a previous state. Remember the 80286 processor protected mode to real-mode switching problems?
We recognize the plethora of functions in current spreadsheets. Could our Office Suite use one more complimentary function?
This question was raised in “[Solved] Reverse “FORMULA” function” at Apache OpenOffice Community Forum - [Solved] Reverse "FORMULA" function - (View topic).
Some people, including me, wish to have a complimentary function to FORMULA(). I would like, from a Donor Document, to update and run a formula in a Receiving Document without calling a macro and without user intervention (ex. “Copy-Paste as unformatted text”) on the Receiving Spreadsheet. Please see DocDonor.ods and DocRecipient_Variable_A_.ods.
Let us say we wanted to add such a function. What would we ask a programmer to do for us?
Form: TYPEIN(Donor_cell, Recipient_cell) to effect TYPEIN(Value_in_one_cell, Formula_in_another_cell)
Donor_cell and Recipient_cell need to be addressed either by Name or by coordinates (A1 notation).
TYPEIN() should follow the OpenFormula standard.
TYPEIN() should support nesting.
TYPEIN() should support standard Error Codes.
TYPEIN() should support the Function Wizard, including the Array checkbox.
TYPEIN() should be a Volatile function.
TYPEIN() should empty Recipient_cell before entering data to it.