Re: [libreoffice-users] torrent download 5.2.5

["Luca Daghino"@Libero]

Il 28/01/2017 00:47, Tim Lloyd ha scritto:

Hi,

I have been trying to download the linux rpm via torrent since about 
24 hours ago. Stuck at 99.5%. Anyone else experiencing problems? 
Windows came down fine.


I could always grab the torrent again but interested if this is a 
common problem.


Cheers



+1
I often have problems downloading *.msi files and relative *msi.torrent 
files (not only 5.2.5 version)
I have tried many times both torrent download (mainly using 
transmission) and downthemall software (firefox plugin), but I always 
have problems; downloads don't complete with torrent and with 
downthemall do not start at all; I have to repeat the whole thing many 
times before it works.
I only have these problems with files downloaded from the document 
foundation website.

Thanks for pointing out.
Namasté :)

--
Luca Daghino
 - - - - - - - -
Icq/Licq/Gaim #175451007
Debian Powered Linux Registered User #310800 at http://counter.li.org
No retreat baby no surrender
http://www.retenergie.it - coop di produttori e utilizzatori di energia da 
fonti rinnovabili
tad evaarthamaatra-nirbhaasaM svaruupa-shuunyam iva samaadhiH
Sanskrit - Realize it's the common language ;-)


--
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] torrent download 5.2.5

[Tim Lloyd]

Hi,

I have been trying to download the linux rpm via torrent since about 24 
hours ago. Stuck at 99.5%. Anyone else experiencing problems? Windows 
came down fine.


I could always grab the torrent again but interested if this is a common 
problem.


Cheers


--
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] Formatting business card template

[Rich Shepard]

  I used the business card template and see that the icons for address,
phone, and e-mail need a space between them and the text. I've not been able
to figure out how to enter this space and would appreciate learning how to
do this. The fields invoved are BC_COMP_STREET, BC_COMP_PHONE, and
BC_COMP_MAIL.

Rich

--
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: Can I reload a form based on a parameter query?

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Am 27.01.2017 um 16:21 schrieb ptoye:
> Hi Robert,
> 
> I've had a look at some of your forms now, especially 
> filter_without_macros and I'm a bit puzzled. I see that the table 
> in the Display part of the form is populated by the "filterquery" 
> query, which references "filter". The table "filter" has one entry 
> - the selection(s) I made in the listbox. But I can't see how the 
> listbox selections get put into the "filter" table. Can you please 
> help me there?

Could be this is a special behavior of Base-forms. There are two forms
beneath each other. One form for "filter" and one for "display". I
change values in "filter". I move to a button in "display". The
content of "filter" will be saved when I push the button in "display"
before the action of the button will happen. So there is needed only
one button, which should refresh the form "display". The query for
this form will be filtered by the entries in the table "filter".


> I also can't understand why there are two columns in the 
> "listbox_n_simple", but that's of less importance.

Most listboxes will show some text-content, but are linked to a table
by an Integer-primarykey. So queries for listboxes look like
SELECT "name", "ID" form "table_names"
"name" will be shown. "ID" will be saved in the column of the form.

You must have a look in the properties > data of the listbox. The
"bounded field" will be '1' by default - and '1' is (a little be
confusing, because it begins with '0') the second field.

If the same content should be shown as it will be saved you could set
this to '0' - so there must be only asked for one field.

You could also set this to '-1'. This will save the numer of the row.
I have never used this, but it works ...

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYi4ucAAoJELDKYwaoS9AITnoQAKhjm6204tHi/aeQy2N9cIZp
jzmXXg6NnQDwy6nGgSMjdoBjtFBMbwwfl76qNJMAQKtN5qigKPah3mBlnR04Yize
NWRCpFuQdYXyv6FqChXh3EdGktfS4eMwpMAgLDaey3Zcbno7tXtetQ7YlJc7iGjd
0eVEw/4Bk0TtDJ3hBLQ3aBe61RKwZnt2h+1V8rJQfvPbWPiSMNr/YznotaKIXSbJ
zLrm6u97BeIcXd5E2K+lXxdmvDHacH5zKbv6j8B3h+D3JrHo5OzG62hYpYptmuh8
dpKgC1D9Wpe3x96Of/5vz82E+csMJqk7VNrT0WgULdrPUy6oqxGoRZviKnS9QwmQ
Et8mDm2PPZGdnvcns4lIaGLwkCPU9ZRyk08Oq1aeWvLp6I5E8M1KKblEURDbMr9W
CTKJVkrEEiVj+MJux+b02GPrLCWIMv0TSoV7L8yiOQLSCb2EPh0DOsm/w3SMYo+t
qV/+nXgdwHztVMZ5F8y33CaWl6LuMMiQJCHZAIY3Wu4qEQlD668J/zVDOA+I/m7I
UG0K96RKNtXGYvf8tWidBhCLaBxaxadmmgfb0yD2r6pWipL6kBJdRWDSlOBczHJT
/BEJQixwe0RgleThXF9AO9hWepq811WOXUF7Sr/XXrIt3ojzYhVgopqHttf5ofJ3
93NMpdUU7TC9gmjU8JVp
=u2Z4
-END PGP SIGNATURE-

