Another bug in xl2bb

[JenniferMurphy]

It appears that xl2bb is unable to handle some types of cell contents that span multiple cells. The three examples in the Mini Sheet below look like this in real life.

But the Mini Sheet expands the column where the actual text is stored to accomodate its width.

1. In the first example, the text is centered in the center cell. The Mini Sheet expands that entire column.
2. In the second example, the text is stored in the first cell, then the three header cells are selected and set to "Centered Across Selection". The Mini Sheet expands the first column.
3. In the third example, the 2 header cells are Merged and Centered. The Mini Sheet handles that correctly.

Binomonial Distribution.xlsx
	C	D	E	F	G	H	I	J	K	L	M
10		Centered in Center Cell			Centered Across Selection				Merged and Centered
11	Wins	Losses	Games		Wins	Losses	Games		Wins	Losses	Games
12	3	0	3		3	0	3		3	0	3
13	3	1	4		3	1	4		3	1	4
14	3	2	5		3	2	5		3	2	5
Sheet1

Cell Formulas
Range	Formula
E12:E14,M12:M14,I12:I14	E12	=C12+D12

 

[RoryA]

Thanks for the heads up.

Just out of interest, why does it matter? The only one that I can see that is likely to affect any solution that might be offered is the merged one, and that is handled correctly. If all three looked the same, I would have thought that would actually be unhelpful.

 

[JenniferMurphy]

Thanks for the heads up.

Just out of interest, why does it matter? The only one that I can see that is likely to affect any solution that might be offered is the merged one, and that is handled correctly. If all three looked the same, I would have thought that would actually be unhelpful.

To me, it matters because it doesn't look like the actual sheet. The mini sheets are intended to provide readers with as close to an exact replica of the actual sheet as possible. I can't think of an example right off where it would affect the excecution, but if I had a table with something like 20 columns with a heading that spanned the entire width of the table, the mioni sheet might be so wide it would not fit on the screen.

To me it's either identical or it's not. It's not.

 

[RoryA]

The mini sheets are intended to provide readers with as close to an exact replica of the actual sheet as possible

I don't fully agree with that. The purpose is to make life easier for those who are trying to help by replicating as much relevant information as possible. To that end, some things are clearly more important than others. XL2BB is not, nor do I believe it is intended to be, an exact replica of Excel. (If that were a simple thing to achieve, Online Excel would be the same as desktop. )

Anyway, I'll make sure that this has been seen by @smozgur but - for the sake of transparency - unless it is a simple change and one that will transfer properly back to Excel (I don't know if you can easily achieve those items with HTML), I would actually vote against implementing it, for the reason I mentioned.

 

[smozgur]

I'll make sure that this has been seen by @smozgur but - for the sake of transparency - unless it is a simple change and one that will transfer properly back to Excel (I don't know if you can easily achieve those items with HTML), I would actually vote against implementing it, for the reason I mentioned.

Thanks, @RoryA.

I don't prefer to repeat this all the time, however, one last time hopefully, XL2BB is not a worksheet replacement, therefore it is not our goal to make it work like a worksheet, which is already not possible, and also not necessary.

It is already not easily possible to implement in HTML as we'd like to keep the custom styling at a minimum level. Therefore, there is no plan to make any changes concerning this minor issue.

The issue could be solved by wrapping that header content as shown below or merging the cells.

Book1
	A	B	C
1		this is a long header
2	1	2	3
Sheet1

 

[JenniferMurphy]

Thanks, @RoryA.

I don't prefer to repeat this all the time, however, one last time hopefully, . . .

Oh my god. I am so, so sorry. I will make a note to not bother you in the future.

 

[smozgur]

Oh my god. I am so, so sorry. I will make a note to not bother you in the future.

Oh no, you don't bother me at all.
I just don't prefer to make the same statement for all cosmetic issues about the mini-sheets related to the fact that it is not a worksheet but simply a range representation to make it easy to exchange data and visualize a range besides the useful features it has. Other than that, we would of course like to hear about functional issues and real bugs that affect the reason for its existence.