xls to html
Thread Starter
Per Ardua ad Astraeus
Joined: Mar 2000
Posts: 18,575
Likes: 4
From: UK
xls to html
I place monthly spreadsheets on a website. I use the 'Save as' web page (htm, html) option. Often I find extraneous cell borders 'added' by M$ which are just not there. Any ways around?
Joined: Feb 2007
Posts: 755
Likes: 26
From: Dublin, Ireland. (No, I just live here.)
I'm not seeing this when I try it on a spreadsheet in Excel 2007. One alternative to try is Gnumeric Portable, which can be installed easily to a USB drive or anything you like, no admin permissions required. The HTML output may be more standards-compliant.
Thread Starter
Per Ardua ad Astraeus
Joined: Mar 2000
Posts: 18,575
Likes: 4
From: UK
Nope, sadly it messes up the cell formatting too much. HTML4 was the closest but no cigar. I'll have to stick with 'spikey bits' on the page I guess - love M$! I suppose I could screen shot it and put a slightly fuzzy jpg up.
Thread Starter
Per Ardua ad Astraeus
Joined: Mar 2000
Posts: 18,575
Likes: 4
From: UK
Sp - by me - it is a month's worth of village hall bookings. 2 long sheets of data abbreviated and posted into 2 horizontal groups of 5 'tables' for two separate facilities, then posted onto the web. Up to yesterday I had only the occasional extra single cell border pop up at random which I credited to Mr Gates not getting it right, but I am now consistently getting a solid right hand border - which ain't there on the xls.
Joined: Apr 2005
Posts: 366
Likes: 0
From: Earth
BOAC,
I believe you may be 'overstepping the mark'. I could, of course, be wrong.
Try this: Once your data input is complete, click on Print Preview. Do you get 1 page, or 2 pages to preview? If 2 pages, is the result of the second page a line of any sort?
Without seeing your page, I am guessing that your data has slipped across your page size, so what looks like a brilliant piece of information on 1 page, has actually made itself into 2 pages. File/View/Page Break will give you a massive visual clue as to how you have made an utter mess of your SS. (JOKE!)
To fix it, (yes, we can) make your margins smaller than the default size (which are huge), so try 1.5 cm all round.
The other trick is to place your mouse cursor over the column heading line, and double click so that the information in the cell is forced to fit to how big it is. Does that make sense? If not call back, and I will do a screen grab.
I believe you may be 'overstepping the mark'. I could, of course, be wrong.
Try this: Once your data input is complete, click on Print Preview. Do you get 1 page, or 2 pages to preview? If 2 pages, is the result of the second page a line of any sort?
Without seeing your page, I am guessing that your data has slipped across your page size, so what looks like a brilliant piece of information on 1 page, has actually made itself into 2 pages. File/View/Page Break will give you a massive visual clue as to how you have made an utter mess of your SS. (JOKE!)
To fix it, (yes, we can) make your margins smaller than the default size (which are huge), so try 1.5 cm all round.
The other trick is to place your mouse cursor over the column heading line, and double click so that the information in the cell is forced to fit to how big it is. Does that make sense? If not call back, and I will do a screen grab.
Chief Tardis Technician
Joined: Jan 2001
Posts: 554
Likes: 0
From: Western Australia S31.715 E115.737
True, but you could link to it.
I just tried a conversion to HTML using Open Office and that worked ok for me, not sure how complex the target spread sheet id though.
I just tried a conversion to HTML using Open Office and that worked ok for me, not sure how complex the target spread sheet id though.