-- 
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: Can I reload a form based on a parameter query?

[Drew Jensen]

howdy,

Ah, considering that the project is actively working on the Base module at
the moment this might be a great time to open a Request For Enhancement.
In this case a request to add a ReloadWith (for example) function on the
data set (form) which would reload the data using the current parameter
variables entered on the initial load.

Just a thought and it couldn't hurt. I think your use case is common enough
that merits a discussion at least.


On Fri, Jan 27, 2017 at 10:21 AM, ptoye  wrote:

> Hi Robert,
>
> I've had a look at some of your forms now, especially
> filter_without_macros and I'm a bit puzzled. I see that the table in the
> Display part of the form is populated by the "filterquery" query, which
> references "filter". The table "filter" has one entry - the selection(s) I
> made in the listbox. But I can't see how the listbox selections get put
> into the "filter" table. Can you please help me there? I also can't
> understand why there are two columns in the "listbox_n_simple", but that's
> of less importance.
>
> Best regards,
>
> Peter
> mailto:l...@ptoye.com
> www.ptoye.com
>
> -
> Tuesday, January 24, 2017, 4:47:52 PM, you wrote:
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Peter,
>
> have a look here:
> http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb
>
> You don't need anything elese but a form and a subform. The example
> includes different forms, some of them working without any macro.
>
> Regards
>
> Robert
> - --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k
> bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N
> huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q
> alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL
> SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6
> rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ
> gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3
> q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd
> hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa
> 3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5
> JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd
> ILXQuH+aT+/Mas+L4BdB
> =zULF
> -END PGP SIGNATURE-
>
> --
> To unsubscribe e-mail to: [hidden email]
> 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
>
>
>
>
> If you reply to this email, your message will be added to the discussion
> below:
> http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-
> parameter-query-tp4206066p4206117.html
> To unsubscribe from Can I reload a form based on a parameter query?, click
> here.
> NAML
>
>
>
> -
> Peter
> --
> View this message in context: http://nabble.documentfoundation.org/Can-I-
> reload-a-form-based-on-a-parameter-query-tp4206066p4206363.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] Macro/button that allows sorting and hiding/unhiding on protected sheet?

[Tanstaafl]

Anyone?


On 1/16/2017, 11:12:21 AM, Tanstaafl  wrote:
> Hello all,
> 
> I am not a programmer, but I'm trying to add a few buttons to a
> worksheet that will allow the boss to do a few things on a protected
> sheet that you normally can't do without unprotecting it.
> 
> Is it possible to create a macro that can, for example, hide/unhide (so
> it would be a toggle button) a group of columns by simply clicking on
> it, without the user first having to unprotect the worksheet? Would this
> require me to actually include the unprotect/re-protect steps into the
> macro? Which would also mean embedding the password?
> 
> Same question for sorting on certain columns, although the sort would be
> just one way (sort order should always be descending).
> 
> Thanks!
> 
> Charles
> 


-- 
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] Macro/button to update link(s) to external sheet(s)

[Tanstaafl]

Hello,

I sure would appreciate if someone familiar with macros could give this
a look and see if this can be made to work.

Thanks


