Bug 60822

Summary:	Support chart sheets in calc
Product:	LibreOffice	Reporter:	bugquestcontri
Component:	Chart	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	LibreOffice
Version:	3.6.5.2 release
Hardware:	Other
OS:	Windows (All)
Whiteboard:	BSA
i915 platform:		i915 features:
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)"

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.