Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
Excel formula in HTML paga

generate the html for such EXCEl workbook sheets. But when I try to display in IE with
such html page from Excel conversion, it just show what you see in Excel is what you see in
IE html page that is good, but the one thing is the formula in each cell in Excel sheet
and query function Cannot be coverted into html page.Conversion is for text and graphic
display only from Excel to HTML , no any formula in such html pages ?
Is it that I need to using html and javascript code to put back those formula into html page ?
Or there is other method I can covert all Excel formula I created in the cells into Html page .
Please advise
1- Any good program suggestion for converting Exact Excel sheet with formular and function into HTML ?
2- Any good program suggestion for converting Exact Excel sheet' VBA code into HTML ?
Duncan
in the table --
<TD id="25" onMouseOver="showFormula(25);"> Total cost = </TD>
Now in javascript, make this function --
function showFormula (cell) {
var formula = formulaArray.value [cell];
alert ('formula = ' + formula );
}
i.e. you set up an array of all formulas on the page, indexed by the cell number, and when a person mouses over that cell, the formula pops up in an alert window
in the table --
<TD id="25" onMouseOver="showFormula(25);"> Total cost = </TD>
Now in javascript, make this function --
function showFormula (cell) {
var formula = formulaArray.value [cell];
alert ('formula = ' + formula );
}
i.e. you set up an array of all formulas on the page, indexed by the cell number, and when a person mouses over that cell, the formula pops up in an alert window
in the table --
<TD id="25" onMouseOver="showFormula(25);"> Total cost = </TD>
Now in javascript, make this function --
function showFormula (cell) {
var formula = formulaArray.value [cell];
alert ('formula = ' + formula );
}
i.e. you set up an array of all formulas on the page, indexed by the cell number, and when a person mouses over that cell, the formula pops up in an alert window
in the table --
<TD id="25" onMouseOver="showFormula(25);"> Total cost = </TD>
Now in javascript, make this function --
function showFormula (cell) {
var formula = formulaArray.value [cell];
alert ('formula = ' + formula );
}
i.e. you set up an array of all formulas on the page, indexed by the cell number, and when a person mouses over that cell, the formula pops up in an alert window
in the table --
<TD id="25" onMouseOver="showFormula(25);"> Total cost = </TD>
Now in javascript, make this function --
function showFormula (cell) {
var formula = formulaArray.value [cell];
alert ('formula = ' + formula );
}
i.e. you set up an array of all formulas on the page, indexed by the cell number, and when a person mouses over that cell, the formula pops up in an alert window