Re: [libreoffice-users] perplexed by password

2017-09-17 Thread zahra a 
hello.
if you set password for your documents, you need to type password when
you want to open your files.
then after writing the correct password, you can read or edit your
files as normal!
God bless you all.

On 9/16/17, krishna  wrote:
> good morning,
>
> does creation of password will disable editing of a document ?
>
> password to open file and File Sharing Password are one and same ?
>
> my queries aroused due to https://gerrit.libreoffice.org/#/c/40458/
>
> regards,
> krishna
>
>
> --
>
> krishna [ never ever ask about my real name or identity ]
>
> ji-bu-rish: https://github.com/kr1shna-opensource/
>
> --
> 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
>


-- 
we have not sent you but as a mercy to the entire creation.
holy quran, chapter 21, verse 107.
in the very authentic narration from prophet Mohammad is:
indeed, imam husayn is the beacon of guidance and the ark of salvation.
best website for studying islamic book in different languages
www.al-islam.org

-- 
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] resume support on daily builds

2017-09-17 Thread krishna 
good morning,

is resume supported on daily builds at [ z ] ? at my present download speed it 
might take at least five days to complete ;)


[ z ] http://dev-builds.libreoffice.org/daily/master/

regards,
krishna


--

krishna [ never ever ask about my real name or identity ]

ji-bu-rish: https://github.com/kr1shna-opensource/

-- 
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: LO printing issue, 5.3.6.1

2017-09-17 Thread Ken Springer 

Interesting.  It's an old problem that has reared it's ugly head.

I'm going to back up to 5.2.7 where it seems this is not a problem.

And it may solve the Start Center/Remote files problem I've found.


On 9/17/17 2:04 PM, Al Maloney wrote:

Please see
https://bugs.documentfoundation.org/show_bug.cgi?id=92190 et al

Velox Versutus Vigilans

On Sun, Sep 17, 2017 at 1:37 PM, Ken Springer  wrote:


I also use the Export to PDF option.  Feels like a lot less work to me!
LOL

What is curious to me, is how this issue escaped notice in the "stable"
version, which is meant for those that don't want to deal with issues.

As well as my thread about opening remote files, which I just discovered
affects more than the remote files I mentioned in my original post.



On 9/17/17 11:03 AM, Tim-L wrote:



I get that issue many times with 64-bit DEB version.

A lot of the times when I see that issue I do a "trick".  I choose a
different printer, then do a "print preview".  After that, I go back to
the original printer and look at the print preview option.  Sometimes
that works.  Why - who knows.  If it does not work the first time, I try
going to a different printer on my network,  Most times the "trick"
works after the second try.

I have 2 Canon inkjet printers that I use most, and the newest has an
internal "filter" deciding what paper tray "IT" wants the document paper
type will be printed.  With the "bug" of not allowing the user to choose
paper orientation, paper tray, and even paper size, is the biggest issue
I have right now.

Yes, the orientation issue is a pain to deal with, along with the other
printing controls, but there is at least an option to export it it a PDF
file and use your PDF document reader and print the document[s] from
that package.  It still is a pain to do this. Hopefully the bug will be
fixed soon, like other ones that creep up from time to time.


On 09/16/2017 09:04 PM, Ken Springer wrote:


Mac OS X 10.11.6

I create a document in portrait orientation.

Print Preview is correct.

PDF export is correct.

Printing is not.  The document displays and print as landscape.

Create a landscape document, and printing is correct.

Bug?










--
Ken
Mac OS X 10.11.6
Firefox 53.0.2  (64 bit)
Thunderbird 52.0
"My brain is like lightning, a quick flash
  and it's gone!"


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
ubscribe/
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






--
Ken
Mac OS X 10.11.6
Firefox 53.0.2  (64 bit)
Thunderbird 52.0
"My brain is like lightning, a quick flash
 and it's gone!"


--
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: Creating a table with equal sized rows

