Excel VBA - Random extra grouping levels -


this not issue affects code rather question of table's appearance. so, table summary of records income , expenses of different business departments. let's call each department type of record. each of types has subtype1. each subtype1 has subtypes2 , each subtype2 has subtypes3. sample data this.

1, type1, sum of subtypes1 1.1, subtype1, sum of subtypes2 1.1.1 subtype2, sum of subtypes3 1.1.1.1 subtype3, amount 1.1.1.2 subtype3, amount 1.2, subtype1, sum of subtypes2 1.2.1, subtype2, sum of subtypes3 1.2.1.1, subtype3, amount

each subtype can have different number of "children subtypes". children subtypes can't go further subtype3.

then using vba script group records of same subtype under direct parent main type. works fine, can expand or hide every single level of structure. however, logically group outline on left side of table rows should show 4 levels. instead shows 8 levels of groups. first 4 expect, show or hide respective subtypes while other 4 levels absolutely nothing expected because don't see reason them there.

any ideas why levels have been created , how rid of them? might have explained in not clear way feel free ask further information.

try stepping through code in trace mode watch groups being set up. (open vba window , use f8 key loop 1 line @ time) may reveal why groups being defined , suggest change.


Comments

Post a Comment

Popular posts from this blog

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

bash - Performing variable substitution in a string -

i have string contains use of variable, , i'd substitute variable's value string. right best have is #!/bin/bash foo='$name; echo bar' name="the name" expanded="$(eval echo "$foo")" echo "$expanded" which has obvious defects: prints the name bar while i'd print the name; echo bar instead of eval can bash's regex matching bash's string replacement: foo='$name; echo bar' name="the name" [[ "$foo" =~ \$([[:alnum:]]+) ]] && s="${!bash_rematch[1]}" && expanded="${foo/\$${bash_rematch[1]}/$s}" echo "$expanded" name; echo bar
Read more