How can i display my listbox data like this

[#1]

Hi All,

I have found the below listbox in API guide(Automationmembers Sheet) .I don't how the listbox is showing data like this.I see the script but i didn't understand.

But i need this requirement.

Can anyone suggest me how can i achieve this with some sample data?

Thanks....

[its_anandrjs]

Hi,

The object that you ask for it is a hierarchical view for this you need to create a data like hierarchy view by the use of  Hierarchy(Fields,.,.,.,.,.) by this you achieve this type of view.

Regards,

Anand

[#3]

Hi Anand,

Thanks for your reply

Please reply with one simple example.

Thanks...

[Or]

I found this explanation useful. See if it helps.

[its_anandrjs]

Hi,

See the attached sample for clearity, it is explaining small data how to show the hiererchical view of the data.

Regards,

Anand

[#6]

Hi Shoham,

I don't need like this (this is treeview structure).

The problem with this is If i want to select any child ,i need to expand it's parent.

I need only like the image what i have attached in my earlier post.

Sample data:

World

   Europe

     UK

     France

      Italy

   Africa

     Nigeria

     South Africa 

   Asia

     Singapore

     Japan

     China

   North America

     USA

     Canada

   South America

     Australia

     New Zeeland

   Oceania

     Colombia

     Brazil

Thanks....

[#7]

Hi Anand,

But the image what i have attached is showing the data not like this.

Any Idea about the data representation like that as in API guide?

Thanks...

[Or]

Unfortunately, the example you provide from the API guide is not in any way a hierarchy - it is simply a list of items, some of which have leading whitespaces. These items are sorted in load order and thus look like a hierarchy would, but they are not in any way related (to confirm this, you can open the listbox, change the sort order, and see what happens). You could copy that technique as long as you maintain the correct order, I suppose...

[SunilChauhan]

hello

when u see code of api guide you will find

mapindents:

mapping load * inline [

x1,x2

Button,Button

CurrentSelection, CurrentSelectionBox

GraphBasics,    GraphBasics

Graph,        Graph

PivotTableBox,        PivotTableBox

StraightTableBox,        StraightTableBox

InputBox,    InputBox

LineArrow,    LineArrowObject

ListBox,    ListBox

MultiBox,    MultiBox

StatisticsBox,    StatisticsBox

TableBox,    TableBox

TextObject,    TextObject

CustomObject,    CustomObject

BookmarkObject,    BookMarkObject

Slider,    Slider

];

you will see all items have some space after comma.

if remove this comma you will see all items willl look like a list box.

see the attached file.

[its_anandrjs]

Hi,

Yes it is different that i explain to you it is a hierarchy view.

Regards,

Anand