Re: [libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

2015-12-15 Thread Don Parris 
On Mon, Dec 14, 2015 at 5:17 AM, Andreas Säger  wrote:

> Am 12.12.2015 um 14:57 schrieb Don Parris:
> > I want to use KAddressBook as the resource for my LibreOffice mailmerge.
> > Unfortunately, the only way this seems possible is by exporting the
> > contacts from KAddressBook to a CSV file.
> >
> > I have searched high and low, and cannot find any good way to use
> > KAddressBook.  The KDE-PIM group seems to offer little help beyond
> > exporting the data.
>
> How did you formulate your question? Can you provide a hyperlink to your
> help request? Did you ask for specific parameters to connect with the
> underlying database?
> Developers don't know anything about LibreOffice except that it has a
> spreadsheet application so they recommend csv because this is what
> everybody does when database data need to be used with non-database
> applications.
>
>


I though my question - posed some time ago now - was quite clear.  I can't
even recall getting an actual reply to my question.  I found a similar
thread via a Google search, but that just basically told the OP to use
import.  It really is difficult to imagine that the KDE-PIM developers
don't know about LibreOffice or its ability to import addresses.  I really
assume it is incumbent on the LibreOffice devs to create the appropriate
tool.  Did the Evolution devs create the LibreOffice tool for accessing its
address book directly?

It really is completely mind-boggling that two prominent projects would
somehow "miss" each other like this.

-- 
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] spreadsheet formulas stopped working

2015-12-15 Thread Tom Davies 
Hi :)
Has the spreadsheet been converted to an MS format such as XlsX and
back again?  Perhaps more importantly has MS Office 2007 been used to
save the Ods file?  Microsoft's support for formats that can be used
by other programs is notoriously weak.
Regards from
Tom :)



On 15 December 2015 at 01:55, RodMyers1960  wrote:
> LibreOffice 5.0.3.2 (pcBSD/FreeBSD)
> LibreOffice 5.0.3.2 (LinuxMint)
>
>
> My spreadsheets formulas have suddenly stopped calculating as they have
> been.
>
> The formulas are to add/subtract money from a previous amount. Basically I'm
> using the spreadsheet as a check book.
>
> as seen in the attached file.
>
> if any monetary amount is changed, the corresponding balance(s) do not
> change.
>
> Any ideas what happened to the spreadsheet, and how to correct it?
>
> Thank you
>
> ledger-2015.ods
> 
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/spreadsheet-formulas-stopped-working-tp4169335.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

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

2015-12-15 Thread Andreas Säger 
Am 15.12.2015 um 17:23 schrieb Don Parris:
> On Mon, Dec 14, 2015 at 5:17 AM, Andreas Säger  wrote:
> I though my question - posed some time ago now - was quite clear.  

But possibly untechnical. Did you ask how you can connect to the
contacts and issue an SQL query such as
  SELECT * FROM CONTACTS
?


-- 
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: Use KAddressBook As LibreOffice Resource

2015-12-15 Thread Andreas Säger 
Am 15.12.2015 um 17:23 schrieb Don Parris:
> 
> It really is completely mind-boggling that two prominent projects would
> somehow "miss" each other like this.
> 

Only a tiny fraction of LO users is aware of database connectivity. Most
users use Base through the mail merge wizard to connect a serial letter
with a spreadsheet. That wizard hides away the whole database thing.
Most software developers never use any office suite.


-- 
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] spreadsheet formulas stopped working

2015-12-15 Thread Brian Barker 

At 11:38 15/12/2015 -0500, Rodney D. Myers wrote:

On Tue, 15 Dec 2015 03:26:27 + Brian Barker wrote:

At 21:01 14/12/2015 -0500, Rodney D. Myers wrote:
My spreadsheets formulas have suddenly stopped calculating as they 
have been. [...]


In order for calculations to be repeated automatically, you have to 
have Tools | Cell Content > | AutoCalculate toggled on.


That was the ticket. I have no recollection of changing this setting.
Thank you for pointing it out


Good-oh!

Incidentally, =SUM(F4;F27) makes sense, as does =F4+F27, but 
=SUM(F4+F27) doesn't: it tries to sum a single value - the result of 
already adding F4 and F27. How about SUM(3) instead of 3? Or 
SUM(SUM(3))? The same applies to =SUM(L25-N26) and =SUM(F29-L29). 
Drop the superfluous "SUM".


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] spreadsheet formulas stopped working

2015-12-15 Thread Rodney D. Myers 
On Mon, 14 Dec 2015 21:01:44 -0500
"Rodney D. Myers"  wrote:

> https://mega.nz/#!jdtFjSyD

Thought I selected no key. 

here's the link to the key






-- 
Rodney D. Myers  - kg6anx