2017-09-17 Thread Ken Springer 
You have to do this with MS Word too.  Never have considered this to be 
a sign of quality.


On 9/17/17 2:32 PM, Steve Edmonds wrote:

I think in LO you always have to have a line after the table on a page.
I sometimes make the character height 6 pt to minimise the visual effect.

steve

On 18/09/17 06:42, Ken Springer wrote:

Libre Office 5.3.6.1

Mac OS X 10.11.6 El Capitan

I've been trying to find a way to easily create a table that starts at
the top margin, ends at the bottom margin, with all rows the same
height, and not create a blank page at the end of the document.

Can this be done?










--
Ken
Mac OS X 10.11.6
Firefox 53.0.2  (64 bit)
Thunderbird 52.0
"My brain is like lightning, a quick flash
 and it's gone!"


--
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] Creating a table with equal sized rows

2017-09-17 Thread Steve Edmonds 
I think in LO you always have to have a line after the table on a page. 
I sometimes make the character height 6 pt to minimise the visual effect.


steve

On 18/09/17 06:42, Ken Springer wrote:

Libre Office 5.3.6.1

Mac OS X 10.11.6 El Capitan

I've been trying to find a way to easily create a table that starts at 
the top margin, ends at the bottom margin, with all rows the same 
height, and not create a blank page at the end of the document.


Can this be done?







--
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] Creating a table with equal sized rows

2017-09-17 Thread Remy Gauthier 
Hi,

You can place the table in a frame that is set to be behind the text on
the page (this will remove the space taken by the paragraph mark after
the table on the page but not in the frame). Anchor the frame to the
page, with the top at 0 cm from the text zone. Place the data in your
table and then spread the rows evenly in the table (from the table
menu). By adjusting the height of your table, you should be able to fit
it between your top and bottom margins. This is the easiest way I can
think of, but it is not straightforward.

I hope this helps.

Rémy Gauthier.

Le dimanche 17 septembre 2017 à 12:42 -0600, Ken Springer a écrit :
> Libre Office 5.3.6.1
> 
> Mac OS X 10.11.6 El Capitan
> 
> I've been trying to find a way to easily create a table that starts at 
> the top margin, ends at the bottom margin, with all rows the same 
> height, and not create a blank page at the end of the document.
> 
> Can this be done?
> 
> 
> 
> 
> -- 
> Ken
> Mac OS X 10.11.6
> Firefox 53.0.2  (64 bit)
> Thunderbird 52.0
> "My brain is like lightning, a quick flash
>   and it's gone!"
> 
> 
-- 
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: LO printing issue, 5.3.6.1

2017-09-17 Thread Al Maloney 
Please see
https://bugs.documentfoundation.org/show_bug.cgi?id=92190 et al

Velox Versutus Vigilans

On Sun, Sep 17, 2017 at 1:37 PM, Ken Springer  wrote:

