https://bugs.kde.org/show_bug.cgi?id=523820
Bug ID: 523820
Summary: xlsx import problem
Classification: Applications
Product: LabPlot2
Version First 2.12.1
Reported In:
Platform: Microsoft Windows
OS: Microsoft Windows
Status: REPORTED
Severity: normal
Priority: NOR
Component: Data
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 194822
--> https://bugs.kde.org/attachment.cgi?id=194822&action=edit
screenshots & sample data
DESCRIPTION
When importing an XLSX worksheet containing separate Date and Time columns, the
import preview displays both columns correctly. The Date column contains the
calendar date, and the Time column contains the actual measurement time.
However, after completing the import, the Time column is not present in the
imported LabPlot spreadsheet. LabPlot creates a single Date & Time column, but
the time component of every imported value is reset to 00:00:00.
This causes all measurements from the same day to receive the same X
coordinate. Consequently, time-series curves contain vertical segments and
appear stepped or distorted.
Example values displayed correctly in the import preview:
Date: Wed Feb 19 2025
Time: 13:28:28
Date: Wed Feb 19 2025
Time: 13:30:00
Date: Wed Feb 19 2025
Time: 13:37:56
Corresponding values after import:
Wed Feb 19 00:00:00 2025
Wed Feb 19 00:00:00 2025
Wed Feb 19 00:00:00 2025
STEPS TO REPRODUCE
Create or open an XLSX worksheet containing separate Date and Time columns,
with several different time values recorded on the same date.
Import the XLSX worksheet into LabPlot using the Excel 2007+ (XLSX) import
filter. Verify in the import preview that both the Date and Time columns are
displayed correctly.
Complete the import and inspect the resulting LabPlot spreadsheet and a
time-series plot using the imported Date & Time column as the X variable.
OBSERVED RESULT
The Time column is missing after the import is completed.
LabPlot creates a Date & Time column, but the time component of every value is
set to 00:00:00. All measurements recorded on the same date therefore have the
same X coordinate.
This produces vertical line segments and distorted, step-like time-series
curves.
EXPECTED RESULT
The imported data should preserve the original time values.
Either:
the Date and Time columns should remain separate after import; or
if LabPlot combines them into a single Date & Time column, the combined values
should contain both the original date and the original time.
For example:
Wed Feb 19 13:28:28 2025
Wed Feb 19 13:30:00 2025
Wed Feb 19 13:37:56 2025
SOFTWARE/OS VERSIONS
Operating System: Windows 11
LabPlot Version: 2.12.1
Import format: Excel 2007+ (XLSX)
KDE Plasma Version: Not applicable
KDE Frameworks Version: [enter version if shown in About LabPlot]
Qt Version: [enter version if shown in About LabPlot]
LabPlot 2.12.1
Release build 2.12.1-3-gd4f909a Aug 18 2025, 09:17:37
System:
Windows 11 Version 25H2
Locale:
Croatian, Croatia
Number Format:
1000.01 (Updated on restart)
Architecture:
x86_64-little_endian-llp64
Kernel:
winnt 10.0.26200
Components:
Qt 6.8.3
KDE Frameworks 6.17.0
Cantor 25.08.0
CFITSIO
Discount 2.2.7
Eigen3 3.4.0
FFTW3 3.3.7
GSL 2.7
HDF5 HDF5 library version: 1.14.6
KSyntaxHighlighting 6.17.0
KUserfeedback 6.17.0
libcerf missing
liborigin 3.0.2
Matio 1.5.21
MCAP 1.4.0
NetCDF 4.8.0
ORCUS 0.20.0
Poppler 25.08.0
Purpose 6.17.0
QADS 2.12.1
Qt MQTT 6.8.3
Qt SerialPort 6.8.3
Qt Svg 6.8.3
QXlsx 1.4.4
ReadStat
Vector BLF git
C++ Compiler: MSVC 19.44.35214.0
C++ Compiler Flags: -IC:/Craft/windows-msvc2022_64-cl/include/boost-1_86
-EHsc /we4715 /W3 /wd4250 /wd4251 /wd4396 /wd4661 /Zc:__cplusplus
-W3
-DPSAPI_VERSION=1 /Zc:externC-
-O2
ADDITIONAL INFORMATION
The original XLSX worksheet is correct. The import preview also displays the
Date and Time columns and their values correctly. The loss of the time
component occurs only after the import is completed.
Attachments include:
a screenshot of the XLSX import preview showing correct Date and Time values;
a screenshot of the imported LabPlot spreadsheet showing all times reset to
00:00:00;
a minimal XLSX file reproducing the issue.
--
You are receiving this mail because:
You are watching all bug changes.
