Date format

  • Resolved areality

    (@areality)


    10 years, 11 months ago

    Hi,

    Is there a way to make Visualizer 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 Vizualizer 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 change locale to the US in the Google Spreadsheets, data appears on Visualizer charts 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 quick move to feed Visualizer with Eurpopean-style dates?
    Thanks!

    https://www.ads-software.com/plugins/visualizer/

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Date format’ is closed to new replies.