> I also use the Export to PDF option.  Feels like a lot less work to me!
> LOL
>
> What is curious to me, is how this issue escaped notice in the "stable"
> version, which is meant for those that don't want to deal with issues.
>
> As well as my thread about opening remote files, which I just discovered
> affects more than the remote files I mentioned in my original post.
>
>
>
> On 9/17/17 11:03 AM, Tim-L wrote:
>
>>
>> I get that issue many times with 64-bit DEB version.
>>
>> A lot of the times when I see that issue I do a "trick".  I choose a
>> different printer, then do a "print preview".  After that, I go back to
>> the original printer and look at the print preview option.  Sometimes
>> that works.  Why - who knows.  If it does not work the first time, I try
>> going to a different printer on my network,  Most times the "trick"
>> works after the second try.
>>
>> I have 2 Canon inkjet printers that I use most, and the newest has an
>> internal "filter" deciding what paper tray "IT" wants the document paper
>> type will be printed.  With the "bug" of not allowing the user to choose
>> paper orientation, paper tray, and even paper size, is the biggest issue
>> I have right now.
>>
>> Yes, the orientation issue is a pain to deal with, along with the other
>> printing controls, but there is at least an option to export it it a PDF
>> file and use your PDF document reader and print the document[s] from
>> that package.  It still is a pain to do this. Hopefully the bug will be
>> fixed soon, like other ones that creep up from time to time.
>>
>>
>> On 09/16/2017 09:04 PM, Ken Springer wrote:
>>
>>> Mac OS X 10.11.6
>>>
>>> I create a document in portrait orientation.
>>>
>>> Print Preview is correct.
>>>
>>> PDF export is correct.
>>>
>>> Printing is not.  The document displays and print as landscape.
>>>
>>> Create a landscape document, and printing is correct.
>>>
>>> Bug?
>>>
>>>
>>>
>>>
>>>
>>
>>
>
> --
> Ken
> Mac OS X 10.11.6
> Firefox 53.0.2  (64 bit)
> Thunderbird 52.0
> "My brain is like lightning, a quick flash
>  and it's gone!"
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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] Creating a table with equal sized rows

2017-09-17 Thread Ken Springer 

Libre Office 5.3.6.1

Mac OS X 10.11.6 El Capitan

I've been trying to find a way to easily create a table that starts at 
the top margin, ends at the bottom margin, with all rows the same 
height, and not create a blank page at the end of the document.


Can this be done?




--
Ken
Mac OS X 10.11.6
Firefox 53.0.2  (64 bit)
Thunderbird 52.0
"My brain is like lightning, a quick flash
 and it's gone!"


--
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: LO printing issue, 5.3.6.1

2017-09-17 Thread Ken Springer 

I also use the Export to PDF option.  Feels like a lot less work to me!  LOL

What is curious to me, is how this issue escaped notice in the "stable" 
version, which is meant for those that don't want to deal with issues.


As well as my thread about opening remote files, which I just discovered 
affects more than the remote files I mentioned in my original post.



On 9/17/17 11:03 AM, Tim-L wrote:


I get that issue many times with 64-bit DEB version.

A lot of the times when I see that issue I do a "trick".  I choose a
different printer, then do a "print preview".  After that, I go back to
the original printer and look at the print preview option.  Sometimes
that works.  Why - who knows.  If it does not work the first time, I try
going to a different printer on my network,  Most times the "trick"
works after the second try.

I have 2 Canon inkjet printers that I use most, and the newest has an
internal "filter" deciding what paper tray "IT" wants the document paper
type will be printed.  With the "bug" of not allowing the user to choose
paper orientation, paper tray, and even paper size, is the biggest issue
I have right now.

Yes, the orientation issue is a pain to deal with, along with the other
printing controls, but there is at least an option to export it it a PDF
file and use your PDF document reader and print the document[s] from
that package.  It still is a pain to do this. Hopefully the bug will be
fixed soon, like other ones that creep up from time to time.


On 09/16/2017 09:04 PM, Ken Springer wrote:

Mac OS X 10.11.6

I create a document in portrait orientation.

Print Preview is correct.

PDF export is correct.

Printing is not.  The document displays and print as landscape.

Create a landscape document, and printing is correct.

Bug?










--
Ken
Mac OS X 10.11.6
Firefox 53.0.2  (64 bit)
Thunderbird 52.0
"My brain is like lightning, a quick flash
 and it's gone!"


--
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] LO printing issue, 5.3.6.1

2017-09-17 Thread Tim-L 


I get that issue many times with 64-bit DEB version.

A lot of the times when I see that issue I do a "trick".  I choose a 
different printer, then do a "print preview".  After that, I go back to 
the original printer and look at the print preview option.  Sometimes 
that works.  Why - who knows.  If it does not work the first time, I try 
going to a different printer on my network,  Most times the "trick" 
works after the second try.


