[LON-CAPA-users] Spreadsheet question

[Guy Albertelli II]

Hi Todd,

> A question about the spreadsheet for the few others of you that use it.
>  At the student level, I can use &SUMSEQ("F","regexp:Homework")
> to sum all the values in column "F", in every folder that has "Homework"
> in it, as an effective way to to get a homework total.
> 
> However, if a "Homework" folder has sub-folders, this does not recurse
> down the tree, which is a "good thing" for many reasons.
> 
> I'm wondering, though, if there is a way to tell &SUMSEQ that I actually
> want it to recurse through all sub-folders.

Nope.

You can, (if you name the subfolders similarly) use the regexp so it
also match all of the subfolders "regexp:(Homework|Sub Folder)"

So a small amount of naming consistancy could make it apply
recursivley...


-- 
guy@albertelli.com   0-7-0-9-27,137