On a SharePoint 2010 page,
- I have HTML form web part that has a simple text box control and
- Excel Web Access webpart that shows an excel that too has a name(defined name) and defined as parameters in Excel and
- Html form webpart is connected to send the text box control's value to Excel web access webpart.
Now with this setup, I am able to change values in a text box and on HTML form submit, that value is passed to EWA and I can see that on the page.
But the problem is if I remove the value(read blank text box) and submit HTML form, I don't see the blank value is being passed. I still see the old value passed by the user.
If a user removes a value and submits, I want the cell in the excel also should be empty.
I tried sending
#Value! nothing worked.
Any help would be highly appreciated