Blank instead of 0% percentage of changes
Performs a cell-by-cell comparison of Excel Worksheets.
Brought to you by:
stevetowner
The listing of changes shows a blank for the percentage if the amount is less than 1% (for example, "61 cell(s) out of a total of 26441 cell(s) have changed (%).").
The solution is, at the end of module CompareWorkbook, to change the "###" to "##0" in the MsgBox that announces the results of the comparison.
Thanks. I will make that change in the next version.
Steve
From: ElrondPA elrondpa@users.sf.net
To: Ticket 51 51@bugs.spreadshcompare.p.re.sf.net
Sent: Thursday, February 20, 2014 10:59 PM
Subject: [spreadshcompare:bugs] #51 Blank instead of 0% percentage of changes
[bugs:#51] Blank instead of 0% percentage of changes
Status: open
Created: Fri Feb 21, 2014 04:59 AM UTC by ElrondPA
Last Updated: Fri Feb 21, 2014 04:59 AM UTC
Owner: nobody
The listing of changes shows a blank for the percentage if the amount is less than 1% (for example, "61 cell(s) out of a total of 26441 cell(s) have changed (%).").
The solution is, at the end of module CompareWorkbook, to change the "###" to "##0" in the MsgBox that announces the results of the comparison.
Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/spreadshcompare/bugs/51/
To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
Related
Bugs: #51