1 / 11

From Spreadsheets to Web Pages

From Spreadsheets to Web Pages. 27 February 2014. Follow Ups. CSS Inheritence. If you have 2 entries in your CSS: d iv {} d iv.class {} BOTH are applied to <div class=“class”> Taking advantage: “all my divs will have a border” Problems: widths can conflict and rules aren’t obvious.

ronda
Download Presentation

From Spreadsheets to Web Pages

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. From Spreadsheets to Web Pages 27 February 2014

  2. Follow Ups

  3. CSS Inheritence • If you have 2 entries in your CSS: div {} div.class {} • BOTH are applied to <div class=“class”> • Taking advantage: “all my divs will have a border” • Problems: widths can conflict and rules aren’t obvious

  4. Looking at Formulas On PC On Mac

  5. Multiple Worksheets

  6. Crossing Worksheets • Can reference a cell on another worksheet by going there or typing worksheet_name!A7 • Computation Worksheets • Build as many columns as you want • Do it in small steps

  7. From Spreadsheet to Web

  8. Getting Tables to the Web • Numerous tools to convert tables • Addition table • Mr. Data Converter • Sets up classes • Formatted • Caveat: it requires that there be a value in the upper left cell • Tableizer • No classes • Not formatted • We have had Mac problems

  9. Using Komodo Tools • Find/Replace is your friend • Resources page on website • Regular Expressions • Komodo Primer • Notes

  10. Regular Expressions • allow you to match other than an exact string • Key capabilities • /w any alphanumeric • /s any space • [] any of the enclosed • + 1 or more • * 0 or more

  11. Table cleanup • From Mr Data Converter • class=“[\w\s-]+” • Will match all of the classes generated • From Tableizer • Need multi-line as well as Regex • Use enter and tabs in Komodo • Copy and paste into “Replace with” OR • Use HTML Formatter

More Related