We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Reading DDE-syntax formulae

Thread ID:

Created:

Updated:

Platform:

Replies:

58278 Mar 21,2007 03:40 PM UTC Apr 5,2007 12:24 PM UTC Windows Forms 5
loading
Tags: XlsIO
Giles Thomas
Asked On March 21, 2007 03:40 PM UTC

Hi,

I am trying to import an Excel spreadsheet that uses DDE syntax to fetch data, but I cannot see the formula when I look at the Cell object provided by XlsIo. In Excel (file attached), you see the following formula:

=BLP|M!'GBPEUR Curncy,[PX_MID]'

However, none of the fields on the Cell contained this as far as I could see; I looked at Formula, Text, FormulaStringValue and FormulaNumberValue. Formula was the closest, but it just contained "GBPEUR Curncy,[PX_MID]"

Does XlsIo support DDE syntax? If so, how do I access formulae that use it? I'm using version 4.4.0.51.


Regards,

Giles


blp-with-funny-dde-syntax.zip

Melba Winshia [Syncfusion]
Replied On March 22, 2007 10:39 AM UTC

Hi Giles,

I was able to reproduce the problem. If we get the formula by using sheet.Range[ "B1" ].Formula "GBPEUR Curncy,[PX_MID]" is displayed instead of "BLP|M!'GBPEUR Curncy,[PX_MID]'". However this issue has been fixed in our internal version. Here is the video clip for your reference:

4.4.0.51
--------

4_4.zip

Upcoming version:(works fine)
----------------

Upcoming.zip

The fix for this issue will be available in our next release, which would be in the last week of March.

Kindly let me know if you have any other questions.

Regards,
Melba

Giles Thomas
Replied On March 23, 2007 02:27 PM UTC

Thanks, Melba - I look forward to seeing the new version next week.


Regards,

Giles

Melba Winshia [Syncfusion]
Replied On March 26, 2007 04:35 AM UTC

Hi Giles,

Thanks for the update.

Kindly let me know if you have any other questions.

Regards,
Melba

Giles Thomas
Replied On April 4, 2007 05:46 PM UTC

Hi,

Any update on when the new version will be available?


Regards,

Giles

Melba Winshia [Syncfusion]
Replied On April 5, 2007 12:24 PM UTC

Hi Giles,

Thanks for being patient.

Could you please refer the following forum thread to obtain the beta version of Essential Studio v5?

http://www.syncfusion.com/support/Forums/message.aspx?&MessageID=57573

Kindly let me know if you have any other questions.

Thanks,
Melba

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;