| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 24172 | 2002-09-05 01:39:00 | *.prn files - do they have a use | Mike S (1766) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 76563 | 2002-09-05 18:56:00 | You can "right click" on the *.prn file and send to some text editor That is if you have set up a text editor on the right click option. And read it just like any other text file. |
E.ric (351) | ||
| 76564 | 2002-09-06 03:49:00 | If and only if it is a plain bog text file for a plain bog teletype emulation. If it is a nice "graphic" output for a clever printer, it will be a binary image file. If it's for a PostScript printer, it will be readable, but it is likely to be enormous. "output to file" is not intended to make a readable file. It is meant to produce a file which can be printed later on a particular printer, perhaps because the printer is offline, out of paper, or away for repair. | Graham L (2) | ||
| 76565 | 2002-09-06 07:26:00 | It should be as simple as Highlighting the portion that you want to send <sans the extra doodads> Copy & paste to word.... then email that.... Yep just tested it, the paste will copy the top layer you highlight, and make a duplicate in word. |
flying_green_leprachaun (1767) | ||
| 76566 | 2002-09-09 04:02:00 | Copying the image into Word is a good method as no formulae are carried over, and the overall format is preserved, colours and all. The two disadvantages are actually carrying out the operation (not easy to make this part of an automated procedure for dummies) and the splitting of a spreadsheet printout, where in the Excel environment the print output has been scaled to fit say one page. | Mike S (1766) | ||
| 76567 | 2002-09-09 04:05:00 | I tried your free pdf printer but I end up with a file that opens in Internet explorer and looks and behaves as the original spreadsheet; you can read all the formulae, alter cells and so on. Also I found that the *.updf file can only be opened if you have the special program installed. Now I know it’s free but this is still an irritation to the recipient. In the kind replies from other respondents, many of the options involved losing original formatting/special colouring etc. In effect I seem to be looking for a ‘prn’ file which is usable by anybody, regardless of printer installed: In addition to the copy/paste (from Excel to Word) advice from flying_green_leprechaun (and that too has some limitations) I could probably get the result I want by scanning a printout and e-mailing the picture: painfully clumsy though! – big files too. |
Mike S (1766) | ||
| 76568 | 2002-09-09 04:16:00 | Greg, what about just using a copy of the final spreadsheet, (using "save as") and highlight all of it, edit|copy edit|paste special - values That gives an exact equivalent of the original, with no formula, only the values. |
godfather (25) | ||
| 76569 | 2002-09-09 04:26:00 | Have to agree that the best way is the repeated one outlined by Godfather. Furthermore, if your end user doesn't have Excel (or the same version as you or later) they can download a free viewer program from the Micro$oft site. |
Capital (813) | ||
| 76570 | 2002-09-09 04:26:00 | I found that trying to do that failed where merged cells had been used. Also you lose all column width settings, colours, justification etc. Mike S |
Mike S (1766) | ||
| 76571 | 2002-09-09 04:31:00 | Mike Sounds like you done a <paste all> rather than just a <paste values>. If you need other than just values try using the options you want one at a time. |
Capital (813) | ||
| 76572 | 2002-09-09 04:50:00 | Its important that you dont copy it and paste it to a new spreadsheet, rename a copy of your old one and edit-copy edit-paste special-values while it is all highlighted, dont paste it somewhere else, then all the things you mention (colours, merged cells) will still be there, only the formula have disappeared. This by the way is very common in business as nobody wants the origin of any figures disclosed. The final sheet is much smaller for e-mailing as well. I don't recall seeing you mention that you needed to keep all the formatting earlier, as much of the advise was unhelpful in that case. Pasting over an existing renamed file is usually the best option in these cases. |
godfather (25) | ||
| 1 2 3 | |||||