They that can give up essential liberty to obtain a
little temporary safety deserve neither liberty nor safety.
        Ben Franklin - 1759

-- 
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: Use KAddressBook As LibreOffice Resource

2015-12-15 Thread Alexander Thurgood 
Le 12/12/2015 14:57, Don Parris a écrit :

Don,



> This leads to a second, related question (maybe a dev lurking around
> here?):  Why hasn't this been addressed after all these years, with Kontact
> as a fairly widely-used program?  Is it impossible?  what would it take to
> get this resolved???  I can't believe I'm the only frustrated Kontact user
> out here.


There's this old stuff :

http://opensource.bureau-cornavin.com/kab/

No idea whether it still works.

And this :

https://forum.openoffice.org/en/forum/viewtopic.php?f=7=36227

would seem to indicate that the shift to the Akonadi backend hosed
connectivity for everyone - you could always blame the KDE people, or
those involved in the KAB software for choosing a backend that no longer
allowed for interfacing with OOo/LO, but I doubt that would do much good

 ;-)

Alex



-- 
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: Use KAddressBook As LibreOffice Resource

2015-12-15 Thread Alexander Thurgood 
Le 12/12/2015 14:57, Don Parris a écrit :



> This leads to a second, related question (maybe a dev lurking around
> here?):  Why hasn't this been addressed after all these years, with Kontact
> as a fairly widely-used program?  Is it impossible?  what would it take to
> get this resolved???  I can't believe I'm the only frustrated Kontact user
> out here.


Someone requested such support back in 2010 :

http://lists.opensuse.org/opensuse-features/2010-12/msg00142.html

and also :

https://bz.apache.org/ooo/show_bug.cgi?id=113909


Doesn't seem like anything happened there either.

Alex





-- 
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: Envelopes print in wrong orientation

2015-12-15 Thread Erik Jan 

Alan B schreef op 14-12-15 om 14:26:

On Mon, Dec 14, 2015 at 7:53 AM, Philip Jackson 
wrote:


When I dropped Windows for linux about 18 months' ago, I moved to
LibreOffice 4.2.8.2 and saw that LO Writer had inherited the same bug
from OO.

My case involved a standard size European envelope to suit A4 paper
folded into a third (two folds on the long side) - approx 22cm x 11cm.
IIRC, this is the DL envelope in LO and OO.

LibreOffice (and OO) give in this case an unwanted 2" top margin. Your
workaround to correct paper size, adjust top margin, shift the text
boxes, is too much hassle if you've lots of envelopes to do.



Yes, that workaround is too much if envelopes are routinely being printed.
I did the same thing, create a template for #10 envelopes, when I was on LO
3.x. Even though I wasn't making lots of envelopes I seem to recall it was
even harder to get a properly printed envelope than the steps provided in
my response. Creating a template was the only way to consistently get a
properly printed envelope.

Since I've been on LO 5 I've only printed #10 envelopes using the menu
features (didn't bring the template forward to the new installation) and
haven't encountered any bug. I was surprised to see it rear its head when I
did the testing to reply to Bill's message. Since it's happening to you on
a different size perhaps the bug is a component of the envelope size or
maybe the printer setting or a combination.

Regardless, yes it is a very frustrating bug to deal with If I was a
programmer I certainly would try and resolve that one. But I'm not. So
can't do more than identify, develop workarounds, and hope for it to go
away.



Coming from MS Word I was horrified to see that I could not print 
envelopes, because OOo/LO did not permit landscape printing. I found 
that the preset language type for printer was "PDF". When I changed this 
to "Postscript" I could print in Landscape. If this is your problem:


Under "Print" -> "General" -> "Properties of Printer" -> "Apparatus" 
choose "Language Type of Printer": "Postscript Level of printing 
propgram". The alternative is "PDF". If you choose the latter, it is 
impossible to print in Landscape. I am working with the Dutch language 
version, so the choices above might be slightly different.


I hope this helps.

Greetings and good luck.

Erik


--
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] Win 10

2015-12-15 Thread Pedro 

what?? lol

On 12/12/2015 22:21, John Boyle wrote:
To Users: I belong to a computer club, and today we had a presentation 
on WIN 10 and how much of a headache it really is to install, even for 
professionals. I would like to know what version of LibreOffice has 
even a chance to work with WIN 10???





--
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] Source Libre

2015-12-15 Thread Tom Davies 
Hi :)
This link might help even more.  LibreOffice is available in many
languages and this link lets you choose which language you prefer;

http://www.libreoffice.org/download/libreoffice-still/?type=win-x86=4.4=pick

Anne-ology's link gives more choices and can lead to the same place
but my link gives the best (imo) version of LibreOffice and gets you
straight to the language option.
Regards from
Tom :)



On 15 December 2015 at 20:29, anne-ology  wrote:
>If, 1, you are attempting to download LO -
>   then delete what you have
>   then go to libreoffice.org
> 
>   then download whichever version you prefer with whatever options;
>if, 2, you are attempting to add something to LO -
>   then open LO
>   then open whichever particular program you prefer;
>if, 3, you are attempting to view your C: drive -
>   then this is separate from LO;
>if, 4, you are attempting to view your LO folder -
>   go to AppData --> Roaming --> scroll to LO;
>if, 5, you are attempting to view your fonts -
>   you might 'search' fonts which should pull up any folders, ...
> you might have on your machine,
>  or you might open any program - including LO - to view which
> fonts are active,
>
>if something else, then please ask again,
>
>
>
>
> From: victor cordeiro 
> Date: Mon, Dec 14, 2015 at 7:40 AM
> Subject: [libreoffice-users] Source Libre
> To: users@global.libreoffice.org
>
>
> Hi, good mornig.
>
> I need help for download to source libre.
>
> I tried to see the disck ( c :) on my computer, but I found the folder with
> the fonts .
> how do I do?
>
> 
> This
> email has been sent from a virus-free computer protected by Avast.
> www.avast.com
> 
> <#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> --
> 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] Source Libre

2015-12-15 Thread anne-ology 
   If, 1, you are attempting to download LO -
  then delete what you have
  then go to libreoffice.org

  then download whichever version you prefer with whatever options;
   if, 2, you are attempting to add something to LO -
  then open LO
  then open whichever particular program you prefer;
   if, 3, you are attempting to view your C: drive -
  then this is separate from LO;
   if, 4, you are attempting to view your LO folder -
  go to AppData --> Roaming --> scroll to LO;
   if, 5, you are attempting to view your fonts -
  you might 'search' fonts which should pull up any folders, ...
you might have on your machine,
 or you might open any program - including LO - to view which
fonts are active,

   if something else, then please ask again,




From: victor cordeiro 
Date: Mon, Dec 14, 2015 at 7:40 AM
Subject: [libreoffice-users] Source Libre
To: users@global.libreoffice.org


Hi, good mornig.

I need help for download to source libre.

I tried to see the disck ( c :) on my computer, but I found the folder with
the fonts .
how do I do?


This
email has been sent from a virus-free computer protected by Avast.
www.avast.com

<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

-- 
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] spreadsheet formulas stopped working

2015-12-15 Thread Tom Davies 
Hi :)
I think this is a duplicate thread and the duplicate has been
discussed quite comprehensively already, perhaps even solved or nearly
solved.  All good! :)
Regards from
Tom :)



On 15 December 2015 at 16:19, Tom Davies  wrote:
> Hi :)
> Has the spreadsheet been converted to an MS format such as XlsX and
> back again?  Perhaps more importantly has MS Office 2007 been used to
> save the Ods file?  Microsoft's support for formats that can be used
> by other programs is notoriously weak.
> Regards from
> Tom :)
>
>
>
> On 15 December 2015 at 01:55, RodMyers1960  wrote:
>> LibreOffice 5.0.3.2 (pcBSD/FreeBSD)
>> LibreOffice 5.0.3.2 (LinuxMint)
>>
>>
>> My spreadsheets formulas have suddenly stopped calculating as they have
>> been.
>>
>> The formulas are to add/subtract money from a previous amount. Basically I'm
>> using the spreadsheet as a check book.
>>
>> as seen in the attached file.
>>
>> if any monetary amount is changed, the corresponding balance(s) do not
>> change.
>>
>> Any ideas what happened to the spreadsheet, and how to correct it?
>>
>> Thank you
>>
>> ledger-2015.ods
>> 
>>
>>
>>
>> --
>> View this message in context: 
>> http://nabble.documentfoundation.org/spreadsheet-formulas-stopped-working-tp4169335.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] spreadsheet formulas stopped working

2015-12-15 Thread Rodney D. Myers 
On Tue, 15 Dec 2015 17:19:37 +
Brian Barker  wrote:

> Good-oh!
> 
> Incidentally, =SUM(F4;F27) makes sense, as does =F4+F27, but 
> =SUM(F4+F27) doesn't: it tries to sum a single value - the result of 
> already adding F4 and F27. How about SUM(3) instead of 3? Or 
> SUM(SUM(3))? The same applies to =SUM(L25-N26) and =SUM(F29-L29). 
> Drop the superfluous "SUM".
> 
> Brian Barker  

Cool.

This spreadsheet is 4 years old, and from 3.*.* days.

I just clicked on the "sum" button to get the  cells to add/etc. I'll
look them over and attempt to clean up

-- 
Rodney D. Myers  - kg6anx

They that can give up essential liberty to obtain a
little temporary safety deserve neither liberty nor safety.
        Ben Franklin - 1759

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