Macro FCTreeView/hr

Description
Macro for list all objects in the project in one list without hierarchy, options sort by name, label, visibility, group, by length option search by name, label .... without case sensitive or with case sensitive and select all objects displayed in the macro window.

Section Window
The title display the option, number and type object(s) displayed

If one object are selected : the Placement Base, Rotation and Center of mass is displayed (if available !) Icon used for the Name of object (the scrollbar is colored blue)
 * O = Objects
 * N = Name
 * L = Label
 * T = Total
 * G = Group
 * S = Single
 * V = Visible
 * H = Hidden

Icon used for the Label of object (the scrollbar is colored blue clear)

Icon used for visualise if the object is status Visible (mouse click for Hidden) (the scrollbar is colored green)

Icon used for visualise if the object is status Hidden (mouse click for Visible) (the scrollbar is colored red)

Icon used for the Name contains objects (or folder Group)

Icon used for inform the object in a group the number objects is displayed in top group (the scrollbar is colored red clear)

Icon used for displayed the single object (not group)

Section Sort by :
Icon used for flip/flop normal/reverse the data listing sort by Name

Icon used for flip/flop normal/reverse the data listing sort by Label

Icon used for flip/flop normal/reverse the data listing sort by Visibile/Hidden

Icon used for flip/flop normal/reverse the data listing sort by Group/Single object

If this check Box is checked the sort is created by length with the button clicked (Name, Label ...)

Section Global
flip/flop Split the Name list

flip/flop Split the Name and Label list

flip/flop the data listing Fold/Expend

flip/flop the data listing Expend/Fold

flip/flop normal/Visibility

flip/flop normal/Group

reload the data in the project

return in original organisation after operation visibility/Hidden

visualise if the object is status Visible

visualise if the object is status Hidden

Section Search
Clear the search line edit

The radioButton options Search:

 * ("NLwc") : Search by Name and Label Without respecting the sensitive Case


 * ("Nsc") : Search by Name and respecting the Sensitive Case


 * ("Lwc") : Search by Label Without respecting the sensitive Case


 * ("NLsc") : Search by Name and Label and respecting the Sensitive Case


 * ("NLwsc") : Search by Name and Label in Word and respecting the Sensitive Case (same panel selection of FreeCAD)


 * (Nu) : Search by numeric value (radius, length, angle .....) see version section

flip/flop for Selected all object(s) displayed in the window

flip/flop Unselected all object(s)

access in Spreadsheet options

The SpreadSheet options:





 * CheckBox options for select the data to save in spreadsheet






 * Value : alone the value is saved in the cell
 * Ex : 10.00 [[File:Macro FCTreeView 30.png]]
 * Val Gr : the value and the unit are saved in unique cell
 * Ex : 10.00 mm [[File:Macro FCTreeView 31.png]]
 * Val Gr Ph : the value, the unit and the physic data is saved in unique cell
 * Ex : 10.00 mm Length [[File:Macro FCTreeView 32.png]]
 * Split : if the Split checkBox is checked, the data is cut saved in separate cell
 * Ex : 10.00 | mm | length [[File:Macro FCTreeView 33.png]]


 * Combobox mm : select the unit length desired. The value is convert in the selected unit. The units length available are:
 * km, hm,  dam,  m,   dm,  cm,  mm,  um,  nm,  pm,  fm,  in,  lk,  ft,  yd,  rd,  ch,  fur,  mi,  lea,  nmi
 * Combobox gram : select the unit weight desired. The value is convert in the selected unit. The units weight available are:
 * t, q,    kg,   hg,   dag,  g,    dg,   cg,   mg,   µg,   ng,   pg,  fg,   gr,   dr,   oz,   oz t,  lb, t lb,   st,   qtr,  cwt,   tonneau fr,    ct
 * Spinbox Densite : give the density by dm3 of the material used (Default : 1.0000)
 * Spinbox Round : give the round value desired (Default : 3)


 * Combobox Name spreadSheet : List the spreadsheet in the document
 * Line edit Name spreadSheet : Display the actual spreadsheet or give the name for the new spreadsheet



select all checkbox options

unselected all checkbox options

save the data in Spreadsheet displayed. if no spreadsheet is active the spreadsheet named FCSpreadSheet is created

quit the Spreadsheet options

Ikone
The icon must be copied into the same directory as the macro



Script
For prevent many instance the clic on ToolBar button are effect flip/flop (hide/visible)

The macro is located in right dock for change it modify the value line number 133 testing       = 0 (or change it with the mouse as a widget normal)

The icon ToolBar

Macro_FCTreeView.FCMacro

Za napraviti
Docked the macro

Version
ver 00.07 (06/05/2018) : modify procedure for search the last cell used

ver 00.06 (13/12/2017) : correct little bug line del line num 1881 "del listeSortedBis[doublon][4:] # supprime le fond inutile" thanks renatorivo

ver 00.05 (27/11/2017) : add creation spreadsheet and many option for him

ver 00.04 (29-09-2017) : add search by numeric value (length, radius....)

values researched :

ver 00.03 (23/09/2017) : add search by type object

ver 00.02 (11/09/2017) : modify for docked and prevent many instance the clic on button are effect flip/flop (macro hide/visible)

ver 00.01 (08/09/2017) :