search

home-assistant / core

:house_with_garden: Open source home automation that puts local control and privacy first.
https://www.home-assistant.io
Apache License 2.0
73.45k stars 30.69k forks source link

issue with number format on downloaded history csv #116985

Closed ChristophCaina closed 2 weeks ago

ChristophCaina commented 6 months ago

The problem

I am currently playing around with the csv download from the history - and noticed, that it is not using the number format selected in my profile.

decimal numbers are using a "."

sensor.steckdose_kuhlschrank_zusammenfassung_geliefert,275.69,2024-05-05T22:00:00.000Z
sensor.steckdose_kuhlschrank_zusammenfassung_geliefert,275.7,2024-05-05T22:51:14.066Z
sensor.steckdose_kuhlschrank_zusammenfassung_geliefert,275.71,2024-05-05T22:58:07.369Z
sensor.steckdose_kuhlschrank_zusammenfassung_geliefert,275.72,2024-05-05T23:06:18.727Z

which is causing some issues when importing the csv into my excel ... grafik

Instead, the CSV should use the language and settings for number formats selected in the User-Profile. In this case, decimal numbers should use a comma "," instead... the number needs to be included in doublequotes to be a valid csv

expected format as per my profile settings:

sensor.steckdose_kuhlschrank_zusammenfassung_geliefert,"275,69",2024-05-05T22:00:00.000Z
sensor.steckdose_kuhlschrank_zusammenfassung_geliefert,"275,7",2024-05-05T22:51:14.066Z
sensor.steckdose_kuhlschrank_zusammenfassung_geliefert,"275,71",2024-05-05T22:58:07.369Z
sensor.steckdose_kuhlschrank_zusammenfassung_geliefert,"275,72",2024-05-05T23:06:18.727Z

What version of Home Assistant Core has the issue?

2024.5.2

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

No response

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

No response

Additional information

No response

ChristophCaina commented 3 months ago

any feedback on this one?

issue-triage-workflows[bot] commented 3 weeks ago

There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates. Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment 👍 This issue has now been marked as stale and will be closed if no further activity occurs. Thank you for your contributions.

ChristophCaina commented 1 week ago

up