excel - Vb.net Custom sum formula not calculating when blank cell are present -

-

i have 2 problems 1 if have empty cells not work , second not calculate on tables when using sum column5 provided

the cinches converting string 12'-3 1/16" 147.0625 inches , tonearest16th converts string closest nearest sixteen of inch 12'-3 1/16" problem when trying sum results using conversion because if there blank cell error show me love guys again 

public shared function totalsumtonearest(nums object) object     '----------------------------------------------------------------------     '** demonstrates how use array(or range of multiple cells)     '   function argument.     '   can called formulas such =getarray(a1:b5), getarray(a1),     '   or getarray({1,2,3;4,5,6}).     '----------------------------------------------------------------------     dim sum double, v object     on error goto handler     if isarray(nums)         each v in nums             'if typeof v.getvalue() excelempty              'else             sum = sum + cdbl(cinches(v) / 12)             'end if         next     else         sum = cdbl(nums)     end if     totalsumtonearest = tonearest16th(sum * 12)     exit function handler:     ' getarray = cverr(2036)  'xlerrnum = 2036 end function

i'm posting working code in case can use it

 public shared function sum_tonearest_16th(values object) object     '----------------------------------------------------------------------     '** demonstrates how use array(or range of multiple cells)     '   function argument.     '   can called formulas such =getarray(a1:b5), getarray(a1),     '   or getarray({1,2,3;4,5,6}).     '----------------------------------------------------------------------     dim sum double      if isarray(values)          each objectvalue object in values             dim doublevalue double = 0              if typeof objectvalue string                ' dim rst string=""                doublevalue = cdbl(cinches(objectvalue))                ' objectvalue=rst             elseif typeof objectvalue double                 doublevalue = objectvalue             else                 double.tryparse(objectvalue.tostring(), doublevalue)             end if              sum += doublevalue          next objectvalue      else         double.tryparse(values.tostring(), sum)     end if      return to_nearest_16th(sum) end function


Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more