J
Jools
Hi all
I'm having a problem when publishing to the web in that my comboboxe
have disappeared and a large amount of text in one cell has also gone.
I've attached a copy of the .xls file, I've also got a .htm file whic
I may have to post in a follow up thread as I don't know if you ca
have 2 attachments.
To explain, I unlocked the three fields (coloured white) for name, sal
price and purchase price so users can type the appropriate text i
these. I also unlocked the 3 combo boxes. I then protected the sheet
In the .xls file I can <tab> between the white text fields and ente
text but have to click onto the comboboxes - I don't mind this and th
calculations in the table below them still work fine anyway.
Cells B22-E22 were merged and a lengthy piece of disclaimer tex
running onto 10 lines was typed in. Text wrap was selected an
everything seems fine on the .xls file. In print preview you can se
the text in full exactly as I want it to print.
*However* this is when I get flummoxed (?!?)
When I save as a web page I make sure I have the interactivity checkbo
selected and then click save. I also tried clicking the publish butto
instead and selected all the contents on sheet 1, added interactivit
with spreadsheet functionality.
When I view the .htm file (by whichever of the 2 ways I created it) Th
combo boxes are gone and the text shows only the first line and doesn'
wrap although the row height appears to be the correct height.
Can anyone please tell me where I am going wrong or point me in th
right direction. Any nuggets of assistance gratefully received.
Many thanks in advance
Juli
Attachment filename: help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=65582
I'm having a problem when publishing to the web in that my comboboxe
have disappeared and a large amount of text in one cell has also gone.
I've attached a copy of the .xls file, I've also got a .htm file whic
I may have to post in a follow up thread as I don't know if you ca
have 2 attachments.
To explain, I unlocked the three fields (coloured white) for name, sal
price and purchase price so users can type the appropriate text i
these. I also unlocked the 3 combo boxes. I then protected the sheet
In the .xls file I can <tab> between the white text fields and ente
text but have to click onto the comboboxes - I don't mind this and th
calculations in the table below them still work fine anyway.
Cells B22-E22 were merged and a lengthy piece of disclaimer tex
running onto 10 lines was typed in. Text wrap was selected an
everything seems fine on the .xls file. In print preview you can se
the text in full exactly as I want it to print.
*However* this is when I get flummoxed (?!?)
When I save as a web page I make sure I have the interactivity checkbo
selected and then click save. I also tried clicking the publish butto
instead and selected all the contents on sheet 1, added interactivit
with spreadsheet functionality.
When I view the .htm file (by whichever of the 2 ways I created it) Th
combo boxes are gone and the text shows only the first line and doesn'
wrap although the row height appears to be the correct height.
Can anyone please tell me where I am going wrong or point me in th
right direction. Any nuggets of assistance gratefully received.
Many thanks in advance
Juli
Attachment filename: help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=65582
