XL2BB - Numeric Strings Aligns Right (Bug?)

[Cubist]

Hi,
I'm wondering if this is a known bug. When posting a numeric text string, the XL2BB aligns the cell right as if it's a numerical type.

Book2
	A	B
1	123	TRUE
2	123,456	TRUE
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=ISTEXT(A1)

Screenshot for comparison.

 

[smozgur]

Thanks for reporting this.

Yes, I have been aware of this issue from the beginning; however, I have intentionally avoided setting the horizontal alignment property by data type in XL2BB, and actually, I would still prefer to avoid it since it complicates the associated rendering script.

That being said, it is reasonable to expect XL2BB to align Text and perhaps even General data type values to the left, unless the cell is explicitly aligned otherwise. I am bookmarking this thread and will consider what can be done about this in the next XL2BB update.

What is the data type for A1 and A2 in your sample above? If it is Text, then XL2BB will recognize it, but the mini-sheet code you generated indicates that those cells are not Text. Are they "General"?

Aside from my comments above, as an additional note: XL2BB uses explicit cell alignment. You can set the horizontal alignment to force XL2BB to display the cell in that alignment. I know this is not the answer to your question, but I just wanted to mention it.

 

[Cubist]

What is the data type for A1 and A2 in your sample above? If it is Text, then XL2BB will recognize it, but the mini-sheet code you generated indicates that those cells are not Text. Are they "General"?

I have tried both formatting General and Text. They both align right.

It's not a big deal but it looks inconsistent in situations like this where they should all be shown as text.

Book1
	A	B	C
1	123	123
2	456, 789, ABC	456, 789, ABC
3	123,456	123	456
4	XYZ,123	XYZ	123
Sheet3

Cell Formulas
Range	Formula
A1:A4	A1	=TEXTJOIN(",",,B1:D1)

Setting the manual alignment does seem to fix it.

Book1
	A	B	C
1	123	123
2	456, 789, ABC	456, 789, ABC
3	123,456	123	456
4	XYZ,123	XYZ	123
Sheet3

Cell Formulas
Range	Formula
A1:A4	A1	=TEXTJOIN(",",,B1:D1)