TM1 Forum

Hi fellas,

I need help on this error that I encounterd in TM1 Web.

"Error occured while converting the MS Excel workbook into XML format : Unable to get the HorizontalAlignment property of the Textbox class."

Here's the set-up:
PC A which is used to create the Excel report - Excel 2003
- TM1 9.4.1 FP002
- Win Vista Home Premium

PC B which takes the Excel report created by PC A and loads it as Application. It then runs a localhost TM1 Web.
- Excel 2007
- TM1 9.4.1 FP0002
- Win XP Pro

PC A is able to convert the Excel file into Websheet in localhost TM1 Web, but PC B encounters the mentioned error. Seems like this is due to different version of Excel used by the TM1 Excel Service during conversion.

Funny thing is, the file was workingg fine previously. So I thought of the changes that were made on this version. On PC A, I change the property of a group of objects (inlcuding images and text boxes) under "Object Positioning" in Excel to from "Move and size with cells" to "Move but don't size with cell". Could this be the issue? Sadly, I do not have PC B right now, so I'm unable to confirm this immediately.

Anyone encountered this before?

Hi harry,

i have also encountered the same error. If you have included any text boxes that is belongs to MS Excel, you will get this error. Remove all MS Excel related objects from the template, it will work fine.