[libreoffice-users] Writer loses format of MSOffice2007-Doc (watermark, embedded image, format etc)

2012-07-27 Thread Miriyala, Vasu
Hi Forum,



Appreciate your pointers or help on how to open the MS office word files in 
writer while retaining the format of original intact. Currently Libre when 
opening MSOffice-word2007 docs loses water mark, embedded image, images 
inserted thru insert features of word 2007 etc



Thanks, Vasu






This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is 
intended only for the person to whom it is addressed. If you are not the 
intended recipient, you are not authorized to 
read, print, retain, copy, disseminate, distribute, or use this message or any 
part thereof. If you receive this message 
in error, please notify the sender immediately and delete all copies of this 
message.

-- 
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc (watermark, embedded image, format etc)

2012-07-27 Thread Mirosław Zalewski
On 27/07/2012 at 09:28, Miriyala, Vasu vasu.miriy...@capgemini.com wrote:

 how to open the MS office word files in writer while retaining the format
 of original intact.

This is not possible. If you want to open MS Office with exactly preserved 
formatting, then you must use MS Office. Preferably in the same version in 
which 
document was created.

LibreOffice is free (as in freedom) office suite, not MS Office documents 
viewer.
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@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


Re: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

2012-07-27 Thread Steve Edmonds



On 26/07/12 12:51 AM, webmaster-Kracked_P_P wrote:

On 07/24/2012 10:34 AM, James Knott wrote:

Russell Wilson wrote:
try  starting with something like 1/4 population of New York, 1000 
times its surface area, and 1/4 of 1% of its financial worth


First off, I was thinking of the international trunks.  Analog 
systems are so obsolete that it would cost more to maintain them then 
to replace.  However, even domestically, the same still applies.  I 
don't know if you're referring to New York City or New York State, 
but even assuming the city, Canada has about 4 × the population, or 
16 × that of NZ, but the area of almost 10 million sq Kilometres is 
close to 40 times that of New Zealand, yet the analog phone system is 
long gone here.


BTW, I've worked in the telecommunications industry for most of my 
career and it's been over 30 years since the last time I saw an 
analog system.  New Zealand would *REALLY* have to be a back water 
country to still be using an analog phone system.


Well just on the outskirts of NZ largest city I am 500m from the 
roadside exchange box thing. The analogue line went out when it rained 
and ADSL was next to useless. The national fibre trunk of the second 
largest telco goes past the door but they won't tap it for me. I have a 
19km line of sight WiMax link now, also on another property that has a 
30km WaiMax relay. Voip on both and stick it to the telcos. The national 
fibre rollout sounds good but I doubt it will reach me.

Steve


I live in the county seat of Chemung County in New York State.  We 
are a city, but not a big one, unlike the county seat 50 mile from 
here.  They are 10 time bigber than ours.


There is a program where the government is pushing broadband access 
for most of the US users, but it does not mean that access is cheap.


What I would love to see is fiber to the homes instead of fiber to a 
node somewhere in the 4-6 block area and then have coax to the 
home.  That is what here for our cable-modem system.  Our DSL system 
goes through the phone line, but it can be more expensive.  They want 
you to have a regular non-digital phone line with them before you 
are able to get their service.  So even if you want a digital-phone 
service, you will be required to have a regular one as well.  I have 
my broadband downloading [only 120 MB/s uploading do to cable issues], 
digital phone, and TV digital cable service from the one company.  It 
cost less this way, but is still cost a lot out of my budget.


I would love to see a cheaper solution in my area.  With an 
inexpensive broadband service, I could add a third-party digital phone 
service and also watch most of my TV shows via the streaming video 
services [free mostly, but paid sometimes].  I could cut my budget for 
those services down to about a third of what I am currently paying.


What we need is the political boost for allowing competition in our 
market instead of having one cable company and one phone company. 
There is no competition to keep the rates down.





--
For unsubscribe instructions e-mail to: users+h...@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



[libreoffice-users] Re: Confluence Word doc export

2012-07-27 Thread Paul Keir

Hi,

The problem document referred to in my earlier email can be found here:
https://docs.google.com/open?id=0B8bUb5ZVQs7iNUthMGs4Ry0xSnM
Like LibreOffice, Google Docs also cannot view it, though a link is 
provided to the original file, at the end of the line starting:

You can also try to download the original document by clicking

Many thanks,
Paul

--
For unsubscribe instructions e-mail to: users+h...@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



[libreoffice-users] Re: Date format macro.

2012-07-27 Thread Andreas Säger

Am 19.07.2012 23:48, rhubarbpie...@gmail.com wrote:


I'd like to create a macro for a user-defined date format (H:MMa/p).  As
examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p.  I can
create the format manually, but I understand the LibreOffice format
can't save user-defined formats.  So my thought is to create a macro
which creates the format each time the spreadsheet is opened.  The
user-defined Format Code is for a saved Style.

The macro records without incident and the date format is correct.
However, running the saved macro doesn't change the format.  It seems
this should work.  Thoughts?  The recorded macro is as follows:



Hello,

The issue is a known one (AOO bug #66842). The office seems to support 
some format codes that have no equivalent expression in the ODF standard.

It has been discussed in a productive manner here:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=53724
http://user.services.openoffice.org/en/forum/viewtopic.php?f=20t=55344

I attached simple Basic macro to a demo document:
http://user.services.openoffice.org/en/forum/download/file.php?id=14598

It links number formats to cell styles so the newly generated number 
formats applies to all the cells where the style is in use.


Hope this helps,
A.S.


--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc (watermark, embedded image, format etc)

2012-07-27 Thread Jay Lozier

On 07/27/2012 03:28 AM, Miriyala, Vasu wrote:

Hi Forum,



Appreciate your pointers or help on how to open the MS office word files in writer while 
retaining the format of original intact. Currently Libre when opening MSOffice-word2007 
docs loses water mark, embedded image, images inserted thru insert features of word 
2007 etc



Thanks, Vasu






This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is
intended only for the person to whom it is addressed. If you are not the 
intended recipient, you are not authorized to
read, print, retain, copy, disseminate, distribute, or use this message or any 
part thereof. If you receive this message
in error, please notify the sender immediately and delete all copies of this 
message.

I generally have success accurately opening docx format files. 
Occasionally I get one that I have to open MSO and convert to doc (2003) 
or ODF 1.0/1.1. Usually it is some graphic layout that causes the 
problem. This is known issue with LO and AOO.


docx file conversions are occasionally difficult because MS is trying to 
push their proprietary MS Office and makes open the file accurately 
problematic.


If you are using Linux, you might try Calligra Words (probably available 
in your repository) to see if it is better at opening the file and 
saving to odt.


--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc (watermark, embedded image, format etc)

2012-07-27 Thread Tom Davies
Hi :)
I've often found that even tho images appear to have vanished they are still 
really there somewhere.  That gives at least 2 opportunities;
1.  Edit and save without trying to find the images and then see if the images 
apparently re-appear in the right places when the edited file is opened back in 
MS Office 2007/2010
2.  Hunt around the edges of the pages and move any images you do find anywhere 
to see if the other images have been hidden underneath as they tend to get 
piled-up on-top of each other.  

