TM1 Forum

is it possible to get information what does user exactly enter to cell? We got user with values 4,..... E+180. But we don't think She entered 4.........0000...0000 (180 zeroes). We suppose she entered something like 4...E... that was a mistake of course. Transaction don't provide information about this only final value.

No, TM1 doesn't record how a user entered the value they entered. Whether they did it by inputting a single figure, using data spreading or a keyboard shortcut, you will only be able to see the end result, I'm afraid.

ioscat wrote:is it possible to get information what does user exactly enter to cell? We got user with values 4,..... E+180. But we don't think She entered 4.........0000...0000 (180 zeroes). We suppose she entered something like 4...E... that was a mistake of course. Transaction don't provide information about this only final value.

I think your guess is a pretty good one that the user entered 4e180. I can't think of any other way to achieve that result.

lotsaram wrote:I think your guess is a pretty good one that the user entered 4e180. I can't think of any other way to achieve that result.

Especially that E is right under 4 on the keyboard, so it's easy to press these two keys together. Solution? Tell users to use the numeric pad on the right side of the keyboard!