https://bugs.documentfoundation.org/show_bug.cgi?id=163418
Bug ID: 163418
Summary: Database range is not updated correctly when importing
csv text data.
Product: LibreOffice
Version: 24.8.2.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Database range is set to an incorrect range if importing csv data with only one
column regardless of the number of rows or one row regardless of the number of
columns. It works as I expect if the source csv file contains at least two
columns and two rows.
Steps to Reproduce:
1.Make a csv file with one column and any number of rows or one row and any
number of columns.
2.Select a range from A1 to B2 in a sheet. Then click Data -> Define Range and
name the Range.
3.After naming the range click "External Links" and select the csv file and
import the data.
Example data for the csv:
ColA,ColB,ColC
A1,B1,C1
A2,B2,C2
A3,B3,C3
A4,B4,C4
A5,B5,C5
Actual Results:
1) If only one column with 6 rows is imported, then the range is set from A1:B2
to A1:A2.
2) If 3 columns with only one row are imported, then the range is set form
A1:B2 to A1:B1.
Expected Results:
1) I expect the range to be set to A1:A6
2) I expect the range to be set to A1:C1
If at least 2 columns and 2 rows are imported, then range "is set" as I expect
it from A1:B2 to A1:B2.
For example 3 columns and 6 rows the range is set to A1:C6 as I would expect.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 480(Build:1)
CPU threads: 128; OS: Linux 6.11; UI render: default; VCL: kf6 (cairo+wayland)
Locale: de-DE (de_DE.UTF-8); UI: en-US
24.8.2-1
Calc: threaded Jumbo
--
You are receiving this mail because:
You are the assignee for the bug.
