Bug 51670 - Add XYZ / Surface chart type
Summary: Add XYZ / Surface chart type
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 72045 81510 (view as bug list)
Depends on:
Blocks: docx-aggressive-competitors Additional-Chart-Types
  Show dependency treegraph
 
Reported: 2012-07-02 14:36 UTC by Valek Filippov
Modified: 2024-01-14 22:41 UTC (History)
12 users (show)

See Also:
Crash report or crash signature:


Attachments
file with a problem (39.00 KB, application/vnd.ms-excel)
2012-07-02 14:36 UTC, Valek Filippov
Details
Screenshot from XL2003 (38.11 KB, image/png)
2012-07-02 14:37 UTC, Valek Filippov
Details
This is Excel 4.0 from 1992 can do 3D plot (139.77 KB, image/jpeg)
2018-06-13 18:07 UTC, Joachim Otahal
Details
LibreOffice 7.1.2.2 XYZ Chart simulation (202.36 KB, application/octet-stream)
2021-04-01 12:07 UTC, Joachim Otahal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Valek Filippov 2012-07-02 14:36:24 UTC
Created attachment 63731 [details]
file with a problem

LO Calc 3.6b2 shows multiple 3d bars instead of surface on the chart.
Comment 1 Valek Filippov 2012-07-02 14:37:10 UTC
Created attachment 63732 [details]
Screenshot from XL2003

How it should look like.
Comment 2 Rainer Bielefeld Retired 2012-07-02 23:42:34 UTC
[Reproducible] with "LibreOffice  3.5.5.2.  German UI/Locale [Build-ID: 24b32b4-b87ec2e-85c8e98-87a4e20-9a1b8c1] on German WIN7 Home Premium (64bit), same with LibO 3.3.3 and OOo 3.1.1, so inherited from OOo.

Looks more or less ok with Gnumeric, fine with MS EXCEL Viewer. 

Another problem with a document created with SoftMaker software (?)

I doubt that many users are affected, so not MAB

@Valek Filippov:
Please contribute info concerning your OS!

@Kohei, @Markus:
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept
this Bug
Comment 3 Robert Cabane 2012-11-24 22:14:19 UTC
See :
https://issues.apache.org/ooo/show_bug.cgi?id=29012
(no solution is given there)
In order to address such chart types, we need a 3 surface renderer (I mean, something like z=F(x,y)).
One could (internally) delegate the plot to gnuplot.
Comment 4 Robert Cabane 2012-11-24 22:15:52 UTC
I'm using LO 3.6.2 under Linux, same effect as noted by the reporter.
Comment 5 Joel Madero 2013-12-22 17:18:04 UTC
*** Bug 72045 has been marked as a duplicate of this bug. ***
Comment 6 Joel Madero 2013-12-22 17:20:08 UTC
I am changing this to an enhancement request - we just don't have this particular type of charting ability, adding it is an additional feature and therefore an enhancement
Comment 7 Gerry 2014-05-20 09:40:27 UTC
There is a basic workaround available for surface charts:
http://ask.libreoffice.org/upfiles/13974882302570861.ods

Of course, it is not a replacement for real Surface charts, but it might be sufficient for a few use cases.
Comment 8 Owen Genat (retired) 2014-08-29 02:05:36 UTC
"Type" added to summary so that all enhancement requests relating to chart types are readily findable.
Comment 9 Joachim Otahal 2018-02-11 19:50:52 UTC
LO 6.0, and still no surface plot/chart.
Comment 10 Buovjaga 2018-06-13 16:54:20 UTC
*** Bug 81510 has been marked as a duplicate of this bug. ***
Comment 11 Joachim Otahal 2018-06-13 18:07:16 UTC
Created attachment 142713 [details]
This is Excel 4.0 from 1992 can do 3D plot
Comment 12 Xisco Faulí 2019-11-29 13:28:53 UTC
Changing priority back to 'medium' since the number of duplicates is lower than 5
Comment 13 birger 2020-03-22 22:09:25 UTC
Is it possible to contribute to bumping up the priority by commenting here or do I have to create a duplicate request? (Looking at the last comment here)

