https://bugs.documentfoundation.org/show_bug.cgi?id=152868
Bug ID: 152868
Summary: Warning: Eye Rolling possible. In Calc, a cell with
a function returns a string to the active cell, but
the string can not yet be pushed into a Designated
Cell by a standard function. [1] Status "NEW"
Product: LibreOffice
Version: Inherited From OOo
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
