I am trying to switch from Open Office 3.3 to Libre Office 3.5 but I am having problems with
my print ranges. All files work well in Open Office 3.3. In Libre Office when we first open the
files most don't show any print range in use. When we go to Format>Print ranges the
Remove is grayed out. We go to Format>Print ranges>edit the drop list on the left has an
entry called "Excel_BuiltIn_Print_Area_1" which is our print range. We can select and use
this print range and save the file. When open the file again it has no print range in use. We
can create a new print range but it does not load after save and close and load file.
I have tried different save and save as options to get this to work but no luck.
I was able to save as xls and the "Excel_BuiltIn_Print_Area_1" range was no longer there. Then
I did a save as ods but neither the xls or ods will let me save a print range.
A few years ago these files originated from wk1 file opened in excel 2000 then
saved as xls files then converted using Open Office.
What I would like is to find a way to get the print ranges to work without
having to re-enter the data into new spread sheet files. We have about 50 files and not
all have the same exact formating (print ranges, row heights, fonts...) creating new sheets
would take some time to make sure we get everything matched up to print exactly the same.
Plus since this problem is not consist we could put in all the time and find print range problem
I was able to get one of the files to work by creating a new ods file and copying the sheet
from original ods to new ods. Then I went to do a second filet and at first it worked when the
external links were not active (I made links text by starting with apostrophe). Once I removed
apostrophe the print range will not load. When I go into the content.xml file I can find the print
range is there.
In all the different files all have worked with Open Office 3.3.
Open office 3.3
Libre Office 3.5 (Installed on 2 computers after uninstalling Open Office)
I can send a sample files to someone if needed I just need to clear out some
names on the sheets.
Thanks, Ron Gregor
For unsubscribe instructions e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] Print range not always loading · Ron Gregor
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy