1. Won't preview whole spreadsheet. 2. Won't keep my preferred fonts

English
#1

I’ve been using OpenOffice for years and have liked it. When I had a question about OpenOffice unrelated to this problem, one person said LibreOffice was much better and was kept updated. So, I’m trying it and so far results are far from spectacular.

  1. I have 3 spreadsheets created in OpenOffice, took me a long time and a lot of work to get them the way I wanted. They were perfect for me to use. Two of them opened and can be previewed for printing OK. That is as it should be. The third, however, Print Preview only shows one row and I cannot find how to make it show the whole sheet. Next, I tried to open the errant spreadsheet in OpenOffice and now it will only show the one row. It looks like I have lost all of that work, just gone. Looks like I get to start all over again.

  2. I have tried to change the fonts to what I like to use and it will not allow it. I opened one of my poems and it would not use the fonts in the document. I tried changing them in LibreOffice and the next time I opened the document in LibreOffice, the fonts I had changed had all gone back to the original fonts LibreOffice says it wants me to use. I wrote it a special way and I want it to stay that way.

I am a senior and computer stuff doesn’t come easy to me. I work hard to get things to be the way I want them and can use them and I don’t want to use a program that disrespectfully changes what I’ve written, formatted, etc. I have asked these questions the best way I can with my limited computer vocabulary.

Please answer in simple to understand English without the computerese.
Thank you,
Bernadine

#2

You have to do this in the same way as you did with OpenOffice.

  • Get a new document, set the font of cell style “Default”
  • Store the document as template: menu:File>Templates>Save…
  • Make that template your default template: menu:File>Templates>Manage… Right-click your template and choose “Set default”.

Styles and templates are essential when working with any office suite.

#3
  • You might have used a Type 1 font. OpenOffice still has partial support for Type 1 fonts. LibreOffice and even Adobe, the creator of them, have removed support for the obsolete Type 1 fonts.
  • You might be seeing a substituted font in OpenOffice while LibreOffice uses a different substitute.

You might be able to find a matching OTF font to install from https://fonts.google.com/ or other sites.

#4

Hi Viieroy,
I never used a template in all the time I used OpenOffice, or any other word processing program for that matter. Started out with WordPerfect in 1992 still my favorite but it’s expensive, so I use it as best I can on here. Never, ever liked MSWord at all, too limiting I think I’ve had OpenOffice for 10 years or more maybe. I’m not a templatey type of writer. And I have my own style too. I go all over the place and use all kinds of fonts, even in one document and never had a problem with OpenOffice. I can open old WordPerfect documents and mostly was fine. Seems like if I have a font in my font list LibreOffice should find and use it. LibreOffice isn’t much use to me if it won’t let me use the fonts I want. Their substitutions have different sizes and a 12 point can be very different from the 12 point I’ve used and that throws the whole alignment of my work into complete disarray. And if I have to create a new template every time I want to use a different font, I’ll never get to do anything but create templates. And when I want to switch fonts around, several and even many types in one document, I guess I’d just be out of luck.
Thanks,
Bernadine

#5

Hi EarnestAI,
I don’t know about Type 1 fonts or Type gazillion fonts. It seems to me that Arial and Times New Roman are standard, well and widely used and I see no reason to substitute them out. (If they are obsolete, I guess I am too. I’m not that old, 75, but it wouldn’t be the first thing that makes me obsolete.) When I have the font in the programs font list, it should use that font. Not switch it around and mess up my work. As far as OpenOffice when I print out a spreadsheet with Arial font, I get Arial font. I don’t know what LibreOffice would give me I closed it down and it’s taken me all this time since I first posted to get my spreadsheet back in workable order.
Thanks,
Bernadine

Anyone up for answering Question 1 above?

#6

You may have defined a print range of just that one row, see Using Print Ranges on a Spreadsheet.

2 Likes
#7

Arial and Times New Roman have no issues, they never were a Type 1 font.

If the font name displayed in the font box is upright then the original font is used, if it is shown in italics then a substitute font has been used. The exception is if the file has been saved as a text only file, that is, no font information has been saved, in which case the default font (user selectable) is used.

A file sample might help, click the up-pointing arrow to upload.

#8

Without seeing your file, we can only guess. And a defined print-range would also be my first idea.
.
You could upload your file here for inspection.
.
On a general view: Stay with Open-office or whatever you like. Don’t expect them to learn new stuff you may never need.
.
Think how to preserve your archived system. Maybe ask somebody how to create a virtual environment where your WordPerfect still runs… Disconnect/isolate this from the internet fore security reasons.

#9

How many pages it says at the bottom left of the preview screen?
image

Maybe the bottom margin of the page is set to a large number (i.e., 25 cm instead of 25 mm). See menu Format - Page Style - Page tab.

#10

I want to thank everyone who replied to my questions. After my last response I decided to try to go back to OpenOffice before this all started. It took quite a while but I think I have my 2 main spreadsheets back to what I want, the third will have to wait until I’m not so stressed about this.
It was all just too much for me to try to understand. I thought maybe today I could read your replies and figure out what went wrong, but just trying to read your replies have made my head spin. LibreOffice is still on my computer and I’ll keep my question and your replies. Maybe sometime in the future I will try it from scratch, if I can figure out how to make it use the fonts I want.
Thank you for your help even though I was able to use it very well,
Bernadine

1 Like

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.