|
1 /* |
|
2 * Copyright (c) 2010 Nokia Corporation and/or its subsidiary(-ies). |
|
3 * All rights reserved. |
|
4 * |
|
5 * Redistribution and use in source and binary forms, with or without |
|
6 * modification, are permitted provided that the following conditions are met: |
|
7 * |
|
8 * - Redistributions of source code must retain the above copyright notice, |
|
9 * this list of conditions and the following disclaimer. |
|
10 * - Redistributions in binary form must reproduce the above copyright notice, |
|
11 * this list of conditions and the following disclaimer in the documentation |
|
12 * and/or other materials provided with the distribution. |
|
13 * - Neither the name of Nokia Corporation nor the names of its contributors |
|
14 * may be used to endorse or promote products derived from this software |
|
15 * without specific prior written permission. |
|
16 * |
|
17 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" |
|
18 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE |
|
19 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE |
|
20 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE |
|
21 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR |
|
22 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF |
|
23 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS |
|
24 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN |
|
25 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) |
|
26 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |
|
27 * POSSIBILITY OF SUCH DAMAGE. |
|
28 * |
|
29 * Initial Contributors: |
|
30 * Nokia Corporation - initial contribution. |
|
31 * |
|
32 * Contributors: |
|
33 * |
|
34 * Description: |
|
35 * |
|
36 */ |
|
37 |
|
38 using System; |
|
39 using System.Runtime.InteropServices; |
|
40 using Microsoft.Office.Interop.Excel; |
|
41 using SymbianExcelUtils; |
|
42 |
|
43 namespace HeapComparisonLib.CSV.Comparers |
|
44 { |
|
45 internal class SlackSpace : ComparerBase |
|
46 { |
|
47 #region Constructors & destructor |
|
48 public SlackSpace( Worksheet aSheet, string aFileName1, string aFileName2 ) |
|
49 : base( aSheet, aFileName1, aFileName2 ) |
|
50 { |
|
51 } |
|
52 #endregion |
|
53 |
|
54 #region API |
|
55 public override string DeltaFormula( int aIndex ) |
|
56 { |
|
57 int column = 4; |
|
58 return Utils.MakeSummationFormula( 3, Row - 2, column, Sheet ); |
|
59 } |
|
60 |
|
61 public override void PrepareWorksheetReadyForData() |
|
62 { |
|
63 Sheet.Name = "Slack Space"; |
|
64 // |
|
65 Range r = null; |
|
66 // |
|
67 Utils.SetValue( Row, 1, Sheet, "Thread" ); |
|
68 r = Utils.SetValue( Row, 2, Sheet, "Slack Space" ); |
|
69 r.AddComment( FileName1 ); |
|
70 r = Utils.SetValue( Row, 3, Sheet, "Slack Space" ); |
|
71 r.AddComment( FileName2 ); |
|
72 Utils.SetValue( Row, 4, Sheet, "Delta" ); |
|
73 // |
|
74 Utils.MakeBoxedTitleRow( Row, 4, Sheet, 0xFF0000 ); |
|
75 // |
|
76 NextRow(); |
|
77 NextRow(); |
|
78 } |
|
79 |
|
80 public override void FinaliseWorksheet() |
|
81 { |
|
82 // Make totals |
|
83 NextRow(); |
|
84 Utils.SetValue( Row, 1, Sheet, "Totals:" ); |
|
85 Utils.SetValue( Row, 2, Sheet, "=SUM(" + Utils.ColumnAndRowAsExcelIdentifier( 3, 2) + ":" + Utils.ColumnAndRowAsExcelIdentifier( Row - 2, 2) + ")" ); |
|
86 Utils.SetValue( Row, 3, Sheet, "=SUM(" + Utils.ColumnAndRowAsExcelIdentifier( 3, 3) + ":" + Utils.ColumnAndRowAsExcelIdentifier( Row - 2, 3) + ")" ); |
|
87 Utils.SetValue( Row, 4, Sheet, DeltaFormula( 0 ) ); |
|
88 Utils.BoldRow( Row, Sheet ); |
|
89 |
|
90 // Calculate column sizes |
|
91 Utils.AutoFitColumn( 1, Sheet, 70.0 ); |
|
92 Utils.AutoFitColumn( 2, Sheet ); |
|
93 Utils.AutoFitColumn( 3, Sheet ); |
|
94 Utils.AutoFitColumn( 4, Sheet ); |
|
95 } |
|
96 |
|
97 public override void Compare( CSVThread aMaster, CSVThread aOther ) |
|
98 { |
|
99 Utils.SetValue( Row, 1, Sheet, aMaster.FullName ); |
|
100 |
|
101 if ( !aMaster.IsDefault ) |
|
102 Utils.SetValue( Row, 2, Sheet, aMaster.FreeSpaceSlack.ToString() ); |
|
103 if ( !aOther.IsDefault ) |
|
104 Utils.SetValue( Row, 3, Sheet, aOther.FreeSpaceSlack.ToString() ); |
|
105 // |
|
106 if ( aMaster.IsDefault || aOther.IsDefault ) |
|
107 { |
|
108 Utils.GetRangeByColumnAndRow( Row, 1, Row, 1, Sheet ).Font.Bold = true; |
|
109 } |
|
110 |
|
111 long delta = aMaster.FreeSpaceSlack - aOther.FreeSpaceSlack; |
|
112 Utils.SetValue( Row, 4, Sheet, ( delta * -1).ToString() ); |
|
113 |
|
114 // Colourise line according to difference |
|
115 int colour = 0x000000; // black |
|
116 if ( aOther.FreeSpaceSlack > aMaster.FreeSpaceSlack ) |
|
117 { |
|
118 colour = 0x0000FF; // red |
|
119 } |
|
120 else if ( aOther.FreeSpaceSlack < aMaster.FreeSpaceSlack ) |
|
121 { |
|
122 colour = 0xFF0000; // blue |
|
123 } |
|
124 Utils.SetRangeFontColour( Row, 4, Row, 4, Sheet, colour ); |
|
125 // |
|
126 NextRow(); |
|
127 } |
|
128 #endregion |
|
129 } |
|
130 } |