Category Archives: Excel

Installation Xcelsius 2008 SP3 and Office 2010 (Excel 2010)

When trying to install Xcelsius with pre-installed Excel 2010 you will get an error message as Office 2010 is not supported yet by SAP BusinessObjects. One solution is: 1. uninstall Office 2010 (do not forget to backup settings) 2. install … Continue reading

Filed under Connection, Excel, Install, Xcelsius | Tagged , , , , , | 8 Comments

Change axes label color in chart

Use the custom format option in Excel if you want to dynamically change the vertical axes labels to a alert color. Eg. [Blue][>0]#,##0;-[Red]#,##0 will show positive numbers in blue and negative numbers in red.

Filed under Components, Design, Excel, Xcelsius | Tagged , , | 3 Comments

Excel file does not open in Windows Explorer

If you work with the Live Office Comptaibility enabled in Xcelsius, changes are that you cannot open an Excel file from the network anymore. However when strating Excel and then navigating to the file on the network in Excel itself, … Continue reading

Filed under Connection, Excel | Tagged , , , , | 2 Comments

Formula: Weeknum() in Excel 2003

In Excel 2003 the Weeknum() formula will only be activated when the Analysis toolpack is installed. Go to Options -> Addin -> select Analysis Toolpack -> OK. The formula should work now. Furthermore if you use the Dutch version of … Continue reading

Filed under Excel | Tagged , , | 1 Comment

Excel formulas translation NL-EN EN-NL

Excel sheet formula translation English to Dutch and vice versa. Functies_Excel_NL-Eng-VBA.xls

Filed under Excel | Tagged , , | 1 Comment

Export to Excel / CSV

2Excel on Apache Tomcat Server «·····» 2CSV on .NET Server «·····» Other formats Export to Excel on Apache Tomcat Server Luca Spinelli and Ivan Aguilar from ClearPeaks (www.clearpeaks.com) introduce users to the new export to Excel solution for Xcelsius using … Continue reading

Filed under Connection, Excel, Xcelsius | Tagged , , , , , , , , | 22 Comments