Ask Your Question

Using Libreoffice Calc, cannot print 1st sheet after printing 2nd [closed]

asked 2018-11-14 07:40:45 +0200

gwgerrity gravatar image

updated 2020-08-14 21:36:30 +0200

Alex Kemp gravatar image

LibreOffice for Mac running under OS X 10.11.6 (El Capitan) on a Mac Pro 3,1 (Early 2008) and using a CUPS Driver for Brother HL-5450DN series 2.

I produced a large spreadsheet in sheet1 of a file, about 8 pages, and then a second, smaller spreadsheet in sheet2 of 4 pages. In the past, I have printed both sheets. Yesterday, I opened up both sheets, named them, gave them titles, and by doing so produced a linked style. I then added additional data to sheet2, opened it in print preview, and printed it.

When I then attempted to print sheet1, it printed sheet2. I deleted sheet2 and again attempted to print sheet1: in this case, the preview indicated an empty page, and print barfed on no data! I opened a new ods file and copied the data from sheet1 to sheet1 of the new empty file: it wouldn’t print either, with the same error.

I think that the problem is in LibreOffice, rather than in the print driver, and it has to do with some incompatibility in assigning separate sheet styles to different sheets, but don’t have any trouble so doing. Original file was one created in LibreOffice, but saved as an xls file.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-12-06 22:16:53.981408


Please provide a sample spreadsheet, to easily find the problem.

Mike Kaganski gravatar imageMike Kaganski ( 2018-11-14 07:46:47 +0200 )edit

I have never had this happen before, and the spreadsheet contains confidential personal data, so I am unwilling to provide it.

gwgerrity gravatar imagegwgerrity ( 2018-11-14 07:50:52 +0200 )edit

just create a new spreadsheet, copy the problematic sheet into it (as you said you did, which resulted in the problem), delete all the data from the sheet, and put something to A1. No need to post your sensitive data. If you need help, you should find a way to provide something to people willing to help; "I am unvilling to provide" is not constructive.

Mike Kaganski gravatar imageMike Kaganski ( 2018-11-14 08:16:36 +0200 )edit

See this site for other ways of anonymising your document

robleyd gravatar imagerobleyd ( 2018-11-14 08:44:52 +0200 )edit

I will be out of town tomorrow, but will take your suggestion and act on it on Friday our time (UT+11:00).

gwgerrity gravatar imagegwgerrity ( 2018-11-14 15:42:56 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-11-14 10:07:53 +0200

Lupp gravatar image

updated 2018-11-14 10:11:39 +0200

I would suspect you re-defined the Print Range(s) for Sheet1 to an empty cell-range inadvertently.

edit flag offensive delete link more

answered 2018-12-06 06:02:56 +0200

gwgerrity gravatar image

Sorry for the late reply: got tied up in other business. I actually had reset the print ranges, but not by highlighting the range: rather, I entered it manually. I just now highlighted the range and selected Print Range —> Define, and Lo! AOK.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-11-14 07:40:45 +0200

Seen: 94 times

Last updated: Dec 06 '18