Description

This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

7.2 How can I round to the nearest multiple of 3? or the nearest nickel? (spreadsheets)

if you have a ROUND() function, simply divide by your grouping,
round your value, and multiply by your grouping.

  e.g., to round to the nearest  use
     3                           ROUND(value/3)*3
     0.05                        ROUND(value/0.05)*0.05
     0.05                        ROUND(value*20)/20     [equivalent]

these results will still be subject to computer accuracy -- if you
round 0.15 to the nearest 0.3, you might get 0 or you might get 0.3
or you might get 0.29999999999.

7.3.1 built-in save-as HTML (spreadsheets)

some spreadsheets have this built-in now. contact your vendor
to see if there is a patch or add-on which will work for you.

7.3.2 dbQuickPage (HTML) (spreadsheets)

dbQuickPage supports the following [...]

Lotus 1-2-3 wk1, wk3, wk4
Excel 3.0, 4.0, 5.0, 8.0

http://www.hallogram.com/dbquickpage/

7.3.3 XTML (Excel to HTML)

http://members.aol.com/ksayward/XTML/

7.3.4 perl source code (spreadsheets)

(source code!)
(doesn't require MS-Windows!)
(free!)

7.3.4.1 Herbert, a free platform independent MS Excel to HTML convertress

http://user.cs.tu-berlin.de/~schwartz/perl/

7.3.4.2 Spreadsheet::ParseExcel

http://www.perl.com/CPAN-local//modules/by-module/Spreadsheet/

7.3.5 Quick View (spreadsheets)

http://www.inso.com/qvp/index.htm
[error 2001/Apr/18]

add-in for Netscape Navigator
views many spreadsheet file types

7.3.6 Corel Quattro Viewer Plugin (spreadsheets)

http://www.corel.com/products/wordperfect/cwps8/plugin.htm

7.3.7 Drag and View (spreadsheets)

http://www.canyonsw.com/dnv.htm

7.3.8 ReadWk (spreadsheets)

ftp://ftp.simtel.net/pub/simtelnet/msdos/spredsht/readw308.zip
WKS,WK1

7.3.9 QView (spreadsheets)

ftp://ftp.simtel.net/pub/simtelnet/msdos/spredsht/qtview11.zip
WKQ,WQ1,WQ2,WB1,WKS,WK1,WRK,WR1

7.3.10 xl2html (spreadsheets)

http://www710.gsfc.nasa.gov/704/dgd/xl2html.xls [hard to reach]
http://www.gwdg.de/samba/winapps/xl2html.zip [unofficial mirror]

 

Continue to:

• prev: 7.1 Why does my spreadsheet say 0.1+0.1+0.1+0.1+0.1-0.5 isn't 0?
• Index
• next: 7.4 How many columns or rows does my spreadsheet allow?

Share and Enjoy

Tags

business, spreadsheets, Excel, Quattro, Lotus 1-2-3, free, open source, commercial, tab delimited, csv, formula, macro