Ask Your Question

Checkboxes & Sorting

asked 2019-02-01 22:31:12 +0100

jodybingo gravatar image

updated 2019-02-01 22:47:00 +0100

I am using Calc for a weekly reservation list. The list includes name, date, time, contact info, group size etc. We regularly sort the list by date then by time. On occasion we have cancellations. I want to create a checkbox that would indicate a reservation was cancelled (it would strikethrough all the cells needed for that reservation). But....when I sort, the checkbox follows but the linked cell does not update.

Can I make that linked cell change in a sort?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-02-02 15:42:23 +0100

jodybingo gravatar image

Thank you!

edit flag offensive delete link more

answered 2019-02-02 12:13:13 +0100

pierre-yves samyn gravatar image

updated 2019-02-02 12:23:50 +0100


You described the problem well.... AFAIK if you need to sort you can't use checkboxes.

I can only propose workarounds:

  • Either type "C" (for example) in the "Cancelled" column
  • Either use the context menu to insert by macro a "checkbox (unchecked)" symbol (must accept to run macros) image description

  • Either use a validity list to insert these symbols image description

In any case, base the conditional formatting (which strikes out the cells) on this value.

See an example of the last two proposals in the attached checkbox.ods.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-01 22:31:12 +0100

Seen: 34 times

Last updated: Feb 02