Apache OpenOffice Community Forum

Welcome beginner. What is your question or comment?
Please try to briefly and clearly tell us: What you want, What you tried, and What happened.
-----------------------------------------------------------------------------------------------------------

hi all,
I wrote a function with three argument which has assigned to any cell address and pass the value.but has a problem,
what i want:
1> select my data out put cell [D5]
2> run my function using macro
3> inside function will ask what is the cell u want as argument..then user select a valid cells by mouse
4> out put will in D5

i need to complete 3rd step.

FUNCTION:
Function volume(a, b, c)
volume = a*b*c
End Function

http://www.oooforum.org/forum/viewtopic ... eselection
[Moved away from "Beginners" forum]

I tried above link ....once i select the cell range then suddenly appears a dialog box saying,

>> Title: exit macro:getTargetCellAddress
"Target needs to be on another sheet or behind/below selection"


what was cause for that?

regrds,
srimal

Read the code. It rejects to paste into the copied region.

thanx i did it.It copies the cell range as it is.

regrds,
srimal

The macro copies the tiles of visible ranges to another place. In case of no hidden columns nor rows it copies the selected range.
The genreic part you need for your own stuff is It returns a com.sun.star.table.CellRangeAddress if the user selected a range. It returns Basic type Empty if the user canceled. You've got to pass the spreadsheet-controller to pick from a default selection as string-address (A1:D4 or empty string), a title for the box and if a single click on the sheet is enough to close the selection box.