Description: Data is transferred from both '. . .DocDonor.ods'#$Sheet1.O1:O13 and . . .P1:R30 to both '. . ._DocRecipient_Variable_A_2'#DonorSheet.O1:O13 and . . P1:R30. From that data a new formula is made in E76. One may see the String from that formula in the active cell -- E76. We would like to send the String to '. . ._DocRecipient_Variable_A_2'#RecipientSheet.C39 and use it to generate the formulae in '. . ._DocRecipient_Variable_A_2'#RecipientSheet.C39:C67. The ability to achieve this objective would give LibreOffice Calc, to my knowledge, one more level of abstraction and thus exceed the power of other spreadsheets in this area. Steps to Reproduce: Since this is an enhancement, let's go through the steps it will do. Step 0 is an example of the current situation in LibO. Step 1 is the difficulty, as I don't know where the string lives. Please see _DocRecipient_Variable_A_2.ods. 0. $DonorSheet.$E$76, a cell with a function, returns a string to the active cell. The active cell is $DonorSheet.$E$76. 1. From where the string lives, set a Variable equal to the string in the active cell. 2. Clear/Delete the Designated Cell text, Date & time, Comments, Numbers, and Formulas. 3. Push the string value of the Variable into the Designated Cell as though the user had typed it character by character. 4. End the standard function. Actual Results: The Enhancement is not yet implemented. Expected Results: The software should have transferred the string in E76 to E81 as though the user had typed it in by means of the keyboard. Reproducible: Didn't try User Profile Reset: No Additional Info: Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded . You seem to have a lot of work to do. On the other hand there are a lot of commits. Caolanm has at least 32,552. Amazing. If I could find where the string lives that is displayed in '. . ._DocRecipient_Variable_A_2'#DonorSheet.E76, then maybe you would not have to code this. However, even though, to me, this looks, since it is so unconventional, like a relatively simple function to make, I do not recognize the true complexity. I expect to be quite mistaken. This is my experience when I am approached in my area of expertise, by someone who has my level of naivete in this -- your area of expertise. But if you care to find where this string lives, I will try to get this function done.
Created attachment 184472 [details] Source of data Thank you for reading this Enhancement request. I appreciate your help. Please feel free to contact me about all the things which are not clear. Bruce
Created attachment 184473 [details] Receives data, makes a formula, transfers the formula string to a designated cell, and sends the new formula to another sheet in the document. Thank you again. Bruce
Thanks to each of the kind people who graciously added valuable information to help this Enhancement Request succeed. . ask.libreoffice.org: Villeroy, Lupp, DanniStories, erAck.de, mikekaganski, EarnestAl, JohnSUN, parsely Libera.Chat: @cloph, IZBot, intp, @mikekaganski, erAck #libera: buZz, nckx, thumbs #libreoffice: erAck
Could this string be in https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/XFormulaOpCodeMapper.html#AttributesSummary?
This is discussed at https://ask.libreoffice.org/t/calc-2-2-4-in-the-base-code-where-is-the-4-represented/86632.