Input field in chart(straight table)

[#1]

Hi,

I have read some discussions in forums but i can't get my wish done up to the end.

I want to have some inputfields to my chart table  where i could pass some values from macro.

I did this way:

In script i load the fields:

INPUTFIELD inpFld1,inpFld2,inpFld3;

LOAD * INLINE [

    inpFld1, inpFld2, inpFld3

   ];

Then i added the fields inpFld1 to my chart table as an expression:

=inputsum(inpFld1)

From macro I'm trying to write anything to this fields but seems this field is not writable for some reason:

set obj = ActiveDocument.GetSheetObject("CH07")

obj.SetInputFieldCell 2,8,"999"

And nothing is happening. I also can't change the value on the input fields in chart manually as well. I can type the value but when i press enter it just disapears.

What I am doing wrong?

Thanks

Julius

[#2 · Accepted solution]

I made it to work. Seems like the input field has to have an unique reference to row. here is what i did:

INPUTFIELD inpFld1;

load

RowNo() AS inpFld1,

now i get unique row numbers in fields and can edit them