Page 1 of 8

Excel tricks

Posted: September 13th, 2012, 10:04 am
by BrightDay
Are you very bored today?

Excel tricks

Posted: September 13th, 2012, 11:56 am
by DevonFangs
I like it

Excel tricks

Posted: September 13th, 2012, 1:07 pm
by DevonFangs
Actually, there's something I wanted to ask around: I know Excel is a good piece of software under several points of view, but am I the only one who f*cking hates the sh*t out of it.

Excel tricks

Posted: September 13th, 2012, 1:50 pm
by DevonFangs
what do you mean withQuoteOriginally posted by: outrun however from an coding point of view there is no need for that whining.Actually, maybe what I don't like is having to write XL addins.

Excel tricks

Posted: September 13th, 2012, 2:47 pm
by Cuchulainn
There are many roads leading to Rome..The C++ ATL and Shared add in wizards are becoming much easier to use, recently.Raw XL looks intimidating.And then there's C# and Excel-DNA. Latter is very user-friendly. DF,Excel addin demos

Excel tricks

Posted: September 13th, 2012, 4:04 pm
by DevonFangs
QuoteOriginally posted by: CuchulainnThere are many roads leading to Rome..The C++ ATL and Shared add in wizards are becoming much easier to use, recently.Raw XL looks intimidating.And then there's C# and Excel-DNA. Latter is very user-friendly. DF,Excel addin demosExcel DNA is very human-friendly indeed. However, one often has to use some proprietary XL interface...

Excel tricks

Posted: September 13th, 2012, 6:06 pm
by Cuchulainn
If you are feeling ambitious you can build an addin with COM and IDTExtendibility2 a mano, brick by brick. Having done that, let ATL do it.

Excel tricks

Posted: September 13th, 2012, 7:55 pm
by tagoma
QuoteOriginally posted by: outrunthe thing I really hate is when you want to move a block of cells with a some merged cells in it to a different empty section. It always warns "Some cells will be unmerged .. bla bla", the same here! that makes me groan each time. eh .. "bark" more exactly

Excel tricks

Posted: September 14th, 2012, 2:32 pm
by tagoma
QuoteOriginally posted by: outrunI have a spreadsheet with the definition of a tree.Each node in the tree is a row in a table with these columns:* node_id* parent_node_id* distance_to_root* descriptionHow can I get a visual representation of the tree, prefereable like a directory structure, and prefreable without VBA, -eg. using a pivot table-? EDIT:Solved it at the Oracle backend with the START WITH and CONNECT BY hierachical SQL language extension. Nice of Oracle to provide that type of query functionality!did you write a script based on the hierachical SQL language extension to build a tree outside of Excel ?