Calc sheet
| # | Post |
|---|---|
| 1 | I am working on a Libra cal sheet and have set all the page up including grid lines but when I do a print preview of it the pages only shows half of what I have done? frustrating never had that before? Please help thanks greenforde - 2021-10-07 07:53:00 |
| 2 | I'm assuming you are talking about 'Borders'... king1 - 2021-10-07 08:29:00 |
| 3 | No I am talking about grid lines in an excel sheet and have tried your suggestion. greenforde - 2021-10-07 08:37:00 |
| 4 | gridlines don't display on anything printed and afaik can't be individually set, they are there purely to give visual clarity to the individual cells for the user. Borders on the other hand are something you can control at the individual cell level and do display on print previews etc you might see what i mean of you open a calc sheet and the use the view menu and select 'view gridlines for sheet' Further, a border is not just a border around the outside of your form, it can also be a border around a cell, or a range of cells in a row/column, giving the effect of a grid... but again, very different to Calc grid lines... Edited by king1 at 8:48 am, Thu 7 Oct king1 - 2021-10-07 08:45:00 |
| 5 | Hi greenforde, king1 makes some good points. How are you putting in the grid lines? Also, if you have a lot of info (and grid lines) in your spreadsheet, the screen resolution just might not show them in the print pre-view *even though they are actually there*. Perhaps you could try printing out a single page and see what happens? - Alternatively, if ink and paper are scarce, try printing to a pdf, then when you open the pdf, you can expand to see if the grid lines would *actaully* print. :) zirconium - 2021-10-07 08:53:00 |
| 6 | If it's a simple I want to print the gridlines (borders) on all cells, click on the menu - Edit - Select all, Format - Calls, Borders tab, then click the 4th one along in the Line arrangement - Presets section with tooltip - Set outer border and all inner borders. This will add borders to all the cells. Click ok. nzstocked - 2021-10-07 09:22:00 |
| 7 | Putting the grid lines in highlight area, format, page, sheet, press grid, ok. Seems to be working now. Can I email the sheet to an other computer for them to work on? Edited by greenforde at 10:03 am, Thu 7 Oct greenforde - 2021-10-07 09:52:00 |
| 8 | Sometimes I think the page breaks get in the way how can I remove them all please greenforde - 2021-10-07 09:53:00 |
| 9 | greenforde wrote: well that's interesting, looks like you can print the gridlines. I still think you should be using the borders for this function, far more control over size of lines color etc you can email it by File -> Send, but you need an email client setup like Outlook or thunderbird king1 - 2021-10-07 10:12:00 |
| 10 | greenforde wrote: king1 - 2021-10-07 10:14:00 |
| 11 | greenforde wrote:
Of course you can email a spreadsheet. nice_lady - 2021-10-07 10:18:00 |
| 12 | greenforde wrote: I don't have Libra but in Excel I highlight the section of the sheet and select Page Layout -> Set Print Area before printing, otherwise the scaling and printing isn't under my control. gyrogearloose - 2021-10-07 11:00:00 |
| 13 | Emails through okay but cannot add to it. All I need I have compiled a calc sheet with gridlines and a bit of typing I want to email it over to another computer for them to add more figures and finish the document? greenforde - 2021-10-07 11:03:00 |
| 14 | greenforde wrote:
You have compiled a spreadsheet. That's nice. I"m confused. Perhaps if you re-read you post and edit it so it makes sense please ? Edited by nice_lady at 11:46 am, Thu 7 Oct nice_lady - 2021-10-07 11:44:00 |
| 15 | greenforde wrote:
By default the calc sheet will be in read only mode when opened from an email on the other computer. nzstocked - 2021-10-07 12:01:00 |
| 16 | Ah of course nice_lady - 2021-10-07 12:36:00 |
| 17 | Oh good when you say My documents do you mean Documents? Thanks greenforde - 2021-10-07 13:08:00 |
| 18 | greenforde wrote:
That's irrelevant. What they mean is the attached spreadsheet needs to be saved to ANY folder on the computer prior to someone trying to edit it. nice_lady - 2021-10-07 13:21:00 |
| 19 | Done thanks for all your help. greenforde - 2021-10-08 08:13:00 |
