I have a cell (example B405) that contains the name of another cell (example C32) as a string. C32 has a number in it. I would like to have a function to bring in the number from C32 using the string from B405. I have a function - but it doesn't work:
{
Function Cell_Equals(Text_From_Cell as string)
Cell_Equals = "=" + Text_From_Cell
end function
}
but all this does is plop =C32 into the new cell as a string. This is what you would type into the cell to get the value from C32, but I don't know how to stop having Calc treat it as a string.
Thanks!
Chris
[Solved] Converting a string into a cell number
[Solved] Converting a string into a cell number
Last edited by robleyd on Thu Oct 08, 2020 11:58 pm, edited 1 time in total.
Reason: Tagged [Solved]
Reason: Tagged [Solved]
OpenOffice 4.1.5, Windows 10
Re: Converting a string into a cell number
Welcome to the Forums.
Rather than creating your own function, this sounds like what the INDIRECT function does.
Rather than creating your own function, this sounds like what the INDIRECT function does.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Converting a string into a cell number
Yes - that is perfect! Thanks!
OpenOffice 4.1.5, Windows 10