Re: [libreoffice-users] State of password support.

[Massimo Del Zotto]

Yes Eric, those problems are surely related as crashes are involved in my
case as well (and I "fixed" it in the same way).
The implication is that temporary saves are not encrypted. Given the modest
size of **usual** files this could probably be done with little performance
loss but after all, this behavior is acceptable in my opinion. Should a
user need more protection, (s)he should likely consider full file-system
crypto.

Massimo


2013/12/18 Eric Beversluis 

> I don't know if this is relevant to Massimo's case but it might be:
> I had a problem a while back with Fedora 15 (and I don't remember which
> version of OO or LO): I would discover that I could open a
> password-protected spreadsheet without being prompted for the password.
> It turned out that it had something to do with Fed 15 shutting down w/o
> prompting to save an open and changed spreadsheet. When restarted, the
> spreadsheet would open without password protection. The workaround
> seemed to be to do a 'save as' at that point and check 'save with
> password'.
>
> More recently this hasn't seemed to be a problem, but I think it has
> happened once or twice, though I didn't bother to try to figure out why.
>
> On Wed, 2013-12-18 at 09:24 -0500, Andrew Douglas Pitonyak wrote:
> > On 12/17/2013 10:12 AM, Massimo Del Zotto wrote:
> > > However, I recently had a problem with OOo password protection.
> Somehow it
> > > disabled password protection for a file I was working on and it took
> me a
> > > while to restore it. Asking for help on OOo forum, I have been informed
> > > password protection is somehow considered "unnecessary" by... I don't
> know
> > > who to be honest.
> >
> > You mean recently?As in the latest version of LO has a problem with
> > passwords?
> >
> > > The forum administrator strongly
> > > suggested me to not use it, and even pointed out a few previous cases
> in
> > > which password protection caused data loss (!!!).
> > Which forum, do you have a link to the post?
> >
> > > I think *this is unacceptable *so I started looking more seriously at
> LO.
> > > Digging the mailing list archives, I noticed there are quite a few
> messages
> > > regarding password protection. It seems most problem were between
> keyboard
> > > and chair, the only exception being perhaps an inter-operability
> problem
> > > after switching to AES-256.
> > >
> > > In your experience, how is LO with password protection?
> > Massimo, you seem to be more informed of this than I, but, I am only
> > aware of one (what I consider) real bug that existed with LO and
> > passwords. At one point, I was no longer able to open a password
> > protected file. Specifically, one version of LO was not able to open a
> > password protected file.  I am pretty sure it was LO and not AOO anyway.
> >
> > I believe that I have seen things such as:
> >
> > 1. I forgot my password, how I open my document
> > 2. I am not able to open a password protected document created by MS
> Office
> > 3. Problems signing a document
> >
> > I don't ever remember anyone saying that password protection should be
> > dropped. Does not mean that it has not been said. I have seen people
> > pushing to drop the ability to write non-ODF format, but I don't
> > remember anyone advocating no support for passwords.
> >
> > I have also seen reports of another bug that sometimes causes total data
> > loss of a file, but, since it is not reproducible in any sort of
> > meaningful way, the bug has not been researched.
> >
> > --
> > Andrew Pitonyak
> > My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
> > Info:  http://www.pitonyak.org/oo.php
> >
> >
>
>
>
> --
> 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] State of password support.

[Massimo Del Zotto]

2013/12/18 Andrew Douglas Pitonyak 
>
> You mean recently?As in the latest version of LO has a problem with
> passwords?

 No, I am referring to OOo. I am considering to switch to LO because of
this problem and I'm trying to figure out if this problem is considered
more important by LO developers.

2013/12/18 Andrew Douglas Pitonyak 

> Which forum, do you have a link to the post?
>
This was in the OOo forum,
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=65690.
I'm not well aware how the forum admins interact with the OOo developer
base, it looks to me they don't. I'd say this is another problem in itself
but luckly, I'm not really interested in that one.


> Massimo, you seem to be more informed of this than I, but, I am only aware
> of one (what I consider) real bug that existed with LO and passwords. At
> one point, I was no longer able to open a password protected file.
> Specifically, one version of LO was not able to open a password protected
> file.  I am pretty sure it was LO and not AOO anyway.

[...omissis...]
>
Thank you very much Andrew, this is very informative. I'm currently
inclined to switch to LO.

Massimo

-- 
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] Re: Label creation Q

[Brian Barker]

At 13:12 19/12/2013 +1000, Peter West wrote:

Too cranky, Brian.


Not cranky at all.


Mr Sowden thought "table" referred to a database table.


And hopefully he now knows what people have been talking about.  I'm 
happy to have been the one to help him.


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

Re: [libreoffice-users] multiple file import

[Tom Davies]

Hi :)
I've not tried this either but in a similar case i often find it's
more efficient to drag the last one in first and then it's easier to
drag in  earlier and earlier ones into the same place each time
without having to scroll through
Regards from
Tom :)

On 18 December 2013 20:32, Brian Barker  wrote:
> At 19:13 18/12/2013 +, Nobody Noname wrote:
>>
>> Is there a way to import multiple files into a new document? The existing
>> function only allows multiples files to be imported successively, which is
>> inefficient. If a directory contains
>> file1
>> file2
>> file3
>> it would be beneficial to be able to select all files in the import
>> dialogue window for automatic successive import into the new document.
>
>
> One obvious problem would be the necessity to indicate the order in which
> multiple files should be incorporated.  It would be easy if you had files
> with carefully organised names, but in general you wouldn't have that.  In
> any case, would file10 become positioned after file9 or between file1 and
> file2?  Would that apply in all operating systems?
>
> If you needed either to list the files in the order in which you wanted them
> incorporated, or else to readjust everything after assembly, you would be
> better off (and achieve a more reliable result) by simply importing one at a
> time.
>
> 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
>

-- 
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] Bonus calculator in Calc

[Tom Davies]

Hi :)
Why not use Base to read the 2 existing sheets?  Then let it do the
bit it does best?
Regards from
Tom :)

