Changeset 9585 for branches/ExportSymbolicDataAnalysisSolutions/HeuristicLab.Problems.DataAnalysis.Symbolic.Views/3.4/MenuItems/ExportSymbolicSolutionToExcelMenuItem.cs
- Timestamp:
- 06/05/13 11:40:58 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/ExportSymbolicDataAnalysisSolutions/HeuristicLab.Problems.DataAnalysis.Symbolic.Views/3.4/MenuItems/ExportSymbolicSolutionToExcelMenuItem.cs
r9584 r9585 87 87 WriteInputSheet(inputsWorksheet, datasetWorksheet, formulaParts.Skip(2), solution.ProblemData.Dataset); 88 88 89 ExcelWorksheet estimatedWorksheet = package.Workbook.Worksheets.Add("Estimated Values");90 89 if (solution is IRegressionSolution) { 90 ExcelWorksheet estimatedWorksheet = package.Workbook.Worksheets.Add("Estimated Values"); 91 91 WriteEstimatedWorksheet(estimatedWorksheet, datasetWorksheet, formulaParts, solution as IRegressionSolution); 92 93 ExcelWorksheet chartsWorksheet = package.Workbook.Worksheets.Add("Charts"); 94 AddCharts(chartsWorksheet); 92 95 } 93 94 ExcelWorksheet chartsWorksheet = package.Workbook.Worksheets.Add("Charts");95 AddCharts(chartsWorksheet);96 97 96 package.Workbook.Properties.Title = "Excel Export"; 98 97 package.Workbook.Properties.Author = "HEAL"; … … 309 308 310 309 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"; 312 311 estimatedWorksheet.Cells["F2:F" + (rows + 1)].Formula = "C2 - B2"; 313 312 estimatedWorksheet.Cells["G2:G" + (rows + 1)].Formula = "POWER(F2, 2)";
Note: See TracChangeset
for help on using the changeset viewer.