Re: [libreoffice-users] Calc - conditional cell formatting - recently modified?

2014-03-31 Thread Tanstaafl

On 3/26/2014 9:07 AM, Tanstaafl tansta...@libertytrek.org wrote:

Hello all,

I'd like to be able to apply a background color to some cells based on
whether or not they were modified within the last x days...

Anyone know if this is possible? I have a feeling not, but you never
know...


Guess not... probably not worth the trouble of adding a feature request 
either...


--
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] Modifying Styles

2014-03-31 Thread anne-ology
   Dale, your copy of LO may be defective  ;-)



From: Dale Erwin dale.er...@casaerwin.org
Date: Sun, Mar 30, 2014 at 11:55 AM
Subject: [libreoffice-users] Modifying Styles
To: LibreOffice Users users@global.libreoffice.org


I was beginning to think I was going crazy.  I tried to modify 2 page
styles in three different documents so that I could copy from one to the
other without destroying the format.  After several attempts, I was still
getting a different format when I copied from one file to another.  It
turns out that if you don't save the document, the changes to the style are
also not saved.

The odd part of this is that it is possible to close the file with no
prompt for saving changes.  Now if I make a change to the text of a
document, then try to close the file, I will get a prompt to either save or
discard my changes, but I got no such prompt after changing styles with no
change to the text.  Even more odd is that the save option is greyed out
(inactive) unless a change has been made and it is not greyed out after
changing a style even without changing text.

Dale Erwin

-- 
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] Modifying Styles

2014-03-31 Thread Tom Davies
Hi :)
I'm not sure if that is defective behaviour.  There was no real change
to the document itself so to my way of thinking i wouldn't want the
changes to be fixed.  The save button is greyed out quite legitimately
imo.

Also if i make changes to a document and realise i didn't want to fix
those changes into the document then i also wouldn't save, in much the
same way.  Whenever i do want to save changes i save the document, or
as a template.

Regards from
Tom :)

On 31 March 2014 15:14, anne-ology lagin...@gmail.com wrote:
Dale, your copy of LO may be defective  ;-)



 From: Dale Erwin dale.er...@casaerwin.org
 Date: Sun, Mar 30, 2014 at 11:55 AM
 Subject: [libreoffice-users] Modifying Styles
 To: LibreOffice Users users@global.libreoffice.org


 I was beginning to think I was going crazy.  I tried to modify 2 page
 styles in three different documents so that I could copy from one to the
 other without destroying the format.  After several attempts, I was still
 getting a different format when I copied from one file to another.  It
 turns out that if you don't save the document, the changes to the style are
 also not saved.

 The odd part of this is that it is possible to close the file with no
 prompt for saving changes.  Now if I make a change to the text of a
 document, then try to close the file, I will get a prompt to either save or
 discard my changes, but I got no such prompt after changing styles with no
 change to the text.  Even more odd is that the save option is greyed out
 (inactive) unless a change has been made and it is not greyed out after
 changing a style even without changing text.

 Dale Erwin

 --
 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


-- 
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] Multiple columns in Writer

2014-03-31 Thread Dave Liesse
And, for those of us who find using menus to be a major inconvenience 
compared to keyboard shortcuts, The Insert ... Manual Break ... Type ... 
Column Break can be accomplished with Ctrl-Shift-Enter.


Nothing to add to the rest of the comments!

Dave



On 3/30/2014 22:10, Brian Barker wrote:

At 21:27 30/03/2014 -0700, Andrew Noname wrote:
I would like to divide my page into two independently controlled 
columns.  Creating columns is easy enough to do.  However, I want the 
text in each column to start at the top of each column.  Think of two 
lists that are independent of each other, column 2 is NOT simply a 
continuation of column 1.  [...]


I know that I can hit enter 30 times or so in the first column in 
order to start the text at the top of the second column, but I was 
hoping there was a smarter way, ...


You can get to the top of a new column very simply and neatly by going 
to Insert | Manual Break... | Type | Column break.  But that still 
doesn't really serve your purpose, since although you talk of a single 
page, your text might eventually want to expand to multiple pages.  In 
that case, text from the left column would flow into the right column 
on the first page, not the left column on the second; text from the 
right column on the first page to the left column, not the right 
column, of the second.  These are called newspaper columns.



