Ask Your Question

Checkboxes & Sorting [closed]

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

jodybingo gravatar image

updated 2020-08-09 00:11:52 +0100

Alex Kemp gravatar image

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-09 00:12:01.440209

2 Answers

Sort by » oldest newest most voted

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

pierre-yves samyn gravatar image

updated 2019-06-08 08:15:16 +0100


[EDIT 06-2019]

Since release 6.1 Images anchored to Calc cells can now be sorted, so the problem is solved. (thanks to @Ratslinger for "bringing up" this question).

[Below is initial text of my answer]

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


@jodybingo As you have been helped, please help others to know the question has been answered by clicking on the ✔ in upper left area of answer which satisfied the question.

Ratslinger gravatar imageRatslinger ( 2019-06-06 20:51:59 +0100 )edit

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

jodybingo gravatar image

Thank you!

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 436 times

Last updated: Jun 08 '19