Can a chart be snapped to the Calc cell grid?

Discuss the spreadsheet application

Can a chart be snapped to the Calc cell grid?

Postby Recycler » Sun Jan 20, 2008 12:15 pm

I notice that there seems to be no built-in snap mechanism to align and resize charts to the worksheet's cell pattern. My charts therefore look slightly messy on the page because their borders are not quite properly aligned with cell borders.

The OO general snap to grid facility doesn't seem to help because this bears no relationship to the cell size & shape chosen by the user for a worksheet.

I can see that there could be complications with the idea of snap-to-cell layout were the user to 'pretty-up' his charts and subsequently decide to resize a column (for example), but I would have thought that would be a manageable problem.

Am I missing something here, please? Thank you.
Recycler
 
Posts: 14
Joined: Sat Jan 05, 2008 8:15 pm

Re: Can a chart be snapped to the Calc cell grid?

Postby acknak » Mon Jan 21, 2008 1:07 am

You can choose to anchor a graphic object (e.g. a chart) either to the page, or to a cell. Neither of these options provides any "snap" to any position: you still have to align/size the object with the cell grid manually, by eye. The "Anchor > To cell" option will try to follow the cell if the cell grid changes (e.g. changing column widths), but it is not very accurate or convenient.

You can turn the grid on, draw some guide lines to help align things, adjust the column/row sizes to align to the guide lines, then remove the guides.

Other than that, I can't think of any other way to help align things the way you want.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests