Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorrect date import from CSV #1719

Open
1 task done
Tyfaspo opened this issue Nov 11, 2024 · 2 comments
Open
1 task done

Incorrect date import from CSV #1719

Tyfaspo opened this issue Nov 11, 2024 · 2 comments
Assignees

Comments

@Tyfaspo
Copy link

Tyfaspo commented Nov 11, 2024

This issue is unique.

  • I have used the search tool and did not find an issue describing my bug.

Operating System

Linux (DEB package)

Version information

version 8.2.0.143 (deb)

Expected Behavior

AQI,Time ISO
46,2024-10-08T10:00:00Z

Converts date to text or correct date format
+---+---------------------------------+
|46|08/10/2024 10:00:00 | - Date
|46|2024-10-08T10:00:00Z | - Text

Actual Behavior

AQI,Time ISO
46,2024-10-08T10:00:00Z

Converts date to incorrect text or incorrect date
+---+-------------------------------+
|46|08/10/2024 12:00AM | - Date
|46|45573 | - Text
image

Reproduction Steps

Open CSV with ISO 8601 Date, import with default options

Additional information

Installed from AUR on Arch Linux.
Same issue with web version.

@LuckySpecialist
Copy link
Member

Hi @Tyfaspo, сan you attach an example of CSV file where the problem is observed?

@Tyfaspo
Copy link
Author

Tyfaspo commented Nov 12, 2024

test.csv
test2.csv

These are examples of many CSV files that I have this problem for past half a year of using onlyoffice, but in new preview window date does look correct

image

After importing data, time in the date was lost, and saving the file will overwrite data incorrectly

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants