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!
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.
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.
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