Quote:
Originally Posted by infocynic  The right way to do it then, Yarthok, is to use custom formatting on these cells.... and I realize this isn't your problem per se, but in Excel, we can set custom formatting on the cells, so I can give this string and it will give me +X if X is 0 or more and -X if X is negative. (It's also possible to get a third format in for exactly 0, but I didn't see the need here). |
Thanks Infocynic! The same format method works in OOCalc. The result is as you described with the display showing a plus sign, but the value can be used directly in numeric calculations in other cells.
As a cascading side effect, my test change to SkillInsight caused cell $'Charsheet I'.CN15 to incorrectly show blank. However, the fix was to simplify CN15 to use SkillInsight directly.
I changed the following:
Code:
$'Charsheet I'.AR73 (SkillInsight)
FROM ==> =IF(F73+B73+J73+N73+R73+V73+Z73+AD73>0;"+"&F73+B73+J73+N73+R73+V73+Z73+AD73;F73+B73+J73+N73+R73+V73+Z73+AD73)
TO ==> =IF(F73+B73+J73+N73+R73+V73+Z73+AD73>0;F73+B73+J73+N73+R73+V73+Z73+AD73;F73+B73+J73+N73+R73+V73+Z73+AD73)
CELL FORMAT CODE CHANGED TO ==> +#0;-#
VALUE DISPLAYED ==> +5
$'Charsheet I'.CU15 (PassiInsight)
FROM ==> =10+VALUE(SkillInsight)
RESTORED TO ==> =10+SkillInsight
VALUE DISPLAYED ==> 15
$'Charsheet I'.CN15
FROM ==> =MID(SkillInsight;2;2)
TO ==> =SkillInsight
VALUE DISPLAYED ==> 5
I will start to come up with a list of cells that might benefit from using your suggested formatting and report back... probably this weekend.
And yet another word from our sponsors
