xl2bb also does not respect the word wrap setting

[JenniferMurphy]

Here's another bug in xl2bb. It does not respect the word wrap setting.

Here's what a little table looks like on the sheet:

The X Axis column is not wrapped. But this is how xl2bb shows it:

Book1
	C	D	E	F
5	Dates
6	Start	End	Days	X Axis
7	6/10/20	8/31/20	82	8/31/20 (82)
8	8/11/20	10/27/20	77	10/27/20 (77)
9	10/12/20	2/02/21	113	2/02/21 (113)
10	1/20/21	2/20/21	31	2/20/21 (31)
11	2/20/21	3/07/21	15	3/07/21 (15)
12	3/07/21	4/02/21	26	4/02/21 (26)
Sheet1

Cell Formulas
Range	Formula
E7:E12	E7	=D7-C7
F7:F12	F7	=TEXT(D7,"m/dd/yy") & CHAR(10) & " (" & E7 & ")"

 

[smozgur]

This is not a bug.

Instead, it is expected behavior since XL2BB doesn't/shouldn't/can't transfer all cell properties as it is not a worksheet object replacement but an HTML converter. Since the final cell value contains a linefeed character as the result of the formula (F7:F12), it is considered as a new line and printed accordingly. The cell property word-wrap is out of the scope of the add-in.