Right alignment error - and fix

[ErikLtz]

Had problems with right-alignment becoming centered in some cells, found this regexp in SimpleXLSGen code:
preg_match('/^[0-9+-.]+$/', $v)
that seem to miss quoting for special chars second - and . so changed to:
'/^[0-9+\-\.]+$/'
which made my cells align right as intended.

Line 985 in SimpleXLSGen.php version 1.5.12, these lines for context:
} elseif (preg_match('/^[0-9+-.]+$/', $v)) { // Long ?
$A += ($A & (self::A_LEFT | self::A_CENTER)) ? 0 : self::A_RIGHT;

Hope this can be verified and included in a future release 😊

[shuchkin]

try 1.5.13
https://github.com/shuchkin/simplexlsxgen/blob/master/CHANGELOG.md

[ErikLtz]

Yes, 1.5.13 seem to quote the Long number - however, diff to 1.5.12 also show change for // Decimal with regexp that seem to have non balancing parentesis? From 1.5.12:
preg_match('/^[-+]?(0|[1-9]\d*).(\d+)$/', $v, $m)
to 1.5.13:
preg_match('/^[-+]?(0|[1-9]\d*).\d\d?)$/', $v, $m)
on about line 950 - and a removed if that did reference $m[2]. Missing left parentesis or extra right that should be removed?

[shuchkin]

u right, fixed

[ErikLtz]

Yes, now it seems good 😊