Bug 135540 - TABLEIMPORT CALC: Format of the header of a table is copied while importing data to the content of all rows
Summary: TABLEIMPORT CALC: Format of the header of a table is copied while importing d...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-08-07 17:45 UTC by Robert Großkopf
Modified: 2024-09-15 14:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
try to import the data of the table. Look for the format. (7.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-08-07 17:45 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2020-08-07 17:45:54 UTC
Created attachment 164040 [details]
try to import the data of the table. Look for the format.

Take the attached little *.ods example file.
The header for the table is set to bold and underlined.
Import the content to Base.
Set in the import wizard "First row as fieldnames".
Set ID to primary key.
Finish.

All the content of the table will be shown underlined and bold.
1. This is the wrong format for the content. It has been the format from the header.
2. No format will be saved in a database. So it will only irritate if there appears a format. People in the international users List had the header with black background and white font. The black background couldn't be set in the table - but all content had been white - and a white background.

This bug appears in all here installed LO-versions, starting with LO 6.1 and ending with LO 7.0.0.3 under OpenSUSE 15.2 Linux.
Comment 1 elmau 2020-08-07 19:30:57 UTC
Confirm bug in ArchLinux

Version: 6.4.5.2
Build ID: 6.4.5-2
CPU threads: 8; OS: Linux 5.7; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 2 Pulkit Krishna 2020-08-08 02:39:52 UTC
Confirm bug in Windows 10

Version: 7.0.0.2 (x64)
Build ID: c01aa64b6c3d89ebe5fe69c28c7adb24eb85249c
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Comment 3 Robert Großkopf 2020-08-08 07:42:36 UTC
I set this bug to NEW. See comment 1 and 2.

Seems the Bug is inherited from OOo. Its the same behavior in AOO.
Comment 4 QA Administrators 2022-08-09 03:39:00 UTC Comment hidden (obsolete)
Comment 5 Robert Großkopf 2022-08-09 05:29:22 UTC
Still the same buggy behavior in LO 7.4.0.2 on OpenSUSE 15-3 64bit rpm Linux.
Comment 6 QA Administrators 2024-09-14 03:15:48 UTC Comment hidden (obsolete)
Comment 7 Robert Großkopf 2024-09-15 14:14:27 UTC
Bug still exists in 
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 0427231a1485d324519e94246ff702bc0cb18b89
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded