Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

[Calc] interactive drop-down?

Hi guys,

I'm not sure if what I want is possible, but maybe anyone of you can tell me if it is.

Lets say in Calc we create 2 tabs. In the second tab I would like to create "categories" with options, for example:

     A      B   
1  color   size
2  red     small
3  blue    medium
4  green   large

The first row acts as a "category", in this case "color" and "size" and the underlaying cells are the options for that specific category. Now what I would like to do, is on the first tab being able to select a category. Once I picked a category, in the next cell I would like to choose one of the options, so you get something like this:

     A           B   
1  CATEGORY   OPTION
2  color      blue
3  size       small

Can this be done?