Ask Your Question

Working with charts as with gnuplot [closed]

asked 2012-12-04 23:00:15 +0200

filo gravatar image

updated 2012-12-08 00:09:42 +0200

qubit gravatar image

Hi all!

I had this idea while working with Calc. As I mentionned in an older post, where I work, we produce a _lot_ of charts. And that always ends up as hours of copy & paste/click to change the source or title or axis or whatever/endless work.

First thing I tried is to work with macros, but the thing is, it's not very practical.

The second one that came to my mind is that it would be great to be able to work with charts just as with plain text. Say for example you want to change the axis range for many charts, you would just create a search & replace pattern with a key like x_axis_range and move it to whatever you like. Or say that I'm copying a sheet, and just changing a few values, I know that the error bars references still refer to the old page. I could just do a search & replace to fix it everywhere instead of doing it by hand.

To summarize, I would see it something like right-click on a chart => get chart attributes, edit & save.

Any idea if that would be feasible?

Thanks! Laurent

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 13:13:35.199029


@filo -- It looks like part of what you want is a programmatic interface for manipulating the features/layout of the charts. Have you tried saving files as flat-ODF, manipulating the XML, then opening them again?

qubit gravatar imagequbit ( 2012-12-23 14:00:33 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2012-12-15 15:14:10 +0200

filo gravatar image


No luck with that idea, although it's still my ideal! What I came up with is more work with the macros. It's possible to do regexp on the titles for example if you need to change them in batch. Same with the data sources. However, for example, if you need to change the data sources for error bars, you're in badluck, after hours of digging, I couldn't find a way to change it.

If anybody has ideas about this last point, I'd be glad to hear it!

edit flag offensive delete link more

answered 2012-12-10 17:11:56 +0200

Any luck with that? I need exactly the same thing!

edit flag offensive delete link more

Question Tools


Asked: 2012-12-04 23:00:15 +0200

Seen: 1,074 times

Last updated: Dec 15 '12