• Another Excel Services (Skydrive) Example

    This particular file will show an interactive breakeven analysis for an event entailing food and beverage.

    You can interact with the file and have the chart redraw. Probably the best route is to adjust by very large amounts to see the effects.

    Here you go, have a play!

    Quote Originally Posted by Gregory
    on March 3rd, 2011 at 11:00 pm

    Nice worksheet.

    I didn’t realize that clicking one of the icons at the bottom right, which shows “Information about this workbook” also gives the embed code.

    It worries me that nowhere on Microsoft’s Sky Drive do you have control over showing the spreadsheet link and embed code to the interactive users. Did they say anything about that at the MVP Summit?
    Hi Greg,

    I don’t think we covered that. We have the ability to set our SkyDrive folder rights to allow certain things (who can view it, for example).

    I noticed that embed part in the more info button too. The user can also open the full workbook in WebApp by using the button in the bottom right, then save it to their hard drive. I haven’t dug around yet, but I highly doubt that, at this stage, you’ll be able to remove either of those from the iFrame. It would certainly be nice if we could though, as that would give us a little more control as to what happens to the files.
    Quote Originally Posted by Bob Phillips
    on March 4th, 2011 at 9:11 am

    Interestingly, I note that I am stuck with your (crappy North American) date format – I cannot enter a date of 25/2.
    Bob, I formatted it as an ISO compliant date. Is that any better?
    Quote Originally Posted by Bob Phillips
    on March 7th, 2011 at 3:03 pm

    No, it’s not actually. I still have to enter 2/25, which is just not natural to we Europeans.
    Quote Originally Posted by Bob Phillips
    on March 7th, 2011 at 3:04 pm

    It has to be that the software has not international setting to tap into, so it imposes American.
    Quote Originally Posted by Bob Phillips
    on March 7th, 2011 at 3:07 pm

    I had another thought, maybe it works in IE (I rarely use IE). But it was just the same.
    Quote Originally Posted by Dan B [MS
    ]on March 10th, 2011 at 11:22 am

    Hey Bob, Ken,

    Some good news for you (maybe). The locale for dates and numbers, etc. is take from your web browser accept-lang – so dates should actually display correctly if that is set to a locale where month/day are backwards – where backwards is umm, whatever you define as backwards .

    Couple things need to happen to make this work though:

    First – the cell should be formatted in Excel as “General” and then default to the “first” Date format in the list of date formats (Ken – the one that says “*3/10/2011″ today – the “*” there means that it adjusts for different locales that the user might use – if you explicitly choose a date format that isn’t one of the first two, then you won’t get this behavior)

    Second, the web browser (yours Bob) needs to be setup correct for accept-lang. You can see how yours is setup by going to this page: http://www.battagin.com/dan/resources.htm and click on the “asp debugger” link. In the response, you’ll find your accept language. If it’s not one that by default uses dd-MM, then you’ll want to update your browser – usually in the settings somewhere – to use a different accept-language.

    I gave this a try here on this page with French (fr-FR) and sure enough, when I enter dates, they end up “backwards” like this: 25/2/2011, and the numbers are all formatted “funny” too – commas where periods should be and whatnot

    Hope that helps guys!

    Thanks Dan!

    I’ve updated the file. Bob, does it work better now?
    So based on further testing here, setting the language to [en-GB] didn’t seem to affect things for me here. As Dan said though, changing to [fr-FR] did work to push it to DD/MM/YYYY.

    It’s a shame that we can define our own local specific settings in Excel though. I try to format all my date cells in the yyyy-mm-dd ISO standard, but have my users enter in MM/DD format. They know that if it converts then the date is a valid date.

    Ideally, I’d like users in other countries to be able to enter in DD/MM format and have it still convert to the ISO standard. It doesn’t look like that’s a possibility here though.

    Still, good to know that we can at least give a format that the users would expect.
    Quote Originally Posted by Bob Phillips
    on March 11th, 2011 at 3:14 pm

    I generally use Firefox, and when I tried Dan’s page it was telling me that the ACCEPT_LANGUAGE was en_us. I couldn’t find where in Firefox to change it.

    So I tried IE, and this told me its (IEs) ACCEPT_LANGUAGE was en_gb. However, I still couldn’t input 25/2 in that date field.
    Try setting it to fr-FR. That one seems to work. But if en-GB is supposed to be using a DD/MM standard, then it would appear that IE is showing a bug, no?

    Re Firefox, I haven’t tried it, but this page points to how to change the default language: http://forums.mozillazine.org/viewto...?f=38&t=880485


    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!


    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!