Ask Your Question

Add tags in Calc [closed]

asked 2012-03-14 20:19:39 +0200

PetruD gravatar image

Is there a way I can add a list of "tags" in a Calc table then search/sort elements in that table based on those tags. The tags would be something like "abcd,xyz,spqr".

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 2015-10-18 03:10:33.754916

2 Answers

Sort by » oldest newest most voted

answered 2012-03-14 23:24:37 +0200

m.a.riosv gravatar image

From where is the list added?

Will be easier to help if you upload a file with a sample about what you want to get.

edit flag offensive delete link more

answered 2012-09-25 19:18:17 +0200

I think what the OP wants (please confirm) is this:

fruit | colors

orange | yellow,white,green

apple | red,white,green

banana | yellow,white

all_colors | red | green | yellow | white

Then a menu where he chooses the phone and tags range, chooses a separator (","), and can then says sort by column 2, first those lines which contain the tag, say "yellow", and then those that do not.

I would also love to see a way to select the cells under tags, and say: suggest autocomplete with content one of the cells from under all_tags (this is indicated by selecting those cells)

[should be a comment on the question, but I can't find how to do this sorry]

edit flag offensive delete link more

Question Tools


Asked: 2012-03-14 20:19:39 +0200

Seen: 761 times

Last updated: Sep 25 '12