Page 1 of 1

Action Button issue

Posted: Fri Apr 19, 2013 10:44 am
by Rosanero4Ever
Hi all,

I create a simple spreadsheet with an action button linked to a process.
This process has 3 parameters in input (please see the attached image)
With this setup, the process works well
With this setup, the process works well
process_works.jpg (88.82 KiB) Viewed 2988 times
After inserting the button I tested the functionalities immediately and they worked well.
So, I saved the spreadsheet.
After a day I opened the same file and I noticed that action button parameters was in an incorrect form (see the attached image please) and the action button doesn't work.
I have found this process setup. Obviously the process doesn't work
I have found this process setup. Obviously the process doesn't work
process_doesn't_work.jpg (86.35 KiB) Viewed 2988 times
Does anybody can tell me the reason of this issue and how can i solve it, please?

Regards

Re: Action Button issue

Posted: Fri Apr 19, 2013 10:54 am
by declanr
This is a known issue/bug and I can't off the top of my head remember whether it was the version of excel you were using combined with TM1 version etc.

But to avoid stuff like this I tend to always save the books in Excel 97-2003 xls format as opposed to xlsx, try that and see if you have the same issue?



Edit - From what I remember it was an issue of using a version of Excel that wasn't fully compatible with your version of TM1 e.g. TM1 9.5.1 with Excel 2010... but I noticed that you are using TM1 10 so I might be thinking of a different issue altogether

Re: Action Button issue

Posted: Fri Apr 19, 2013 11:14 am
by Rosanero4Ever
Great!
I saved all my spreadsheet in XLS formato and now all work well!
Many thanks!!!