This is *the* feature I have been missing for many years. 3D surface plots are the best way I have found to visualize stuff like RAID controller performance. It would be very nice to have it built in instead of having to reformat data for gnuplot and run an external program.
Comment 14 Joachim Otahal 2020-03-22 22:31:41 UTC
(In reply to birger from comment #13)
> Is it possible to contribute to bumping up the priority by commenting here
> or do I have to create a duplicate request? (Looking at the last comment
> here)

Nope and Nope. Neither here or the feature request page. This request is simply turned down every time I contact them. Including Facebook and others.
The actual "usable" answer I got way: Pay one of the developers, and the MAYBE the feature will be programmed.
I would not have a problem shelling out three digit Euros for KNOWING this feature will be included within three month, and it's usability improved in later version. But in its current state LO does IMHO not have the right priority list. Making new icons is more important than a 28 year old excel feature - why?
Luckily there are other free office products, though not open source, which can do it when needed. Softmaker Freeofice is one example.
Comment 15 Joachim Otahal 2021-04-01 12:07:14 UTC
Created attachment 170892 [details]
LibreOffice 7.1.2.2 XYZ Chart simulation

This is the closest to a XYZ chart you can get with LO 7.1.2.2
Comment 16 Joachim Otahal 2021-05-06 14:03:06 UTC
I tried contacting certified developers again, like a few years ago. Clearly saying "you don't have to do it for free".
What is the problem with LO/Document Foundation not listening to users, not even when they don't have to do it for free.
It is like there is no interest in improving, no matter how old feature requests are, not matter how much they make sense.
Just because not enough users reporting dupes. Which means: Advanced users who know how to use the bugsearch are excluded this way.
Result: Giving up. Again. Being force to MS-Office and Softmaker Office 'cause LO does not have interest in users requests.
Comment 17 David Tardon 2021-05-07 13:33:00 UTC
(In reply to Joachim Otahal from comment #16)
> I tried contacting certified developers again, like a few years ago. Clearly
> saying "you don't have to do it for free".
> What is the problem with LO/Document Foundation not listening to users, not
> even when they don't have to do it for free.
> It is like there is no interest in improving, no matter how old feature
> requests are, not matter how much they make sense.

I wonder: have you considered the possibility that there may simply be no developer interested (enough) in working on this particular feature request?

(I love how the complainers almost always generalize from "my pet bug isn't receiving attention" to "LO is ignoring bug reports", "LO is not listening to users", or similar.)
Comment 18 Joachim Otahal 2021-05-07 13:54:20 UTC
(In reply to David Tardon from comment #17)
> (I love how the complainers almost always generalize from "my pet bug isn't
> receiving attention" to "LO is ignoring bug reports", "LO is not listening
> to users", or similar.)

You are absolutely right, this is one of those petty pet features. There is absolutely no reason denying. It is just one among some, but not many, features forcing me to use MS Office in parallel, even though many other small things in LO are better than in MS Office.
Comment 19 Thomas Bertels 2022-10-17 18:32:25 UTC
See https://app.bountysource.com/issues/3523535-add-xyz-graph-surface-chart if you want to add a bounty.
Comment 20 Joachim Otahal 2022-10-17 18:43:14 UTC
That bugbounty doesn't even work in a hardened Firefox. I don't dare to open that link in anything else than a hardened browser. Is this a scam? It looks so very much like scam to me!
Comment 21 Thomas Bertels 2022-10-21 18:28:10 UTC
https://en.wikipedia.org/wiki/Bountysource
Comment 22 Joachim Otahal 2022-10-21 19:42:15 UTC
Site worked today, same hardened browser. But sign-up does not work, never got confirmation mail - and all anti-spam is handled locally, so I CANNOT miss a mail.
I'd say: Bugbounty is dead since 2020. Citing you wikipedia link:
"In 2020 it was bought by a company named The Blockchain Group, which became the owner on July 1st."
If a site is in such a bad condition there is no base for any trust it actually does what it says it does. Like praymedia/calvali.