Ask Your Question
1

How to align numerous checkboxes in Calc.

asked 2016-04-02 14:47:30 +0100

Muldoonsghost gravatar image

updated 2016-04-03 18:14:20 +0100

C:\fakepath\checkbox example 1.ods

My spreadsheet (just my home accounts) uses dozens of checkboxes. If a bill is paid (tick the box) then take the amount from the amount still to be paid out and show corrected balances. Easy.

But, if I resize the sheet for any reason the alignment of the checkbox to the cell it's linked to sometimes goes off. It just leaves an untidy sheet with boxes drifting away. How can I force a checkbox to fill the cell that it is linked to? Is there a way to do it for lots of boxes in one formula?

Thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-04-02 19:00:31 +0100

m.a.riosv gravatar image

I think could be easy using Menu/Data/Validity and formatting the cell, two click for select instead one.

DataValidityOk.ods

edit flag offensive delete link more

Comments

1

Maybe I'm being thick here? If I enable design mode to be able to place the checkbox then select it, validity is greyed out.

I see your example, please see mine. Col E has the checkboxes and cols F & G would be hidden.

Muldoonsghost gravatar imageMuldoonsghost ( 2016-04-02 22:56:08 +0100 )edit

Please share again your sample, I can't see it.

m.a.riosv gravatar imagem.a.riosv ( 2016-04-02 23:18:43 +0100 )edit
1

Can't attach my example or upvote yet, dayam. Haven't got 3 points.

http://www.thunderin.co.uk/calc/ It's in this directory.

Muldoonsghost gravatar imageMuldoonsghost ( 2016-04-02 23:19:57 +0100 )edit

I have voted you comment to get the points, please try again.

m.a.riosv gravatar imagem.a.riosv ( 2016-04-02 23:22:17 +0100 )edit

Please try again.

m.a.riosv gravatar imagem.a.riosv ( 2016-04-03 01:49:47 +0100 )edit

Thanks for the votes. I've now added my example to my original post.

I'm in the UK so have been asleep and at work since my last post.

Muldoonsghost gravatar imageMuldoonsghost ( 2016-04-03 18:16:00 +0100 )edit
1

In your sample the checkbox control it's 'anchored To Page', I think to get it working fine when you resize or insert/delete rows/columns, you need to have it 'anchored To Cell', with the whole box positioned inside the cell.

m.a.riosv gravatar imagem.a.riosv ( 2016-04-03 23:48:32 +0100 )edit

Thanks for looking. In my example I thought I had done that, I had, slowly, one at a time, for each cell in my working sheet. But they still drifted off, hence hoping I could set them in place programmatically.

Never mind, it was just 'icing on the cake'.

Muldoonsghost gravatar imageMuldoonsghost ( 2016-04-04 21:14:20 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-04-02 14:47:30 +0100

Seen: 698 times

Last updated: Apr 03 '16