LibreOffice Calc - Help Please

LadyDee

I've been struggling with this all morning, so I have tried!

I have a spreadsheet saved using LibreOffice Calc which I'm trying to print.
The only thing that is printing is one sheet with the contents of one cell in it.

Somehow, I've managed to number this cell as Page 1, and for the life of me I can't find how to un-name it. The system seems to think this is a one page document, so in the printer menu where I've selected "print all pages" it's still only printing that cell.

I've even tried copying the document into a fresh spreadsheet but of course that hasn't worked as it copies the formatting too.

So - can anybody help please? If I smoked, I'd have gone through a packet by now!

kwikbreaks

With my version of Libre Office (5.0.4.2) selecting a range or cell and pressing the key combo CRTL F3 brings up the Manage Names dialog. You can select and delete any name although it can't be "Page 1" as spaces are not allowed.

I tried adding the name Page1 to a cell in one of my sheets and it had no impact on the print preview so this may be a red herring and it isn't a cell name at all.

Take a look at print preview and try playing around with the margins and scaling.

If this is just a list type sheet and doesn't contain many formulae you might try saving it out as a CSV then using that to build a new sheet from the data.

LadyDee

kwikbreaks wrote: »

With my version of Libre Office (5.0.4.2) selecting a range or cell and pressing the key combo CRTL F3 brings up the Manage Names dialog. You can select and delete any name although it can't be "Page 1" as spaces are not allowed.

I tried adding the name Page1 to a cell in one of my sheets and it had no impact on the print preview so this may be a red herring and it isn't a cell name at all.

Take a look at print preview and try playing around with the margins and scaling.

If this is just a list type sheet and doesn't contain many formulae you might try saving it out as a CSV then using that to build a new sheet from the data.

Thank you - that did appear to have solved the problem of the document only being 1 page/1 cell, but it doesn't seem to want to print at all now. I removed a 'copy' of the printer driver that had mysteriously appeared in my list of devices, cancelled all the queued print jobs, switched the printer off, then on - tried again and nothing happens.

I have paper, toner and all the correct lights are on. Any more ideas please?

Oh, I did re-save the CSV as an XLS file but neither will print.

Edited to add: I have now found that the reason it's not printing is that it thinks it's connected by USB but I have it connected wirelessly. I can't find where to make a selection for wireless connection as I've never had any problems before. When I installed the printer some time ago it just worked. Sorry, it's a Brother-2130 Laser Printer.

kwikbreaks

All I can suggest is that you delete all versions of the printer and try re-adding it.

You'll need to check the printer manual to make sure it is connecting to the WiFi correctly if you don't see it as an option when trying to add the printer back.

LadyDee

kwikbreaks wrote: »

All I can suggest is that you delete all versions of the printer and try re-adding it.

You'll need to check the printer manual to make sure it is connecting to the WiFi correctly if you don't see it as an option when trying to add the printer back.

Thank you - I did wonder if I should uninstall and start from scratch, I'll give it a try.

kwikbreaks

I think you can get squared paper + pencils in pound shops if the worst comes to the worst

Dontcha just love computers. Think how much time they save you......

LadyDee

UPDATE: All sorted, by re-adding the printer, so I now have two copies in my devices again (the Brother support chap suggested not deleting the other copy). What I did to the original document in LibreOffice remains a mystery but the rescued version in Excel has now printed successfully.

Thanks again for your help.

LadyDee

kwikbreaks wrote: »

I think you can get squared paper + pencils in pound shops if the worst comes to the worst

Dontcha just love computers. Think how much time they save you......

I know, but so boring:rotfl:

paddyrg

The two versions are because the computer doesn't know the two instances are the same printer - it's going to talk to one via USB, the other wirelessly. For all it knows, they could be two entirely separate devices. If it makes it easier, rename them to clarify which is the wireless and which USB instance.