Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Pasting HTMLmaker into "Test Here" differs from "Excel Question"; misleading errors

  1. #11
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    9,977
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pasting HTMLmaker into "Test Here" differs from "Excel Question"; misleading errors

    Without being able to download yet, the missing colour you mentioned wasn't coloured by conditional formatting was it?
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  2. #12
    Board Regular
    Join Date
    Mar 2014
    Posts
    1,995
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pasting HTMLmaker into "Test Here" differs from "Excel Question"; misleading errors

    Quote Originally Posted by MARK858 View Post
    Without being able to download yet, the missing colour you mentioned wasn't coloured by conditional formatting was it?
    Aha! Yes, it was. Thanks for making me see the distinction. I wish HTMLmaker understood that. But at least now I know its limitation, and I can work around it in a better way.

    (Editing HTML in Source mode is not fun.)

  3. #13
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    9,977
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pasting HTMLmaker into "Test Here" differs from "Excel Question"; misleading errors

    It was raised as an issue previously but as far as I know a resolution was never made (obviously).
    I have now tested with your file here and as far as I can see that is the only issue but have a look and please let me know if you see anything else.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  4. #14
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    39,383
    Post Thanks / Like
    Mentioned
    77 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Pasting HTMLmaker into "Test Here" differs from "Excel Question"; misleading errors

    Quote Originally Posted by joeu2004 View Post
    Aha! Yes, it was. Thanks for making me see the distinction.
    .. and yet all your colour disappeared, including column B that was not applied with CF. You will note that my post in the Test forum in your thread still has the colour in column B


    Quote Originally Posted by joeu2004 View Post
    I wish HTMLmaker understood that.
    If you want/need to post Conditional Formatting, Excel jeanie will do that. I haven't tested it will all the types of CF available these days but works for the ones I usually use in the forum.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  5. #15
    Board Regular
    Join Date
    Mar 2014
    Posts
    1,995
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pasting HTMLmaker into "Test Here" differs from "Excel Question"; misleading errors

    Quote Originally Posted by Peter_SSs View Post
    and yet all your colour disappeared, including column B that was not applied with CF.
    Two different problems. The overall disappearance of color is specific to my posting in "Test Here". The lack of background color in column I is universal. It is the latter that is due CF.


    Quote Originally Posted by Peter_SSs View Post
    You will note that my post in the Test forum in your thread still has the colour in column B
    Yes. And I was just going to post an update here to note that your posting indicates that your IE 11 is more up-to-date than mine. Thanks.

    But on second thought, that might not help me -- although I should update IE, anyway. I forgot the issue: for **me**, HTMLmaker works find in "Excel Question", but not in "Test Here".

    Admittedly, I don't know how things work "under the hood", but my problem seems to be related to a difference in the two forums, not so much the browser. However, the root cause might be some flaw in my version of IE that "Test Here" trips over, but not "Excel Question".

    I intend to update my IE, and see if that fixes my problem. Thanks, Peter and Mark, for your comments.
    Last edited by joeu2004; Oct 8th, 2018 at 07:28 PM.

  6. #16
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    1,113
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pasting HTMLmaker into "Test Here" differs from "Excel Question"; misleading errors

    Quote Originally Posted by Fluff View Post
    Regarding the format.
    If you just paste the html code into the reply window & hit Submit, it should be ok.
    I've always found that if I look at the preview then the format disappears.

    I have the same problem, if I select preview first then press submit, the table will be messed up.
    My trick is, if I still want to see a preview:
    1. before the click preview button, select all text & copy
    2. click preview
    3. delete all text
    4. paste
    5. submit

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •