Changing data between Excel and Xcelsius

[Former Member]

I have a Xcelsius 4.5 app that is not displaying data correctly. The app has a combination chart that is connected to a series of cells in an excel spreadsheet. When I connect the combination chart to those cells via that data range and/or series the combination chart displays the data correctly. When I preview the data though I get incorrect data. It subtracts the data in cell 1 from all the other cells. Any ideas what is happening here?

This is what is originall displayed (top row for the columns, bottom row for the line):

first row:

42 52 68 68 68 68 86 97 97 102

second row:

50 67 64 61 58 89 102 102 102 102

But then in preview mode the first value (42) is subtracted from every number and that is displayed instead

first row:

- 10 26 26 26 26 44 55 55 60

second row

8 25 22 19 16 47 60 60 60 60

By the way, the same thing happens when I put the data into a table.

Edited by: bwiegert on Sep 3, 2009 5:17 PM

[Former Member]

Please give some idea about how did you resolve this issue. because i am facing the same issue.in my excel i have 5 tabs(sheets) and it is refering the cells from 0ne sheet to another sheet also.

[former_member186358]

Fremlin,

I just had a quick look at the Spreadsheet you had sent...

I am unable to figure out the problem, because there is no data, looks like it is getting data at run time.

I am sure there is some calculation happening that is manipulating the target cells.

-Anil

[Former Member]

As an aside, I have noticed another thing that might cause this type of behavior is the maximum rows setting. If it is set too low truncation of data occurs. To change this setting go to Data/Maximum Rows... and change the setting. Do not set it too high or it may affect the load time for your app negatively.

[Former Member]

Thank you Anil

[former_member186358]

Welcome to SCN!!

Can you please share the excel file, you can contact me through my profile..

-Anil

[Former Member]

Hello Anil, thank you for your response!

I deleted approx 5 hidden tabs from the excel spreadsheet I was working with, and then refreshed my connection. This meant that I had to remove formulas (copy, paste special/values) from other tabs that my tab referred to, but I did not remove any formulas from the tab that Xcelsius was pointing to. This took care of the problem, but I am not sure why.

Do you have any idea why this would resolve my issue, and do you still want to see the spreadsheet now that the issue is resolved?

[former_member186358]

No, that is fine as long as your issue is resolved

-Anil