I would like to generate a formula in BO that works in Excel like this
BO-Input: ="=left("+char(34)+“Hello World”+char(34)+";5)"
Excel-Output: =left(“Hello World”;5)
After the export, Excel just shows me the formula as a text and not the result of the formula (World). So I must click into each specific cell and press ‘Enter’. Is there any way to avoid that, because I must do this thousand times.
I tried different Excel-options and char(13) without success.
MNA_de (BOB member since 2009-04-06)
I presume that you’re not getting 1000 instances of hello world but 1000 different items?
Do you seriously need to see a formula as the output in Excel??
There’s no way to do this. There’re multiple threads in the Excel forums on microsoft asking the same question (and not just regards BO output to Excel). Excel will treat it as text no matter what.
Why do you want to do this anyway out of interest?
SteveD 
(BOB member since 2009-11-02)
Thank you, I fear that. 
“Hello World” is just an simple example. I need it for the formula
=“=SumIf(R2;”+Char(34)+[Dimension]+Char(34)+“;R)” *
*(Row/Line-Notation)
The task is for a typical planing Excel-sheet (Given data and empty cells). This formula is in a group-footer. The cells above are empty. The formula should sum the values automatically, that a user entered in the empty cells. There are more than 20 groups for 12 months for each of the 40 users…
MNA_de (BOB member since 2009-04-06)
Thought so!
Planning… 
- sorry, personal experience coming through there.
The only thing like this that does work is if you save your output as a text file be it tab or , delimited and then open it into Excel. (.txt or .csv). The problem then is that when you save a BO file as .csv then it kicks out all the content of the data providers, not what you see on screen.
I’m was pretty adamant that I’d seen that webi xi r3 had changed that, but I tested it myself a few days ago and it still just kicks out the content of a queries resutls - not your formatted report. So, in that case, a possible workaround would be to create an object in the universe that gives you your formula string…?
SteveD 
(BOB member since 2009-11-02)
I think, I’ll do it with a excel-macro that runs trough all sheets and all cells and sets a “carriage return” everywhere… but my questions for that that, I must post to another board.
MNA_de (BOB member since 2009-04-06)
FYI - with regard to ASCII in Visual Basic, you can insert carriage returns they’re ASCII char 10. There’re a host of good answered topics on microsofts office forums (I know, I asked one similar a while back). E.g. http://social.answers.microsoft.com/Forums/en-US/officeprog/thread/e43085cd-f927-4d9c-bb03-279ea2c72d36 might help you get started.
SteveD (BOB member since 2009-11-02)