Page 1 of 1

[v1.70] formatting issue with charges

Posted: Tue Apr 01, 2014 2:05 pm
by LordVorp
Sometimes, when specifying charges on a wand with a formula, as listed in the docs, the column formats it as a date. It happens often, but not always.

For example, on of the last items I had is a wand with 10 charges, so the Quantity is the formula "=10/50". However, the display in the "Qty" column shows Jan-00.

I'm using Excel 2010 but have seen it on Excel 2007 as well.

Re: [v1.70] formatting issue with charges

Posted: Thu Oct 02, 2014 10:28 am
by admin
I was unable to replicate the problem, but I made sure all the Qty column is set to 'general'...
(I hesitated forcing it to Number, as I find it annoying that it adds decimal places when not needed, or does not show them when needed...)

I'll tag this as pending for further tests in the next update. Thanks!
admin