Re: [libreoffice-users] Numbered List Help

2013-08-22 Thread ZP

On 08/22/2013 09:03 AM, Tom Davies wrote:
Oddly enough we recently had a thread about ePub and generally found 
it quite difficult so you might be able to help other people straight 
away!  I think we did manage to find out 1 way of doing it using eLaix 
or something.


I saw that thread...long and intimidating! lol.

Personally, I keep it very simple:  I copy the document (cut  paste or 
type) into LO Writer.  I only use the following paragraph styles 
'Default' or 'Text Body' and Heading 1, 2, 3 for chapter headings.  
Occasionally, I'll use a quotation style as required. All edits are done 
in a fixed-width font for readability and editing (I prefer Courier Prime).


Footnotes are always end of chapter if I use sections and a master 
document, or end of document (which is easier to manage, IMO, since I 
don't have to mess with a master document.  Some long and complex books 
with lots of footnotes get the master document treatment, with each 
chapter having its own section.


When finished with the input and review, I change Default Paragraph, 
Text Body, and Heading fonts to 'Times New Roman'.  I don't use the 
writer to epub plugin...since I've had bad luck with it.  Instead, I use 
Calibre to convert from .odt to .epub.  The good thing about Calibre, is 
I can keep the .odt file IN the calibre library for edits later on (if I 
find an error, etc), and just convert it to epub again as required.  
Very simple.


--
To unsubscribe e-mail to: users+unsubscr...@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] the password of Libreoffice

2013-09-12 Thread ZP


Well, here's a shot in the dark.  The .odt fileis simply a container 
(like a .zipfile).  Use a program like 7-zip (confirmed to work) and 
extract the content.xml file.  It won't be clean, but you may be able to:


1) copy the content.xml into a new.odt file without password 
protection, or...
2) just open the content.xml file directly in LO.  You'll have a lot 
of xml data in there...so its quite messy.


|ZP|



Disregard my last message.  You can open the .odt file in 7-zip, or 
Gnome Archive Manager, or whatever...unfortunately, the content.xml is 
scrambled after password protection.  My apologies for the misdirection.


|ZP|

--
To unsubscribe e-mail to: users+unsubscr...@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] the password of Libreoffice

2013-09-12 Thread ZP

On 09/11/2013 01:09 AM, tangchao...@gmail.com wrote:

Dear All ,

I Forger My password of the Libreoffice file .
Who can tell me how to deal with it ?

Thanks ... ...
Well, here's a shot in the dark.  The .odt fileis simply a container 
(like a .zipfile).  Use a program like 7-zip (confirmed to work) and 
extract the content.xml file.  It won't be clean, but you may be able to:


1) copy the content.xml into a new.odt file without password protection, 
or...
2) just open the content.xml file directly in LO.  You'll have a lot of 
xml data in there...so its quite messy.


|ZP|

--
To unsubscribe e-mail to: users+unsubscr...@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] the password of Libreoffice

2013-09-15 Thread ZP

On 09/15/2013 03:06 PM, Kracked_P_P---webmaster wrote:

Yes, that works, unless you system does a crash/burn and for some reason
you cannot get all of your files and data off your backups.  Oooops,
sorry you forgot to backup that file somehow.


This is diverging slightly off the original topic, but I felt compelled 
to respond.  Depending upon your security concerns, a variety of tools 
will allow you to sync and backup password databases to a variety of 
systems (windows, linux, mac, android, etc.). Here are just a few:


Secure Password Tools:

1. Keepass.  I can't live without it.  Store windows registration codes, 
software registration codes (Adobe, etc), passwords, anything you can 
think of.  Linux (KeepassX, Keepass 2.0), Windows (Keepass 1.0, Keepass 
2.0), Android and iPhone/iPad software available. Generate crazy long 
passwords if you must.


2. TrueCrypt.  Set up a truecrypt container (file folder) and put your 
file passwords in a plain text document.  Put the truecrypt container on 
a USB key and carry it around with you.  Inefficient, but doable.


3. Lastpass.  See below.

Sync Tools:

1. Dropbox. I use Dropbox to maintain specific Keepass databases synced 
on all computers, tablets, phones.  You can argue the security concerns, 
but the convenience outweighs them.  Use your database wisely, set up 
multiple authentication rules, and use it for non-critical password 
items if you must. You can use multiple databases as you wish...for 
example, non-critical passwords in a specific Keypass database synced on 
Dropbox called 'LibreOffice Files'.


2. Lastpass. Very convenient, and I just started using it.  Its strength 
mostly lies in web passwords, but you can add anything you want, to 
include LO document passwords, readily accessible online. I DO NOT use 
it for critical, personal information.


3. BitTorrent Sync.  Personally, my new fave.  It allows syncing of any 
folder across your network.  No communication outside your LAN, unless 
you specifically set it up.  Use Keypass, Truecrypt, whatever.  More of 
a syncing tool, but you can set up rules to act like a backup system to 
a specific computer/drive.  Much easier to use than any Windows/Linux 
backup solution tbh.


Old school paper files are effective, until your house burns down...so 
the argument works both ways.  Personally, given the proliferation of 
tools/devices we use, I need password capability across all devices.  
All of my passwords are Keepass generated (25+ characters and symbols) 
and writing them all down is simply not an option. Plus I set reminders 
to change passwords every month or so, within Keypass.


Give them a try, I think you'll find the tools listed above are useful 
and productive...just take extra care protecting where and how you store 
these files, that's all.


--
To unsubscribe e-mail to: users+unsubscr...@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] Can't get leading zeros in Calc

2014-05-31 Thread ZP
On Sun, 01 Jun 2014 01:11:36 +0100
Brian Barker b.m.bar...@btinternet.com wrote:

 At 17:34 31/05/2014 -0600, Oogie McGuire wrote:
 I'm tearing my hair out here.
 
 Don't!
 
 I have a spreadsheet and the data was originally entered as 4 
 digits. I need to pass it to a database system that requires 6 
 digits. I've tried formatting with 2 leading zeros but I still 
 cannot get the number to properly show up as 00number. Any ideas?
 
 Yes. If the values you have are numbers, then formatting them (as 
 something like 00) should display them as you need. Whether you 
 get six digits into your database depends on exactly how you then 
 transfer the values.
 
 But you say this doesn't work. The most likely explanation is that 
 the values stored in the cells are not numbers but text strings - 
 albeit made up of four numeric characters. Changing the formatting of 
 such cells after the event will not change text values into numbers. 
 (You generally wouldn't want it to.)
 
 How to proceed? Take your pick:
 
 o In a new column, enter =VALUE(Xn) and fill it down the column. You 
 will now have numbers and can format them as you wish. You could even 
 copy them back over the original values, using Paste Special... and 
 pasting Numbers but not Formulas.
 
 o In a new column, enter =00Xn and fill it down the column. You 
 will now have six-character text values. Again, you could copy these 
 back over the original values, using Paste Special... and pasting 
 Text but not Formulas.
 
 I trust this helps.
 
 Brian Barker
 
 

Just change the properties to 'Text'.  It'll preserve the format and
you can still do math functions using the cell.

-- 
To unsubscribe e-mail to: users+unsubscr...@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