I have 2 Canon inkjet printers that I use most, and the newest has an 
internal "filter" deciding what paper tray "IT" wants the document paper 
type will be printed.  With the "bug" of not allowing the user to choose 
paper orientation, paper tray, and even paper size, is the biggest issue 
I have right now.


Yes, the orientation issue is a pain to deal with, along with the other 
printing controls, but there is at least an option to export it it a PDF 
file and use your PDF document reader and print the document[s] from 
that package.  It still is a pain to do this. Hopefully the bug will be 
fixed soon, like other ones that creep up from time to time.



On 09/16/2017 09:04 PM, Ken Springer wrote:

Mac OS X 10.11.6

I create a document in portrait orientation.

Print Preview is correct.

PDF export is correct.

Printing is not.  The document displays and print as landscape.

Create a landscape document, and printing is correct.

Bug?







--
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] Base query - CONCAT function

2017-09-17 Thread Harvey Nimmo 


On Sat, 2017-09-16 at 18:37 +0200, Harvey Nimmo wrote:
> On Sat, 2017-09-16 at 18:31 +0200, Robert Großkopf wrote:
> > 
> > Hi Harvey,
> > > 
> > > 
> > > 
> > > But shouldn't the CONCAT( ' & ', [Partnervorname] ), '' )
> > > actually
> > > return a NULL due to the '' (i.e. not a space, zero length)?
> > 
> > NULL: There is nothing inside, no string, no number, no data ...
> > Empty: Could only be for strings - nothing to see, but its a string
> > with
> > zero length.
> > 
> > Base will save for default all fields without content as NULL, not
> > as
> > fields, which are empty. The difference: You could concatenate
> > empty
> > fields with content of other fields without problems, because it
> > recognizes an empty string. With NULL it won't work.
> > 
> > The Help in LibreOffice and the GUI is missleading here, because
> > Base
> > won't save fields as empty fields but as NULL.
> > 
> > Regards
> > 
> > Robert
> >  
> 
> Thanks, Robert. I had a feeling that would be the answer. Many thanks
> for helping me to clear that up. Your proposed syntax is certainly
> more
> economical than the COALESCE alternative.
> 
> Cheers
> Harvey

Hi Robert,
but as I now have discovered, the COALESCE command is the correct
solution to cope with several alternative syntax combinations by
concatenation. Each CONCAT expression in the COALESCE parameter list
can represent one of the desired syntax combinations, always assuming
that the successive expressions in the parameter list can 'disqualify'
themselves by returning a NULL from CONCAT before reaching the desired
combination. It strikes me as being quite an elegant solution.

Many thanks for your help.

Cheers
Harvey


-- 
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: LO printing issue, 5.3.6.1

2017-09-17 Thread Ken Springer 

That's too bad.  :-(

A printing bug seriously cripples a program, IMO.


On 9/16/17 10:32 PM, Ginterak wrote:

Yes


On Sep 16, 2017, at 5:04 PM, Ken Springer  wrote:

Mac OS X 10.11.6

I create a document in portrait orientation.

Print Preview is correct.

PDF export is correct.

Printing is not.  The document displays and print as landscape.

Create a landscape document, and printing is correct.

Bug?


--
Ken
Mac OS X 10.11.6
Firefox 53.0.2  (64 bit)
Thunderbird 52.0
"My brain is like lightning, a quick flash
 and it's gone!"


--
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] calc macro selected range

2017-09-17 Thread Gary Collins 
Hi
Im writing a macro to replace a number of characters with corresponding 
alternative chars wherever they occur  in strings in a selected cell range. To 
accomplish this im currently calling uno:executeSearch multiple times - once 
for each character that needs to be changed. Problem is, when the first 
character is changed the selected range changes to just those cells that have 
been updated. So what i need is either a way to execute the search and replace 
that leaves the selected range intact OR a way to read the initial selection 
and reset to that selection after search and replace has executed (OR a better 
way to go about this altogether). Can anyone help me out?

Thanks,
Gary

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