On 18 December 2013 23:46, John Meyer  wrote:
> I know it's a relational database.  ;-) Is there any way to design this to
> work on a spreadsheet?
>
>
> On 12/18/2013 4:40 PM, Tom Davies wrote:
>>
>> Hi :)
>> That is very much like a relational database.  The 1st sheet is the
>> main table.  The 2nd sheet would be a separate table but would be
>> linked by a relationship between both column As.  The 3rd sheet would
>> actually not be a table as such, it would be a Query that takes data
>> from the 2 tables and performs calculations on them.  Hmm, it could be
>> a Form or Report but if i was doing it (and note that  i'm not) then i
>> tend to prefer using a Query for as much of this sort of thing as
>> possible because it makes it easier to adjust the formulae in the
>> future
>> Regards from
>> Tom :)
>>
>> On 18 December 2013 20:22, John Meyer 
>> wrote:
>>>
>>> A while back I posted up about calculating bonuses based upon a lookup.
>>> now, I need to add an additional step.  Every once in a while, agents get
>>> additional bonuses for sales outside of the normal commission ladder.
>>> Here's the layout of the main sheet
>>>
>>>
>>> A  B CD   E
>>>  Date1 Date2
>>> Date3  .
>>> agent ID  Agent Name$###   $###  $###
>>>
>>>
>>>
>>>
>>> What I wanted to do was add an "Additional Bonus sheet"  With a layout
>>> like
>>> this
>>>
>>>
>>> A   B C
>>> agentID   DateBonus
>>>
>>>
>>>
>>> Then have a "final bonus screen" with this layout and formula similar to
>>> the
>>> main sheet
>>>
>>>
>>> A   B CDE
>>> Date1 Date2  Date3
>>> agentIDAgent Name$(sales + add bonus total)
>>> ... 
>>>
>>>
>>> Note: the agent can have multiple bonuses for the same date on the
>>> additional bonus sheet.  Where would i start doing something like that?
>>> I
>>> might figure that out while I'm typing that out (which is probably one of
>>> the most useful functions of this list), but right now I'm spinning.
>>>
>>>
>>>
>>>
>>> --
>>> 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] Bonus calculator in Calc

[Tom Davies]

Hi :)
That is very much like a relational database.  The 1st sheet is the
main table.  The 2nd sheet would be a separate table but would be
linked by a relationship between both column As.  The 3rd sheet would
actually not be a table as such, it would be a Query that takes data
from the 2 tables and performs calculations on them.  Hmm, it could be
a Form or Report but if i was doing it (and note that  i'm not) then i
tend to prefer using a Query for as much of this sort of thing as
possible because it makes it easier to adjust the formulae in the
future
Regards from
Tom :)

On 18 December 2013 20:22, John Meyer  wrote:
> A while back I posted up about calculating bonuses based upon a lookup.
> now, I need to add an additional step.  Every once in a while, agents get
> additional bonuses for sales outside of the normal commission ladder.
> Here's the layout of the main sheet
>
>
> A  B CD   E
> Date1 Date2
> Date3  .
> agent ID  Agent Name$###   $###  $###
>
>
>
>
> What I wanted to do was add an "Additional Bonus sheet"  With a layout like
> this
>
>
> A   B C
> agentID   DateBonus
>
>
>
> Then have a "final bonus screen" with this layout and formula similar to the
> main sheet
>
>
> A   B CDE
> Date1 Date2  Date3
> agentIDAgent Name$(sales + add bonus total)
> ... 
>
>
> Note: the agent can have multiple bonuses for the same date on the
> additional bonus sheet.  Where would i start doing something like that?  I
> might figure that out while I'm typing that out (which is probably one of
> the most useful functions of this list), but right now I'm spinning.
>
>
>
>
> --
> 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] Re: Label creation Q

[Peter West]

Too cranky, Brian.

Mr Sowden thought "table" referred to a database table.

Peter West

"For my yoke is easy, and my burden is light."

On 19 Dec 2013, at 1:00 pm, Brian Barker  wrote:

> At 15:10 18/12/2013 -0800, John R. Sowden wrote:
>> I do not know what ya'all mean by 'table' ...
> 
> Have you looked at the help text?  Do you see that menu labelled "Table"?  
> That's all about tables.  Table | Insert > | Table... inserts a table.  Try 
> it and see how it works.
> 
>> So having a command that would take the label that you just created and 
>> populate the other label locations on the sheet seemed to be the next step, 
>> and I could not find the option.
> 
> If you are using a table, see previous advice.  If not, I don't imagine 
> anyone can help you whilst you keep secret exactly what you are doing.
> 
>> Problem: In label design, the text and the drawing are separate objects, ...
> 
> The *drawing*?!  Why did no-one mention drawings in their answers?  Oh, 
> perhaps because you kept them a secret too?
> 
>> ... so selecting the top left label by highlighting the upper left to lower 
>> right the, rt cl copy, put cursor in upper right box, upper right corner, 
>> put the lower half of my original label (drawing only, no text) below the 
>> original and nothing in the upper right box.
> 
> This behaviour appears to depend on how your graphic is anchored.  Try 
> anchoring As Character to achieve what you need easily.
> 
>> It just seems that a "populate other empty labels on this sheet with 
>> original" would make sense.
> 
> With tables, it's probably too simple for there to be a special command.  See 
> previous advice.
> 
> 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
> 


-- 
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] Mail Merge and Labels

[Don Myers]

Hi Brian,

That is a much better solution. Thanks for suggesting it.

Don

On 12/18/2013 10:00 PM, Brian Barker wrote:

At 18:09 18/12/2013 -0500, Don C. Myers wrote:
When you use the table style templates, the wizard does not work. It 
is designed for the frame style. What I do is fill in one label. Then 
if you have a 30 label sheet with 3 columns and 10 rows, I copy and 
paste it to the nest two labels to the right. Then I copy all three 
of those labels on row 1, and paste into the complete second row. 
Then I copy rows 1 and two and paste into rows 3 & 4, 5 & 6, 7 & 8, 
and 9 & 10. It really goes pretty fast that way.


Copy one cell.  Select all cells.  Paste once into all.  (That's 
Ctrl+A, Ctrl+C, Ctrl+A, Ctrl+V.)  Isn't that even faster than "pretty 
fast" - and equally fast no matter how many labels you have?


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

Re: [libreoffice-users] Re: Label creation Q

[Brian Barker]

At 15:10 18/12/2013 -0800, John R. Sowden wrote:

I do not know what ya'all mean by 'table' ...


Have you looked at the help text?  Do you see that menu labelled 
"Table"?  That's all about tables.  Table | Insert > | Table... 
inserts a table.  Try it and see how it works.


So having a command that would take the label that you just created 
and populate the other label locations on the sheet seemed to be the 
next step, and I could not find the option.


If you are using a table, see previous advice.  If not, I don't 
imagine anyone can help you whilst you keep secret exactly what you are doing.



Problem: In label design, the text and the drawing are separate objects, ...


The *drawing*?!  Why did no-one mention drawings in their 
answers?  Oh, perhaps because you kept them a secret too?


... so selecting the top left label by highlighting the upper left 
to lower right the, rt cl copy, put cursor in upper right box, upper 
right corner, put the lower half of my original label (drawing only, 
no text) below the original and nothing in the upper right box.


This behaviour appears to depend on how your graphic is 
anchored.  Try anchoring As Character to achieve what you need easily.


It just seems that a "populate other empty labels on this sheet with 
original" would make sense.


With tables, it's probably too simple for there to be a special 
command.  See previous advice.


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

Re: [libreoffice-users] Mail Merge and Labels

[Brian Barker]

At 18:09 18/12/2013 -0500, Don C. Myers wrote:
When you use the table style templates, the wizard does not work. It 
is designed for the frame style. What I do is fill in one label. 
Then if you have a 30 label sheet with 3 columns and 10 rows, I copy 
and paste it to the nest two labels to the right. Then I copy all 
three of those labels on row 1, and paste into the complete second 
row. Then I copy rows 1 and two and paste into rows 3 & 4, 5 & 6, 7 
& 8, and 9 & 10. It really goes pretty fast that way.


Copy one cell.  Select all cells.  Paste once into all.  (That's 
Ctrl+A, Ctrl+C, Ctrl+A, Ctrl+V.)  Isn't that even faster than "pretty 
fast" - and equally fast no matter how many labels you have?


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

Re: [libreoffice-users] Bonus calculator in Calc

[John Meyer]

Let's assume I can't get IT to install the JRE for database access.


On 12/18/2013 4:48 PM, Tom Davies wrote:

Hi :)
Why not use Base to read the 2 existing sheets?  Then let it do the
bit it does best?
Regards from
Tom :)

On 18 December 2013 23:46, John Meyer  wrote:

I know it's a relational database.  ;-) Is there any way to design this to
work on a spreadsheet?


On 12/18/2013 4:40 PM, Tom Davies wrote:

Hi :)
That is very much like a relational database.  The 1st sheet is the
main table.  The 2nd sheet would be a separate table but would be
linked by a relationship between both column As.  The 3rd sheet would
actually not be a table as such, it would be a Query that takes data
from the 2 tables and performs calculations on them.  Hmm, it could be
a Form or Report but if i was doing it (and note that  i'm not) then i
tend to prefer using a Query for as much of this sort of thing as
possible because it makes it easier to adjust the formulae in the
future
Regards from
Tom :)

On 18 December 2013 20:22, John Meyer 
wrote:

A while back I posted up about calculating bonuses based upon a lookup.
now, I need to add an additional step.  Every once in a while, agents get
additional bonuses for sales outside of the normal commission ladder.
Here's the layout of the main sheet


A  B CD   E
  Date1 Date2
Date3  .
agent ID  Agent Name$###   $###  $###




What I wanted to do was add an "Additional Bonus sheet"  With a layout
like
this


A   B C
agentID   DateBonus



Then have a "final bonus screen" with this layout and formula similar to
the
main sheet


A   B CDE
Date1 Date2  Date3
agentIDAgent Name$(sales + add bonus total)
... 


Note: the agent can have multiple bonuses for the same date on the
additional bonus sheet.  Where would i start doing something like that?
I
might figure that out while I'm typing that out (which is probably one of
the most useful functions of this list), but right now I'm spinning.




--
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] Bonus calculator in Calc

[John Meyer]

I know it's a relational database.  ;-) Is there any way to design this 
to work on a spreadsheet?


On 12/18/2013 4:40 PM, Tom Davies wrote:

Hi :)
That is very much like a relational database.  The 1st sheet is the
main table.  The 2nd sheet would be a separate table but would be
linked by a relationship between both column As.  The 3rd sheet would
actually not be a table as such, it would be a Query that takes data
from the 2 tables and performs calculations on them.  Hmm, it could be
a Form or Report but if i was doing it (and note that  i'm not) then i
tend to prefer using a Query for as much of this sort of thing as
possible because it makes it easier to adjust the formulae in the
future
Regards from
Tom :)

On 18 December 2013 20:22, John Meyer  wrote:

A while back I posted up about calculating bonuses based upon a lookup.
now, I need to add an additional step.  Every once in a while, agents get
additional bonuses for sales outside of the normal commission ladder.
Here's the layout of the main sheet


A  B CD   E
 Date1 Date2
Date3  .
agent ID  Agent Name$###   $###  $###




What I wanted to do was add an "Additional Bonus sheet"  With a layout like
this


A   B C
agentID   DateBonus



Then have a "final bonus screen" with this layout and formula similar to the
main sheet


A   B CDE
Date1 Date2  Date3
agentIDAgent Name$(sales + add bonus total)
... 


Note: the agent can have multiple bonuses for the same date on the
additional bonus sheet.  Where would i start doing something like that?  I
might figure that out while I'm typing that out (which is probably one of
the most useful functions of this list), but right now I'm spinning.




--
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] with styles, is not master document functionality unnecessary+

[tk]

e-letter  wrote:

>What is the benefit of using master document function (presumably a gratuitous
copy of m$), when styles function is available in LO? 

For all practical purposes, the advantages and virtues of using Master Document 
functionality is completely irrelevant to the advantages and virtues of using 
Styles.

>be more stable and easier to manage if these files were imported into one new 
>document?

Whether it is more appropriate for the  content to maintained as One Single 
File, One Master Document file, or 100 individual files, depends upon a dozen 
different factors, starting with the type of content, and ending up with the 
size of the components of that content.

Regardless of which approach is used (single document, master document, 
individual files), what is crucial, is that a named template be used, which is 
where all style changes are made.

jonathon
-- 
Sent from the eating establishment at the Far side of the Universe, at the 
begining of Time, and at  the end of Space.

-- 
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] Re: Label creation Q

[John R. Sowden]

Good morning:

(Nice Farm Site Don)  I do not know what ya'all mean by 'table' unless 
you are saying that I might get the "name address" data from a 
database.  I am not.  I am creating a shipping label to put on large (9 
x 12) envelopes for my security system proposals.  I am using equivalent 
to Avery 5164 labels (6 on a page).  I fill them out manually on a 
typewriter.


My question related to the concept of "obvious" and "efficiency", 
meaning most label creation would be:

1. Design label (lines, test colors, etc.)
2. Copy to other label locations on the sheet
3. Print Labels

So having a command that would take the label that you just created and 
populate the other label locations on the sheet seemed to be the next 
step, and I could not find the option.


Problem: In label design, the text and the drawing are separate objects, 
so selecting the top left label buy highlighting the upper left to lower 
right the, rt cl copy, put cursor in upper right  box, upper right 
corner, put the lower half of my original label (drawing only, no text) 
below the original and nothing in the upper right box.


It just seems that a "populate other empty labels on this sheet with 
original" would make sense.


John


On 12/17/2013 02:32 PM, Don C. Myers wrote:

Hi John,

If you are using the table based templates, simply copy and paste.

Don



On 12/17/2013 02:35 PM, John R. Sowden wrote:
With the recent messages re: the label function, I created a shipping 
label.  Worked very nicely.  Is there a feature to populate the rest 
of the labels on a sheet (on the screen), from the top left one, so 
they are all the same?


John








--
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] Mail Merge and Labels

[Don C. Myers]

Hi Cliff,

When you use the table style templates, the wizard does not work. It is 
designed for the frame style. What I do is fill in one label. Then if 
you have a 30 label sheet with 3 columns and 10 rows, I copy and paste 
it to the nest two labels to the right. Then I copy all three of those 
labels on row 1, and paste into the complete second row. Then I copy 
rows 1 and two and paste into rows 3 & 4, 5 & 6, 7 & 8, and 9 & 10. It 
really goes pretty fast that way.


Don


On 12/18/2013 08:46 AM, Cliff Scott wrote:

** Reply to message from "Don C. Myers"  on Tue, 17
Dec 2013 10:53:17 -0500

Don,

Initially I just want a sheet with all the labels the same. Being able to
fill a sheet with addresses from a database or even directly print envelopes
may be in the future.

For now I can obviously copy/paste to each label, but the wizard's way of
entering data for one then propagating it to all is handy for like a set of
return address labels.

Cliff


Hi Cliff,

Are you using fields from a data base, or do you simply want something
like return labels where every label is the same?

Don

On 12/17/2013 10:06 AM, Cliff Scott wrote:

** Reply to message from "Don C. Myers"  on Mon, 16
Dec 2013 20:48:12 -0500

Don,

Thanks for the link to the templates, but, pardon my ignorance, what is the
proper way to setup a table based template?

The wizard is useful, but, as already discussed, the built-in templates often
don't work well. If the built in ones could be replaced with these table
based ones and still have the wizard work it would be the best of both worlds.

Cliff


Hi Virgil,

They have really worked well for me. With the frame based templates, I
always had trouble with the spacing on the labels changing as you would
get into the bottom third of the label sheet. The frame based templates
print out perfectly from top to bottom, and they are so easy to adjust.
I've left similar posts when people have had issues before, but it seems
very few are willing to try the table based formats. Maybe they try to
use the wizard, which is not the way to set up a table based template.

Don

On 12/16/2013 08:11 PM, Virgil Arrington wrote:

Don,

Thank you for this. I knew I had seen something like that before.

LO uses a frame based label template. I agree that a table based
template makes far more sense.

Virgil

-Original Message- From: Don C. Myers
Sent: Monday, December 16, 2013 7:34 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Mail Merge and Labels

About 5 or 6 years ago when using OpenOffice to print Christmas labels,
I ran across an article about using table style labels in OpenOffice
instead of the type which come with Word, OpenOffice, and LibreOffice.
It is far easier to adjust the table style labels. To adjust the top
spacing, simply adjust the top margin for the page. To adjust the column
width, simply drag the column borders and the entire column is adjusted.
At one time OpenOffice had these label templates available as an
extension. I don't know if they still do or not. But they are available
from World Label here:
http://www.worldlabel.com/Pages/openoffice-template.htm
They can be downloaded individually, or all together as a pdf.

I've found them much easier to use and adjust, and have never used any
other label templates since then. Also, when you enter the text or
fields in them, the text is starts with being paced in the center of the
label between the top and the bottom, and then as additional lines are
added, the text of fields are automatically centered within the label
itself, top to bottom. I've never used the standard templates with
OpenOffice or LibreOffice since finding these. Nor have I wasted any
sheets of labels because they didn't print properly.

Don

---Extra trimmed---


--


**


--
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] using database

[Tom Davies]

Hi :)
There is a handbook
https://wiki.documentfoundation.org/Documentation/Publications
and the 1st 3 chapters of the full guide.

Also the Faq wiki has a section about Base
https://wiki.documentfoundation.org/Faq

Regards from
Tom :)


On 18 December 2013 12:42, Keith Armbruster  wrote:
> Is there any written document that I could get for creating/using the 
> database feature?  Or...a phone number I could use to BRIEFLY contact and 
> speak to someone there about the same issue?
> --
> 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: Formats & failed marketing, was: Fwd: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office

[tk]

James Knott  wrote:

>> There is AndroidOpenOffice.

>I tried that a while ago, on my Nexus 7, and it didn't work very well. 

It is very inconsistent in how well it works.  The updates, bug-fixes, etc. can 
either be much better, or much worse than the previous version.

For the most part, releases within the last month are much more stable, and 
offer more features that work as expected, than releases from even four months 
ago.

All that said, I don't think it quite yet suitable for mission critical work.

jonathon
-- 
Sent from the eating establishment at the Far side of the Universe, at the 
begining of Time, and at  the end of Space.

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

[Brian Barker]

At 19:13 18/12/2013 +, Nobody Noname wrote:
Is there a way to import multiple files into a new document? The 
existing function only allows multiples files to be imported 
successively, which is inefficient. If a directory contains

file1
file2
file3
it would be beneficial to be able to select all files in the import 
dialogue window for automatic successive import into the new document.


One obvious problem would be the necessity to indicate the order in 
which multiple files should be incorporated.  It would be easy if you 
had files with carefully organised names, but in general you wouldn't 
have that.  In any case, would file10 become positioned after file9 
or between file1 and file2?  Would that apply in all operating systems?


If you needed either to list the files in the order in which you 
wanted them incorporated, or else to readjust everything after 
assembly, you would be better off (and achieve a more reliable 
result) by simply importing one at a time.


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] Bonus calculator in Calc

[John Meyer]

A while back I posted up about calculating bonuses based upon a lookup.  
now, I need to add an additional step.  Every once in a while, agents 
get additional bonuses for sales outside of the normal commission 
ladder.   Here's the layout of the main sheet



A  B CD   E
Date1 Date2 
Date3  .

agent ID  Agent Name$###   $###  $###




What I wanted to do was add an "Additional Bonus sheet"  With a layout 
like this



A   B C
agentID   DateBonus



Then have a "final bonus screen" with this layout and formula similar to 
the main sheet



A   B CDE
Date1 Date2  Date3
agentIDAgent Name$(sales + add bonus 
total)   ... 



Note: the agent can have multiple bonuses for the same date on the 
additional bonus sheet.  Where would i start doing something like that?  
I might figure that out while I'm typing that out (which is probably one 
of the most useful functions of this list), but right now I'm spinning.





--
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] with styles, is not master document functionality unnecessary+

[Virgil Arrington]

Another benefit of master documents is that it forces all styles of the same 
name to appear the same. For example, suppose I have written five documents, 
all having a style called "BodySingle." But, in one document, my 
"BodySingle" style uses a Consolas font (good for on screen editing). In 
another, I have set the "BodySingle" font to "Iowan Old Style," a personal 
favorite of mine.


Now, let's say I combine these documents into a master document for final 
output. The styles of the master document will control over the styles of 
the individual files. So, in my master document, I set my "BodySingle" font 
to Linux Libertine G with a host of expert effects (old style numbers, 
historic or discretionary ligatures, etc.) This is great for printing a 
final document (to either a printer or PDF file), but not so effective for 
onscreen editing. So, I can change the final output by editing only the 
styles of the master document without having to edit the styles in each 
individual document.


Virgil


-Original Message- 
From: Gabriel Risterucci

Sent: Wednesday, December 18, 2013 2:19 PM
Cc: users@global.libreoffice.org
Subject: Re: [libreoffice-users] with styles, is not master document 
functionality unnecessary+


2013/12/18 e-letter 


Readers,

Suppose a collection of documents each about 100kb size. What is the
benefit of using master document function (presumably a gratuitous
copy of m$), when styles function is available in LO? Surely it would
be more stable and easier to manage if these files were imported into
one new document?



Master document are not only about sharing styles (in fact, I never saw
them in this light), it's about splitting your work in easily manageable
smaller files. I don't even know why having styles would concern having the
possibility to create a master document.
When you're working on a reasonnably large project, it's simply easier to
split it. For example, having each chapter in it's own file, instead of
loading one huge file​​. It's more stable and easier to navigate.
Ahem, still don't get why you're mixing the presence of styles and master
document. The only link I can think of is that a master document's style
override the sub-documents, but even then... maybe you can clarify what you
meant?

--
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] with styles, is not master document functionality unnecessary+

[Gabriel Risterucci]

2013/12/18 e-letter 

> Readers,
>
> Suppose a collection of documents each about 100kb size. What is the
> benefit of using master document function (presumably a gratuitous
> copy of m$), when styles function is available in LO? Surely it would
> be more stable and easier to manage if these files were imported into
> one new document?
>
>
Master document are not only about sharing styles (in fact, I never saw
them in this light), it's about splitting your work in easily manageable
smaller files. I don't even know why having styles would concern having the
possibility to create a master document.
When you're working on a reasonnably large project, it's simply easier to
split it. For example, having each chapter in it's own file, instead of
loading one huge file​​. It's more stable and easier to navigate.
Ahem, still don't get why you're mixing the presence of styles and master
document. The only link I can think of is that a master document's style
override the sub-documents, but even then... maybe you can clarify what you
meant?

-- 
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] multiple file import

[e-letter]

Readers,

Is there a way to import multiple files into a new document? The
existing function only allows multiples files to be imported
successively, which is inefficient. If a directory contains

file1
file2
file3

it would be beneficial to be able to select all files in the import
dialogue window for automatic successive import into the new document.

-- 
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] with styles, is not master document functionality unnecessary+

[e-letter]

Readers,

Suppose a collection of documents each about 100kb size. What is the
benefit of using master document function (presumably a gratuitous
copy of m$), when styles function is available in LO? Surely it would
be more stable and easier to manage if these files were imported into
one new document?

-- 
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: Formats & failed marketing, was: Fwd: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office

[James Knott]

tk wrote:
> There is AndroidOpenOffice.

I tried that a while ago, on my Nexus 7, and it didn't work very well. 
I uninstalled it.

-- 
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: Formats & failed marketing, was: Fwd: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office

[tk]

James E Lang wrote:

>I really wish there were a LO Calc implementation for Android to use in
place of Kingsoft Office. I don't feel secure using a proprietary
office product; especially one from China.

There is AndroidOpenOffice.
Whilst closed source, it is based upon Apache Open Office, to the point of  
including most of the obvious, and all of the non-obvious AOo tells.
(I'm not sure, but I think it is simply a recompiled version of AOO, with 
things that throw errors simpoly commented out.  Then latter rewritten to 
comppile correctly.)

jonathon
-- 
Sent from the eating establishment at the Far side of the Universe, at the 
begining of Time, and at  the end of Space.

-- 
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] Mail Merge and Labels

[Brian Barker]

At 07:46 18/12/2013 -0600, Cliff Scott wrote:
Initially I just want a sheet with all the labels the same. [...] 
For now I can obviously copy/paste to each label, but the wizard's 
way of entering data for one then propagating it to all is handy for 
like a set of return address labels.


If you are using a table, have you tried my suggestion in a related thread?

o Put the cursor in the cell containing the text.
o Press Ctrl+A to select all the text in that cell.
o Press Ctrl+C to copy that text.
o Press Ctrl+A again to select the entire table.
o Press Ctrl+V to paste copies of the text into all the cells at once.

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

Re: [libreoffice-users] video in impress presentation mode

[Tom Davies]

Hi :)
Perhaps copy your old User Profile from your old machine to your new
one?  I'm specifically think about the memory settings

Tools - Options - Memory

and just bump them right up, not by a small fraction but by setting
things to 100MB or however large the video-file is (well a little bit
more than however large it is).

Copying the entire User Profile will bring in more of your old
settings too and galleries, templates, blah, blah.
Regards from
Tom :)



On 18 December 2013 04:53, Jay Tasson  wrote:
> I have been running libreoffice impress 3.7.2 on my desktop computer in
> Ubuntu 12.04 for some time without difficulty.  I recently purchased a
> laptop with Ubuntu 13.10.  Everything about libreoffice impress works well
> on the laptop also except that inserted movies cause problems in the default
> presentation mode.  The movies play in a slow, jerky way, or crash impress.
> It seems that it is not a hardware issue as the specs on the laptop are much
> better than my rather old desktop where things work fine.  The problem
> occurs in impress 4.1 as well as 3.7.2 on the laptop, but the same impress
> files work fine on my desktop.  The relevant video files (avi) also play
> fine on the laptop in any other mode: in video player, outside of
> presentation mode in impress, and when "window" is selected as the
> presentation mode.  This is a fairly serious problem for me as this was my
> primary intended use for the laptop.  Help would be greatly appreciated.
>
> --
> 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] video in impress presentation mode

[Jay Tasson]

Hi Tom,

Thanks for your reply.  I tried memory.  It's set to several times the 
size of the video and matches the desktop settings.  I tried changing it 
with no improvement in the result.  I'd love to hear any other ideas you 
or others might have.  I will also try the whole user profile later.


Jay

On 12/18/2013 05:56 AM, Tom Davies wrote:

Hi :)
Perhaps copy your old User Profile from your old machine to your new
one?  I'm specifically think about the memory settings

Tools - Options - Memory

and just bump them right up, not by a small fraction but by setting
things to 100MB or however large the video-file is (well a little bit
more than however large it is).

Copying the entire User Profile will bring in more of your old
settings too and galleries, templates, blah, blah.
Regards from
Tom :)



On 18 December 2013 04:53, Jay Tasson  wrote:

I have been running libreoffice impress 3.7.2 on my desktop computer in
Ubuntu 12.04 for some time without difficulty.  I recently purchased a
laptop with Ubuntu 13.10.  Everything about libreoffice impress works well
on the laptop also except that inserted movies cause problems in the default
presentation mode.  The movies play in a slow, jerky way, or crash impress.
It seems that it is not a hardware issue as the specs on the laptop are much
better than my rather old desktop where things work fine.  The problem
occurs in impress 4.1 as well as 3.7.2 on the laptop, but the same impress
files work fine on my desktop.  The relevant video files (avi) also play
fine on the laptop in any other mode: in video player, outside of
presentation mode in impress, and when "window" is selected as the
presentation mode.  This is a fairly serious problem for me as this was my
primary intended use for the laptop.  Help would be greatly appreciated.

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

[libreoffice-users] using database

[Keith Armbruster]

Is there any written document that I could get for creating/using the database 
feature?  Or...a phone number I could use to BRIEFLY contact and speak to 
someone there about the same issue?
-- 
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] Issues downloading LibreOffice Portable

[Tom Davies]

Hi :)
This link might help
https://www.libreoffice.org/download/portable/

There is another portable apps type of place that has every version of
LibreOffice but i'm not sure of the address.  The marketing team were
going to put their link on the same page as the link i just gave but i
didn't read the page to see if it's there.
Regards from
Tom :)

On 18 December 2013 01:40, Name Hidden for Security Reasons
 wrote:
