MrExcel HTML Maker Update - Page 4

Page 4 of 6 FirstFirst ... 23456 LastLast
Results 31 to 40 of 56

Thread: MrExcel HTML Maker Update

  1. #31
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,648
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

     
    Quote Originally Posted by Peter_SSs View Post
    Anyway, in very limited testing now, it seems to be working. I have two identical right-click menus though, which is quite confusing.
    Great - glad the root cause of that issue has been found (thank you, @Dave Patton)! I actually have an updated version on my end which adds some icons to the right-click menu, so it will differentiate between the two. I was holding off on releasing it until we were sure the issues between Forum Tools and this add-in were resolved, which it appears they have.

    That being said, here is the updated version with added icons!

    Dropbox - MrExcelHTMLMaker20170807.xlam
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  2. #32
    Board Regular DRSteele's Avatar
    Join Date
    Mar 2015
    Location
    Calgary
    Posts
    1,571
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    I followed the instructions and posted a response in a thread. All looked good in the Go Advanced preview, but when I submitted the thread some of the fill colours disappeared and the layout of the formula boxes and tables lack colours. Am I doing something wrong?
    Windows10, Excel 2016 (365 Insider)
    My formulas are always in
    Green
    You can get the HTML Maker.

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

    Default Re: MrExcel HTML Maker Update

    Quote Originally Posted by DRSteele View Post
    but when I submitted the thread some of the fill colours disappeared
    @DRSteele, I just done some further testing, were the cells where the colors disappeared from the cells normally filled or by conditional formatting?
    I am getting the colors not showing when they are conditionally formatted.

    I also have an issue if the cells aren't a solid color (can't remember if that was the same with the old version).

    Quote Originally Posted by DRSteele View Post
    the layout of the formula boxes and tables lack colours.
    I used to get this with the old version depending (I think) on the different options used but at the moment I can't replicate the behaviour.
    Last edited by MARK858; Aug 22nd, 2017 at 10:16 PM.
    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, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  4. #34
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,648
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Quote Originally Posted by MARK858 View Post
    @DRSteele, I just done some further testing, were the cells where the colors disappeared from the cells normally filled or by conditional formatting?
    I am getting the colors not showing when they are conditionally formatted.

    I also have an issue if the cells aren't a solid color (can't remember if that was the same with the old version).
    After doing some testing, I can confirm that it is working as intended for cells which do not have conditional formatting, though I may be able to update it to include cell colors for conditional formatting - we'll see

    As for the solid color issue, are you referring to if the cells have a pattern in them? If so, this is because the code converts the cell color into a hex format; it is not aware of cell patterns, and unfortunately likely won't ever really be aware of cell patterns due to no easy way to convert them to HTML (at least to my knowledge). It at least does grab the interior color of any patterned cell.

    To the point of colors in formulas, I'm not able to replicate this issue either. Colors are appearing in the formula box as intended. See my test post here

    Keep reporting issues as you find them! Thanks all!

    Cheers
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  5. #35
    Board Regular DRSteele's Avatar
    Join Date
    Mar 2015
    Location
    Calgary
    Posts
    1,571
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    I was not using any conditional formatting; just fill colours. Like this:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5 " /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5 ;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="color: #E2EFDA;background-color: #000000;;">Green, Accent 6, Lighter 80%</td><td style="background-color: #E2EFDA;;">226, 239, 218</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="color: #FFF2CC;background-color: #000000;;">Gold, Accent 5, Lighter 80%</td><td style="background-color: #FFF2CC;;">255, 242, 204</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="color: #DDEBF7;background-color: #000000;;">Blue, Accent 4, Lighter 80%</td><td style="background-color: #DDEBF7;;">221, 235, 247</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="color: #DDEBF7;background-color: #000000;;">Orange, Accent 2, Lighter 80%</td><td style="background-color: #FCE4D6;;">252, 228, 214</td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5 ;color: #161120">Sheet24</p><br /><br />
    Windows10, Excel 2016 (365 Insider)
    My formulas are always in
    Green
    You can get the HTML Maker.

  6. #36
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,648
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    @DRSteele,

    That HTML didn't parse correctly, but in looking at it, that doesn't appear to be code that my updated version generates. Specifically, I note that in the code you pasted, it has "background-color: #FFFFFF ;" in the initial < table> section. In my updated version, it no longer uses that hex value, but instead uses rgb(255,255,255). Are you using another addin which parses excel tables to html?
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  7. #37
    Board Regular DRSteele's Avatar
    Join Date
    Mar 2015
    Location
    Calgary
    Posts
    1,571
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    I don't know what's going on there. I pasted the same thing on your Test page (from post34) and it worked just fine there.

    Another problem is that I keep getting a security m,message about enabling macros.
    Windows10, Excel 2016 (365 Insider)
    My formulas are always in
    Green
    You can get the HTML Maker.

  8. #38
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,970
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    I don't know what's going on there. I pasted the same thing on your Test page (from post34) and it worked just fine there.
    The About the board forum doesn't allow HTML code, the Test page does. It tells you in the bottom right of the page what is allowed.
    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, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  9. #39
    Board Regular DRSteele's Avatar
    Join Date
    Mar 2015
    Location
    Calgary
    Posts
    1,571
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Ah, I see. Thank you.

    But the problem persists. No fill colours.

    Also, I have two instances of the "Generate HTML..." options in the right-click context sensitive menu. Three of the items are obviously for the old HTML maker which I've completely deleted; when I click on them I get error messages. The other three have icons beside them, and they seem to work for this new version (though clicking on any of the items to set a default does nothing.)

    Can someone please help me sort this out?
    Windows10, Excel 2016 (365 Insider)
    My formulas are always in
    Green
    You can get the HTML Maker.

  10. #40
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,970
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

      
    MrKwoz, I am not getting the issues DRSteele is getting at the moment (including the set default is changing the default setting fine for me) but I am just wondering if the issues DRSteele has is partly still down to some Hex code being left, as in the code it appears that there is still some Hex code appearing for the background color (please see the red text below).

    The below was taken using the all formulas option and produces the results here.

    Btw, I am using the version from post number 18 not 31.


    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">bbbb</td><td style="text-align: right;background-color: #00B0F0;;">123</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">vvvv</td><td style="text-align: right;;">456</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">vvvv</td><td style="text-align: right;background-color: #FFFF00;;">789</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">xxxx</td><td style="text-align: right;;">1122</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="background-color: #C00000;;">zzzz</td><td style="text-align: right;;">1455</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">\\\\</td><td style="text-align: right;;">1788</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet4</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G1</th><td style="text-align:left">=A1</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H1</th><td style="text-align:left">=B1</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G2</th><td style="text-align:left">=A2</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H2</th><td style="text-align:left">=B2</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G3</th><td style="text-align:left">=A3</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H3</th><td style="text-align:left">=B3</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G4</th><td style="text-align:left">=A4</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H4</th><td style="text-align:left">=B4</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G5</th><td style="text-align:left">=A5</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H5</th><td style="text-align:left">=B5</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G6</th><td style="text-align:left">=A6</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H6</th><td style="text-align:left">=B6</td></tr></tbody></table></td></tr></table><br />
    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, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

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
  •  

 

 
DMCA.com