A Free Newsletter for Users of the HP95LX/100LX/200LX
In this issue:
---Linking Spreadsheets in Lotus 1-2-3
---Tip: Export data from 1-2-3 with the 123DLM Add-in Program
---Apologies to Lewis Carroll
Linking Spreadsheets in Lotus 1-2-3
If you're using 1-2-3 worksheets to track monthly expenses and you want to consolidate the spreadsheets into a year-end, summary spreadsheet, the linking feature of Lotus 1-2-3 is just what you need. The linking feature automatically copies values from spreadsheets saved on disk and presents these values in your current , on-screen worksheet. Here's a recipe for making this happen. The example assumes that you have a spreadsheet called JanExp.wk1 and it has a cell with the range name "Total".
1. Move the cursor to cell A1, for instance, in the target worksheet.
2. Type a plus (+) followed by the file name enclosed in double angle brackets, followed by the cell reference. For example:
The file reference is the location and name of the source file. If the source file is not in 1-2-3's default directory, you will have to enter the complete path of the file.
The cell reference is either the range name or the actual address of the source cell (e.g. K56). Note that this is cell-to-cell communication between two spreadsheets. The only thing passed from the source to the target spreadsheet is the value in one cell. Of course you can have several links in the target spreadsheet to accommodate several values in the source spreadsheet. You can also put links to several, on-disk spreadsheet files in one target spreadsheet.
For more about this feature I refer you to the following resource.
Complete, searchable palmtop reference library: MICROREF 1-2-3 and DOS manuals. Forty nine issues of The HP Palmtop Paper, HP Palmtop User's Guide, HP 100/200/700LX Developer's Guide, hypertext version of palmtop classic "PC in Your Pocket" ready for Palmtop viewing. All on 1999 CD InfoBase at http://www.PalmtopPaper.com
Thaddeus Computing also sells the MICROREF 1-2-3 manual in a printed booklet form.
Tip: Export data from 1-2-3 with the 123DLM Add-in Program
Once you have a spreadsheet prepared, you can add headers, footers, page numbers and have 1-2-3 send a report to a printer or to a text file. However, you have to lay out the report by hand: the Palmtop version of 1-2-3 does not have an automated "report" feature common to many database programs such as DataPerfect, dBASE III+ or PC-File.
If you want to use a database program to prepare a report you can use Window's Access database. It will read .WK1 files directly. But that suggestion is anathema to hard-core Palmtoppers.
On the Palmtop the process of exporting 1-2-3 data involves creating what is called a Comma Delimited Format (CDF) or Comma Separated Value (CSV) file. Both names refer to the same thing.
Many users like the 1-2-3 add-in program called 123DLM.ADN. It simplifies the task of outputting (and inputting) CDF files. Since most database programs import and export CDF files this makes it easier to exchange data between 1-2-3 and these programs.
123DLM.ADN does have a moderate learning/setup curve but once it's installed, it performs like a champion on the HP Palmtop. The file is available on the CD-InfoBase from Thaddeus Computing,Inc. and from http://wwww.PalmtopPaper.com/download.htm
Apologies to Lewis Carroll
In the most recent issue of The HP Palmtop Paper, in the "Through the Looking Glass" article, I mentioned that "Lewis Carroll" is the pseudonym for Charles Dobson. My apologies to all those who know that Lewis Carroll is Charles L. Dodgson, the author of the "Alice" books and "The Game of Logic". No excuses for that mistake. I've already made my word processor write "Lewis Carroll is Charles Dodgson" ten thousand times.
If you're no longer using your HP Palmtop, please consider selling it to Thaddeus Computing. We're out of used LX's and have a backlog of orders. Please help other users keep your Palmtop alive. Sell us 1 or 1000 Palmtops even if they are broken. See
http://www.PalmtopPaper.com or e-mail email@example.com.
If you've switched to the WinCE platform, check out http://www.hpcmag.com