JVParth

i have annoying problem in 1 of worksheets in workbook. using excel 2007. cell's value not updated unless hit enter. either if formula in cell includes if condition, or vlookup function or average function. calculations set automatic, application.calculation = xlautomatic, , calculations specific worksheet enabled, : ws.enablecalculation = true. furthermore, screenupdating set true. after hit enter or drag down right corner, cells updated, , keep being updated if make change. however, after saving file , reopening again frozen again. haven't figured out when stop being updated again. formatting set general or number. especially in if conditions, when check calculations through evaluate feature, result correct not passed on screen. any suggestion? thing driving me crazy. it sounds workbook got set manual calculation. can change automatic going formulas > calculation > calculation options > automatic. manual calculation can useful reduce computati...

i define exceptions on command line: -dexception_1=\"first\" -dexception_2=\"second\" -dexception_3=\"third\" which check against string: except = 0; #ifdef exception_1 if (! strcmp(exception_1, mystring)) { except = 1; } #endif #ifdef exception_2 if (! strcmp(exception_2, mystring)) { except = 1; } #endif #ifdef exception_3 if (! strcmp(exception_3, mystring)) { except = 1; } #endif if (except == 1) { // } else { // else } needless say, while works, quite ugly, inflexible , causes redundancy in code. is there way append string preprocessor macro variable? i (the problem of course #append not exist): #ifdef exception_1 #append exceptions if (! strcmp(exception_1, mystring)) { except = 1; } #ifdef exception_2 #append exceptions if (! strcmp(exception_2, mystring)) { except = 1; } #ifdef exception_3 #append exceptions if (! strcmp(exception_3, mystring)) { except = 1; } then use exceptions in code , work possible permutations of...

i have pojo class below public class product { private string productname; private string quantity; public string getproductname() { return productname; } public void setproductname(string productname) { this.productname = "laptop"; } public string getquantity() { return quantity; } public void setquantity(string quantity) { this.quantity = "25"; } } using datamapper converrt pojo csv <file:outbound-endpoint path="c:\temp" outputpattern="#[function:datestamp]_product.csv" responsetimeout="10000" doc:name="file"/> it create file without data laptop,25 datamapper ignore null values default so, if you're not calling setters, getters return null, if want have "default" values can standard java way, either set on constructor or directly in field declaration i.e private string quantity = 25 also java in general,...

i have list year , day starting december till february 2003 2005. want divide list list of lists hold year day december february: a = ['2003337', '2003345', '2003353', '2003361', '2004001', '2004009', '2004017', '2004025', '2004033', '2004041', '2004049', '2004057', '2004337', '2004345', '2004353', '2004361', '2005001', '2005009', '2005017', '2005025', '2005033', '2005041', '2005049', '2005057'] output should like: b = [['2003337', '2003345', '2003353', '2003361', '2004001', '2004009', '2004017', '2004025', '2004033', '2004041', '2004049', '2004057'] ['2004337', '2004345', '2004353', '2004361', '2005001', '2005009', '2005017', '200502...

i'm building poco library 1.6.0 under mingw32, environment: windows 7 ultimate 32-bit, shell: msys. executed ./configure . $ ./configure configured mingw contents of config.make: poco_config = mingw poco_base = /c/dev/poco poco_build = /c/dev/poco poco_prefix = /usr/local poco_flags = omit = export poco_config export poco_base export poco_build export poco_prefix export poco_flags after launching mingw32-make i'm getting: $ mingw32-make --debug -w gnu make 3.82 built i386-pc-mingw32 copyright (c) 2010 free software foundation, inc. license gplv3+: gnu gpl version 3 or later <http://gnu.org/licenses/gpl.html> free software: free change , redistribute it. there no warranty, extent permitted law. reading makefiles... updating goal targets.... file `poco' not exist. file `libexecs' not exist. file `foundation-libexec' not exist. must remake target `foundation-libexec'. invoking recipe makefile:69 update target `foundation-libexec...

i having hard time figuring out pattern ignore escaped quotes. want this: "10\" 2 topping pizza, pasta, or sandwich $5 each. valid until 2pm. carryout only.","blah blah" to match as: 1> "10\" 2 topping pizza, pasta, or sandwich $5 each. valid until 2pm. carryout only." 2> "blah blah" i have been trying this: pattern pattern = pattern.compile("\"[^\"]*\""); matcher matcher = pattern.matcher(filteredcoupons); and 1> "10\" 2> "," the regex looking is "[^"\\]*(?:\\.[^"\\]*)*" see demo in java, string pattern = "\"[^\"\\\\]*(?:\\\\.[^\"\\\\]*)*\"";

how can change spritekit on collision in spritekit swift. else if collidedbird.birdtype == 6 { if uidevice.currentdevice().userinterfaceidiom == .pad { _bird.physicsbody?.applyimpulse(cgvectormake(0, birdimplusereturn(70.0))) } else { _bird.physicsbody?.applyimpulse(cgvectormake(0, birdimplusereturn(70.0))) } let fire = nstimer.scheduledtimerwithtimeinterval(0.05, target: self, selector: selector("createdragonfire"), userinfo: nil, repeats: false) playeffectsound("bs_std_jump_sfx.mp3") _platform.removefromparent() } if want change image of sprite, should use skphysicscontactdelegate method. in general means have implement skphysicscontactdelegate , make new struct: for example: struct physiccategories { static let nonec : uint32 = 0x1 << 0 static let bird : uint32 = 0x1 << 1 stat...