Error in formula..

[avijit]

I am using OWC for creating a smart client in excel.
In my code I am sending an XML request over Http and getting an XML response
which I am populating in a excel page(in an excel template with a schema
mapped in it).Then I am doing some calculation in the excel page.
eg. =(Sheet1!E15/Sheet1!E5)*100

Now my problem is when I execute the code the formula chages automatically
and gives me error. What is the problem??

Please let me know if you need more details on what I am doing.

 

[Wei-Dong XU [MSFT]]

Hi,

Could you be so kind to post the error message here? And if you attch one
repro workbook here, that will be very helpful for us on the research of
this issue. Thanks in advance! If you don't want to post the repro workbook
in the newsgroup, you could also mail it to me. My email account is:
(e-mail address removed) (please remove "online" avoiding the spam).

Expect to your update!

Best Regards,
Wei-Dong XU
Microsoft Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Wei-Dong XU [MSFT]]

Hi Avijit,

Thank you for the file and repro code!

Based on my research, your excel workbook doesn't put all the xml schema so
this xml data is not exportable; I can only save the workbook into one
spreadsheet xml. After that, I run your code and found there was no
"C:\EXCELProject\ProductivityMonitor.txt" available and the web service
call can't be executed. So I'd suggest you could save your web service call
result (in your sample code, the returend string is stored in the vairable
"responseFromServer") directly into one xml file and send it to me. Then I
could research this based on it then.

Look forward to your file!

Best Regards,
Wei-Dong XU
Microsoft Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.