Bug 60822

Summary: Support chart sheets in calc
Product: LibreOffice Reporter: bugquestcontri
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: adams13soft, aron.budea, batavist, christoph, franciscoadriansanchez, himajin100000, joe, kelemeng, LibreOffice, libreoffice, ozsolarwind, rb.henschel, sandor.mes
Priority: medium    
Version: 3.6.5.2 release   
Hardware: Other   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=81514
https://bugs.documentfoundation.org/show_bug.cgi?id=38212
Whiteboard: BSA
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107334    
Attachments: image of chart wizard with indication where the location choice could be shown

Description bugquestcontri 2013-02-14 00:48:15 UTC
Created attachment 74792 [details]
image of chart wizard with indication where the location choice could be shown

Problem description: 
Calc offers only a chart being on the same sheet as the data. Although copying a chart on a new sheet and expand it full window size is possible and maintain the links to the data. However, this takes a lot of work and reduces productivity. 

Solution:
Enable Calc to let users choose location of charts can be selected
- beside data only
- in a separate sheet only (like MS EXCEL)
- beside data AND in a separate sheet. (not available in EXCEL thus a unique feature of Calc)

Default: beside data

Location of the new feature: at the bottom of the chart wizard; see attached image, yellow marked text

The idea came up in AskLibO
http://ask.libreoffice.org/en/question/11775/how-can-i-put-a-chart-on-a-separate-sheet-in-calc/#comment-12087




Operating System: Windows XP
Version: 3.6.5.2 release
Comment 1 Rainer Bielefeld Retired 2013-02-14 07:06:58 UTC
I think we are talking about something similar as we already have for the pivot table. There we have a selector "Results to", where it can be selected where the pivot table should appear.

@bugquestcontri
is my assumption correct?
Comment 2 bugquestcontri 2013-02-17 11:59:06 UTC
I am not aware of the pivot table issue, thus, cannot sat Yes or NO.
Comment 3 Markus Mohrhard 2013-03-12 23:21:26 UTC
This requires to support chart sheets and is a big task. It is part of our GSoC ideas but I have no idea if there will be a student applying for it.

It requires us to rework how we handle sheets in calc core.
Comment 4 bugquestcontri 2013-03-24 11:22:45 UTC
I am sorry to hear that this requires a major change.

I keep fingers crossed that someone applies for this job because it really would be a very nice feature. Especially the part "beside data AND in a separate sheet. (not available in EXCEL thus a unique feature of Calc)"
Comment 5 Joe Nahmias 2015-04-07 17:26:56 UTC
It has been two years.  Any updates on this enhancement?
Comment 6 bugquestcontri 2015-04-21 10:58:47 UTC
At least I would appreciate highly if this feature is implemented. It saves a lot of copy & paste and size adjustment work.
Comment 7 adams13soft 2015-08-22 22:23:13 UTC
One can split this into two tasks.

First, add an interface possibility to create / move chart to a separate sheet. It does not necessarily require changing the core since a chart as a separate sheet is available in MS excel import and one can take the existing routine, which will create a worksheet with a chart. This does not require any core change but will solve at least 80% of the problem.

Second, if there will be a possibility to have a chart as a separate sheet in a workbook, one will have to update the routine to have everything clean and nice.
Comment 8 Regina Henschel 2018-03-04 15:50:44 UTC
Having a new typ of sheets for charts is covered by bug 108913. So let us keep this for the UI option to generate the chart on a new sheet. That would combine the currently three operations "generate chart", "create new sheet" and "move chart to new sheet".
Comment 9 Regina Henschel 2018-03-04 15:53:50 UTC
*** Bug 116181 has been marked as a duplicate of this bug. ***
Comment 10 m_a_riosv 2022-02-15 16:06:51 UTC
*** Bug 147428 has been marked as a duplicate of this bug. ***