Regards from
Tom :)  



--- On Fri, 27/7/12, Jay Lozier jsloz...@gmail.com wrote:

From: Jay Lozier jsloz...@gmail.com
Subject: Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc 
(watermark, embedded image, format etc)
To: users@global.libreoffice.org
Date: Friday, 27 July, 2012, 13:50

On 07/27/2012 03:28 AM, Miriyala, Vasu wrote:
 Hi Forum,



 Appreciate your pointers or help on how to open the MS office word files in 
 writer while retaining the format of original intact. Currently Libre when 
 opening MSOffice-word2007 docs loses water mark, embedded image, images 
 inserted thru insert features of word 2007 etc



 Thanks, Vasu






 This message contains information that may be privileged or confidential and 
 is the property of the Capgemini Group. It is
 intended only for the person to whom it is addressed. If you are not the 
 intended recipient, you are not authorized to
 read, print, retain, copy, disseminate, distribute, or use this message or 
 any part thereof. If you receive this message
 in error, please notify the sender immediately and delete all copies of this 
 message.

I generally have success accurately opening docx format files. 
Occasionally I get one that I have to open MSO and convert to doc (2003) 
or ODF 1.0/1.1. Usually it is some graphic layout that causes the 
problem. This is known issue with LO and AOO.

docx file conversions are occasionally difficult because MS is trying to 
push their proprietary MS Office and makes open the file accurately 
problematic.

If you are using Linux, you might try Calligra Words (probably available 
in your repository) to see if it is better at opening the file and 
saving to odt.

-- 
Jay Lozier
jsloz...@gmail.com


-- 
For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] starting Base

2012-07-27 Thread Don C. Myers

Hi,

I run Ubuntu 12.04 with Unity. Did you download LO 3.3.5 from 
LibreOffice, or are you using the Ubuntu repository version. In Ubuntu, 
the default install from Ubuntu for LibreOffice does not include Base. 
It can be added separately through the software center. Be careful also 
not to mix the two versions, the one from the repository and the one 
from LibreOffice directly.


Don


On 07/27/2012 09:43 AM, Heinrich Stoellinger wrote:

Hello,
I have just installed libreoffice 3.5.5 on my lately upgraded Mint
system (Maya). When I now start LO the entry for base doesn't appear.
On the other hand, writer, impress, calc, etc. DOES appear. Any idea
what might be the cause?
Thanks
H. Stoellinger



--

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at 
_www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/

_View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/
*~~*


--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] starting Base

2012-07-27 Thread webmaster-Kracked_P_P


I have not loaded 3.5.5, but I have 3.5.4 on my Ubuntu 12.04 laptop with 
MATE as its desktop environment and it does show Base in the 
applications/office menu.


Also, I installed LibreOffice from the download site and not the repository.

I was planning on installing 3.5.5 on the laptops [Ubuntu, XP, and 
Vista] but I did not have the time.


Actually we had a tornado pass by yesterday about 1 mile north of me and 
almost hit one of our two hospitals.  They are stopping people from 
entering our city, unless you live or work here - and can prove it.


I will install 3.5.5 on my laptop in a few minutes and see what happens 
with Base.



On 07/27/2012 10:00 AM, Don C. Myers wrote:

Hi,

I run Ubuntu 12.04 with Unity. Did you download LO 3.3.5 from 
LibreOffice, or are you using the Ubuntu repository version. In 
Ubuntu, the default install from Ubuntu for LibreOffice does not 
include Base. It can be added separately through the software center. 
Be careful also not to mix the two versions, the one from the 
repository and the one from LibreOffice directly.


Don


On 07/27/2012 09:43 AM, Heinrich Stoellinger wrote:

Hello,
I have just installed libreoffice 3.5.5 on my lately upgraded Mint
system (Maya). When I now start LO the entry for base doesn't appear.
On the other hand, writer, impress, calc, etc. DOES appear. Any idea
what might be the cause?
Thanks
H. Stoellinger






--
For unsubscribe instructions e-mail to: users+h...@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



[libreoffice-users] how block image/graphic to background for OTT?

2012-07-27 Thread manuel_songokuh
hello

i'm looking for :

1 - how block an image/a graphic to background for OTT?
   -because i wanted to create new document template for my colleagues not 
modify to background OR cancel background..

2 - VERY IMPORTANT: i NEED to be disable over mouse...because when my 
mouse is over to background and click it so i cant write my words because 
background is selected..but background is already to send back (use send to 
back)
like as example impress has MASTER SLIDE so it can't modify background close of 
master, this is very GOOD for impress but i want same to my writer with 
template OTT...how?

i use libreoffice 3.5.4

-- 
For unsubscribe instructions e-mail to: users+h...@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



[libreoffice-users] how block image/graphic to background for OTT?

2012-07-27 Thread Dan

manuel_songo...@yahoo.it wrote: hello

 I'm looking for :

 1 - how block an image/a graphic to background for OTT?
 -because i wanted to create new document template for my 
colleagues not modify to background OR cancel background..


 2 - VERY IMPORTANT: i NEED to be disable over mouse...because 
when my mouse is over to background and click it so i cant write my 
words because background is selected..but background is already to send 
back (use send to back)
 like as example impress has MASTER SLIDE so it can't modify 
background close of master, this is very GOOD for impress but i want 
same to my writer with template OTT...how?


 i use libreoffice 3.5.4


 Please, when you are asking questions, compose a new email rather 
than replying to someone email. Your email came in the midst of four 
emails: three were discussing Base, and the four was yours that had 
nothing to do with Base. This is because I tell my email client to 
thread the emails. So do many of the other members of this list. This 
groups the incoming emails (original and replies) by the original subject.
 I have composed your original email including your subject. Now 
this will be seen as a new subject and any replies will be threaded with it.
 Now to answer at least part of your question: background images 
for OTT documents. You need to open the Page style of your document, and 
enter the required data in the Background tab. Then save the document as 
a OTT. It should be saved in the user folder for LibreOffice. 
Information on how to change the page style of a document is discussed 
in the Writer Guide for LibreOffice available at

http://wiki.documentfoundation.org/Documentation/Publications.
Changing the page style should also solve your other problem as well.

--Dan

--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] starting Base

2012-07-27 Thread Jay Lozier

On 07/27/2012 09:43 AM, Heinrich Stoellinger wrote:

Hello,
I have just installed libreoffice 3.5.5 on my lately upgraded Mint
system (Maya). When I now start LO the entry for base doesn't appear.
On the other hand, writer, impress, calc, etc. DOES appear. Any idea
what might be the cause?
Thanks
H. Stoellinger

Can you check Synaptic and verify that Base is installed. I think Ubuntu 
and clones do not always install Base by default.


--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] starting Base - works for me

2012-07-27 Thread drew jensen
On Fri, 2012-07-27 at 10:41 -0400, webmaster-Kracked_P_P wrote:
 OK
 I just installed the non-repository version of 3.5.5 as an upgrade to 
 3.5.4 on my Ubuntu 12.04/MATE laptop.
 
 I still have Base listed, and working, in my Applications/Office menu 
 listing.

Hi,

Right - if you already had Base installed then an update will include
it.

//drew

 
 It shows:
 
  LibreOffice 3.5
  LibreOffice 3.5 Base
  LibreOffice 3.5 Calc
  LibreOffice 3.5 Draw
  LibreOffice 3.5 Impress
  LibreOffice 3.5 Printer Administration
  LibreOffice 3.5 Writer
 
 in that order.
 
 SO
 it could be the Repository version of LO and its desktop-integration 
 package, of it could be Unity's menu system.
 
 As I said, I use MATE for Ubuntu 12.04 and I see Base in the menu.
 
 I use MATE so I have the best looking GNOME desktop that looks and 
 acts like the GNOME desktop that I use for my desktop's 10.04/GNOME 
 system.  I use the 10.04 system as my default system and wanted any of 
 my other Ubuntu systems run either 10.04 or 12.04/MATE so it looks/works 
 like I want it to do.
 
 On 07/27/2012 10:23 AM, webmaster-Kracked_P_P wrote:
 
  I have not loaded 3.5.5, but I have 3.5.4 on my Ubuntu 12.04 laptop 
  with MATE as its desktop environment and it does show Base in the 
  applications/office menu.
 
  Also, I installed LibreOffice from the download site and not the 
  repository.
 
  I was planning on installing 3.5.5 on the laptops [Ubuntu, XP, and 
  Vista] but I did not have the time.
 
  Actually we had a tornado pass by yesterday about 1 mile north of me 
  and almost hit one of our two hospitals.  They are stopping people 
  from entering our city, unless you live or work here - and can prove it.
 
  I will install 3.5.5 on my laptop in a few minutes and see what 
  happens with Base.
 
 
  On 07/27/2012 10:00 AM, Don C. Myers wrote:
  Hi,
 
  I run Ubuntu 12.04 with Unity. Did you download LO 3.3.5 from 
  LibreOffice, or are you using the Ubuntu repository version. In 
  Ubuntu, the default install from Ubuntu for LibreOffice does not 
  include Base. It can be added separately through the software center. 
  Be careful also not to mix the two versions, the one from the 
  repository and the one from LibreOffice directly.
 
  Don
 
 
  On 07/27/2012 09:43 AM, Heinrich Stoellinger wrote:
  Hello,
  I have just installed libreoffice 3.5.5 on my lately upgraded Mint
  system (Maya). When I now start LO the entry for base doesn't appear.
  On the other hand, writer, impress, calc, etc. DOES appear. Any idea
  what might be the cause?
  Thanks
  H. Stoellinger
 
 
 
 
 
 



-- 
For unsubscribe instructions e-mail to: users+h...@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


Re: [libreoffice-users] starting Base - works for me

2012-07-27 Thread Don C. Myers

Hi,

As I understand it, Mint uses the Ubuntu software center. The default LO 
install in Ubuntu does not include base. If the user wishes to have base 
installed, you would add that to the Ubuntu installation from the 
software center. If I install from a direct LO download from LO, I have 
all of the programs listed below in webmaster-Kracked_P_P's post. In 
Unity, there is a launcher bar on the left side of the screen. The top 
button on the launcher bar is called dash, which has multiple uses. One 
use is to show the installed applications. When I do an upgrade, I 
completely remove the old install using the terminal, and then do the 
new install in the terminal. I use the following commands (This is for 
the 64 bit 3.5.5.3 from LO):


Download LibO_3.5.5_Linux_x86-64_install-deb_en-US.tar.gz to the desktop.
Right click on it and extract it to the desktop. This will give you the 
folder LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US

