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?
Hi
[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)
Either use a validity list to insert these symbols
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.
Regards
@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.
Thank you!
