Changeset 9585


Ignore:
Timestamp:
06/05/13 11:40:58 (6 years ago)
Author:
mkommend
Message:

#1730: Added necessary plugin dependency and improved error handling.

Location:
branches/ExportSymbolicDataAnalysisSolutions
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • branches/ExportSymbolicDataAnalysisSolutions/HeuristicLab.Problems.DataAnalysis.Symbolic.Views/3.4/MenuItems/ExportSymbolicSolutionToExcelMenuItem.cs

    r9584 r9585  
    8787          WriteInputSheet(inputsWorksheet, datasetWorksheet, formulaParts.Skip(2), solution.ProblemData.Dataset);
    8888
    89           ExcelWorksheet estimatedWorksheet = package.Workbook.Worksheets.Add("Estimated Values");
    9089          if (solution is IRegressionSolution) {
     90            ExcelWorksheet estimatedWorksheet = package.Workbook.Worksheets.Add("Estimated Values");
    9191            WriteEstimatedWorksheet(estimatedWorksheet, datasetWorksheet, formulaParts, solution as IRegressionSolution);
     92
     93            ExcelWorksheet chartsWorksheet = package.Workbook.Worksheets.Add("Charts");
     94            AddCharts(chartsWorksheet);
    9295          }
    93 
    94           ExcelWorksheet chartsWorksheet = package.Workbook.Worksheets.Add("Charts");
    95           AddCharts(chartsWorksheet);
    96 
    9796          package.Workbook.Properties.Title = "Excel Export";
    9897          package.Workbook.Properties.Author = "HEAL";
     
    309308
    310309      estimatedWorksheet.Cells["D2:D" + (rows + 1)].Formula = "ABS(B2 - C2)";
    311       estimatedWorksheet.Cells["E2:E" + (rows + 1)].Formula = "ABS(D2 / B2)";
     310      estimatedWorksheet.Cells["E2:E" + (rows + 1)].Formula = "D2 / B2";
    312311      estimatedWorksheet.Cells["F2:F" + (rows + 1)].Formula = "C2 - B2";
    313312      estimatedWorksheet.Cells["G2:G" + (rows + 1)].Formula = "POWER(F2, 2)";
  • branches/ExportSymbolicDataAnalysisSolutions/HeuristicLab.Problems.DataAnalysis.Symbolic.Views/3.4/Plugin.cs.frame

    r9462 r9585  
    3636  [PluginDependency("HeuristicLab.Data", "3.3")]
    3737  [PluginDependency("HeuristicLab.Data.Views", "3.3")]
     38  [PluginDependency("HeuristicLab.EPPlus", "3.1")]
    3839  [PluginDependency("HeuristicLab.Encodings.SymbolicExpressionTreeEncoding", "3.4")]
    3940  [PluginDependency("HeuristicLab.Encodings.SymbolicExpressionTreeEncoding.Views", "3.4")]
  • branches/ExportSymbolicDataAnalysisSolutions/HeuristicLab.Problems.DataAnalysis.Symbolic/3.4/Formatters/SymbolicDataAnalysisExpressionExcelFormatter.cs

    r9584 r9585  
    167167        stringBuilder.Append(")");
    168168
    169       } else if (symbol is HeuristicLab.Problems.DataAnalysis.Symbolic.Variable) {
     169      } else if (symbol is Variable) {
    170170        VariableTreeNode variableTreeNode = node as VariableTreeNode;
    171171        stringBuilder.Append(variableTreeNode.Weight.ToString(CultureInfo.InvariantCulture));
     
    185185        stringBuilder.Append(",0))");
    186186      } else {
    187         stringBuilder.Append("ERROR");
     187        throw new NotImplementedException("Excel export of " + node.Symbol + " is not implemented.");
    188188      }
    189189      return stringBuilder.ToString();
Note: See TracChangeset for help on using the changeset viewer.