Thanks, folks, for trying.
JeJe's suggestion,
Code: Select all
thiscomponent.currentcontroller.activesheet.getCellRangeByName("A1").value = 6
would work fine if I were inserting a number. Unfortunately, I'm trying to get a number by referencing another cell, and it puts the cell reference in there and "blows up":
Code: Select all
with thiscomponent.currentcontroller
.select .activesheet.getCellRangeByName(srcCellPos)
trans = .gettransferable
.select .activesheet.getCellRangeByName(destCellPos).value
.inserttransferable trans
end with
It's a reference to a cell on another sheet that references another cell on that sheet, which references another cell in that sheet, and inserts
Code: Select all
=$'recipe log'.#ref!16'Recipe Log'.E21`$'Recipe Log'.G18
into the destination cell, when I intended it to store a numerical value, which starts off with, for example, 0.0036855 I'm wondering if it thinks the value is the reference string instead of a number.
Sorry that it's so complicated, but it seemed like an easier way to go than doing a database lookup. In retrospect, maybe not. Maybe I'll have to rewrite the intermediate cells to ".value" references (which I'll try next), or use a simpler data storage arrangement with table lookup functions. Aarrgghh!
...any other thoughts? BTW thanks for the Pitonyak reference. It's very helpful.