https://bugs.documentfoundation.org/show_bug.cgi?id=160398
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=16 | |0411 Status|UNCONFIRMED |NEW Ever confirmed|0 |1 Keywords| |filter:xlsx --- Comment #6 from Stéphane Guillou (stragu) <[email protected]> --- (In reply to Eyal Rozenberg from comment #5) > (In reply to Richard M from comment #0) > > ... plot data on a World Map. For example given a dataset > > of [COUNTRY CODE, COUNT] you could > > see a "Count" over each country code with highlights. > This would be useful for sure, but - the question is whether your specific > request actually requires a new kind of chart, or can be a variation on an XY If it is automatically matched to a country code as OP suggests, it would need a new type. > Do we have an "Excel feature parity" tracker meta-bug? I couldn't find one... This table fills that role: https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_Microsoft_Office I've added this report to the table. > > No idea how such a chart is defined in OOXML, but supporting displaying it > > could be a separate ticket to supporting the creation / editing of such > > charts. > Are you sure? I would say keep it as a single bug, unless a developer tells > us they can fix only one of the two without the other. My understanding is that just displaying a static picture would be a lot easier to implement, and would be good to have independently from supporting creating these charts. > > I note that dealing with spatial data is quite the challenge. > Maybe in the most general case. But - in a simpler case, wouldn't an > "XY+Value" chart type (bug 160411), plus background map, be enough? That would be the simplest first subset of spatial charting, yes. > > - recognition of lat/lon coordinates for point data > What kind of recognition do you mean? LO being able to understand various formats of coordinates. Some examples here: https://www.earthpoint.us/Convert.aspx > > - a small set of projection options > Hmm... do you really want LO to "know" about 3D points and 2D projections? > As opposed to only recognizing 2D shapes, i.e. pre-projected shapes? What I mean is a set of common global projection options good enough for global datasets, for example: Gall-Peters (for equal area), Robinson (for familiarity), Mercator (kind of legacy, shouldn't be default)... but we could also somehow leverage the modern S2 library for a modern default: https://opensource.googleblog.com/2017/12/announcing-s2-library-geometry-on-sphere.html For more local data, we will need some understanding of different coordinate reference systems, but that's where it gets really hairy and where a choice of a solid, lightweight spatial library dependency is required. Note also the extension GeOOo that's been around for a while: https://extensions.libreoffice.org/en/extensions/show/geooo And EuroOffice Map Chart: https://extensions.openoffice.org/en/project/eurooffice-chart-map-0 (the company that developed it does not exist anymore) In any case, marking as New at least because we need to be able to render these Excel charts. -- You are receiving this mail because: You are the assignee for the bug.
