Skip to content
This repository has been archived by the owner on Jul 25, 2021. It is now read-only.

Extra spaces added to the cell which makes the column looks empty. #42

Closed
MikeAlhayek opened this issue Jan 17, 2017 · 2 comments
Closed

Comments

@MikeAlhayek
Copy link

MikeAlhayek commented Jan 17, 2017

I have been trying recreate the same issue on a fiddler to explain the problem but a different problem is preventing me from doing so. Here is the fiddle to give you at least the html code that I am using https://jsfiddle.net/DTcHh/28806/

Here is a screenshot of the exact file the I downloaded "Columns D-Q appears to be empty columns"

screenshot_1

After expanding column "F" or any column between D-Q you'll see the data.

screenshot_2

Also, you may want to convert any <br> or <br /> to a new line when exporting html code.

@MikeAlhayek
Copy link
Author

MikeAlhayek commented Jan 19, 2017

What seems to be causing this problem are the whitespaces in the HTML code.

So this causes the problem

<th class="text-center">
    Monday<br>
    01/16/2017
</th>

But making the html code look like this fixes the problem.

<th class="text-center">Monday<br> 01/16/2017</th>

I would suggest trimming the white spaces. Also, convert
to new line in excel.

@clarketm
Copy link
Owner

Thanks to @boonep and his much appreciated PR, this patch has been applied and will be slated for the v3.3.8 release.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants