Re: [libreoffice-users] Print range not always loading

Hi :)
You might find the 3.4.5 is better
http://www.libreoffice.org/download/?type=win-x86&lang=en-US&version=3.4.5
If you want the English (UK) version then just change the US to GB in that link.  Quite a few other 
languages are available too.

We generally have 2 branches being developed at the same time.  The 3.5.x branch is a bit like 
development or "latest features" branch and the 3.4.x is the stable branch.  On the other hand it 
might be worth waiting a few days for the 3.5.1 to be released but there seems to be a bit of a 
delay so i would go with 3.4.5.  Oh wait, that is the one i am using :)


> From the Release Plan is here.  You can see there is still 1 more release in the 3.4.x branch 
> scheduled for release.  
https://wiki.documentfoundation.org/ReleasePlan
Regards from
Tom :)


--- On Wed, 14/3/12, Ron Gregor <rgregor@wcnjcd.com> wrote:

From: Ron Gregor <rgregor@wcnjcd.com>
Subject: [libreoffice-users] Print range not always loading
To: users@global.libreoffice.org
Date: Wednesday, 14 March, 2012, 19:21

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 still exists.

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)
win xp

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: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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