Page 1 of 1

Table in Noventri Suite doesn't match Excel file

Posted: Thu May 03, 2012 6:00 pm
by sirluke34
Hello,
I have a few pages in a Noventri project that are pulling "databased" text fields from an Excel file. Each page will have text objects that reference different Excel "sheets/tabs" by column/row. A couple of my pages are working correctly, meaning pulling data and updating properly.

One page however, doesn't match the Excel file. When I link up the Excel file to the text file, I can see data in any tab using the advanced properties of the text box, except for this one. I do actually see data, but all data is 0.00, not populated like it is in Excel. I have tried recreating the page and the text fields in Noventri.

Below are some pics for reference. Is there anything I've overlooked?

Image
Image

Re: Table in Noventri Suite doesn't match Excel file

Posted: Fri May 04, 2012 8:03 am
by Trent S
Hello sirluke34,

This may be caused by the format that the cells containing those dollar values are in.

What format is your top row (containing column header names) in, and what format are your other cells (containing dollar values) currently in?

Kind Regards,

Re: Table in Noventri Suite doesn't match Excel file

Posted: Fri May 04, 2012 11:58 am
by sirluke34
Thanks Trent - this seemed to be the culprit. They were all formatted as a number/currency. I changed the top header row to text and the rest as a number and it worked just fine.

Thanks for the quick response.