HTML add-in - formulas not displaying

[PaddyD]

Hi all,

HTML'd a spreadsheet using the add-in (v 2.10). The resulting .htm file worked OK - all formulas displayed etc. But formulas didn't display when I posted to the board.

My guess is that Colo & Ivan have added some aesthetics routines & the add-in will refuse to display anything it considers to be unnecessarily inelegant, thereby disqualifying all my code!

Any other ideas?

Paddy

 

[Colo]

Hi Paddy,

Please show us the html.
Post it on "test posting here".

I'll check it out.

 

[Colo]

Hi Paddy, me again.
All right. You are talking about following thread aren't you?
http://www.mrexcel.com/board/viewtopic.php?topic=10409&forum=2

I've checked the HTML source and I found the cause.
I've expected this problem.
However, I did not think that it will be realized.

The cause by which this error took place is as follows.
Same object names were used in same thread.
I used the random number of 3 figures in the code, in order to avoid above situation.

But this time, The random number used by tagger post was the same as
the random number used by your post.
It is generated in the probability of 1/100.

So I'll update my code. (change 1/100 to 1/1000)

Thank you very much for your post.

 

[PaddyD]

Colo,

You got the right thread - would you recommend downloading a 'patched' version of the add-in or is it a sufficiently unlikely event not to worry too much?

Paddy

 

[Colo]

Hi PaddyD,

Updated version is Ver. 2.12.

Please note following:

-------------------------------------
8. History:
-------------------------------------
11 May 2002 1.22 Released
12 May 2002 1.23 made into Addin
17 May 2002 1.24 Released Mods
18 May 2002 1.25 Released Mods
19 May 2002 1.26 Released Mods
20 May 2002 1.27 Released Mods
23 May 2002 1.28 Released Mods
24 May 2002 2.00 Released Mods and Help
29 May 2002 2.01 OS Mods + update Help/Readme
- OS Version tests carried out by
Nate O, Mark O'Brien, Juan Pablo and DK (Dan)
5 June 2002 2.11 Released Mod_EmailSheet
5 June 2002 2.12 Released Mods_HTML
This was documented On 2002-06-04 21:42 , by "PaddyD"


Thank you.

 

[PaddyD]

Colo,

Fame at last!!

Paddy

 

[Jack in the UK]

Colo - Ivan

Let me know if i can help you test!

I use this a lot and get good results, I HOPE~

 

[Colo]

Thank you very much Jack,

 

[Ivan F Moala]

On 2002-06-06 15:07, Jack in the UK wrote:
Colo - Ivan

Let me know if i can help you test!

I use this a lot and get good results, I HOPE~

Yes thanks Jack that would be nice.

Colo, I have updated DK code to handle the
instance where Ol IS NOT installed...I thought I had this covered and then realised, thanks to Mark O'Brien that it doesn't actually do this.
I have changed it to Late binding.
See code @ MVP msgboard + I'll email you

 

[Colo]

On 2002-06-06 18:06, Ivan F Moala wrote:
Yes thanks Jack that would be nice.

Colo, I have updated DK code to handle the
instance where Ol IS NOT installed...I thought I had this covered and then realised, thanks to Mark O'Brien that it doesn't actually do this.
I have changed it to Late binding.
See code @ MVP msgboard + I'll email you

All right Ivan, thanks a lot.