On 1/17/2017, 1:16:52 PM, Tanstaafl  wrote:
> Doesn't work for me but seems to try to do something.
> 
> The article is 4 years old and based on Openoffice - so maybe something
> changed and someone here can spot the problem?
> 
> Here is the code from the linked article:
> 
> REM  *  BASIC  *
> 
> Sub refreshAllSheetLinks()
>oEnum = thisComponent.SheetLinks.createEnumeration
>while oEnum.hasMoreElements
>   oLink = oEnum.NextElement
>   oLink.refresh
>wend
> End Sub
> 
> Sub Main
> end sub
> 
> On Mon Jan 16 2017 16:23:46 GMT-0500 (Eastern Standard Time), Cley Faye
>  wrote:
>> Ok, I can't test this right now, but this page might have an acceptable
>> answer: http://blog.louic.nl/?p=622
>>
>> The part about adding a nice button have a small macro in it. Here it's
>> used for linked CSV files, but since the dialog asking to update links
>> that's shown when you reload your file is the same, maybe the same
>> procedure works.
>>
>> Other than that I didn't find a quicker way to reload external references
>> than file->reload->accept the dialog that asks for refresh :(
>>
> 
> 


-- 
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: Can I reload a form based on a parameter query?

[ptoye]

Hi Robert,

I've had a look at some of your forms now, especially filter_without_macros and 
I'm a bit puzzled. I see that the table in the Display part of the form is 
populated by the "filterquery" query, which references "filter". The table 
"filter" has one entry - the selection(s) I made in the listbox. But I can't 
see how the listbox selections get put into the "filter" table. Can you please 
help me there? I also can't understand why there are two columns in the 
"listbox_n_simple", but that's of less importance.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Tuesday, January 24, 2017, 4:47:52 PM, you wrote:


-BEGIN PGP SIGNED MESSAGE- 
Hash: SHA1 

Hi Peter, 

have a look here: 
http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb

You don't need anything elese but a form and a subform. The example 
includes different forms, some of them working without any macro. 

Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k 
bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N 
huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q 
alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL 
SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6 
rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ 
gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3 
q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd 
hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa 
3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5 
JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd 
ILXQuH+aT+/Mas+L4BdB 
=zULF 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
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 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206117.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206363.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

[libreoffice-users] Re: Can I reload a form based on a parameter query?

[ptoye]

HI Tom,

Thanks for this, but my basic question was whether there's an easier way than 
using macros :) I'm not frightened by macro programming (I wrote my first ever 
program in about 1961, and was in the profession for far too many years). 
Except for the difficulty in working out which method applies to which object, 
but that's a documentation issue.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Thursday, January 26, 2017, 2:49:47 PM, you wrote:


Hi :) 
Chapter 13 of the "Getting Started with LibreOffice" Guide may help with 
understanding macros.  There is an outstandingly good entire book about 
LibreOffice/OpenOffice macros by Andrew Pitonyak but that probably goes 
into far more detail than you need right now. 
Regards from 
Tom :) 

If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206277.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206352.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] LibreOffice help menu

[Tom Davies]

Hi :)
The user-profile contains all the Extensions/plugins/addons in one folder.
It is usually one of them that causes any weird problems that 'shouldn't'
be happening (but are).  However it also contains galleries, libraries and
configurations any of which may have gone wonky to produce a weird and
unusual error.

So renaming the user-profile is like a "magic pill" that cures a wide
variety of completely unrelated errors.  If you have the time and patience
to track down the specific problem you may well find it relates to one file
in the user-profile that got hit by cosmic rays or some other unlikely
event.  This can then allow you to fix a problem with surgical precision.
However the specific problem is very unlikely to arise again and if you are
unlucky enough to have another problem, even one that is very similar, then
it could easily be one of the other files in the user-profile.  So the
"nuke 'em 'till they glow" solution is usually a 'better' approach if you
just want the problem fixed without spending ages over it.

Of course if renaming the user-profile doesn't fix a particular problem
then you can always rename it to overwrite the fresh new auto-generated
one. If it did work then you can start on a process of elimination such as
copying half the user-profile's folders back in until something gets broken
again - or you could just stick with the fresh new profile that does work.


Yes, uninstalling and reinstalling is a very Windowsy answer but it's
beginning to sound as  though the repos got updated with a newer version of
LibreOffice and for some weird unknown reason the normal upgrades route
somehow hasn't upgraded  all the LibreOffice components but has upgraded
some of them.  This is, of course, impossible but has happened on other odd
occasions.  Perhaps it was a timing issue, or perhaps the problem will
magically sort itself out in a few days when upgrades finally work.
However you could force the issue by using the Windowsy answer.

Regards from
Tom :)





On 25 January 2017 at 13:06, Philip Jackson 
wrote:

> On 24/01/17 12:17, Dave Howorth wrote:
>
> >
> > That was the first thing I tried. There is no such package. Neither is
> > there in Ubuntu from what Philip says.
>
> >>  When i have installed LibreOffice in
> >> Ubuntu in the past (when else right??) i'm sure the help-files were
> >> all selected by default, automatically.  This behaviour may well have
> >> been changed either temporarily or deliberately for many different
> >> reasons.
> >
> Just for the record, I was speaking about Ubuntu 1404LTS. That is why I
> had to refresh my memory of how I got away from the LO website page that
> appeared so unhelpful.
>
> The later version of Ubuntu, 1604 LTS, does indeed have the internal
> help files installed in the distro supplied version.
> But as Tom and others have remarked in the past, the internal help files
> often appear incorrect and out of date.
>
> Philip
>
> --
> 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