Simple in concept... not so simple to make happen in Writer.


Actually, it is very simple.  Go to Table | Insert  | Table... and 
create a table with two columns and (probably) one row.  You will find 
that the table cells expand as necessary to accommodate your text - 
even to additional pages - and that the two columns will remain 
independent.


I trust this helps.

Brian Barker





--
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



[libreoffice-users] What's the best way to convert a .pdf form to .odt

2014-03-31 Thread paulwhitehurst
I have a .pdf form I would like to use as a mail merge form.  I see there's
no way to do merge in Draw.I opened the .pdf in Draw and cut and pasted
from the .pdf to a new .odt document.  This only put images in the new
document that I couldn't edit.   I opened the .pdf in Reader and did the
same.   It copied all the text, but the formatting was poor.  Is there a
better way to do this so I don't have to retype the whole thing?

Thanks,

Paul Whitehurst
whan...@aol.com



--
View this message in context: 
http://nabble.documentfoundation.org/What-s-the-best-way-to-convert-a-pdf-form-to-odt-tp4103644.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] What's the best way to convert a .pdf form to .odt

2014-03-31 Thread Marc Grober
export to docx format from Acrobat Pro and then convert from docx to odt

On 3/31/14, 10:29 AM, paulwhitehurst wrote:
 I have a .pdf form I would like to use as a mail merge form.  I see there's
 no way to do merge in Draw.I opened the .pdf in Draw and cut and pasted
 from the .pdf to a new .odt document.  This only put images in the new
 document that I couldn't edit.   I opened the .pdf in Reader and did the
 same.   It copied all the text, but the formatting was poor.  Is there a
 better way to do this so I don't have to retype the whole thing?

 Thanks,

 Paul Whitehurst
 whan...@aol.com



 --
 View this message in context: 
 http://nabble.documentfoundation.org/What-s-the-best-way-to-convert-a-pdf-form-to-odt-tp4103644.html
 Sent from the Users mailing list archive at Nabble.com.




-- 
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] What's the best way to convert a .pdf form to .odt

2014-03-31 Thread Tom Davies
Hi :)
Surely just copypaste special as unformatted text.  Then apply
styles.  Avoid trying to be too close to the original if that is
possible.

It's good if you can create an excuse so that people see your new form
as an improvement over the old one.  Easy ones for LIbreOffice is that
the new form is more internally consistent, ie doesn't change fonts or
sizes so much.  Maybe make it all 11point font-size to increase
readability (shouldn't that be more legible?).
Regards from
Tom :)






On 31 March 2014 19:56, Marc Grober m...@interak.com wrote:
 export to docx format from Acrobat Pro and then convert from docx to odt

 On 3/31/14, 10:29 AM, paulwhitehurst wrote:
 I have a .pdf form I would like to use as a mail merge form.  I see there's
 no way to do merge in Draw.I opened the .pdf in Draw and cut and pasted
 from the .pdf to a new .odt document.  This only put images in the new
 document that I couldn't edit.   I opened the .pdf in Reader and did the
 same.   It copied all the text, but the formatting was poor.  Is there a
 better way to do this so I don't have to retype the whole thing?

 Thanks,

 Paul Whitehurst
 whan...@aol.com



 --
 View this message in context: 
 http://nabble.documentfoundation.org/What-s-the-best-way-to-convert-a-pdf-form-to-odt-tp4103644.html
 Sent from the Users mailing list archive at Nabble.com.




 --
 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


-- 
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] CALC: repeat first line to each page

2014-03-31 Thread Tim Deaton

On 3/28/2014 5:11 AM, Rafnews wrote:

Hi,

i would like to know if there is an option like under MS Excel, to 
repeat first line or 2 first lines of the document on each printing 
page (or PDF page) ?


thx.

A.

If you're used to Excel (like I am), this does not seem very intuitive, 
but here's how to do it in LO 4.x:


From the menu, choose Format, then Print Ranges, then Edit. On 
the Rows to repeat line, define which rows you want printed on every 
page, such as $2:$4 (without the quote marks).  As shown in my 
example, the repeating rows don't HAVE TO be the first rows in the 
spreadsheet.  You can set up repeating columns as well, if you wish.  
You do NOT have to set up a Print Range if you don't want to.


Hope this helps,

-- Tim
===



--
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