> Hello,
> Sorry for replying so late.  I was just searching my disposable inbox for
> "portable," not expecting to find anything, and found your e-mail.
>
> I found that LibreOffice Portable is available on CNet's Download.com
> service
> (http://download.cnet.com/LibreOffice-Portable/3000-18483_4-75449672.html?tag=mncol;1).
> However, the version is shown as 4.1, and last updated July 29, 2013.  The
> LibreOffice Portable site on PortableApps.com lets me download version
> 4.1.3, but the same problems persist.  I've cleared the browser cache, tried
> different browsers (IE, Firefox, and Chrome), and even tried different
> computers and wireless networks.  I get the same result, in which the
> browser gets the impression that the download is complete, and upon opening
> the .paf.exe file, I get "Installer integrity check failed." error.
> I'm using Windows Vista 64-bit.
> Version 4.1 (downloadable from Download.com) downloaded successfully, and I
> installed it on my flash drive successfully. Did The Document Foundation
> quit mirroring their downloads off of Download.com?
> Thank you.
>
>
> On 12/3/2013 7:55 AM, Tom Davies wrote:
>>
>> Hi :)
>> Did you manage to solve this in the end?  I think the Portable Aps
>> version is only for Windows.  On Linux it's much easier to install
>> LibreOffice through any of your package managers although you might
>> not get the most up-to-date one.
>>
>> However it is odd that you were having trouble downloading with
>> Firefox.  Any nonIE web-browser tend to be able to cope better with
>> intermittent connections.
>>
>> The only way you could usually improve on that is by using the
>> torrent.  You probably have a reasonably good torrenting client
>> built-in to your system so just download the tiny torrent and then
>> allow your client to use it or else double-click on it when it's
>> downloaded.  Either way the full download should start shortly after.
>>
>> It might be even better to try a different mirror but i've not figured
>> out how to do anything like that.  Most people know but it eludes me
>> Regards from
>> Tom :)
>>
>>
>>
>> On 28 November 2013 18:53, Name Hidden for Security Reasons
>>   wrote:
>>>
>>> Hello,
>>> I was trying to download the LibreOffice 4.1.3 Portable edition from
>>> LibreOffice.org, and then tried the download from PortableApps.com.
>>> I've tried to download the package using different methods and browsers,
>>> and
>>> the download (which is supposed to be around 113 MB, according to HTTP
>>> headers) stops (at anywhere from 7.9 MB downloaded to 40.2 MB downloaded,
>>> in
>>> the multiple attempts to download LibreOffice Portable).  The browser
>>> gets
>>> the impression that the download is completed.  However, I get an error
>>> message when opening the
>>> "LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe" file, saying that
>>> the
>>> installer integrity check failed.
>>> I know that:
>>>
>>>   * I am using a direct connection to the internet router.
>>>   * I got the same, repeating issue every time I tried to re-download
>>> the file.
>>>   * It appeared as if I were being redirected to a mirror.
>>>   * Nothing is wrong with my "hosts" file
>>> (%systemroot%\system32\drivers\etc\hosts).
>>>   * I didn't lose my internet connection.
>>>
>>>
>>> I've come to the conclusion that something might be wrong with the
>>> servers
>>> of The Document Foundation, LibreOffice, or the mirror
>>> mirror.nexcess.net.
>>> Is there anything I can do to download LibreOffice Portable without these
>>> issues, or is something going on on your servers or the mirror?
>>> I also noticed unusual behavior of the LibreOffice website when
>>> attempting
>>> to download LibreOffice Portable, as described below in the HTTP headers:
>>> Data I found questionable is marked red, while data that is unusual is
>>> marked yellow, followed by a note.
>>>
>>> When I clicked the download button for LibreOffice, I noticed that it
>>> goes
>>> to the url
>>>
>>> http://download.documentfoundation.org/libreoffice/portable/4.1.3/LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe.
>>> However, I get redirected to a mirror url
>>>
>>> (http://mirror.nexcess.net/tdf/libreoffice/portable/4.1.3/LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe).
>>>
>>> When reviewing the headers of the requests, I found some information in
>>> the
>>> headers that is questionable, as seen below.
>>>
>>> Request URL:
>>>
>>> http://download.documentfoundation.org/libreoffice/portable/4.1.3/LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe
>>> Request Method: 

[libreoffice-users] Libre Office Calc - Header and Footer

[IGRI08 - TIAGO POLICARPO]

Hello team.

I come from the following suggestionto Libre Office Calc:
In the Header and Footer option the possibility to insert picture.

Microsoft Excel have this option use daily format. Xlsx to have this 
funcionadade.


Thank you very much for your time.


Cumprimentos
Tiago Policarpo
--

Cumprimentos
Tiago Policarpo

AVISO LEGAL
A informação presente nesta mensagem, bem como em qualquer dos seus anexos é 
confidencial e destinada exclusivamente ao(s) destinatário(s).
Qualquer utilização desta informação que não esteja de acordo com o seu 
objectivo, qualquer disseminação ou divulgação, total ou parcial, é proibida 
excepto se formalmente aprovada.
A Internet não garante a integridade desta mensagem, a qual poderá ter sido 
interceptada, corrompida, perdida, atrasada ou acrescida de vírus.
Assim, o Tiago Policarpo não se responsabiliza pela mensagem se modificada.

DISCLAIMER
The information in this e-mail and in any attachments is confidential and 
intended exclusively for the named adressee(s).
Any use of this information not in accordance with its purpose, any 
dissemination or disclosure, either whole or partial, is prohibited except if 
formally approved.
The Internet can not guarantee the integrity of this message, as it could be 
intercepted, corrupted, lost, destroyed, arrive late or incomplete or have 
viruses added to it.
Tiago Policarpo will not therefore be liable for the message if modified.


--
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] State of password support.

[Eric Beversluis]

I don't know if this is relevant to Massimo's case but it might be:
I had a problem a while back with Fedora 15 (and I don't remember which
version of OO or LO): I would discover that I could open a
password-protected spreadsheet without being prompted for the password.
It turned out that it had something to do with Fed 15 shutting down w/o
prompting to save an open and changed spreadsheet. When restarted, the
spreadsheet would open without password protection. The workaround
seemed to be to do a 'save as' at that point and check 'save with
password'.

More recently this hasn't seemed to be a problem, but I think it has
happened once or twice, though I didn't bother to try to figure out why.

On Wed, 2013-12-18 at 09:24 -0500, Andrew Douglas Pitonyak wrote:
> On 12/17/2013 10:12 AM, Massimo Del Zotto wrote:
> > However, I recently had a problem with OOo password protection. Somehow it
> > disabled password protection for a file I was working on and it took me a
> > while to restore it. Asking for help on OOo forum, I have been informed
> > password protection is somehow considered "unnecessary" by... I don't know
> > who to be honest.
> 
> You mean recently?As in the latest version of LO has a problem with 
> passwords?
> 
> > The forum administrator strongly
> > suggested me to not use it, and even pointed out a few previous cases in
> > which password protection caused data loss (!!!).
> Which forum, do you have a link to the post?
> 
> > I think *this is unacceptable *so I started looking more seriously at LO.
> > Digging the mailing list archives, I noticed there are quite a few messages
> > regarding password protection. It seems most problem were between keyboard
> > and chair, the only exception being perhaps an inter-operability problem
> > after switching to AES-256.
> >
> > In your experience, how is LO with password protection?
> Massimo, you seem to be more informed of this than I, but, I am only 
> aware of one (what I consider) real bug that existed with LO and 
> passwords. At one point, I was no longer able to open a password 
> protected file. Specifically, one version of LO was not able to open a 
> password protected file.  I am pretty sure it was LO and not AOO anyway.
> 
> I believe that I have seen things such as:
> 
> 1. I forgot my password, how I open my document
> 2. I am not able to open a password protected document created by MS Office
> 3. Problems signing a document
> 
> I don't ever remember anyone saying that password protection should be 
> dropped. Does not mean that it has not been said. I have seen people 
> pushing to drop the ability to write non-ODF format, but I don't 
> remember anyone advocating no support for passwords.
> 
> I have also seen reports of another bug that sometimes causes total data 
> loss of a file, but, since it is not reproducible in any sort of 
> meaningful way, the bug has not been researched.
> 
> -- 
> Andrew Pitonyak
> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
> Info:  http://www.pitonyak.org/oo.php
> 
> 



-- 
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] State of password support.

[Andrew Douglas Pitonyak]

On 12/17/2013 10:12 AM, Massimo Del Zotto wrote:

However, I recently had a problem with OOo password protection. Somehow it
disabled password protection for a file I was working on and it took me a
while to restore it. Asking for help on OOo forum, I have been informed
password protection is somehow considered "unnecessary" by... I don't know
who to be honest.


You mean recently?As in the latest version of LO has a problem with 
passwords?



The forum administrator strongly
suggested me to not use it, and even pointed out a few previous cases in
which password protection caused data loss (!!!).

