Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Excel no longer pasting backgrounds (Frontpage 97

    At work, we just upgraded from Office 97 to Office 2000; although, I still have Frontpage 97. Office 2000 does not appear to be a well thought out program and the switch (I will not call it an upgrade) is causing me all sorts of problems. The latest one is this.

    I keep my grades in Excel. When a student does not do an assignment and gets a zero, I shade that cell red to call attention to it. I display the grades by pasting the worksheets into Frontpage and then posting the web page inside WebCT. That worked find with Office 97 & Frontpage 97. But with Office 2000, the cell shading is not pasted into Frontpage. Additionally, I get a lot of strange HTML like the following:

    <td style="height:15.75pt" x:num align="right">4123</td>
    <td class="xl25" x:num="71.562824675324677" align="right">72</td>
    <td class="xl25" x:num align="right">50</td>
    <td class="xl25" x:num align="right">100</td>
    <td class="xl26" x:num="83.735714285714295" align="right">84</td>
    <td class="xl26" x:num="84.183982683982677" align="right">84</td>

    Does anyone know what is going on? Can I get Frontpage to behave normally, e.g. like it did with Excel 97?

    Ronny
    Ronny Richardson

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Excel no longer pasting backgrounds (Frontpage 97

    Office 2000 does not appear to be a well thought out program
    We'll have to just agree to disagree on this one, I found it a worthwhile upgrade. On the other hand, I'm having my doubts about the latest version of Office <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.
    Anyhow, instead of debating - the strange HTML is caused by Office 2K's love of the web. In a nutshell about the time Office 2K was being written - Redmond got the web religion and thought that every organization wiould love to keep all of their documents in internal websites instead of mapped directories. So theoretically, you'd save your documents to the corporate web - then retreive them as web documents and save them back as Excel or Word or whatever files. The extra code is to retain the original structure of the document. They were calling this "round tripping".

    The idea flew like a brick. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> And most of us have spent time working around it - so you aren't alone.

    Now, how can you get what you what out of Excel and FP 97?
    First, download the Office 2000 HTML Filter 2.0. It's a quick download and fast install. It's designed to strip the extra code from your Office 2000 documents. In my installation, I've enabled all of the Options so it will strip as much extraneous code from my documents as possible.
    Next, in Excel go to Tools, Options,General and click the Web Options button.
    Under Web Options, General disable the option for Relying on CSS for font formatting. In mine I've also disabled the option to save hidden data. You may want to look through the rest of the tabs to see if there is anything else you want to turn off.
    In your spreadsheet, select the cells you want and choose the File, Save as WebPage Option. Once there you can decide whether to save the entire workbook or only your selection. Note where you save the file to.
    Do this with as many worksheets as you wish.
    Now run the Office HTML filter. You can filter a large number of files at the same time. It is very fast - but oddly there isn't a button to tell you when it is finished filtering, the file names just disappear. Warning- the web pages can not be open in another application while you do this.
    Once filtered you can look at the files with internet explorer and copy and paste into the HTML view in FP.

    Yes, I know this is tedious. And for whatever reason, it still doesn't get rid of the x:num tag (whatever they are supposed to do). It should however, strip everything else but leave your cell formatting in place.

    Hope this helps.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Excel no longer pasting backgrounds (Frontpage 97

    While back, someone posted an Excel VBA solution that would convert a bunch of selected cells into Lounge table markup. It would not be difficult to convert that to real HTML. But... I don't remember whether it dealt with the cell's background colors. Perhaps a polite request on the Excel board would get you a solution.

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Excel no longer pasting backgrounds (Frontpage

    Catharine,

    Thank you for such a detailed answer. I've downloaded the software you suggested and I'll do the steps you've outlined. Thanks.

    Ronny
    Ronny Richardson

Posting Permissions

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