hi,
is there a way in BO to copy the content of a cell instead of the definition?
i.e. if I select a cell and do copy, I get the formula, not the value.
thanks,
Benoit
benoitd (BOB member since 2004-06-30)
Your use of the word “cell” is the tipoff – a cell is what is in Excel.
BusinessObjects reports are band-style – and if you look at them in structure mode – that’s where you see what might be called a “cell” – the object/variable/formula/text. It defines the layout.
When you want to go for data – i.e., not in structure mode – you get all the data, because the report is not actually an Excel worksheet.
Anita Craig 
(BOB member since 2002-06-17)
I don’t quite follow you.
I know the difference between the structure and the data view.
But even in data view, if you select something on the report (don’t want to use the word “cell” here 
) and do edit/copy , you will get the “structure”, not the data.
for example, if I have a variable = "hello " & “you” and put it on a report. Select it and do a copy, I get ="hello " & “you”, instead of “hello you”
benoitd (BOB member since 2004-06-30)
That’s correct. There is no way to copy a value out of a cell 
because the cell doesn’t contain the value. The cell contains the formula.
Think of it another way… if you copy a cell in Excel that has a formula in it, and paste it into another cell, what do you get? You get the formula. Yes, Excel has a function to copy / paste “values” that BusinessObjects does not. But at the core it works the exact same way.
If you have a cell that contains the value “hello you” and you copy it, you get the value.
Dave Rathbun (BOB member since 2002-06-06)
If you want All the values there is the Copy ALL function on the Edit menu. Which lets you take all the data values on the report and put them into excel etc. You could write some VBA (some sendkeys I think because I don’t remember seeing copyall exposed to VBA) and then pick up certain cells from the excel, but it seems an extremely longwinded soluttion.
G.E.Davies 
(BOB member since 2003-01-20)