vim/bundle/vim-table-mode/t/formula.vim


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

" vim: fdm=indent
source t/config/options.vim

describe 'Formulas'
  describe 'Add Formula'
    before
      new
      read t/fixtures/formula/sample.txt
    end

    it 'should add a formula successfully'
      call cursor(6, 15)
      call tablemode#spreadsheet#formula#Add("Sum(1:3)")
      Expect tablemode#spreadsheet#cell#GetCell() == '125.0'
      call cursor(8, 15)
      Expect getline('.') == '/* tmf: $4,2=Sum(1:3) */'

      call cursor(7, 15)
      call tablemode#spreadsheet#formula#Add("Sum(1:-1)")
      Expect tablemode#spreadsheet#cell#GetCell() == '250.0'
      call cursor(8, 15)
      Expect getline('.') == '/* tmf: $4,2=Sum(1:3); $5,2=Sum(1:-1) */'
    end
  end

  describe 'Evaluate Formula'
    before
      new
      read t/fixtures/formula/formula.txt
    end

    it 'should evaluate the formula successfull'
      call cursor(6, 15)
      call tablemode#spreadsheet#formula#EvaluateFormulaLine()
      Expect &modified == 1
      Expect tablemode#spreadsheet#cell#GetCell() == '125.0'
    end
  end
end