If you look at the attached screenshot you’ll see that the Xcelsius spreadsheet component isn’t displaying exactly what is in my excel model. If I enter the date ‘1/Oct/2006’ in my model/spreadsheet and display this using a spreadsheet component I get the date ‘30/Sep/2006’.
It took me a long time to find this bug in my model and I can’t for the life of me work out why it’s occuring. Can someone confirm whether it’s an Xcelsius bug or a problem with my environment (Xcelsius 2008, Excel 2003, Australian regional settings)???
I have Xcelsius 2008 SP2 installed on XP and wanted to confirm what “gcrow” was saying. In my case it shows ######## instead of an invalid date. So i guess, there is indeed some problem with dates and after further testing i could narrow down the problem with October month dates only for e.g. 31/10/2006 also shows #######.
Could someone in other regions check this as even i am in Australia.
i think it’s a bug, because i encountered it before and it’s really hard to analyze the problem. what i did is i have a cell that get’s the date, like this: b3=today() then on a different column i pointed a cell to b3 that will be shown in an xcelsius component: c2=b3-1; c3=b3; c4=b3+1 that solved my problem.
FYI the spreadsheet wasn’t imported. The screenshot that I posted above is the entire model. I just typed the three dates into the cells and displayed using the spreadsheet component.
I ended up getting around the problem by using 2/Oct/2006 (as for my purposes I was only using the year and month components).
(BOB member since 2009-07-15)
(BOB member since 2005-08-27)
(BOB member since 2008-10-28)
(BOB member since 2009-07-01)