https://bugs.documentfoundation.org/show_bug.cgi?id=120348
Bug ID: 120348
Summary: Copy-paste of line chart to another spreadsheet
results in data loss if the data-range of the chart
contains cells that have value ERR:502
Product: LibreOffice
Version: 6.0.6.2 release
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 145415
--> https://bugs.documentfoundation.org/attachment.cgi?id=145415&action=edit
Spreadsheet contains data and chart. Copying chart to another spreadsheet
results in corrupted chart.
I have numerical data in four columns. These columns contains references to
cells in other columns eg. LOG(C6). Some of the cells that are referenced are
blank. This results in ERR:502 (log(0)!).
I select the columns and insert a chart: Insert -> Chart -> Line. I select
"Lines only". I get a line chart where the parts of the lines that refer to
ERR:502-cells are not drawn (This is the desired behaviour). I can copy the
chart (Ctrl-C, Ctrl-V) on the same spreadsheet with no corruption.
I then paste the chart on another spreadsheet, text document, drawing or
presentation. The chart is otherwise identical to the original one except:
Only the first part of the line that is non-continuous due to ERR:502-cells is
present on the copied chart. The latter parts of the line are not shown.
(One of the lines is also non-continuous due to empty cells (no error). This
line is copied correctly.)
I inspected the copied charts: Right-click -> Data table... The data table does
not contain values after the first blank area of the corrupted line. It seems
that the data for the line does not get copied after cells that contain
ERR:502.
The data table of the copied chart contains only values and empty cells. It
does not contain cells that have value "ERR:502".
Work-around:
1. "Export as image" results in correct png-images that can be imported to
other documents.
2. The sheet could be modified so that no ERR:502 cells are present.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
