[O] how to refer row's by name in a spreadsheet formula?
Hi list, Formulas reference in a long table are very easy corrupted by manually inserting. so, I think, refer using name instead of num. is better. but how to refer the rows by name? For example, |---+--+-++-+--| | ! | date | amount | item | account | note | | | date | amount | item | account | note | |---+--+-++-+--| | _ | | bamount || | | | | | 12 | lunch | pocket | | | | | 59 | dinner | pocket | | | ^ | | eamount || | | |---+--+-++-+--| | _ | | total || | | | # | | #ERROR || | | |---+--+-++-+--| #+TBLFM: $total=vsum($bamount..$eamount);%.2f I'd expected $bamount..$eamount is the range of @II$amount..@III$amount, but it's not. $bamount and $eamount are epxanded to the values too early. Changsheng Jiang
Re: [O] Largest org file you have + performance
My largest org file is QuanSongCi.org, contains ci poetry of Song dynasty, about 6MB size. Editing in emacs is very slow, save needs to wait about minutes. convert to html needs to wait about minutes, too. So, sometimes, sed like tools is preferred to do editing and converting. Changsheng Jiang On Fri, Aug 5, 2011 at 04:18, Milan Zamazal wrote: > My largest org file is an org-drill file of almost 1 MB size, containing > about 32000 lines (most of them are entry properties) and 2000 org-drill > entries. It's well useable but tag and property editing is better to be > done by hand instead of using org commands and I have to use some > folding trick to prevent org-drill performance problems. > > > >
