tamc / excel_to_code Goto Github PK

spec.license = 'MIT'
# or
spec.licenses = ['MIT', 'GPL-2']

Failure: test_ranges_c3(TestExampleSpreadsheet [/Users/tamc/Documents/github/excel_to_code/spec/commands/excel_to_X_output_actual/c/test_examplespreadsheet.rb:46]: <:name> expected but was <0.0>.

test_ranges_c3(TestExampleSpreadsheet [/Users/tamc/Documents/github/excel_to_code/spec/commands/excel_to_X_output_actual/c/test_examplespreadsheet.rb:46]: <:name> expected but was <0.0>.

command = ExcelToC.new
command.excel_file = 'my_path_file'
command.output_directory = 'my_path_output'
command.output_name = 'test_model_c'
command.named_references_that_can_be_set_at_runtime = { "Control" => (44.upto(117).to_a.map { |r| "f#{r}" }) }

command.cells_to_keep = {
  "Resultados Intermedios" => :all, 
}
command.actually_compile_code = true
command.actually_run_tests = true
command.go!

16:51   Excel to Code version 0.3.17

16:51   Removing any old xml
bin/rails: No such file or directory - unzip -q 'c:/sites/calculator2050/docs/model/modelo_prueba.xlsx' -d 'C:/User
DRI~1/AppData/Local/Temp/d20170829-3496-1aaihpy'
16:51   Unziping excel into xml
16:51   Extracting shared strings
16:51   C:/Users/PRODRI~1/AppData/Local/Temp/d20170829-3496-1aaihpy/xl/sharedStrings.xml does not exist in xml(["sh
trings.xml"]), using blank instead
16:51   Extracting named references
16:51   C:/Users/PRODRI~1/AppData/Local/Temp/d20170829-3496-1aaihpy/xl/workbook.xml does not exist in xml(["workboo
"]), using blank instead
16:51   Extracting worksheet names
16:51   C:/Users/PRODRI~1/AppData/Local/Temp/d20170829-3496-1aaihpy/xl/workbook.xml does not exist in xml(["workboo
"]), using blank instead
16:51   C:/Users/PRODRI~1/AppData/Local/Temp/d20170829-3496-1aaihpy/xl/_rels/workbook.xml.rels does not exist in xm
rels", "workbook.xml.rels"]), using blank instead
16:51   Extracting Tables
16:51   Cells to keep includes :"Resultados Intermedios" but could not be found in workbook: []
Completed 500 Internal Server Error in 156ms

SUM(10:10 C:C) 

SUM(C10)

09:53   Excel to Code version 0.3.19
09:53   Removing old folders
/home/tur-ium/.rvm/gems/ruby-2.5.8/gems/excel_to_code-0.3.19/src/commands/excel_to_x.rb:299: warning: Insecure world writable dir /home/tur-ium/.rvm/gems/ruby-2.5.8/bin in PATH, mode 040777
09:53   Unzipping the spreadsheet
Traceback (most recent call last):
        5: from translate_excel_into_c.rb:46:in `<main>'
        4: from translate_excel_into_c.rb:29:in `translate_excel_into_c'
        3: from /home/tur-ium/.rvm/gems/ruby-2.5.8/gems/excel_to_code-0.3.19/src/commands/excel_to_x.rb:150:in `go!'
        2: from /home/tur-ium/.rvm/gems/ruby-2.5.8/gems/excel_to_code-0.3.19/src/commands/excel_to_x.rb:294:in `unzip_excel'
        1: from /home/tur-ium/.rvm/gems/ruby-2.5.8/gems/excel_to_code-0.3.19/src/commands/excel_to_x.rb:299:in execute_system_command'
/home/tur-ium/.rvm/gems/ruby-2.5.8/gems/excel_to_code-0.3.19/src/commands/excel_to_x.rb:299:in ': No such file or directory - unzip (Errno::ENOENT)

'G.20 (data)'!Q1149:'G.20 (data)'!Q

index(indirect("全局假设["&$C397&"]"),match(F$396,indirect("全局假设[年份]"),0))

Failures:

  1) ReplaceIndirectsWithReferences should replace INDIRECT() functions with the reference that they refer to, if they have been passed a string value
     Failure/Error: output.string.should == expected_output
     
       expected: "A1\t[:cell, :\"$A$5\"]\nA2\t[:function, :INDIRECT, [:cell, :\"$A$5\"]]\nA3\t[:function, :SUM, [:area...r, \"3\"]]\nA5\t[:cell, :\"$A$5\"]\nA6\t[:table_reference, \"X.a.autoproducao.info\", \"Vector\"]\n"
            got: "A1\t[:cell, :\"$A$5\"]\nA2\t[:function, :INDIRECT, [:cell, :\"$A$5\"]]\nA3\t[:function, :SUM, [:area...constant, \"C3545\"]], [:number, \"3\"]]\nA5\t[:cell, :\"$A$5\"]\nA6\t[:named_reference, \"X.a\"]\n" (using ==)
       Diff:
       @@ -3,5 +3,5 @@
        A3	[:function, :SUM, [:area, :"$A$5", :"$B$10"]]
        A4	[:function, :IFERROR, [:function, :INDEX, [:error, "#VALUE!"], [:constant, "C3545"]], [:number, "3"]]
        A5	[:cell, :"$A$5"]
       -A6	[:table_reference, "X.a.autoproducao.info", "Vector"]
       +A6	[:named_reference, "X.a"]