Which forum, do you have a link to the post?


I think *this is unacceptable *so I started looking more seriously at LO.
Digging the mailing list archives, I noticed there are quite a few messages
regarding password protection. It seems most problem were between keyboard
and chair, the only exception being perhaps an inter-operability problem
after switching to AES-256.

In your experience, how is LO with password protection?
Massimo, you seem to be more informed of this than I, but, I am only 
aware of one (what I consider) real bug that existed with LO and 
passwords. At one point, I was no longer able to open a password 
protected file. Specifically, one version of LO was not able to open a 
password protected file.  I am pretty sure it was LO and not AOO anyway.


I believe that I have seen things such as:

1. I forgot my password, how I open my document
2. I am not able to open a password protected document created by MS Office
3. Problems signing a document

I don't ever remember anyone saying that password protection should be 
dropped. Does not mean that it has not been said. I have seen people 
pushing to drop the ability to write non-ODF format, but I don't 
remember anyone advocating no support for passwords.


I have also seen reports of another bug that sometimes causes total data 
loss of a file, but, since it is not reproducible in any sort of 
meaningful way, the bug has not been researched.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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] Mail Merge and Labels

[Cliff Scott]

** Reply to message from "Don C. Myers"  on Tue, 17
Dec 2013 10:53:17 -0500

Don,

Initially I just want a sheet with all the labels the same. Being able to
fill a sheet with addresses from a database or even directly print envelopes
may be in the future.

For now I can obviously copy/paste to each label, but the wizard's way of
entering data for one then propagating it to all is handy for like a set of
return address labels.

Cliff

> Hi Cliff,
> 
> Are you using fields from a data base, or do you simply want something 
> like return labels where every label is the same?
> 
> Don
> 
> On 12/17/2013 10:06 AM, Cliff Scott wrote:
> > ** Reply to message from "Don C. Myers"  on Mon, 16
> > Dec 2013 20:48:12 -0500
> >
> > Don,
> >
> > Thanks for the link to the templates, but, pardon my ignorance, what is the
> > proper way to setup a table based template?
> >
> > The wizard is useful, but, as already discussed, the built-in templates 
> > often
> > don't work well. If the built in ones could be replaced with these table
> > based ones and still have the wizard work it would be the best of both 
> > worlds.
> >
> > Cliff
> >
> >> Hi Virgil,
> >>
> >> They have really worked well for me. With the frame based templates, I
> >> always had trouble with the spacing on the labels changing as you would
> >> get into the bottom third of the label sheet. The frame based templates
> >> print out perfectly from top to bottom, and they are so easy to adjust.
> >> I've left similar posts when people have had issues before, but it seems
> >> very few are willing to try the table based formats. Maybe they try to
> >> use the wizard, which is not the way to set up a table based template.
> >>
> >> Don
> >>
> >> On 12/16/2013 08:11 PM, Virgil Arrington wrote:
> >>> Don,
> >>>
> >>> Thank you for this. I knew I had seen something like that before.
> >>>
> >>> LO uses a frame based label template. I agree that a table based
> >>> template makes far more sense.
> >>>
> >>> Virgil
> >>>
> >>> -Original Message- From: Don C. Myers
> >>> Sent: Monday, December 16, 2013 7:34 PM
> >>> To: users@global.libreoffice.org
> >>> Subject: Re: [libreoffice-users] Mail Merge and Labels
> >>>
> >>> About 5 or 6 years ago when using OpenOffice to print Christmas labels,
> >>> I ran across an article about using table style labels in OpenOffice
> >>> instead of the type which come with Word, OpenOffice, and LibreOffice.
> >>> It is far easier to adjust the table style labels. To adjust the top
> >>> spacing, simply adjust the top margin for the page. To adjust the column
> >>> width, simply drag the column borders and the entire column is adjusted.
> >>> At one time OpenOffice had these label templates available as an
> >>> extension. I don't know if they still do or not. But they are available
> >>> from World Label here:
> >>> http://www.worldlabel.com/Pages/openoffice-template.htm
> >>> They can be downloaded individually, or all together as a pdf.
> >>>
> >>> I've found them much easier to use and adjust, and have never used any
> >>> other label templates since then. Also, when you enter the text or
> >>> fields in them, the text is starts with being paced in the center of the
> >>> label between the top and the bottom, and then as additional lines are
> >>> added, the text of fields are automatically centered within the label
> >>> itself, top to bottom. I've never used the standard templates with
> >>> OpenOffice or LibreOffice since finding these. Nor have I wasted any
> >>> sheets of labels because they didn't print properly.
> >>>
> >>> Don
> > ---Extra trimmed---

-- 
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] Label creation Q

[Don Myers]

Yes, if you are using the table style templates.
Don


On 12/17/2013 08:33 PM, Tom Davies wrote:

Hi :)
Errr, Copy&paste?
Regards from
Tom :)





On 17 December 2013 19:35, John R. Sowden  wrote:

With the recent messages re: the label function, I created a shipping label.
Worked very nicely.  Is there a feature to populate the rest of the labels
on a sheet (on the screen), from the top left one, so they are all the same?

John


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

[Gabriel Risterucci]

2013/12/18 Richard Vickery 

> Dear Sirs/Madame:
>
> I wonder if I could make a suggestion for improvement to the program.
> Somehow, early on, Microsoft built into Word an ability of the program to
> suggest various ways to correct grammar. I wonder if the same could be done
> for Writer? I switched to Linux after getting frustrated with Microsoft's
> crashing in 1998 and have not gone back since, neither have I the energy to
> put up with their crap: do you think that you can help me out?
>

It is possible to install an extension that work reasonnably well.
It support a large range of languages, some better than other.


​​

-- 
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] Label creation Q

[Brian Barker]

At 11:35 17/12/2013 -0800, John R. Sowden wrote:
With the recent messages re: the label function, I created a 
shipping label.  Worked very nicely.  Is there a feature to populate 
the rest of the labels on a sheet (on the screen), from the top left 
one, so they are all the same?


That depends rather on how you have created your label - which you 
have kept a secret!  Have you used a table?


o Put the cursor in the cell containing the text.
o Press Ctrl+A to select all the text in that cell.
o Press Ctrl+C to copy that text.
o Press Ctrl+A again to select the entire table.
o Press Ctrl+V to paste copies of the text into all the cells at once.

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