TM1Web Issue
Posted: Thu Apr 29, 2010 1:08 pm
hey,
i found a curious issue here, maybe somebody saw it before and knows how to deal with it.
Windows Server 2003 SP2
IIS 6.0
Excel 2003 SP3
TM1 9.1 SP4 FP1
Websheet with subnm & actionbutton for making a selection
actionbutton executes a process and opens another websheet
Actionbutton Worksheet Options:
[x] Match Title Elements
[x] Replace Current Workbook
Advanced Options...
Source Type | Source Object | Target Type | Target Object
Value | check | Range | A1
Value | =E5 | Range | A2
if you press the actionbutton in sheet1 you jump to sheet2 and match the title elements, you also write check in A1 and take the value out of sheet1:E5 and write it to sheet2:A2
everything works fine, until you try to snapshot the websheet to excel.
following message appears:
okay, let's check the tm1excelservice logfile
now, if you take out the second advanced option of the websheet actionbutton stuff (i mean this line: Value | =E5 | Range | A2) it works.
if you do these steps in excel & upload the excelfile to the webserver and try to snapshot it without the action button fun before, snapshot works.
so, i know that it works if i delete the second line of the advanced options of the actionbutton websheet thing, but i need it.
of course restarting tm1excelservice, iis, or cleaning up temp dirs of tm1web does not help..
any ideas?
br,
Martin!
i found a curious issue here, maybe somebody saw it before and knows how to deal with it.
Windows Server 2003 SP2
IIS 6.0
Excel 2003 SP3
TM1 9.1 SP4 FP1
Websheet with subnm & actionbutton for making a selection
actionbutton executes a process and opens another websheet
Actionbutton Worksheet Options:
[x] Match Title Elements
[x] Replace Current Workbook
Advanced Options...
Source Type | Source Object | Target Type | Target Object
Value | check | Range | A1
Value | =E5 | Range | A2
if you press the actionbutton in sheet1 you jump to sheet2 and match the title elements, you also write check in A1 and take the value out of sheet1:E5 and write it to sheet2:A2
everything works fine, until you try to snapshot the websheet to excel.
following message appears:
Code: Select all
Excel could not open XML spreadsheet: ?Code: Select all
2010-04-29 15:01:51,788 [5504] ERROR Applix.TM1.ExcelApp.ExcelApplication - Failed to close xls file: Object reference not set to an instance of an object.if you do these steps in excel & upload the excelfile to the webserver and try to snapshot it without the action button fun before, snapshot works.
so, i know that it works if i delete the second line of the advanced options of the actionbutton websheet thing, but i need it.
of course restarting tm1excelservice, iis, or cleaning up temp dirs of tm1web does not help..
any ideas?
br,
Martin!