https://bugs.documentfoundation.org/show_bug.cgi?id=115012
Buovjaga changed:
What|Removed |Added
See Also||https://bugs.documentfounda
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
László Németh changed:
What|Removed |Added
Resolution|--- |FIXED
Status|NEW
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #23 from Commit Notification
---
László Németh committed a patch related to this issue.
It has been pushed to "master":
https://git.libreoffice.org/core/+/f684c074d5f66c8b1546a626766bc045c04cebc3%5E%21
tdf#115012 XLSX chart
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
Commit Notification changed:
What|Removed |Added
Whiteboard||target:6.3.0
--
You are r
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #22 from Adam Kovacs ---
https://opengrok.libreoffice.org/xref/core/chart2/source/tools/ChartTypeHelper.cxx?r=21b22421#600
--
You are receiving this mail because:
You are the assignee for the bug.
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #21 from Adam Kovacs ---
20.64 chart:treat-empty-cells
The chart:treat-empty-cells attribute specifies how missing and invalid values
are plotted
in a chart.
The defined values for the chart:treat-empty-cells attribute are:
-
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #20 from Adam Kovacs ---
https://opengrok.libreoffice.org/xref/core/chart2/source/tools/DiagramHelper.cxx?r=21b22421#1544
https://opengrok.libreoffice.org/xref/core/chart2/source/view/main/ChartView.cxx?r=0d1253c2#522
https:
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #18 from Adam Kovacs ---
Some related stuff in LibreOffice:
https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1chart_1_1MissingValueTreatment.html
--- Comment #19 from Adam Kovacs ---
https://opengrok.li
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #18 from Adam Kovacs ---
Some related stuff in LibreOffice:
https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1chart_1_1MissingValueTreatment.html
--
You are receiving this mail because:
You are the assi
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
Aron Budea changed:
What|Removed |Added
See Also||https://bugs.documentfounda
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #17 from Adam Kovacs ---
Some related stuff in Excel:
https://www.extendoffice.com/documents/excel/4374-excel-skip-blanks-in-chart.html
--
You are receiving this mail because:
You are the assignee for the bug.___
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #16 from Adam Kovacs ---
How to reproduce it:
1. Open Excel/Calc
2. Write some values in a column, one of them should be ="" (an empty formula),
for example: 1, ="", void cell, 3
3. Select the area of column
4. Insert a line
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #15 from Adam Kovacs ---
Created attachment 149671
--> https://bugs.documentfoundation.org/attachment.cgi?id=149671&action=edit
empty formula line chart in excel vs calc
I was wrong when I thought that this bug was about Li
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #14 from Adam Kovacs ---
Created attachment 149522
--> https://bugs.documentfoundation.org/attachment.cgi?id=149522&action=edit
line chart empty cells and nan cells in excel vs calc
this screenshot shows what is the differe
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #13 from Adam Kovacs ---
Created attachment 149521
--> https://bugs.documentfoundation.org/attachment.cgi?id=149521&action=edit
line chart vs stacked line chart in MSO
another comparsion in Excel 2016
--
You are receiving
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #12 from Adam Kovacs ---
Created attachment 149520
--> https://bugs.documentfoundation.org/attachment.cgi?id=149520&action=edit
line chart vs stacked line chart in MSO
By the way, by default, MSO line charts also use gaps f
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #11 from Adam Kovacs ---
Created attachment 149422
--> https://bugs.documentfoundation.org/attachment.cgi?id=149422&action=edit
sal_debug_calc_cell_content_2
So if we write this...
*pArr = rItem.mbIsValue ? rItem.mfValue :
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #10 from Adam Kovacs ---
In the member function ScChart2DataSequence::getNumericalData():
https://opengrok.libreoffice.org/xref/core/sc/source/ui/unoobj/chart2uno.cxx?r=b4f38d8b#2923
There is a line:
*pArr = rItem.mbIsValue ?
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #9 from Adam Kovacs ---
https://cgit.freedesktop.org/libreoffice/core/commit/?id=18b3138a7ac4da823e41640bed8a4707029b8fb0
--
You are receiving this mail because:
You are the assignee for the bug._
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #8 from Adam Kovacs ---
This can be also related:
https://bugs.documentfoundation.org/show_bug.cgi?id=102621
--
You are receiving this mail because:
You are the assignee for the bug.__
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #7 from Adam Kovacs ---
Created attachment 149406
--> https://bugs.documentfoundation.org/attachment.cgi?id=149406&action=edit
sal_debug_calc_cell_content
Refreshing the topic with some links.
The file you were talking abo
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #6 from Aron Budea ---
Some comments from Markus on IRC:
<@moggi> the behavior, it is not the chart side but the calc side that forces
us to interpret ="" as empty
<@moggi> implemented in ScChart2DataSequence::BuildDataCache
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #5 from Aron Budea ---
An idea: add a GAP_MSO variant to the internal representation of the attribute
values (the name is just for identification in this comment).
Gap value in ODS chart would be imported as GAP, but in XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #4 from Aron Budea ---
Interesting difference in wording as well.
Excel:
- Show empty cells as: Gaps / Zero / Connect data points with line.
Calc:
- Plot missing values: Leave gap / Assume zero / Continue line.
The bug occu
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #3 from Aron Budea ---
The problem here is that the same setting (leave gap for missing values) is
interpreted slightly differently in Excel and in Calc: the mentioned cell
content (="") is considered a missing value in Calc,
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
Xisco Faulí changed:
What|Removed |Added
Status|UNCONFIRMED |NEW
CC|
https://bugs.documentfoundation.org/show_bug.cgi?id=115012
--- Comment #1 from Aron Budea ---
Created attachment 139099
--> https://bugs.documentfoundation.org/attachment.cgi?id=139099&action=edit
Screenshot in Excel
--
You are receiving this mail because:
You are the assignee for the bug.___
27 matches
Mail list logo
