英文:
BusinessObjects - export cells as 'general'
问题
我在BusinessObjects中创建了一个变量，它只是一个Excel公式。一切都好，但当我将报告导出到Excel时，它将单元格格式设置为“文本”，但我希望它将它们格式化为“常规”（最好能自动应用我的公式）。
有没有办法实现这个？
首先，我想在BusinessObjects中创建这个公式，但它是一个指向外部应用程序的超链接，所以我相当确定它必须是一个Excel公式。
我已经查看了所有格式选项，但找不到任何更改它的内容。
英文:
I created a variable in BusinessObjects that's just an Excel formula.
That's all fine, but when I export my report to Excel, it formats the cells as 'Text' but I want it to format them as 'General' (and ideally automatically apply my formula).
Any idea how to make this happen?
To start with I wanted to create the formula in BusinessObjects, but it's a hyperlink to an external application, so I'm pretty sure it must be an Excel formula.
I've gone through all format options and can't find anything to change it.
答案1
得分: 0
我不认为你可以在Web Intelligence中构建一个Excel公式，然后在导出后在Excel中运行它。
既然最终看起来你想要一个超链接，那就在WebI中构建它吧。
免责声明：我不是网页开发者。我可能没有使用精确的术语。此外，可能有多种（更好的）方法来做到这一点，但这是我们的做法。
创建一个变量，构建一个HTML<a>标签。我发现我需要转义其中需要的双引号。
="<a href=\"https://YourBaseURL" + [SomeObject] + "\" title=\"\" target=\"_blank\" nav=\"web\">" + [SomeObject] + "</a>"
然后只需将这个新变量添加到你的表格中，并将该列的属性更改为“HTML”或“超链接”。
我不确定（HTML与超链接）之间的区别，或者在这种情况下是否重要。
希望这能帮助你入门，并且你可以调整这个方法以满足你的需求。
Noel
英文:
I don't think you can build an Excel formula in Web Intelligence and have it work in Excel after export.
Since it ultimately seems like you want a hyperlink just build that in WebI.
Disclaimer: I am not a web developer. I may not use the exact proper terminology. Also, there may be multiple (and better) ways to do this, but this is how we have done it.
Create a variable that builds an HTML <a> Tag. I have found that I need to escape the double-quotes needed within it.
="<a href=\"https://YourBaseURL" + [SomeObject] + "\" title=\"\" target=\"_blank\" nav=\"web\">" + [SomeObject] + "</a>"
Then just add that new variable to your table and change the properties of that column to “HTML” or “Hyperlink”.
I am not sure of the difference (HTML vs. Hyperlink) or if it matters in this case.
Hopefully, that gets you started and you can adjust this approach to meet your needs.
Noel
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论