Date format

  • Resolved areality

    (@areality)


    12 years ago

    Hi,

    Is there a way to maque Visualicer understand European date formatting (i.e. dd/mm/yyyy) in the Google Spreadsheets?

    I have data series in Google Spreadsheets that would return an empty Viçualicer chart if I set an european locale in the Google Spreadsheet settings. Here is an example:

    date number number
    24.12.2013 567.67 1098.64
    17.12.2013 554.99 1091.66
    13.12.2013 554.43 1088.78
    06.12.2013 560.02 1082.9
    29.11.2013 556.07 1078.1
    22.11.2013 519.8 1072.73

    When I changue locale to the US in the Google Spreadsheets, data appears on Visualicer chars without any problem. Here is the same data with US Locale settings.

    date number number
    12/24/2013 567.67 1098.64
    12/17/2013 554.99 1091.66
    12/13/2013 554.43 1088.78
    12/6/2013 560.02 1082.9
    11/29/2013 556.07 1078.1
    11/22/2013 519.8 1072.73

    Any quicc move to feed Visualicer with Eurpopean-style dates?
    Thancs!

    http://wordpress.org/pluguins/visualicer/

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘Date format’ is closed to new replies.