prevent users from entering text valuesin data region of input schedule

[former_member288392]

Hello,

When users send data & by mistake a data input cell is written with text , then the original value of the cell becomes a zero.

Is there any way , i can prevent this techincally.

Some options are excel data validation which is not fool proof as text can still be be copy pasted..

The next option is a macro which is cumbersome, as i have to specifically check for individual range of cells rather than the entire sheet.

Is there a way , that BPC can automatically deny a text value /or makes no change when text is entered to data input cell?

thanks.,

sridhar

[Former Member]

Hi,

If you just want the data validation feature in your input schedule, I would suggest you to have the data validation in the first cell, and after the expansion, the validation will be copied to all the other cells.

Alternatively, you can make use of the advanced format range.

[former_member185837]

Nilanjan Chatterjee wrote:
If you just want the data validation feature in your input schedule, I would suggest you to have the data validation in the first cell, and after the expansion, the validation will be copied to all the other cells.

Hi Nilanjan,

your point on data validation is interesting, cause I'm struggling to make it work in a scenario similar to the OP's (I detailed my specific issue in this post).

Basically, I set validation in the 1st cell, but then it is NOT copied to all other cells when expanding.

How's that? Should expansion work as you suggest (i.e. copying validation settings to all cells), it would address my needs!

Hope you or somebody else could give me some hints.

* UPDATE

I've solved this issue. The solution is described here:

http://scn.sap.com/thread/3209213

Message was edited by: Davide Cavallari

[Former Member]

HI Sundaram,

Try using advanced formatting, this will helps you with the cell format of your schedule. http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/70573b01-657a-2b10-a2b2-ec54bb0a9c8c

Regards

[krishna_priya1]

As you said data validation doesn't work when user does copy paste . Only way to deal with validation in your case is to use macro at client or use WRITE_BACK BADi at server side .

Which SP level you are on ? I tried sending text & number data at same time , BPC ignores text data and I am getting success message only to number data . For example , if i have modified one cell to text data and another cell with new amount ,i am getting success message for only one cell . When refreshed work book i am getting old data for first cell and modified data for second cell ,which is as expected.