Hello,
Does anyone have experience using a third party spell checker for TM1 websheets rendered in internet explorer? I work for a legislative body and our budgeting process is very language intensive.
Our websheets were developed to be viewed in internet explorer as our IT dept. does not currently support Firefox. We have been looking at Firefox as on option for spellchecking, but it renders the websheets differently than explorer, sometimes quite seriously.
I would have thought that that this product would not require browser specific development, however that does not appear to be the case.
We are using IBM approved version of both browsers.
Any advice is appreciated. I’ve searched fairly extensively and have found little information on this topic.
Thank you,
Chris
Spell Check for TM1 web
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Spell Check for TM1 web
Chris,
Do you mean that users enter string into a cell and you want that entry to be subject to a spellchecker as they are typing it?
Do you mean that users enter string into a cell and you want that entry to be subject to a spellchecker as they are typing it?
Declan Rodger
Re: Spell Check for TM1 web
Yes, Thank you.
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Spell Check for TM1 web
Well I wouldn't go as far as thanking me...
I haven't personally come across the ability to spell-check the string entries via the web but I know that if you were to spell-check the string cells within an Excel wookbook (which the websheets will be rendered from) it wouldn't come up with errors due to the way that string cells are recognised.
I expect someone on here will have possibly come across such an issue before and possibly come up with a solution...
but my personal recommendation would be to tell people to spell things correctly in the first instance or deal with any mistakes that may occur. Another option if people have some OCD surrounding it would be to write out the string entry in Word, spell-check and then copy/paste into TM1 web.
I haven't personally come across the ability to spell-check the string entries via the web but I know that if you were to spell-check the string cells within an Excel wookbook (which the websheets will be rendered from) it wouldn't come up with errors due to the way that string cells are recognised.
I expect someone on here will have possibly come across such an issue before and possibly come up with a solution...
but my personal recommendation would be to tell people to spell things correctly in the first instance or deal with any mistakes that may occur. Another option if people have some OCD surrounding it would be to write out the string entry in Word, spell-check and then copy/paste into TM1 web.
Declan Rodger
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Spell Check for TM1 web
Without sounding too much like an apologist for IBM, developing web-based tools can be incredibly frustrating. I have a little side business hosting tennis court reservations (http://www.onlinecourtreservations.com) and I have to keep my html, style sheets and javascript extremely generic. If I don't there is always one of the stupid browsers that will render it incorrectly. So, you end up making things as generic as possible and making sure it works on IE, Safari and Chrome. Firefox can be a bugger!csb wrote:I would have thought that that this product would not require browser specific development, however that does not appear to be the case.
Note to mods: Sorry if posting the link violates any rules. Purpose was to establish street cred, not advertise my business.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Spell Check for TM1 web
I'd be impressed if Firefox, or any browser, automatically validated text entry in TM1 Web - have you seen it do that?csb wrote:I would have thought that that this product would not require browser specific development, however that does not appear to be the case.
I'd say your problem isn't one of browser-specific development, but that TM1 Web, as an application, doesn't provide any spell-check on string entry. I imagine that it is do-able to implement it client-side (dirty hack alert), but it probably would end up costing you a lot more than the inconvenience of having to spell-check externally.
TM1 is really a numbers-orientated system and they don't show a lot of love towards people who want to work with a lot of text....
Robin Mackenzie
Re: Spell Check for TM1 web
Here is what I have found.
True, I am finding TM1 is numbers not text system.
Luckily, If you adjust your Firefox browser settings, you can get it to recognize websheet entries as text and spell check them, this was a serendipitous find for us.
However, Firefox is not rendering our websheets correctly, particularly in terms of the placement of buttons.
We have submitted a ticket to IBM on this issue.
Thanks for the help to date.
True, I am finding TM1 is numbers not text system.
Luckily, If you adjust your Firefox browser settings, you can get it to recognize websheet entries as text and spell check them, this was a serendipitous find for us.
However, Firefox is not rendering our websheets correctly, particularly in terms of the placement of buttons.
We have submitted a ticket to IBM on this issue.
Thanks for the help to date.
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Spell Check for TM1 web
I wouldn't hold my breath on this one. I doubt they'll devote any resources to fixing a TM1Web on Firefox issue for you. Have you tried another browser, like Chrome?csb wrote:We have submitted a ticket to IBM on this issue.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Spell Check for TM1 web
It's great that it does that... hope it comes in handy some day...csb wrote:Luckily, If you adjust your Firefox browser settings, you can get it to recognize websheet entries as text and spell check them, this was a serendipitous find for us.
I've had the same problem with the button placement and unfortunately I am at least as pessimistic as tomok about seeing it get fixed. IE is pretty much the standard everywhere and they are developing for that browser platform.csb wrote:However, Firefox is not rendering our websheets correctly, particularly in terms of the placement of buttons.
Robin Mackenzie