Ask Your Question
0

Checkboxes & Sorting

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

jodybingo gravatar image

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

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
0

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

pierre-yves samyn gravatar image

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

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) 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.

Regards

edit flag offensive delete link more

Comments

@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 +0200 )edit
0

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

jodybingo gravatar image

Thank you!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 113 times

Last updated: Jun 08