Run the following terminal commands to install it:
1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i 
~/Desktop/LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US/DEBS/*.deb
3. sudo dpkg -i 
~/Desktop/LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US/DEBS/desktop-integration/libreoffice3.5-debian-menus_3.5.5-3_all.deb


After this install, all of the applications below will show up in Dash. 
To add them to the Launcher bar, simply drag the icons for the ones you 
want to the launcher bar and place them where you wish to have them. 
I've never had any issue with opening any of the applications.


I read several days ago that Unity is now available for Fedora and for 
Mint for those who would like to have it.


Don


On 07/27/2012 10:41 AM, webmaster-Kracked_P_P wrote:


OK
I just installed the non-repository version of 3.5.5 as an upgrade 
to 3.5.4 on my Ubuntu 12.04/MATE laptop.


I still have Base listed, and working, in my Applications/Office menu 
listing.


It shows:

LibreOffice 3.5
LibreOffice 3.5 Base
LibreOffice 3.5 Calc
LibreOffice 3.5 Draw
LibreOffice 3.5 Impress
LibreOffice 3.5 Printer Administration
LibreOffice 3.5 Writer

in that order.

SO
it could be the Repository version of LO and its desktop-integration 
package, of it could be Unity's menu system.


As I said, I use MATE for Ubuntu 12.04 and I see Base in the menu.

I use MATE so I have the best looking GNOME desktop that looks and 
acts like the GNOME desktop that I use for my desktop's 10.04/GNOME 
system.  I use the 10.04 system as my default system and wanted any of 
my other Ubuntu systems run either 10.04 or 12.04/MATE so it 
looks/works like I want it to do.


On 07/27/2012 10:23 AM, webmaster-Kracked_P_P wrote:


I have not loaded 3.5.5, but I have 3.5.4 on my Ubuntu 12.04 laptop 
with MATE as its desktop environment and it does show Base in the 
applications/office menu.


Also, I installed LibreOffice from the download site and not the 
repository.


I was planning on installing 3.5.5 on the laptops [Ubuntu, XP, and 
Vista] but I did not have the time.


Actually we had a tornado pass by yesterday about 1 mile north of me 
and almost hit one of our two hospitals.  They are stopping people 
from entering our city, unless you live or work here - and can prove it.


I will install 3.5.5 on my laptop in a few minutes and see what 
happens with Base.



On 07/27/2012 10:00 AM, Don C. Myers wrote:

Hi,

I run Ubuntu 12.04 with Unity. Did you download LO 3.3.5 from 
LibreOffice, or are you using the Ubuntu repository version. In 
Ubuntu, the default install from Ubuntu for LibreOffice does not 
include Base. It can be added separately through the software 
center. Be careful also not to mix the two versions, the one from 
the repository and the one from LibreOffice directly.


Don


On 07/27/2012 09:43 AM, Heinrich Stoellinger wrote:

Hello,
I have just installed libreoffice 3.5.5 on my lately upgraded Mint
system (Maya). When I now start LO the entry for base doesn't appear.
On the other hand, writer, impress, calc, etc. DOES appear. Any idea
what might be the cause?
Thanks
H. Stoellinger











--

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at 
_www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/

_View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/
*~~*


--
For unsubscribe instructions e-mail to: users+h...@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: 

Re: [libreoffice-users] Lost my spreadsheet

2012-07-27 Thread Dan

joto2036 wrote:



Hi,

I had LibreOffice 3.5.4 installed on my computer. After I downloaded LibreOffice 
3.5.5 (before Installation) I couldn’t access my LibreOffice Calc (Which was a 
spreadsheet for my Medical  Dental Expenses). It was just a blank spreadsheet.

I then Uninstalled LibreOffice 3.5.4  then Installed LibreOffice 3.5.5 but again I 
couldn’t access my LibreOffice Calc spreadsheet of my Medical  Dental expenses for 
2012.

Any ideas what happened to my spreadsheet?


 You did not mention what OS (operating system) you use. Windows 
perhaps? If so, which one?
 It may be something happened when you have this spreadsheet opened 
which deleted your data in the spreadsheet. It is also possible that 
something caused the spreadsheet to become corrupted. If this is the 
case, others may should able to tell you how to possibly salvage your 
data. The spreadsheet file is a zip file. This means that information 
about the file can be extracted from it.


--Dan

--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] starting Base - works for me

2012-07-27 Thread webmaster-Kracked_P_P


Mint is where I originally found MATE.

Then I looked into installing it with Ubuntu 12.04.

If you want your desktop to look and act the most like GNOME in 10.04, 
MATE was what I found to work the best.



On 07/27/2012 12:26 PM, Don C. Myers wrote:

Hi,

As I understand it, Mint uses the Ubuntu software center. The default 
LO install in Ubuntu does not include base. If the user wishes to have 
base installed, you would add that to the Ubuntu installation from the 
software center. If I install from a direct LO download from LO, I 
have all of the programs listed below in webmaster-Kracked_P_P's post. 
In Unity, there is a launcher bar on the left side of the screen. The 
top button on the launcher bar is called dash, which has multiple 
uses. One use is to show the installed applications. When I do an 
upgrade, I completely remove the old install using the terminal, and 
then do the new install in the terminal. I use the following commands 
(This is for the 64 bit 3.5.5.3 from LO):


Download LibO_3.5.5_Linux_x86-64_install-deb_en-US.tar.gz to the desktop.
Right click on it and extract it to the desktop. This will give you 
the folder LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US

Run the following terminal commands to install it:
1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i 
~/Desktop/LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US/DEBS/*.deb
3. sudo dpkg -i 
~/Desktop/LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US/DEBS/desktop-integration/libreoffice3.5-debian-menus_3.5.5-3_all.deb


After this install, all of the applications below will show up in 
Dash. To add them to the Launcher bar, simply drag the icons for the 
ones you want to the launcher bar and place them where you wish to 
have them. I've never had any issue with opening any of the applications.


I read several days ago that Unity is now available for Fedora and for 
Mint for those who would like to have it.


Don


On 07/27/2012 10:41 AM, webmaster-Kracked_P_P wrote:


OK
I just installed the non-repository version of 3.5.5 as an upgrade 
to 3.5.4 on my Ubuntu 12.04/MATE laptop.


I still have Base listed, and working, in my Applications/Office menu 
listing.


It shows:

LibreOffice 3.5
LibreOffice 3.5 Base
LibreOffice 3.5 Calc
LibreOffice 3.5 Draw
LibreOffice 3.5 Impress
LibreOffice 3.5 Printer Administration
LibreOffice 3.5 Writer

in that order.

SO
it could be the Repository version of LO and its 
desktop-integration package, of it could be Unity's menu system.


As I said, I use MATE for Ubuntu 12.04 and I see Base in the menu.

I use MATE so I have the best looking GNOME desktop that looks and 
acts like the GNOME desktop that I use for my desktop's 10.04/GNOME 
system.  I use the 10.04 system as my default system and wanted any 
of my other Ubuntu systems run either 10.04 or 12.04/MATE so it 
looks/works like I want it to do.


On 07/27/2012 10:23 AM, webmaster-Kracked_P_P wrote:


I have not loaded 3.5.5, but I have 3.5.4 on my Ubuntu 12.04 laptop 
with MATE as its desktop environment and it does show Base in the 
applications/office menu.


Also, I installed LibreOffice from the download site and not the 
repository.


I was planning on installing 3.5.5 on the laptops [Ubuntu, XP, and 
Vista] but I did not have the time.


Actually we had a tornado pass by yesterday about 1 mile north of me 
and almost hit one of our two hospitals.  They are stopping people 
from entering our city, unless you live or work here - and can prove 
it.


I will install 3.5.5 on my laptop in a few minutes and see what 
happens with Base.



On 07/27/2012 10:00 AM, Don C. Myers wrote:

Hi,

I run Ubuntu 12.04 with Unity. Did you download LO 3.3.5 from 
LibreOffice, or are you using the Ubuntu repository version. In 
Ubuntu, the default install from Ubuntu for LibreOffice does not 
include Base. It can be added separately through the software 
center. Be careful also not to mix the two versions, the one from 
the repository and the one from LibreOffice directly.


Don


On 07/27/2012 09:43 AM, Heinrich Stoellinger wrote:

Hello,
I have just installed libreoffice 3.5.5 on my lately upgraded Mint
system (Maya). When I now start LO the entry for base doesn't appear.
On the other hand, writer, impress, calc, etc. DOES appear. Any idea
what might be the cause?
Thanks
H. Stoellinger














--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] Re: Date format macro.

2012-07-27 Thread rhubarbpieguy

On 07/27/12 05:14, Andreas Säger wrote:

Am 19.07.2012 23:48, rhubarbpie...@gmail.com wrote:


I'd like to create a macro for a user-defined date format (H:MMa/p).  As
examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p. I can
create the format manually, but I understand the LibreOffice format
can't save user-defined formats.  So my thought is to create a macro
which creates the format each time the spreadsheet is opened. The
user-defined Format Code is for a saved Style.

The macro records without incident and the date format is correct.
However, running the saved macro doesn't change the format.  It seems
this should work.  Thoughts?  The recorded macro is as follows:



Hello,

The issue is a known one (AOO bug #66842). The office seems to support 
some format codes that have no equivalent expression in the ODF standard.

It has been discussed in a productive manner here:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=53724
http://user.services.openoffice.org/en/forum/viewtopic.php?f=20t=55344

I attached simple Basic macro to a demo document:
http://user.services.openoffice.org/en/forum/download/file.php?id=14598

It links number formats to cell styles so the newly generated number 
formats applies to all the cells where the style is in use.


Hope this helps,
A.S.


Thank you!  That's a very good solution which I'll use - problem 
solved.  I also thank Johnny Rosenberg for his suggestion.



--
For unsubscribe instructions e-mail to: users+h...@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


Re: [libreoffice-users] starting Base - works for me

2012-07-27 Thread Jay Lozier

On 07/27/2012 12:26 PM, Don C. Myers wrote:

Hi,

As I understand it, Mint uses the Ubuntu software center. The default 
LO install in Ubuntu does not include base. If the user wishes to have 
base installed, you would add that to the Ubuntu installation from the 
software center. If I install from a direct LO download from LO, I 
have all of the programs listed below in webmaster-Kracked_P_P's post. 
In Unity, there is a launcher bar on the left side of the screen. The 
top button on the launcher bar is called dash, which has multiple 
uses. One use is to show the installed applications. When I do an 
upgrade, I completely remove the old install using the terminal, and 
then do the new install in the terminal. I use the following commands 
(This is for the 64 bit 3.5.5.3 from LO):


Download LibO_3.5.5_Linux_x86-64_install-deb_en-US.tar.gz to the desktop.
Right click on it and extract it to the desktop. This will give you 
the folder LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US

Run the following terminal commands to install it:
1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i 
~/Desktop/LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US/DEBS/*.deb
3. sudo dpkg -i 
~/Desktop/LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US/DEBS/desktop-integration/libreoffice3.5-debian-menus_3.5.5-3_all.deb


After this install, all of the applications below will show up in 
Dash. To add them to the Launcher bar, simply drag the icons for the 
ones you want to the launcher bar and place them where you wish to 
have them. I've never had any issue with opening any of the applications.


I read several days ago that Unity is now available for Fedora and for 
Mint for those who would like to have it.


Don


An alternative is to install the ppa libreoffice/ppa using:

sudo add-apt-repository ppa: libreoffice/ppa
sudo apt-get update
sudo apt-get install libreoffice

This ppa is updated within a couple of days of a release of a new 
version of LO. Thus your update manager will keep track of LO for you.


On 07/27/2012 10:41 AM, webmaster-Kracked_P_P wrote:


OK
I just installed the non-repository version of 3.5.5 as an upgrade 
to 3.5.4 on my Ubuntu 12.04/MATE laptop.


I still have Base listed, and working, in my Applications/Office menu 
listing.


It shows:

LibreOffice 3.5
LibreOffice 3.5 Base
LibreOffice 3.5 Calc
LibreOffice 3.5 Draw
LibreOffice 3.5 Impress
LibreOffice 3.5 Printer Administration
LibreOffice 3.5 Writer

in that order.

SO
it could be the Repository version of LO and its 
desktop-integration package, of it could be Unity's menu system.


As I said, I use MATE for Ubuntu 12.04 and I see Base in the menu.

I use MATE so I have the best looking GNOME desktop that looks and 
acts like the GNOME desktop that I use for my desktop's 10.04/GNOME 
system.  I use the 10.04 system as my default system and wanted any 
of my other Ubuntu systems run either 10.04 or 12.04/MATE so it 
looks/works like I want it to do.


On 07/27/2012 10:23 AM, webmaster-Kracked_P_P wrote:


I have not loaded 3.5.5, but I have 3.5.4 on my Ubuntu 12.04 laptop 
with MATE as its desktop environment and it does show Base in the 
applications/office menu.


Also, I installed LibreOffice from the download site and not the 
repository.


I was planning on installing 3.5.5 on the laptops [Ubuntu, XP, and 
Vista] but I did not have the time.


Actually we had a tornado pass by yesterday about 1 mile north of me 
and almost hit one of our two hospitals.  They are stopping people 
from entering our city, unless you live or work here - and can prove 
it.


I will install 3.5.5 on my laptop in a few minutes and see what 
happens with Base.



On 07/27/2012 10:00 AM, Don C. Myers wrote:

Hi,

I run Ubuntu 12.04 with Unity. Did you download LO 3.3.5 from 
LibreOffice, or are you using the Ubuntu repository version. In 
Ubuntu, the default install from Ubuntu for LibreOffice does not 
include Base. It can be added separately through the software 
center. Be careful also not to mix the two versions, the one from 
the repository and the one from LibreOffice directly.


Don


On 07/27/2012 09:43 AM, Heinrich Stoellinger wrote:

Hello,
I have just installed libreoffice 3.5.5 on my lately upgraded Mint
system (Maya). When I now start LO the entry for base doesn't appear.
On the other hand, writer, impress, calc, etc. DOES appear. Any idea
what might be the cause?
Thanks
H. Stoellinger














--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] starting Base - works for me

2012-07-27 Thread Tom Davies
Hi :)
Ubuntu doesn't seem to manage to get early versions of branches in the repos 
quickly.  often people have complained about that but it works out quite nicely 
for me :)
Regards from
Tom :)


--- On Fri, 27/7/12, Don C. Myers donmy...@myersfarm.com wrote:

From: Don C. Myers donmy...@myersfarm.com
Subject: Re: [libreoffice-users] starting Base - works for me
To: users@global.libreoffice.org
Date: Friday, 27 July, 2012, 19:01

Hi Jay,

Thanks for that information. I was aware of that. I have two concerns with 
using it. First, it may update me when I don't want to be updated, like from 
3.5.x to an early 3.6.x. I generally don't go to a new LibreOffice series until 
the second beta has been finished, so for the 3.6 series, it would be 3.6.2. 
The other concern is in the past I had issues with OpenOffice releases in the 
Ubuntu repositories, and just seemed to have better luck with the ones directly 
from OpenOffice/LibreOffice.

Any thoughts or comments about my thoughts would be appreciated. I'm assuming 
the ppa you are speaking of is in the Ubuntu repositories and it is the Ubuntu 
version.

Don


On 07/27/2012 01:48 PM, Jay Lozier wrote:
 An alternative is to install the ppa libreoffice/ppa using:
 
 sudo add-apt-repository ppa: libreoffice/ppa
 sudo apt-get update
 sudo apt-get install libreoffice
 
 This ppa is updated within a couple of days of a release of a new version of 
 LO. Thus your update manager will keep track of LO for you. 

-- 
*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at 
_www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/
_View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/
*~~*


-- For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] starting Base - works for me

2012-07-27 Thread Heinrich Stoellinger

Thanks, Don,
There WAS a problem with the installation of the desktop-integration debs.
I use Maya-KDE, by the way. I have removed libreoffice completely - as you
suggest in your post and after installing the downloaded packages using
dpkg - *deb everything works beautifully.
Thanks again
H.S.
P.S.: As usual - it's not necessary to know everything (!?) but it's good
to know somebody who knows or knows somebody who ...

On Fri, 27 Jul 2012 18:26:23 +0200, Don C. Myers donmy...@myersfarm.com wrote:


Hi,

As I understand it, Mint uses the Ubuntu software center. The default LO
install in Ubuntu does not include base. If the user wishes to have base
installed, you would add that to the Ubuntu installation from the
software center. If I install from a direct LO download from LO, I have
all of the programs listed below in webmaster-Kracked_P_P's post. In
Unity, there is a launcher bar on the left side of the screen. The top
button on the launcher bar is called dash, which has multiple uses. One
use is to show the installed applications. When I do an upgrade, I
completely remove the old install using the terminal, and then do the
new install in the terminal. I use the following commands (This is for
the 64 bit 3.5.5.3 from LO):

Download LibO_3.5.5_Linux_x86-64_install-deb_en-US.tar.gz to the desktop.
Right click on it and extract it to the desktop. This will give you the
folder LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US
Run the following terminal commands to install it:
1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i
~/Desktop/LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US/DEBS/*.deb
3. sudo dpkg -i
~/Desktop/LibO_3.5.5rc3_Linux_x86-64_install-deb_en-US/DEBS/desktop-integration/libreoffice3.5-debian-menus_3.5.5-3_all.deb

After this install, all of the applications below will show up in Dash.
To add them to the Launcher bar, simply drag the icons for the ones you
want to the launcher bar and place them where you wish to have them.
I've never had any issue with opening any of the applications.

I read several days ago that Unity is now available for Fedora and for
Mint for those who would like to have it.

Don


On 07/27/2012 10:41 AM, webmaster-Kracked_P_P wrote:


OK
I just installed the non-repository version of 3.5.5 as an upgrade
to 3.5.4 on my Ubuntu 12.04/MATE laptop.

I still have Base listed, and working, in my Applications/Office menu
listing.

It shows:

LibreOffice 3.5
LibreOffice 3.5 Base
LibreOffice 3.5 Calc
LibreOffice 3.5 Draw
LibreOffice 3.5 Impress
LibreOffice 3.5 Printer Administration
LibreOffice 3.5 Writer

in that order.

SO
it could be the Repository version of LO and its desktop-integration
package, of it could be Unity's menu system.

As I said, I use MATE for Ubuntu 12.04 and I see Base in the menu.

I use MATE so I have the best looking GNOME desktop that looks and
acts like the GNOME desktop that I use for my desktop's 10.04/GNOME
system.  I use the 10.04 system as my default system and wanted any of
my other Ubuntu systems run either 10.04 or 12.04/MATE so it
looks/works like I want it to do.

On 07/27/2012 10:23 AM, webmaster-Kracked_P_P wrote:


I have not loaded 3.5.5, but I have 3.5.4 on my Ubuntu 12.04 laptop
with MATE as its desktop environment and it does show Base in the
applications/office menu.

Also, I installed LibreOffice from the download site and not the
repository.

I was planning on installing 3.5.5 on the laptops [Ubuntu, XP, and
Vista] but I did not have the time.

Actually we had a tornado pass by yesterday about 1 mile north of me
and almost hit one of our two hospitals.  They are stopping people
from entering our city, unless you live or work here - and can prove it.

I will install 3.5.5 on my laptop in a few minutes and see what
happens with Base.


On 07/27/2012 10:00 AM, Don C. Myers wrote:

Hi,

I run Ubuntu 12.04 with Unity. Did you download LO 3.3.5 from
LibreOffice, or are you using the Ubuntu repository version. In
Ubuntu, the default install from Ubuntu for LibreOffice does not
include Base. It can be added separately through the software
center. Be careful also not to mix the two versions, the one from
the repository and the one from LibreOffice directly.

Don


On 07/27/2012 09:43 AM, Heinrich Stoellinger wrote:

Hello,
I have just installed libreoffice 3.5.5 on my lately upgraded Mint
system (Maya). When I now start LO the entry for base doesn't appear.
On the other hand, writer, impress, calc, etc. DOES appear. Any idea
what might be the cause?
Thanks
H. Stoellinger














--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+h...@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 

Re: [libreoffice-users] starting Base - works for me

2012-07-27 Thread Don C. Myers

Hi Jay,

Thank you.

Don

On 07/27/2012 03:31 PM, Jay Lozier wrote:

On 07/27/2012 02:01 PM, Don C. Myers wrote:

Hi Jay,

Thanks for that information. I was aware of that. I have two concerns 
with using it. First, it may update me when I don't want to be 
updated, like from 3.5.x to an early 3.6.x. I generally don't go to a 
new LibreOffice series until the second beta has been finished, so 
for the 3.6 series, it would be 3.6.2. The other concern is in the 
past I had issues with OpenOffice releases in the Ubuntu 
repositories, and just seemed to have better luck with the ones 
directly from OpenOffice/LibreOffice.
The launchpad page for the ppa indicates that it is an unofficial 
repository.


To turn off automatic updating in Synaptic go to SettingsRepositories 
and select Other Software tab. Then scroll until you find the ppa 
and unselect it. The Update Manager will ignore the ppa until it is 
reactivated.


Any thoughts or comments about my thoughts would be appreciated. I'm 
assuming the ppa you are speaking of is in the Ubuntu repositories 
and it is the Ubuntu version.


Don


On 07/27/2012 01:48 PM, Jay Lozier wrote:

An alternative is to install the ppa libreoffice/ppa using:

sudo add-apt-repository ppa: libreoffice/ppa
sudo apt-get update
sudo apt-get install libreoffice

This ppa is updated within a couple of days of a release of a new 
version of LO. Thus your update manager will keep track of LO for you. 







--

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at 
_www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/

_View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/
*~~*


--
For unsubscribe instructions e-mail to: users+h...@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



[Solved] Re: [libreoffice-users] Re: Date format macro.

2012-07-27 Thread rhubarbpieguy

On 07/27/12 05:14, Andreas Säger wrote:

Am 19.07.2012 23:48, rhubarbpie...@gmail.com wrote:


I'd like to create a macro for a user-defined date format (H:MMa/p).  As
examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p. I can
create the format manually, but I understand the LibreOffice format
can't save user-defined formats.  So my thought is to create a macro
which creates the format each time the spreadsheet is opened. The
user-defined Format Code is for a saved Style.

The macro records without incident and the date format is correct.
However, running the saved macro doesn't change the format.  It seems
this should work.  Thoughts?  The recorded macro is as follows:



Hello,

The issue is a known one (AOO bug #66842). The office seems to support 
some format codes that have no equivalent expression in the ODF standard.

It has been discussed in a productive manner here:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=53724
http://user.services.openoffice.org/en/forum/viewtopic.php?f=20t=55344

I attached simple Basic macro to a demo document:
http://user.services.openoffice.org/en/forum/download/file.php?id=14598

It links number formats to cell styles so the newly generated number 
formats applies to all the cells where the style is in use.


Hope this helps,
A.S.

I'm uncertain of the proper method of labeling this as solved. But, 
for my purposes it is and as I began the thread, perhaps [Solved] is 
appropriate.




--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] Lost my spreadsheet

2012-07-27 Thread joto2036
Hi Tom, 
Thanks for the reply. I've inserted some answers to your questions as noted 
below.

I do back up my computer about once per week.

Someone mentioned you have to go to Page to access your file. I went to Page 
Preview and that brought the file back in.

I didn't have any problems with LibreOffice before. I used Open Office before.

Luckily, I have been also making a spread sheet for this same file on Excel 
2007, for income tax purposes.

Thanks again.



- Original Message - 
From: Tom Davies tomdavie...@yahoo.co.uk
To: users@global.libreoffice.org
Sent: Friday, July 27, 2012 3:52 PM
Subject: Re: [libreoffice-users] Lost my spreadsheet


 Hi :)
 Do you have any idea which folder you were saving the document in?  My 
 Documents
 
 Have you ever emailed a copy to yourself or to someone else? No. Have you 
 ever tried copying it to another computer? No. Is there a copy on Usb-stick 
 or Cd/Dvd somewhere. Do you print it and if so where do you print it from, 
 your own machine?  Yes. 
 Do you know which operating system you are using? Windows? Mac, something 
 else?  Windows XP Pro, SP3
 
 With a bit of luck  this guide 
 http://wiki.documentfoundation.org/Documentation/UserProfile
 might help you work out where your old User Profile was and a back-ups folder 
 should be in there. Unfortunately the default setting is to not make a 
 back-up but that might have been changed by yourself or someone with any luck.
 
 Regards from
 Tom :)
 
 
 --- On Fri, 27/7/12, joto2036 joto2...@verizon.net wrote:
 
 From: joto2036 joto2...@verizon.net
 Subject:
 [libreoffice-users] Lost my spreadsheet
 To: users@global.libreoffice.org
 Date: Friday, 27 July, 2012, 15:59
 
 
 
 Hi,
 
 I had LibreOffice 3.5.4 installed on my computer. After I downloaded 
 LibreOffice 3.5.5 (before Installation) I couldn’t access my LibreOffice Calc 
 (Which was a spreadsheet for my Medical  Dental Expenses). It was just a 
 blank spreadsheet.
 
 I then Uninstalled LibreOffice 3.5.4  then Installed LibreOffice 3.5.5 but 
 again I couldn’t access my LibreOffice Calc spreadsheet of my Medical  
 Dental expenses for 2012.
 
 Any ideas what happened to my spreadsheet?
 
 -- 
 For unsubscribe instructions e-mail to: users+h...@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
 
 
 -- 
 For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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


Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc (watermark, embedded image, format etc)

2012-07-27 Thread anne-ology
   This is possible - when I want to view a document from another
source in LO [and worked previously in OO],
   I merely 'select all' then 'copy' then 'paste' ... many times,
the placement is off, but this can be fixed with a little time  effort.



On Fri, Jul 27, 2012 at 2:28 AM, Miriyala, Vasu vasu.miriy...@capgemini.com
 wrote:

Hi Forum,


 Appreciate your pointers or help on how to open the MS office word files
 in writer while retaining the format of original intact. Currently Libre
 when opening MSOffice-word2007 docs loses water mark, embedded image,
 images inserted thru insert features of word 2007 etc

 Thanks, Vasu



-- 
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc (watermark, embedded image, format etc)

2012-07-27 Thread anne-ology
   yes;

   I've found a simple way to sometimes 'find' these hidden images is
to minimize the window file ...
  then when you 're-open' it, these images appear;

   I think this is one of the mysteries of the electronic age -
  if anyone has a reason for this phenomenon, I'm listening as long
as it's in layman's terms  ;-)



On Fri, Jul 27, 2012 at 8:02 AM, Tom Davies tomdavie...@yahoo.co.uk wrote:

Hi :)
 I've often found that even tho images appear to have vanished they are
 still really there somewhere.  That gives at least 2 opportunities;
 1.  Edit and save without trying to find the images and then see if the
 images apparently re-appear in the right places when the edited file is
 opened back in MS Office 2007/2010
 2.  Hunt around the edges of the pages and move any images you do find
 anywhere to see if the other images have been hidden underneath as they
 tend to get piled-up on-top of each other.

 Regards from
 Tom :)




 From: Jay Lozier jsloz...@gmail.com
 Subject: Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc
 (watermark, embedded image, format etc)
 To: users@global.libreoffice.org
 Date: Friday, 27 July, 2012, 13:50

 On 07/27/2012 03:28 AM, Miriyala, Vasu wrote:
  Hi Forum,
 
  Appreciate your pointers or help on how to open the MS office word files
 in writer while retaining the format of original intact. Currently Libre
 when opening MSOffice-word2007 docs loses water mark, embedded image,
 images inserted thru insert features of word 2007 etc
 
  Thanks, Vasu
 
 
 
 I generally have success accurately opening docx format files.
 Occasionally I get one that I have to open MSO and convert to doc (2003)
 or ODF 1.0/1.1. Usually it is some graphic layout that causes the
 problem. This is known issue with LO and AOO.

 docx file conversions are occasionally difficult because MS is trying to
 push their proprietary MS Office and makes open the file accurately
 problematic.

 If you are using Linux, you might try Calligra Words (probably available
 in your repository) to see if it is better at opening the file and
 saving to odt.

 --
 Jay Lozier
 jsloz...@gmail.com


-- 
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc (watermark, embedded image, format etc)

2012-07-27 Thread Andrew Brager
Sounds like whatever is displaying the image isn't being initialized 
properly for whatever reason. Reopening it allows that function to 
execute with the proper parameters.  To sit on the page in the proper 
place the coordinates of the image would have to be known and set 
properly. If the images are stacking then they're all getting the same 
set of coordinates.  The trick is to figure out why.


For the laymen... the best analogy I can think of is to picture an 
assembly line, with a conveyor belt.  Empty bottles sit on the conveyor 
belt.  When you start the conveyor belt and the associated machinery 
that fills the bottles with some liquid, the bottles are not aligned 
properly so when the filling nozzle starts pouring liquid it misses the 
bottle opening by just enough that it sprays onto the belt and spills 
over onto the floor. By restarting the machinery at the exact moment 
that the bottles are properly aligned it fixes the problem.


Kind of a lame analogy but like I say, the best I can think of at the 
moment.


On 7/27/2012 4:58 PM, anne-ology wrote:

yes;

I've found a simple way to sometimes 'find' these hidden images is
to minimize the window file ...
   then when you 're-open' it, these images appear;

I think this is one of the mysteries of the electronic age -
   if anyone has a reason for this phenomenon, I'm listening as long
as it's in layman's terms  ;-)



On Fri, Jul 27, 2012 at 8:02 AM, Tom Davies tomdavie...@yahoo.co.uk wrote:

Hi :)

I've often found that even tho images appear to have vanished they are
still really there somewhere.  That gives at least 2 opportunities;
1.  Edit and save without trying to find the images and then see if the
images apparently re-appear in the right places when the edited file is
opened back in MS Office 2007/2010
2.  Hunt around the edges of the pages and move any images you do find
anywhere to see if the other images have been hidden underneath as they
tend to get piled-up on-top of each other.

Regards from
Tom :)




From: Jay Lozier jsloz...@gmail.com
Subject: Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc
(watermark, embedded image, format etc)
To: users@global.libreoffice.org
Date: Friday, 27 July, 2012, 13:50

On 07/27/2012 03:28 AM, Miriyala, Vasu wrote:

Hi Forum,

Appreciate your pointers or help on how to open the MS office word files

in writer while retaining the format of original intact. Currently Libre
when opening MSOffice-word2007 docs loses water mark, embedded image,
images inserted thru insert features of word 2007 etc

Thanks, Vasu




I generally have success accurately opening docx format files.
Occasionally I get one that I have to open MSO and convert to doc (2003)
or ODF 1.0/1.1. Usually it is some graphic layout that causes the
problem. This is known issue with LO and AOO.

docx file conversions are occasionally difficult because MS is trying to
push their proprietary MS Office and makes open the file accurately
problematic.

If you are using Linux, you might try Calligra Words (probably available
in your repository) to see if it is better at opening the file and
saving to odt.

--
Jay Lozier
jsloz...@gmail.com




--


--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc (watermark, embedded image, format etc)

2012-07-27 Thread anne-ology
   Thanks; that makes sense.

   Wow, with the help of this list, I might make it from the
middle-ground to the nerd status anon  ;-)



On Fri, Jul 27, 2012 at 9:02 PM, Andrew Brager apb3...@bak.rr.com wrote:

Sounds like whatever is displaying the image isn't being initialized
 properly for whatever reason. Reopening it allows that function to
 execute with the proper parameters.  To sit on the page in the proper place
 the coordinates of the image would have to be known and set properly. If
 the images are stacking then they're all getting the same set of
 coordinates.  The trick is to figure out why.

 For the laymen... the best analogy I can think of is to picture an
 assembly line, with a conveyor belt.  Empty bottles sit on the conveyor
 belt.  When you start the conveyor belt and the associated machinery that
 fills the bottles with some liquid, the bottles are not aligned properly so
 when the filling nozzle starts pouring liquid it misses the bottle opening
 by just enough that it sprays onto the belt and spills over onto the floor.
 By restarting the machinery at the exact moment that the bottles are
 properly aligned it fixes the problem.

 Kind of a lame analogy but like I say, the best I can think of at the
 moment.


 On 7/27/2012 4:58 PM, anne-ology wrote:

 yes;

 I've found a simple way to sometimes 'find' these hidden images is
 to minimize the window file ...
then when you 're-open' it, these images appear;

 I think this is one of the mysteries of the electronic age -
if anyone has a reason for this phenomenon, I'm listening as
 long
 as it's in layman's terms  ;-)



 On Fri, Jul 27, 2012 at 8:02 AM, Tom Davies tomdavie...@yahoo.co.uk
 wrote:

 Hi :)

 I've often found that even tho images appear to have vanished they are
 still really there somewhere.  That gives at least 2 opportunities;
 1.  Edit and save without trying to find the images and then see if the
 images apparently re-appear in the right places when the edited file is
 opened back in MS Office 2007/2010
 2.  Hunt around the edges of the pages and move any images you do find
 anywhere to see if the other images have been hidden underneath as they
 tend to get piled-up on-top of each other.

 Regards from
 Tom :)




 From: Jay Lozier jsloz...@gmail.com
 Subject: Re: [libreoffice-users] Writer loses format of MSOffice2007-Doc
 (watermark, embedded image, format etc)
 To: users@global.libreoffice.org
 Date: Friday, 27 July, 2012, 13:50

 On 07/27/2012 03:28 AM, Miriyala, Vasu wrote:

 Hi Forum,

 Appreciate your pointers or help on how to open the MS office word files

 in writer while retaining the format of original intact. Currently Libre
 when opening MSOffice-word2007 docs loses water mark, embedded image,
 images inserted thru insert features of word 2007 etc

 Thanks, Vasu



  I generally have success accurately opening docx format files.
 Occasionally I get one that I have to open MSO and convert to doc (2003)
 or ODF 1.0/1.1. Usually it is some graphic layout that causes the
 problem. This is known issue with LO and AOO.

 docx file conversions are occasionally difficult because MS is trying to
 push their proprietary MS Office and makes open the file accurately
 problematic.

 If you are using Linux, you might try Calligra Words (probably available
 in your repository) to see if it is better at opening the file and
 saving to odt.

 --
 Jay Lozier
 jsloz...@gmail.com



-- 
For unsubscribe instructions e-mail to: users+h...@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