Re: [libreoffice-users] oooforum.org

[Dave Barton]

 Original Message  
From: Tim Lloyd 
To: users@global.libreoffice.org
Date: Mon, 25 Feb 2013 04:17:56 +0100

> Hi, not an issue with LO but hopefully someone has some feedback.
> 
> I am just flicking through the LO4.0 "getting started" guide and
> there is a reference to http://www.oooforum.org/. When I click on
> that link (fedora/firefox/seamonkey) the browser just sits there and
> eventually times out. Is this address still valid?
> 
> I tried the address in Windows 7 with the same result.
> 
> Cheers

Hi Tim,

The oooforum.org site is still operational, but their server is (at
best) unreliable. Sometimes you can connect without any problem and
other times the connection will time out. I have no idea why this is.

BTW Tom, oooforum.org was never under Sun or Oracle's control and was
established independently from the original OpenOffice.org project.
Neither it is not part of AOO or hosted ASF servers.
Think of it like this:
oooforum.org = The independent, unofficial form.
forum.openoffice.org = The official AOO forum, which offers some support
for LO users.

Regards
Dave


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Finding data at end of column

[Dave Barton]

 Original Message  
From: John R. Sowden 
To: users@global.libreoffice.org
Date: Tue, 26 Feb 2013 10:19:45 -0800

> I create a lot of ledger spreadsheets, including date,doc
> no,item,debit,credit,balance,notes.
> I have a formula in the balance column that tests for data in the item
> column to show the balance otherwise I put a space there
> [=if(c23="";"";g22+d23-e23)], so the balance does not display down the
> page.
> 
> That said, I am trying to figure out how to put the last amount (not
> space) in the balance column  in a formula to display the balance at the
> top of the screen, refer to it in a consolidated sheet, etc.
> 
> tia,
> John

Hi John,

For a range A1:A10 you could use =INDEX(A1:A10,COUNT(A1:A10)) in the
target cell.

HTH

Dave


-- 
For unsubscribe instructions e-mail to: users+h...@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] =IF Function

[Dave Barton]

 Original Message  
From: Tinkerer 
To: users@global.libreoffice.org
Date: Wed, 13 Mar 2013 04:03:55 -0700 (pdt)

> Using Mac 10.8.2 and Libre 4.0.1, I find that the the IF function does not
> place a blank space as the second option.
> Have I done something insanely stupid, or is this a bug?
> Where I should get blank cells I am getting:   #DIV/O!
> 
> ASTest.ods   
> 
> Tests and comments please.
> 
> Tink.

Using the formula in G10 as an example:
=IF(C10*100/B10>0,C10*100/B10,"")
C10 is empty (zero value)
B10 is empty (zero value)
So zero * 100 / zero = Divide by zero error.

One possible alternative (other tests could be added):
=IF(B10<>"",(C10*100/B10>0,C10*100/B10,""))

Dave




-- 
For unsubscribe instructions e-mail to: users+h...@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] Hyperlink Bug in calc - bug 62289

[Dave Barton]

Tanstaafl wrote:
> Hi everyone,
> 
> Would appreciate if some of you could confirm this bug for me.
> 
> I'm on Windows XP sp3, with LibreOffice 4.0.1 release...
> 
> https://bugs.freedesktop.org/show_bug.cgi?id=62289
> 
> Bug report:
> 
> A hyperlink defined on one worksheet that is linked to another sheet/tab
> in the same workbook that is named only with a number, when clicked,
> takes you to the ROW NUMBER in the same sheet, instead of the desired
> sheet.
> 
> Steps to reproduce:
> 
> 1. Create a new/blank worksheet
> 
> 2. Create an additional sheet
> 
> 3. Rename the sheet to any number
> 
> 4. Add a hyperlink in sheet1, and make the target the other sheet that
> has a number for the name
> 
> 5. Click the hyperlink
> 
> 6. Instead of taking you to the desired sheet, you go to the ROW that
> has the same number as the sheet you are trying to go to.
> 

Confirmed.
Version 4.0.1.2 (Build ID: 84102822e3d61eb989ddd325abf1ac077904985)

Dave


-- 
For unsubscribe instructions e-mail to: users+h...@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] Duden Korrektor?

[Dave Barton]

On the Releases Notes page for 4.0.4rc1
https://wiki.documentfoundation.org/Releases/4.0.4/RC1 under the
installation notes for Windows it says: "Duden Korrektor will work with
this version only if you put the stlport_vc7145.dll from 3.6.x
installation somewhere in your %PATH%. Note that you will have to have
also MSVCR90.DLL installed on your system."

Duden Korrektor seems to be something in German, but the best
translation to English I can get is something like "Google Corrector".
What does "Duden Korrektor" mean in English?

This is a Release Candidate not a developer snapshot, so why are we
asking end users, willing to test our proposed release, to move dlls
around and make additions to the %PATH% ?

Dave



-- 
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] Recent Documents List

[Dave Barton]

 Original Message  
From: Dr. R. O Stapf 
To: users@global.libreoffice.org
Date: Wed, 12 Jun 2013 10:33:34 +0900

> 
> On 12.06.2013 07:22, Steve Edmonds wrote:
>>
>> On 2013-06-12 10:15, Dan Lewis wrote:
>>> On 06/11/2013 11:53 AM, Mirosław Zalewski wrote:
 On 11/06/2013 at 16:09, Tom Davies  wrote:

> Does anyone remember how to fix the list of recent documents to be
> longer
> than 10?
 I don't know how to "fix" list of recent documents, but if you want
 to have
 access to more than 10 documents, you might want to have a look at this
 message:
 
>>>  I just looked at this link. Then I looked for the file:
>>> registrymodifications.xcu. While it exists in the User folder of the
>>> configuration files, I did not find the item >> oor:path="/org.openoffice.Office.Common/History". Nor could I locate
>>> . This is true for
>>> LibreOffice 3.6.6 and 4.0.3. What line is this found in this file?
>>>  Any other suggestions?
>>>
>>> --Dan
>>>
>> Hi. I used to (may be back at 2.4) edit an xcu file to increase
>> history length to 32. Then they changed something in LO that made it
>> impractical so now I use History Master that is an easier way.
>> steve
>>
> Could you please explain the way you used the History Master to obtain a
> longer recent file list?

http://bernard.marcelly.perso.sfr.fr/HM/index.html




-- 
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] How do I find a font called "Cloister"?

[Dave Barton]

John Boyle wrote:
> To Users: I had that font, at one time, but when I upgraded to libre
> office 4, I seem to have lost it. I would like to know where I can go
> and download just one font, not 1000 fonts which I do not need?

A Google search for "cloister font free download" (sans quote marks),
will return thousands of links to what you want.

HTH

Dave


-- 
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] How do I find a font called "Cloister"?

[Dave Barton]

Hi John,

Based on your email header you appear to running a 64bit edition of
Windows 7. If this is correct, you don't add fonts to LO, because LO
will use fonts installed on your Windows system.

The file you downloaded was either a zip file containing one or more TTF
(TrueType Font) files or just a single TTF file. If it is zip file,
extract (unzip) the contents to a suitable directory (folder) on your
computer. This could be the same directory you downloaded the file to.

Use Windows Explorer (eg. My Computer in the start menu) to locate the
TTF file(s) and follow the Windows Help instructions:

To install a font: Right-click the font you want to install and click
Install.
You can also install a font by dragging it into the Fonts Control Panel
page.

Dave

 Original Message  
From: John Boyle 
To: users@global.libreoffice.org
Date: Mon, 17 Jun 2013 12:24:15 -0700

> To Dave Barton,et al: I managed to download the font or at least the
> installer, but now cannot figure out how to get it into LO? I am not
> really sure I got anything beyond the installer, though?
> On 6/16/2013 11:17 PM, Dave Barton wrote:
>> John Boyle wrote:
>>> To Users: I had that font, at one time, but when I upgraded to libre
>>> office 4, I seem to have lost it. I would like to know where I can go
>>> and download just one font, not 1000 fonts which I do not need?
>> A Google search for "cloister font free download" (sans quote marks),
>> will return thousands of links to what you want.
>>
>> HTH
>>
>> Dave
>>
>>
> 


-- 
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] Auto-sort group of cells when any cell is modified/saved?

[Dave Barton]

Johnny Rosenberg wrote:
> 2013/7/11 Errol Goetsch :
>> Hi all
>>
>> You can get to a auto-sorted table in 4 steps without macros by using
>> vlookup, hlookup, count, max and min.
>> Ive sent Charles a working example for 20 salespeople over 12 months, where
>> the duplicate list re-sorts as soon as the YTD total changes.
> Why not upload it somewhere and give us the link? Maybe someone else
> want to study it. Me, for instance

>
>
> Johnny Rosenberg

+1

Dave




-- 
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] Notes in Impress vs. PowerPoint

[Dave Barton]

Hi Jeff,

Sorry you got a less than welcoming response to your question on the
Apache list, but let's see what we can do to help you.

My suggestions are given in-line with your original message.

 Original Message  
From: Jeffrey Deutsch 
To: users@global.libreoffice.org
Date: Sat, 27 Jul 2013 23:49:03 -0400

> Hello,
> 
> My wife is willing to consider converting to LibreOffice 4
> permanently. Here's her major issue, in two parts:
> 
> (1) She does not know how to start or use Notes in LibO Impress (the
> presentation part).

It's not clear to me what you mean by "how to start or use Notes".
You will find it helpful to read the "Getting Started" and "User"
guides, available from:
http://www.libreoffice.org/get-help/documentation/
Specific information about Notes can be found in chapter 8 of the
Impress User Guide:
http://www.odfauthors.org/libreoffice/english/impress-guide/published-lo-4.0/ig4-0-ch8-adding-and-formatting-slides-notes-and-handouts/view

> (2) When she starts (and saves) Notes in PowerPoint, and then works on
> the presentation in LibO -- even if she does not touch the Notes while
> in LibO -- when she re-opens the presentation in PowerPoint the Notes
> are all fouled up every which way.
> 
> When she uses LibO, it's version 4.0, on Windows 7 Home Premium, and
> she saves the file as PowerPoint 2007/2010 (.pptx). And she uses
> PowerPoint 2010, also on Windows (she thinks Windows 7 for Government
> but is not certain).

Unfortunately, MS XML file formats are something of a moving target.
Although there have been many improvements in LO/MS XML compatibility
there is still work to be done.

As previously suggested to you by Clarence M Weaver, try using the older
".ppt" format to move presentations between Powerpoint and Impress.
Clarence & I have both tested this and it appears to be a reliable
work-around.

> What does she need to do?
> 
> Thank you very much!
> 
> Jeff Deutsch

Hope this helps.

Dave




-- 
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] Fixing Printing Paper Defaults

[Dave Barton]

 Original Message  
From: Budgie 
To: users@global.libreoffice.org
Date: Thu, 01 Aug 2013 22:54:28 +0100

> Hi, my first post here.
> 
> I am presently running LibreOffice 3.5:build-413, Build ID:
> 350m1(Build:413) on OS:  Linux 3.4.47-2.38-desktop x86_64, System:
> openSUSE 12.2 (x86_64) and KDE:  4.8.5 (4.8.5) "release 2"openSUSE 12.2
> desktop.  I know there is a more recent LO version but not on openSUSE
> 12.2 repo site.
> 
> I have just had to start using LO as my usual word processor Lotus
> WordPro (on OS/2 Warp 4.5) is not available as machine is under repair.
> 
> My main use of LO will be for business correspondence and I need some
> help with templates.  In WordPro my template has company details in the
> header but I am able to supress this on the second and subsequent
> sheets.  Is it possible to do this in LO and if not how do I achieve the
> same objective of having different header (blank) on sheets 2 onwards.
> Also how do I keep numbering in footer correct?
> 
> Budge

Welcome Budge,

What you need to do is have two separate "Page Styles", one for the
first page and one for the remaining pages. See:
https://help.libreoffice.org/Writer/Creating_and_Applying_Page_Styles
For more detailed information see chapters 6 & 7 of the Writer User
Guide: https://www.libreoffice.org/get-help/documentation/
or:
http://www.odfauthors.org/libreoffice/english/writer-guide/published-lo-3.6
Once you have created the styles with the first page header, etc. save
the document layout as a template. Chapter 10 of the Writer User Guide
covers templates.

Hope this helps.

Dave



-- 
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: connecting to oooforum.org

[Dave Barton]

Tom,

Undoubtedly you post with the best of intentions, but please stop
jumping in with confusing misinformation.

There are two entirely separate forums:

1. http://www.oooforum.org The independent "unofficial" one Jim was
referring to. For reasons nobody has been able to explain, their server
is at best unreliable and frequently times out.

2. http://forum.openoffice.org/en/forum/ The "official" one Apache
inherited from OpenOffice.org which you are referencing.

Dave


Tom Davies wrote:
> Hi :)
> I think it might perform better if you go to the link i gave and do your 
> search from inside their forums.  That way you might dodge any links with 
> domains that might have changed.  Outside of their forums search engines may 
> still be giving old links.  
> Regards from 
> Tom :)  
>
>> 
>> From: Tim Lloyd 
>> To: Jim Byrnes ; "users@global.libreoffice.org" 
>>  
>> Sent: Tuesday, 13 August 2013, 4:16
>> Subject: [libreoffice-users] Re: connecting to oooforum.org
>>
>>
>> Hi Jim,
>>
>> I didn't realise this had cropped up before - pretty sad as I logged the 
>> first message! I have attached a link to when this was discussed back in 
>> February
>>
>> http://nabble.documentfoundation.org/oooforum-org-td4039871.html#a4040074
>>
>> BTW, link not working for me at present either
>>
>> Cheers
>>
>> On 08/13/2013 01:09 PM, Jim Byrnes wrote:
>>> On 08/12/2013 07:54 PM, Tim Lloyd wrote:
 Jim,

 I don't really use that forum but if you can send the link I will give
 it a go

 Cheers

 On 08/13/2013 10:42 AM, Jim Byrnes wrote:
> Is anyone else having trouble connecting to oooforum.org or is just me?
>
> Been doing a lot of googling trying to figure out how to write some
> python macros in LO calc and many links lead to posts on oooforum.org.
> Lately everytime I try one it times out.
>
> Regards,  Jim
>
>

>>> I don't use it either, this is a link to an archived post.
>>>
>>> http://www.oooforum.org/forum/viewtopic.phtml?p=56015#56015
>>>
>>> Thanks,  Jim



-- 
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: connecting to oooforum.org

[Dave Barton]

Andrew Douglas Pitonyak wrote:
> 
> On 08/13/2013 02:32 AM, Dave Barton wrote:
>> 1. http://www.oooforum.org The independent "unofficial" one Jim was
>> referring to. For reasons nobody has been able to explain, their server
>> is at best unreliable and frequently times out.
> oooforum was setup and is controlled by a single very busy person with
> no help from anyone else in any way. So, it uses resources available to
> this person and is maintained by this person. The other forum is
> maintained by a group of volunteers so there are more people to fix it.

Yes Andrew, I am fully aware of the history behind oooforum.org and the
number of times in 10+ years the owner has refused outside help. You & I
both remember in the early days of OOo it was proposed to merge the two
forums and Ed would not even join in the discussion. He may well be a
very busy person and as you observe in another post "you could call it a
sentimental attachment", but over the years users have contributed a
vast amount of useful material, which is all too frequently locked away
from other users because of his personal workload and/or sentimentality.

My original reply was not intended as a criticism, it was just note to
indicate that one of the two longest established forums was not always
accessible.



-- 
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] shifting focus to licencing

[Dave Barton]

Nino Novak wrote:
> Am 14.08.2013 18:39, schrieb Dave Barton:
>> Andrew Douglas Pitonyak wrote:
>>> On 08/13/2013 02:32 AM, Dave Barton wrote:
>>>> 1. http://www.oooforum.org The independent "unofficial" one Jim was
>>>> referring to. For reasons nobody has been able to explain, their server
>>>> is at best unreliable and frequently times out.
>>> oooforum was setup and is controlled by a single very busy person with
>>> no help from anyone else in any way. So, it uses resources available to
>>> this person and is maintained by this person. The other forum is
>>> maintained by a group of volunteers so there are more people to fix it.
> so this looks to me like people have contributed to a site which took
> their knowledge but later did (or does) not present it back to the
> public in a satisfactory way.

Based on my years of experience as a user of the site, I seriously doubt
that this was/is the owner's intention.

> Two thoughts:
>
> 1 - Does the owner sufficently understand the public need for high
> availability of the forum's content?

I am convinced that he does. The problem appears to be twofold:
  1. His personal workload prevents him from giving sufficient attention
to server administration and spam elimination.
  2. His reluctance to accept much (if any) outside assistance.

> 2 - How is the forum's content licenced?

I have never found any notice on the site to indicate what the content
licence is. IANAL, but the absence of such I notice and no mention of
content licensing in the "Registration Agreement Terms", would lead me
to believe the content is public domain, just like this email.

> Nino

The good news is that the site is currently accessible, albeit with the
usual amount of spam adorning the main page.

Dave



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

[Dave Barton]

Kunwar Shivpal Singh wrote:
> Hi ALL
> 
> I am just a user & ardent fan of LO.
> 
> I came across a problem in LO - cant say whether its with my computer or
> LO. Version i have is the latest 4.1.
> 
> Spelled check in Calc & the moment opted for the suggested correction
> Calc crashed.
> 
> The file was recovered, tried the same thing again with the same result.
> did this atleast 5 - 6 times with the same result - crash & recovery
> with the word not getting replaced.
> 
> Hope you can suggest the shortcomings in my computer if the problem is
> due to this. If it is due to some shortcoming in LO request you to pls
> fix it.
> 
> Thanks
> Kr. Shivpal Singh

It is a known issue. Please see:
https://bugs.freedesktop.org/show_bug.cgi?id=68220

Regards
Dave



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

[Dave Barton]

Please address any reply to the users@global.libreoffice.org list, not
directly to me. There are many knowledgeable subscribers to this list,
who may be able to provide better answers than myself.

My responses are given in-line with your original message.

 Original Message 
From: Kunwar Shivpal Singh 
To: Dave Barton 
Date: Tue, 20 Aug 2013 11:11:07 +0530
> Thanks Dave,
>
> but as already mentioned in my mail, I am just a user not very tech
> savvy to understand all this. I feel it is ultimately users like me
> who will count & are the final segment where LO has to be propogated.

Other than being subscribed to this mailing list (see:
https://www.libreoffice.org/get-help/mailing-lists/), my status is no
different to yours (ie. an ordinary user of the software).

> I request if you could guide me on how to fix this problem.

At this time there is no work-around (what you call "fix") for this
issue, that I could suggest to you.

> Went to the link given in your mail. From there to another which said
> fixed by Coalan Mcnamara, but could make head or tail of all that.

The link to "Bugzilla" gave you, is where the project records and
monitors software issues and RFE (Requests For Enhancement). Coalan is
one of the project's leading developers and the "fixed" tag indicates
that he has worked on and resolved this issue. After "peer review" the
"fix" will be included in the next update/release of the software.

> Does'nt Lo send updates to set such things right or anything which
> ordinary users like me could download & install & that settles the
> issue.   
>
> regards
> Kr. Shivpal Singh

Your closing commentary insinuates that project members (including the
developers) do not care about us "ordinary users". Nothing could be
further from the truth.

Yes LO does provide updates and on a much more frequent and regular
schedule than other similar software. What you need to understand is
that the developers are resolving many issues (like this one) and adding
improvements every day, and it would be impossible to update/release a
new version every time a single issue was resolved.

According to this page https://wiki.documentfoundation.org/ReleasePlan
the next update/release (which should include the "fix" for your issue)
is due in a matter of days.

Regards
Dave

> On 20-08-2013 00:24, Dave Barton wrote:
>> Kunwar Shivpal Singh wrote:
>>> Hi ALL
>>>
>>> I am just a user & ardent fan of LO.
>>>
>>> I came across a problem in LO - cant say whether its with my computer or
>>> LO. Version i have is the latest 4.1.
>>>
>>> Spelled check in Calc & the moment opted for the suggested correction
>>> Calc crashed.
>>>
>>> The file was recovered, tried the same thing again with the same result.
>>> did this atleast 5 - 6 times with the same result - crash & recovery
>>> with the word not getting replaced.
>>>
>>> Hope you can suggest the shortcomings in my computer if the problem is
>>> due to this. If it is due to some shortcoming in LO request you to pls
>>> fix it.
>>>
>>> Thanks
>>> Kr. Shivpal Singh
>> It is a known issue. Please see:
>> https://bugs.freedesktop.org/show_bug.cgi?id=68220
>>
>> Regards
>> Dave
>>
>>
>>



-- 
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] Automatic Capitalization of First Word

[Dave Barton]

 Original Message  
From: Dale Erwin 
To: users@global.libreoffice.org
Date: Sat, 07 Sep 2013 17:09:37 -0500

> I know I have done this before, but I can't remember now where I found
> the setting.  I would like to disable the capitalization of the first
> word in a sentence or paragraph.
> 
> I am not sure if I am subscribed to this list.  I send an empty message
> to users+subscr...@global.libreoffice.org but I never received the
> confirmation mail.

Hi Dale,

What you are looking for is the: "Format -> AutoCorrect -> AutoCorrect
Options..." menu entry.

In the "AutoCorrect" dialog click the "Options" tab and untick/uncheck
the "Capitalize first letter of every sentence".

Just in case you are not subscribed I have cc'd you with an small screen
capture attached.

Regards
Dave



-- 
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] Date format macro.

[Dave Barton]

 Original Message  
From: rhubarbpie...@gmail.com
To: users@global.libreoffice.org
Date: Thu, 19 Jul 2012 16:48:53 -0500

> 
> I'd like to create a macro for a user-defined date format (H:MMa/p).  As
> examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p.  I can
> create the format manually, but I understand the LibreOffice format
> can't save user-defined formats.  So my thought is to create a macro
> which creates the format each time the spreadsheet is opened.  The
> user-defined Format Code is for a saved Style.
> 
> The macro records without incident and the date format is correct.
> However, running the saved macro doesn't change the format.  It seems
> this should work.  Thoughts?  The recorded macro is as follows:
> 
> sub FormatTime
> rem --
> rem define variables
> dim document   as object
> dim dispatcher as object
> rem --
> rem get access to the document
> document   = ThisComponent.CurrentController.Frame
> dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
> 
> rem --
> dim args1(0) as new com.sun.star.beans.PropertyValue
> args1(0).Name = "ToPoint"
> args1(0).Value = "$D$13"
> 
> dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())
> 
> rem --
> dim args2(0) as new com.sun.star.beans.PropertyValue
> args2(0).Name = "DesignerDialog"
> args2(0).Value = true
> 
> dispatcher.executeDispatch(document, ".uno:DesignerDialog", "", 0, args2())
> 
> rem --
> rem dispatcher.executeDispatch(document, ".uno:EditStyle", "", 0, Array())
> 
> rem --
> dim args4(0) as new com.sun.star.beans.PropertyValue
> args4(0).Name = "DesignerDialog"
> args4(0).Value = false
> 
> dispatcher.executeDispatch(document, ".uno:DesignerDialog", "", 0, args4())
> 
> 
> end sub

Sorry I can't help with your macro, but I like your idea.
An alternative approach I use, is to add my user defined date format to
my Calc default template.

Dave


-- 
For unsubscribe instructions e-mail to: users+h...@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] Date format macro.

[Dave Barton]

 Original Message  
From: rhubarbpie...@gmail.com
To: users@global.libreoffice.org
Date: Fri, 20 Jul 2012 20:33:27 -0500

> On 07/20/12 02:16, Dave Barton wrote:
>>  Original Message  
>> From: rhubarbpie...@gmail.com
>> To: users@global.libreoffice.org
>> Date: Thu, 19 Jul 2012 16:48:53 -0500
>>
>>> I'd like to create a macro for a user-defined date format (H:MMa/p).  As
>>> examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p.  I can
>>> create the format manually, but I understand the LibreOffice format
>>> can't save user-defined formats.  So my thought is to create a macro
>>> which creates the format each time the spreadsheet is opened.  The
>>> user-defined Format Code is for a saved Style.
>>>
>>> The macro records without incident and the date format is correct.
>>> However, running the saved macro doesn't change the format.  It seems
>>> this should work.  Thoughts?  The recorded macro is as follows:
>>>
8<-- code snip for brevity -->8
>> Sorry I can't help with your macro, but I like your idea.
>> An alternative approach I use, is to add my user defined date format to
>> my Calc default template.
>>
>> Dave
>>
>>
> Thank you for responding; I admire your style. I manually changed the
> date format of my spreadsheet, saved , then coded it as the default
> template. The default template took, but unfortunately, again the
> user-defined date format wasn't saved.
> 
> 
> Do I understand you can save a user-defined date format in the default
> template and it takes? I'm sure a macro would work and I can wade
> through the code, but if there's an easier way I'm interested.

I am not sure what you mean by "coded it as the default  template".
If you follow this procedure:
http://user.services.openoffice.org/en/forum/viewtopic.php?t=1161
the ".ots" (Calc template) file will include your date format, as would
be the case for any ODF file.
I am sending you (off-list) an example template which has a DD.MM.
date format, which is not included in standard list of date formats.
Open it and you will find 31.12.1999 at the end of the Format => Date ->
Category format list.

HTH

Dave


-- 
For unsubscribe instructions e-mail to: users+h...@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] Date format macro.

[Dave Barton]

 Original Message  
From: rhubarbpie...@gmail.com
To: Dave Barton 
Date: Sat, 21 Jul 2012 12:59:52 -0500

> On 07/21/12 00:45, Dave Barton wrote:
>>  Original Message  
>> From: rhubarbpie...@gmail.com
>> To: users@global.libreoffice.org
>> Date: Fri, 20 Jul 2012 20:33:27 -0500
>>
>>> On 07/20/12 02:16, Dave Barton wrote:
>>>>  Original Message  
>>>> From: rhubarbpie...@gmail.com
>>>> To: users@global.libreoffice.org
>>>> Date: Thu, 19 Jul 2012 16:48:53 -0500
>>>>
>>>>> I'd like to create a macro for a user-defined date format
>>>>> (H:MMa/p).  As
>>>>> examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p.  I can
>>>>> create the format manually, but I understand the LibreOffice format
>>>>> can't save user-defined formats.  So my thought is to create a macro
>>>>> which creates the format each time the spreadsheet is opened.  The
>>>>> user-defined Format Code is for a saved Style.
>>>>>
>>>>> The macro records without incident and the date format is correct.
>>>>> However, running the saved macro doesn't change the format.  It seems
>>>>> this should work.  Thoughts?  The recorded macro is as follows:
>>>>>
>> 8<-- code snip for brevity -->8
>>>> Sorry I can't help with your macro, but I like your idea.
>>>> An alternative approach I use, is to add my user defined date format to
>>>> my Calc default template.
>>>>
>>>> Dave
>>>>
>>>>
>>> Thank you for responding; I admire your style. I manually changed the
>>> date format of my spreadsheet, saved , then coded it as the default
>>> template. The default template took, but unfortunately, again the
>>> user-defined date format wasn't saved.
>>>
>>>
>>> Do I understand you can save a user-defined date format in the default
>>> template and it takes? I'm sure a macro would work and I can wade
>>> through the code, but if there's an easier way I'm interested.
>> I am not sure what you mean by "coded it as the default  template".
>> If you follow this procedure:
>> http://user.services.openoffice.org/en/forum/viewtopic.php?t=1161
>> the ".ots" (Calc template) file will include your date format, as would
>> be the case for any ODF file.
>> I am sending you (off-list) an example template which has a DD.MM.
>> date format, which is not included in standard list of date formats.
>> Open it and you will find 31.12.1999 at the end of the Format => Date ->
>> Category format list.
>>
>> HTH
>>
>> Dave
>>
>> .
>>
> Thank you again for responding.  However, I think we're talking apples
> and oranges.  I opened your template and the DD.MM. user-defined
> format works.  My problem is I can't get the H:MMa/p user-defined Format
> Code to take.  While the document is opened I can change 1:11PM to 1:11p
> for instance.  However, after saving, closing, and reopening the
> document the time appears as 1:11PM, not 1:11p, which is the format code
> I wanted saved.  I've always been able to save the user-defined code, I
> just can't get the lower-case a/p to take.  It does work with other file
> formats.
> 
> That happens regardless of whether I save as an .ods or .ots file. I do
> see the user-defined Format Code, but it always comes up as H:MMAM/PM
> even though I save it as H:MMa/p.  I believe I originally created a
> default template correctly, but just redid the process with your
> instructions.  The same thing happens if I save the format in your
> attached template.
> 
> So, can you successfully save the H:MMa/p format code?  That would
> address the apples/oranges question.  I'd appreciate your testing that
> if possible.  If it works for you I'm doing something wrong. It's not a
> huge deal to manually change AM/PM to a/p each time I open the
> spreadsheet, but not having to do so would be better.

Your "apples & oranges" analogy is correct. I was misled by your
original reference to "Date" format and although you spelled it out
quite clearly I overlooked the fact that your issue was with "Time" format.

I have now done some testing on this issue, with the following results:
* Saving from LO in ODF (".ods" or ".ots") format does not preserve the
user defined time format you want. (As you have already established.)
* Saving from LO 

[libreoffice-users] LibreOffice Kills Windows Explorer

[Dave Barton]

I suddenly started getting reports from some of my LO 3.6 users that
Windows Explorer randomly crashed when they went to open an ODF file and
my own tests confirmed this to be true for all Windows versions from XP
through 7 both 32 & 64 bit.

I think I am experiencing something related to this bug:
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=53534 but before I
start escalating this report, or opening a new one, I would like to get
feedback on other users experience of this issue.

If you have LO 3.6.0 or 3.6.1 installed, open Windows Explorer and
browse for any ODF file, hover the cursor over the file and wait for the
tool/file tip to appear, this is when Windows Explorer might crash. I
say "might", because it does not occur on all ODF file types, Base
".odb" files seem to generate the crash more frequently than others. If
you can capture the crash report, it will clearly show that the culprit
is either:
C:\Program Files\LibreOffice 3.6\program\shlxthdl\shlxthdl.dll
or
C:\Program Files (x86)\LibreOffice 3.6\program\shlxthdl\shlxthdl_x64.dll

Apologies for cross posting, but I think this is a critical issue,
because we do not want LO to get the reputation of an application that
kills core OS services.

Dave


-- 
For unsubscribe instructions e-mail to: users+h...@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: Sun dll shlxthdl and windows explorer.exe crash

[Dave Barton]

V Stuart Foote wrote:
> Probably related to the LibreOffice's Windows Explorer extension
>
> Most issues fixed with 3.6.1 build.
>
> Ref these bugzilla reports:
>
> https://bugs.freedesktop.org/show_bug.cgi?id=52078
> https://bugs.freedesktop.org/show_bug.cgi?id=53533
>
> Install a current Java JRE and LO 3.6.1 and should resolve.
>
> Stuart


Unfortunately, this is not the solution. LO Version 3.6.1.2 (Build ID:
e29a214) still kills Windows Explorer when the mouse is hovered over
some ODF file names. It make no difference if Java is installed or not.

Dave



-- 
For unsubscribe instructions e-mail to: users+h...@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] usb crashes explorer

[Dave Barton]

Simon Warner wrote:
> When I try to copy a Libre Office Writer file off my usb key it crashes
> windows explorer.
> The log file blames LibreOffice. See below
> ==
> Faulting application name: Explorer.EXE, version: 6.1.7601.17567, time
> stamp: 0x4d672ee4
> Faulting module name: shlxthdl_x64.dll, version: 3.6.1.2, time stamp:
> 0x5034bc94
> Exception code: 0xc005
> Fault offset: 0x0001b1bf
> Faulting process id: 0x3c0
> Faulting application start time: 0x01cd9797a664be0d
> Faulting application path: C:\windows\Explorer.EXE
> Faulting module path: C:\Program Files (x86)\LibreOffice
> 3.6\program\shlxthdl\shlxthdl_x64.dll
> Report Id: f6b22737-038a-11e2-a1b9-00245487be84
>

Yes it is a known bug in 3.6.1 which appears to have been fixed in 3.6.2
RC1.

Dave


-- 
For unsubscribe instructions e-mail to: users+h...@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 crashes IE?

[Dave Barton]

 Original Message  
From: Jay Lozier 
To: users@global.libreoffice.org
Date: Sun, 30 Sep 2012 11:32:43 -0400

> On 09/30/2012 07:46 AM, Thomas Blasejewicz wrote:
>> Good evening
>> I am struggling to make a certain CAT tool (memoQ) work with very
>> complex (crazy) Word files.
>> Since that did not work, I tried to save a file as ODF file and use that.
>> Apart from the trouble I have otherwise ...
>>
>> When I click in Internet Explorer on that particular file to copy / move
>> / delete etc. it ...
>> Explorer hangs (crashes) and tells me, it is not responding.
>> This happens even if I restart the computer and NO OTHER software except
>> IE is running.
>> And this happens ONLY with this particular LO file.
>> It is not a "read only" file.
>> LO officed files stored in their specific folder do not cause problems.
>>
>> The above file ... when I want to delete it, the only way to accomplish
>> that is to open LO Writer,
>> click file open -> select that file and then hit "Del".
>> File location (desktop, any drive, any folder) has no influence on this
>> behavior.
>>
>> Has anybody any idea what this strange behavior may be due to?
>> Can possibly offer a solution?
>>
>> Thank you.
>> Thomas
>>
> Thomas
> 
> I think you mean Windows Explorer, the MS file manager. Are getting any
> specific error message? When you open the file with LO can you save it
> to another location?
> 
> I am not sure what is causing the problem. Hopefully someone more
> knowledgeable about Windows quirks can advise.

If as Jay suggests you mean Windows Explorer, not Internet Explorer and
you have version 3.6.1 installed, you are encountering a known bug in
LO's Windows shell extension shlxthdl.dll or shlxthdl_x64.dll. The issue
has been resolved in version 3.6.2.x

Some possible options are:
o Run the installer in repair mode and untick/uncheck the shell
extension option.
o Revert to the 3.5.x series.
o Install 3.6.2 RC2 (Not recommended for production use, but I have been
hammering fairly hard and not discovered any show stoppers. Yet!)

Dave



-- 
For unsubscribe instructions e-mail to: users+h...@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 4.0.0.3 has no printer in Win7 - SHOW STOPPER

[Dave Barton]

webmaster-Kracked_P_P wrote:
>
> I just installed 4.0.0.3 on my Win7 laptop.
>
> It will not show anyprinters at all.  Claims there is noneis installed.
>
> 4.0.0.2 does prints fine, but 4.0.0.3 does not.
>
> This is a Show Stopper.
>

Just installed 4.0.0.3 over 4.0.0.2 on a Win 7 laptop and printing works
perfectly.

-- 
For unsubscribe instructions e-mail to: users+h...@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] page down in word processors - find next

[Dave Barton]

 Original Message  
From: bill 
To: users@global.libreoffice.org
Date: Fri, 15 Feb 2013 16:59:03 -0500

> 
> I am keeping the same thread as it is closely related. The one thing
> that I really don't like is that as soon as you do a search the page
> down button becomes "continue search forward" and the page up becomes
> "continue search backwards."  That is fine while you are searching,
> but how does one return it to page up and page down ?
> 
> 
> --Bill Drescher william {at} TechServSys {dot} com

Which version of LO are you using? I would really like to have that
facility.

Maybe the 'Esc' key would return the paging key to normal operation.

Dave



-- 
For unsubscribe instructions e-mail to: users+h...@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] stopping superscript text in Calc

[Dave Barton]

8<-- snip -->8

> -Oorspronkelijk bericht- From: John R. Sowden
> Sent: Friday, October 11, 2013 8:21 PM
> To: users@global.libreoffice.org
> Subject: [libreoffice-users] stopping superscript text in Calc
>
> Been having the problem for a long time.  Using Calc, I write a date,
> Oct 23rd, (I add the rd which shows as a superscript. Problem is
> whenever I add new text to the cell, it is in the superscript size, not
> regular text.
>
> John
>
>
>
> I took the list's advise of turning off the superscript function. If 
> enough people are aggravated by the anomaly, it will be adjusted.
>
> Thanks,
> John

Just for the record, it is not necessary to follow John's more extreme
solution.

For recent versions of LO (eg. 4.1.2.3) placing a full stop/period/dot
or comma immediately after the superscript rd reverts any following text
to normal size.

Dave



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

[OT] Re: [libreoffice-users] stopping superscript text in Calc

[Dave Barton]

Tim Deaton wrote:
> On 10/13/2013 4:11 PM, Dave Barton wrote:
>> 8<-- snip -->8
>>
>>> -Oorspronkelijk bericht- From: John R. Sowden
>>> Sent: Friday, October 11, 2013 8:21 PM
>>> To: users@global.libreoffice.org
>>> Subject: [libreoffice-users] stopping superscript text in Calc
>>>
>>> Been having the problem for a long time.  Using Calc, I write a date,
>>> Oct 23rd, (I add the rd which shows as a superscript. Problem is
>>> whenever I add new text to the cell, it is in the superscript size, not
>>> regular text.
>>>
>>> John
>>>
>>>
>>>
>>> I took the list's advise of turning off the superscript function. If
>>> enough people are aggravated by the anomaly, it will be adjusted.
>>>
>>> Thanks,
>>> John
>> Just for the record, it is not necessary to follow John's more extreme
>> solution.
>>
>> For recent versions of LO (eg. 4.1.2.3) placing a full stop/period/dot
>> or comma immediately after the superscript rd reverts any following text
>> to normal size.
>>
>> Dave
>>
>>
>>
> I understand the "period/dot or comma", but what is a "full stop"?
> - Tim

A "full stop" is the same as a "period" or a "dot".

Quote from Wikipedia: https://en.wikipedia.org/wiki/Full_stop

"A full stop (British English, Hiberno-English, Australian English,
Indian English, South African English, Sri Lankan English and New
Zealand English) or period (American English and Canadian English) is
the punctuation mark placed to indicate the end of sentences. In the
context of web addresses and computing in general, it is typically
called a dot."

Dave



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

[Dave Barton]

 Original Message   From: Tom Davies 
To:  Date: Fri, 17 Jan 2014 21:00:55 +

> Hi :)
> Yes there is but it's not advisable.  Its better to keep your
> originals in ODF and only
> File - "Save As ..."
> when you really need to.  Otherwise formatting and things can go a bit
> wrong.  MS Office 2013 can read ODF.

There is also the "MultiFormatSave" extension available:
http://extensions.libreoffice.org/extension-center/multisave-1

MultiFormatSave enables you to save simultaneously a document in the
OpenDocument, MS Office and/or PDF formats as you choose for Writer,
Calc or Impress.

Hope this helps.

Dave





-- 
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: low traffic lately?

[Dave Barton]

CVAlkan wrote:
> Hi Tom:
> 
> Just my two cents. I've tried using AskLO several times and have never
> figured out how to set up an account, so I hope you don't drop this in favor
> of AskLO.
> 
> Maybe I'm just dense (and I've only been using computers and bulletin boards
> and mailing lists and their descendants since the mid-80s), but all I see
> are ways to sign in using Google or Facebook and so forth, and I don't have
> any of those accounts, and don't want them, since I get enough spam already
> and don't have much interest in cat videos or what my neighbors had for
> dinner.
> 
> Sorry - I'll go away now.
> 
> Frank

Hi Frank,

For some unexplained reason The Document Foundation board chose to use a
modified edition of the Askbot software [1] which, unlike Askbot's own
forum [2], does not allow you to set up a local log-in account.

If you dare suggest that you do not want to have a third party social
media account, you run the risk of at least one TDF board member calling
you a "paranoid" freak [3].

I was working with a small (only 40-50 seat) client company on a
proposal for migrating to LibreOffice. Mistakenly, in the process of
showing them the software's features, I demonstrated the new "Help ->
Send Feedback" "Ask a question" option, which ultimately leads to the
AskLibO site. The client asked me why they or their staff would be
required to have a third party social media account to use that service.
Unlike some TDF board members, I do not make it a practice to tell my
clients that they need to get a life and get over their stupid "paranoia".

Dave

[1] https://askbot.com/
[2] http://askbot.org/en/account/signin/?next=/en/
[3] http://nabble.documentfoundation.org/AskLibO-Access-td4091511.html



-- 
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] 4.3 Writer Beta Breaks Alternate Search Extension

[Dave Barton]

 Original Message 
From: Joel Madero 
To: users@global.libreoffice.org
Date: Mon, 27 Jan 2014 22:10:04 -0800

> On 01/27/2014 12:19 PM, CVAlkan wrote:
>> I'm using Writer Version: 4.3.0.0.alpha0+ Build ID:
>> be4035d00f37c492494fa7860955b6d0868c7f77 on Ubuntu 12.04 LTS 64 bit Linux
>>
>> In the course of trying to figure out how to remove index marks from a
>> Writer document, one of the things I tried was to load the Alternate Search
>> and Replace Extension, which I had used before. As it turns out, it doesn't
>> have the capability of finding index marks (the Index Property is for
>> something else), so it wouldn't have helped me anyway, but while trying, I
>> ran into a bug I thought should be reported.
>>
>> I downloaded the latest available version 1.4 (Jan 21, 2014) of the
>> Alternate Search and Replace Extension, but found that I could no longer
>> choose items from the drop down list of Properties, as it simply used
>> whatever it felt like. Not good.
>>
>> So thinking the new version perhaps had a bug of some sort, I loaded the
>> version I had used earlier, which was 1.3.2 (July 1, 2013).
>>
>> Same problem.
>>
>> Then I ran Writer Version: 4.2.0.1 Build ID:
>> 7bf567613a536ded11709b952950c9e8f7181a4a (I'm using the 4.3 alpha because of
>> another bug in 4.2, but that's a whole other story). I tried both versions
>> of the Alternate Search and Replace Extension and they both work fine with
>> Writer 4.2.
>>
>> I can only draw the conclusion that something has gotten broken between the
>> two Writer versions referenced above.
>>
>> How does this get reported to the developers?
> Extensions are third party development and therefore not part of our bug
> tracker. Unfortunately all you can do is hope that the developer of the
> extension sees that it is broken and fixes it (currently we have no
> method of contacting the extension provider).
>
>
> Best,
> Joel

The developer is /Tomáš Bílek/ see
http://www.volny.cz/macrojtb/AltSearch_cs.html

Regards
Dave




-- 
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] ver. 4.2 copy/past bug

[Dave Barton]

It may be related to this issue:
https://bugs.freedesktop.org/show_bug.cgi?id=74042
which claims to have been fixed in 4.2.1 but is still present in
Version: 4.2.1.1
Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b

Dave

 Original Message  
From: Tom Cloyd 
To: 
Date: Tue, 18 Feb 2014 18:26:02 -0700

> UPDATE re: the below problem:
> 
> This is very odd. Here's an example of what I'm seeing: I have a
> hyperlink from a cell in sheet C to a cell in sheet A. I
> click/double-click the link. Nothing happens. I inspect the link, and
> where the link target URL should be I see "!!br0ken!!"
> 
> But the tool-tip over the link advises me to try "Ctrl-click" and
> that actually works.
> 
> Is this the default? Could be, for all I know. And why does the link
> indicate it's broken, yet it still works?
> 
> I can make NO sense of this, I'll admit.
> 
> t.
> 
> =
> 
> Tom,
> 
> Well, I'm back on ver. 4.2. I have a lot of files in Calc with links -
> to various sheets, and to other files. THEY ARE ALL BROKEN NOW.
> 
> This is a disaster, and reverting LO isn't, I think going to fix it.
> 
> Sigh.
> 
> Re: faster load/save of files - xml is a text format, and will
> necessarily be slower than a binary equivalent - that's my
> understanding, anyway. I noticed quite some time ago, when converting
> from Excel to Calc that the save took about 3 times as along.
> 
> t.
> 
> On 02/18/2014 10:12 AM, Tom Davies wrote:
>> Hi :)
>> Thanks! :)
>>
>> Xml is the way all the office formats are going.  It does have 3 main
>> advantages afaik;
>> 1.  When things go wrong it's easier to poke around inside and maybe
>> even fix corrupted files
>> 2.  It's easy to compress further into Zip or other compression formats
>> 3.  errr, oh i thought it was faster and easier to load/save but i've
>> never seen anyone produce stats about it.  Now you mention it i've no
>> idea whether it feels faster or slower to open files.
>>
>> As for your User Profile, it might be a really good idea to
>> occasionally create a back-up copy in the same way and then keep the
>> one with the settings you like best to put on any machine just before
>> installing LibreOffice or OpenOffice so that you get all your fav.
>> settings but with all the relevant updated bits added by the
>> installer.
>>
>> Regards from
>> Tom :)
>>
>>
>> On 18 February 2014 16:41, Tom Cloyd  wrote:
>>>   Tom,
>>>
>>> I have to say that nothing makes me smile quite like a quick, detailed
>>> response to a problem reported to a user discussion list!
>>>
>>> For years, the absolute best list in this regard I've experienced has
>>> been
>>> that for the Lilypond music engraving software, but LO's list is
>>> surely a
>>> close second.
>>>
>>> As for gnumeric - that's totally new to me. I like calc, but do NOT
>>> like the
>>> fact that it save files in xml and thus they are large and slow to
>>> save and
>>> retrieve. There's just  no need for that. Xml should be an option, with
>>> binary the default, in my opinion. Will definitely give gnumeric a try.
>>>
>>> Thanks for the profile-renaming tip. I followed your advice, and thus
>>> saved
>>> my dictionaries - probably the single most valuable thing in my user
>>> profile.
>>>
>>> Thanks again for all the help!
>>>
>>> Tom
>>>
>>>
>>> On 02/18/2014 09:32 AM, Tom Davies wrote:
 Hi :)
 No worries!  It's what we are here for! :)

 The thing in my answer was to try Gnumeric
 http://projects.gnome.org/gnumeric
 instead of Calc/Excel for that 1 spreadsheet (or for all of them to
 make it easier).


 Renaming (or deleting) the User Profile seems to fix something like
 90% of weird problems that suddenly start but didn't occur before.
 It's a "magic cure all" worth knowing.  I prefer renaming so i can go
 back (some day (if i ever get around to it)) to get details of why it
 happened.  I keep meaning to back-up my User Profile when i get it
 just right but keep forgetting.

 Regards from
 Tom :)


 On 18 February 2014 15:56, Tom Cloyd  wrote:
> Hey, thanks, guys. That's a ton of help. I've a bit more time
> today, and
> will pursue the problem.
>
> There's also some great stuff in your email, Tom, for my carefully
> kept
> notes on LO, and especially on Calc., which I use a great deal
> every day.
> You took real time to give me that much info. I seriously
> appreciate this
> effort!
>
> Thank you both for the quick and thoughtful response.
>
> Tom
>
> On 02/18/2014 01:51 AM, Tom Davies wrote:
>> Hi :)
>> If something worked and suddenly stopped working as if by magic then
>> the first thing to try is to rename your User Profile
>> https://wiki.documentfoundation.org/UserProfile
>>
>> Renaming is better than deleting because you might have tons of stuff
>> in your profile (templates, galleries, Extensions, file-backups etc)
>> that yo

Re: [libreoffice-users] ver. 4.2 copy/past bug (Correction)

[Dave Barton]

It seems that I have too many test versions installed to accurately
recognise which one I am looking at.

Correction: The issue _HAS_ been fixed in 4.2.1.1 RC1

Sorry for the noise.

Dave

 Original Message  
From: Dave Barton 
To: LibreOffice User's Help Forum  It may be related to this issue:
> https://bugs.freedesktop.org/show_bug.cgi?id=74042
> which claims to have been fixed in 4.2.1 but is still present in
> Version: 4.2.1.1
> Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b
> 
> Dave
> 
>  Original Message  
> From: Tom Cloyd 
> To: 
> Date: Tue, 18 Feb 2014 18:26:02 -0700
> 
>> UPDATE re: the below problem:
>>
>> This is very odd. Here's an example of what I'm seeing: I have a
>> hyperlink from a cell in sheet C to a cell in sheet A. I
>> click/double-click the link. Nothing happens. I inspect the link, and
>> where the link target URL should be I see "!!br0ken!!"
>>
>> But the tool-tip over the link advises me to try "Ctrl-click" and
>> that actually works.
>>
>> Is this the default? Could be, for all I know. And why does the link
>> indicate it's broken, yet it still works?
>>
>> I can make NO sense of this, I'll admit.
>>
>> t.
>>
>> =
>>
>> Tom,
>>
>> Well, I'm back on ver. 4.2. I have a lot of files in Calc with links -
>> to various sheets, and to other files. THEY ARE ALL BROKEN NOW.
>>
>> This is a disaster, and reverting LO isn't, I think going to fix it.
>>
>> Sigh.
>>
>> Re: faster load/save of files - xml is a text format, and will
>> necessarily be slower than a binary equivalent - that's my
>> understanding, anyway. I noticed quite some time ago, when converting
>> from Excel to Calc that the save took about 3 times as along.
>>
>> t.
>>
>> On 02/18/2014 10:12 AM, Tom Davies wrote:
>>> Hi :)
>>> Thanks! :)
>>>
>>> Xml is the way all the office formats are going.  It does have 3 main
>>> advantages afaik;
>>> 1.  When things go wrong it's easier to poke around inside and maybe
>>> even fix corrupted files
>>> 2.  It's easy to compress further into Zip or other compression formats
>>> 3.  errr, oh i thought it was faster and easier to load/save but i've
>>> never seen anyone produce stats about it.  Now you mention it i've no
>>> idea whether it feels faster or slower to open files.
>>>
>>> As for your User Profile, it might be a really good idea to
>>> occasionally create a back-up copy in the same way and then keep the
>>> one with the settings you like best to put on any machine just before
>>> installing LibreOffice or OpenOffice so that you get all your fav.
>>> settings but with all the relevant updated bits added by the
>>> installer.
>>>
>>> Regards from
>>> Tom :)
>>>
>>>
>>> On 18 February 2014 16:41, Tom Cloyd  wrote:
>>>>   Tom,
>>>>
>>>> I have to say that nothing makes me smile quite like a quick, detailed
>>>> response to a problem reported to a user discussion list!
>>>>
>>>> For years, the absolute best list in this regard I've experienced has
>>>> been
>>>> that for the Lilypond music engraving software, but LO's list is
>>>> surely a
>>>> close second.
>>>>
>>>> As for gnumeric - that's totally new to me. I like calc, but do NOT
>>>> like the
>>>> fact that it save files in xml and thus they are large and slow to
>>>> save and
>>>> retrieve. There's just  no need for that. Xml should be an option, with
>>>> binary the default, in my opinion. Will definitely give gnumeric a try.
>>>>
>>>> Thanks for the profile-renaming tip. I followed your advice, and thus
>>>> saved
>>>> my dictionaries - probably the single most valuable thing in my user
>>>> profile.
>>>>
>>>> Thanks again for all the help!
>>>>
>>>> Tom
>>>>
>>>>
>>>> On 02/18/2014 09:32 AM, Tom Davies wrote:
>>>>> Hi :)
>>>>> No worries!  It's what we are here for! :)
>>>>>
>>>>> The thing in my answer was to try Gnumeric
>>>>> http://projects.gnome.org/gnumeric
>>>>> instead of Calc/Excel for that 1 spreadsheet (or for all of them to
>>>>> make it easier).
&g

Re: [libreoffice-users] System-wide document template?

[Dave Barton]

nicolai.ros...@gmail.com wrote:
> I was wondering if there is a system-wide document template that overrides a
> user's default template when opening plain text files. If there is one, I
> will change it.
> 
> LibreOffice Writer just ignores my default template when opening plain text.
> 
> Try creating a new style and saving your document as your default template.
> The new style is gone if you open a plain text file.
> 
> Nicolai

I thought that Regina had helped you resolve this issue, but...

Yes, there is a global default template, but it is hard wired (coded)
into the software. That is what the user's default or any other template
overrides.

Unless there is something extremely abnormal about your plain text file,
the user default or any other template used definitely will format plain
text as set in the template. So the question is:
Are you setting the default template as described here?:
https://help.libreoffice.org/Writer/Changing_the_Default_Template
and in chapter 10 of the Writer User Guide here:
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide

I am cc'ing you with an example template (the list server normally
strips attachments). You do not have to install or do anything special
with it. Simply open it in Writer and then use the "Insert -> File..."
menu option to insert any plain text file. Your text should appear in
some ugly blue font, with double spaced lines centered on the page.

Please write back to the list and let us know if this works for you.

Regards
Dave



-- 
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] Compress images

[Dave Barton]

Kracked_P_P---webmaster wrote:
> On 02/26/2014 10:43 PM, Dale Rebgetz wrote:
>>> There is a 10 MB file size limit, which my book exceeds due to the
>>> included pictures.
>> Thomas, beginning with LibreOffice 4.1 there is a new feature where if
>> you right-click on an image in your document you will see the option
>> "Compress Graphic...".
>>
>> This opens a dialogue box where you are provided with information about
>> that image (including its current size), proposed compression settings,
>> and a Calculate button to see the new size of that image if you were to
>> accept those settings.
>>
>> I have not found a way to do this on all the images at once.
>>
>> Because the changes are permanent, I suggest you *first* save a copy of
>> the original (large) document. That way you can try again if you
>> compress the images too much and loose too much image quality.
>>
>> Dale.
> What format and compression "level" are you using for your images?
> 
> You could always use JPG and make the image "compressed" to the greatest
> level that still a good viewable quality. Also, make sure you images are
> the "exact" size you want for the document and not need to resize it to
> a smaller size in the document to fit the image area you are using. That
> will reduce the amount of "space" in the file needed to store the image.
> I have seen too many documents with nearly full page size images that
> are reduced to a visible one of less that 2 inches. That just add a lot
> of file size to the document that is not needed.
> 
> So, make you image out side your document the visible size and
> compression level you want/need first, then you do not need to resize it
> in the document and add unneeded file space/size in your document.

Many image formats, especially jpeg images downloaded from digital
cameras, contain metadata tags (eg camera maker/model, time/date and
many others). Removing all these metadata tags can sometimes make a
worthwhile contribution to reducing the size of your image files.

A handy little program I use for resizing, compressing and stripping
metadata from images before inserting them into a document is "FastStone
Image Viewer": http://www.faststone.org/FSViewerDetail.htm Not OSS, but
free for personal use. A Windows only program, but undoubtedly there are
equal or better ones for other platforms.

Dave




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns

[Dave Barton]

 Original Message  
From: Carlo Gonzato 
To: users@global.libreoffice.org
Date: Fri, 28 Feb 2014 20:04:43 + (GMT)

> Egregi Signori:
> 
> non c'è nessuno che capisca e scriva in italiano?
> 
> Sono un assoluto sostenitore di Libre Office, da tempo, ma ora ho un problema 
> dovuto al cambio di ordinatore (computer): non riesco a copiare il testo da 
> Libre Office Writer sul mio conto email.
> 
> Come risolvere questo problema?
> 
> Distinti saluti, C. Gonzato

Sì, il contatto:

http://it.libreoffice.org/supporto/
e
http://it.libreofficeforum.org/forum

Distinti saluti,
Dave






-- 
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] copy & paste into Thunderbird

[Dave Barton]

Thomas wrote:
> Good afternoon
> I recently upgraded to LO 4.2.xx
> As far as I can recall, I have NEVER had any problems selecting text
> portions (or all of it) in LO and then copy that portion into a TB mail.
> However, no matter what I try now, this does NOT work.
> NOTHING happens.
> 
> But the same procedure works, using Openoffice Write, MS Word, text
> editors (naturally), even copying from PDF files works ...
> 
> So, what is this all about?
> How is this supposed to be "fixed"?
> 
> Thank you.
> Thomas

Works for me in 4.2.2.1 on Win 7 x64 no matter which paste option I use
in Thunderbird.

Dave





-- 
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] Windows-Mac compatibility

[Dave Barton]

Steve Edmonds wrote:
> 
> On 2014-03-17 03:11, Lorenzo Pii wrote:
>> Dear all,
>> I'm interested in experiences for cross compatibility between Windows
>> and Mac for Calc. Is it fully compatible or only partially? I have a
>> file on dropbox and I’m wondering if I’d be able to edit it both from
>> my work pc and my personal mac with the same version of libreoffice. I
>> know the best and clever way would be to try it myself, fact is my
>> file has quite some sheets and I would like to avoid to start saving
>> it with both machines and eventually find out in a month or so that
>> something went bad in the process.
>>
>> Thanks a lot
>>
>> Lorenz
> Hi. I have Linux and macs and have no cross-compatibility issues with LO.
> With my work colleagues there is no compatibility issues windows-Linux.
> I do however standardise fonts across machines, for instance I found the
> Arial on mac was different to the one on Linux causing text to flow
> differently, so I copied my Linux font to my mac.
> Steve

Have you tried the "Embed fonts in the document" option under the "Font"
tab of the document "Properties" dialog?

In some cases this can "bloat" the file size, but I have found it useful.

Dave




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

[Dave Barton]

 Original Message 
From: Dale Erwin 
To: users@global.libreoffice.org
Date: Thu, 17 Apr 2014 16:14:37 -0500

> Could someone please point me to documentation that will explain how
> to create and maintain an index?  Thanks.
>
> Dale Erwin

Hi Dale,

Have you checked chapter 12 of the Writer Guide:
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide

The following are little dated, but...
http://www.taming-openoffice-org.com/newsite/?page_id=69
http://voices.yahoo.com/creating-open-office-writer-index-7043324.html
Search the internet for "libreoffice document index" (sans quotes) and
you will get links to many similar documents and articles.

Dave



-- 
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] Empty fields in mail merge/labels.

[Dave Barton]

A client has asked me a question I am unable to answer, or find definite
information about. I suspect the answer will be "not possible", but
wanted to check with you folks first.

In mail merge and labels there is a work-around to skip empty lines, but
is there a hack to skip empty fields within an otherwise populated line?

The data file includes:
Title, Firstname, Joint, Partner, Surname, Label, Address1, Address2,
Suburb, State, Postcode.

Assuming a label design:
Title, Firstname, Joint, Partner, Surname,
Address1
Address2
Suburb, State Postcode.

Some recipients have partners and some do not. The field “Joint” inserts
“and Mrs”. Some have house or property names which go in Address1.

Fully populated fields result in:

Mr Alpha and Mrs Bravo Smith
The Place
1 High Street
Somewhere Here 1234

But empty "Joint", "Partner" & "Address1" fields for single people
results in:

Mr Alpha (space) (space) (space) Smith
1 High Street
Somewhere Here 1234

FWIW. I am told (not been able to check) that in MS Works all empty
fields are skipped.

The solution I put forward was to put the partner name on a separate
line, left blank when not needed, but this does not satisfy the client's
requirements.

Any other thoughts, suggestions or pointers to a solution would be welcome.

TIA
Dave



-- 
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] Dear libreoffice

[Dave Barton]

 Original Message 
From: Colin James Lichtwark 
To: users@global.libreoffice.org 
Date: Thu, 8 May 2014 07:26:38 +1000

> Hello, my name is Colin Lichtwark. I am a postgraduate student at
> Swinburne University in Melbourne Australia. I am trying to use
> ubuntu as much as possible but the issue I have is with libre office
> note having an effective citation manager interface especially with
> mendeley. I feel this is a huge impedance to the popular adoption of
> ubuntu.Is the work being done in this area with your software
> development?.
>
> Yours Sincerely, Colin Lichtwark

Hi Colin,

I think you are looking at this the wrong way round. Mendeley already
has an Ubuntu plugin to interface LibreOffice. It seems they initially
had some problems with this plug-in, but according to this thread
http://support.mendeley.com/customer/portal/questions/1384344-mendeley-plugin-for-libreoffice-4-1-4-
it now works as advertised. I may be wrong, because I am not a Mendeley
user (my personal preference is Zotero) but from what I read the plug-in
appears to be part of the Mendeley Desktop package, or at least
available from the Mendeley "Tools -> Install LibreOffice/OpenOffice
Plugin", see: http://www.mendeley.com/features/reference-manager/

Hope this helps.

Regards
Dave


 


-- 
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] print table without internal borders

[Dave Barton]

Thomas wrote:
>
> (2014/05/12 20:19), Brian Barker wrote:
>> At 19:45 12/05/2014 +0900, you wrote:
>>
>> I'm not sure what you can mean by "etc.": what else did you do, then?
>>
>>> ... but so far no setting has changed how the table looks in the
>>> "print preview".
>>
>> If you turn off the lines for a table, you should see the result in
>> Print Preview.
>>
>>> I just cannot figure it out.
>>
>> A few suggestions:
>>
>> o If you select a cell range before you turn off table boundaries,
>> your action will affect only those cells: other cells will retain
>> their borders. Is that what you did?
>>
>> o Do you have a single table or are there actually a number of
>> adjacent tables? (If you inherited this document, you may not know
>> how it was constructed.) If so, you'll need to adjust the borders on
>> all of them.
>>
>> o Do you have a table within another table?
>>
>> o Do you really have not a table but a set of frames? Or frames
>> within a table?
>>
>> o Do you actually have a picture of a table, perhaps imported from
>> another application?
>>
>> I trust this helps.
>>
>> Brian Barker - privately
>>
>>
> Maybe I need to specify:
> I myself created ONE table in a Writer document.
> No images, no frames etc.
> Started with 6 columns and about 30 rows.
> Joined a few cells in the upper portion (to make more room for entries
> like "address" etc).
> Below there are the 6 colums and 14 rows.
> For THIS block - part of the ONE table - I would like to make the
> lines inside the table disappear (or at least NOT print)
> and retain only the border that surrounds the whole table.
>
> Yet, (so far) regardless of what cell/block of cells I select and what
> option pertaining to "borders", "lines" etc. I choose ...
> NONE has ANY effect on the appearance of that table.
> Is that not a little strange?

Hi Thomas,

What makes it "/strange/", or I should say difficult, is that we cannot
see your document or know what options you are using.
I am attaching a sample document (which may be removed by the list
server) in the form of a mini-tutorial. Please follow the steps in that
document using a new document of your own and write back to the list
(not directly to me) and let us know if this works for you or not. This
will give us some idea if the problem is in your existing document, or
in the options you have been using.

Regards
Dave - (Writing Publicly Brian)




-- 
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] Galaxy Icons For 4.3

[Dave Barton]

I see that the Galaxy icon set has been dropped from 4.3 Is there any
way for a user to add this icon set to 4.3 without compiling the whole
program?

Dave



-- 
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] Galaxy Icons For 4.3

[Dave Barton]

Regina Henschel wrote:
> Hi Dave,
> 
> Dave Barton schrieb:
>> I see that the Galaxy icon set has been dropped from 4.3 Is there any
>> way for a user to add this icon set to 4.3 without compiling the whole
>> program?
>>
> 
> Look into the installation path in folder share/config. There should be
> an archive "image.zip". Copy it to name "image_galaxy.zip", same pattern
> as the other archives. The Galaxy icon set is there, but it has a wrong
> name.
> 
> https://bugs.freedesktop.org/show_bug.cgi?id=75937#c11
> 
> Kind regards
> Regina

Many thanks Regina. I never expected such a simple solution.

After all these years you would think I could remember to check Bugzilla
first, more so for a beta build.

Best Regards
Dave



-- 
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] disable "cntrl click to follow link"

[Dave Barton]

 Original Message 
From: 4130 <4...@charter.net>
To: Dave Barton 
Date: Mon, 25 Aug 2014 10:37:34 -0700 (PDT)

> Hi,
>
> New to Libre office, been using MS office, mostly Word.
>
> How can I enable Libre Writer to show a hand icon while hovering over link
> like in Word.
>
> "cntrl click to follow link" wastes time 
>
> cheers,
>
> 4130

>From the main menu select "/Tools -> Options.../".
In the "/Options/" dialog that opens, click to expand the "LibreOffice"
heading.
Click the "/Security/" sub-heading.
Click the "/Options.../" button.
In the "/Security options and warnings/" dialog that opens, click to
untick/uncheck the "/Ctrl-click required to follow hyperlinks/" option.
Click the "/OK/" buttons to save the change and close the dialogs.




-- 
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] Send Document as Microsoft Word doesn't

[Dave Barton]

Steve Edmonds wrote:
> Must be a bug because it works in my LO 3.6 and 4.1.
> 
> Steve
> On 2014-08-26 01:27, Gordon Burgess-Parker wrote:
>> LO 4.3.0.4 on Ubuntu 14.04 - Thunderbird as default email client.
>> In LO Writer, if I click on File>Send>Email as Microsoft Word then it
>> opens a new message window in TBird, but with no attachment, which
>> rather negates the function!
>> I use this facility to be able to keep one format of document on my
>> machine, rather than having to do a "Save As" into MS Word format.
>> Is this a bug in 4.3?

If it is a bug it might be Linux specific, because it works on Win7 x64
with LO 4.3.0.4 and TB.
I don't have access to my Linux machines right now, but I will take a
look later.

Dave



-- 
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] how to turn off read only

[Dave Barton]

 Original Message 
From: John R. Sowden 
To: users@global.libreoffice.org
Date: Fri, 05 Sep 2014 17:59:24 -0700

> Now that I have created my invoice form, I went into file/properties
> and checked 'open as read only', so the form does not get "filled in".
>
> Then I decided to make some improvements.  When I opened the file, of
> course, it is set to read only, so I went to properties and found the
> check box grayed out, so I exited LO and used Linux to set the file to
> read/write for me and my group (of me).  When I opening the file, I
> found it was still grayed out.  Help explained how to edit the file,
> but when I went to save it, it would only save as 'save as'.
>
> How do I change the setting so it does not go to 'read only' when I
> open the file in LO?
>
> John
>

On the main toolbar you will find an "/Edit File/" icon. Clicking that
icon allows you to edit read only documents.


You can also set/unset a file's read only status under the "/Security/"
tab of the document "/Properties/" dialog. From the main menu select the
"/File -> Properties.../" option.

You will find it helpful to read the "Getting Started" and "User" guides
at: http://www.libreoffice.org/get-help/documentation/

Dave





 

-- 
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] Styles Don't Retain Bold?

[Dave Barton]

Joel Madero wrote:
> 
> On 09/10/2014 08:21 AM, Sophie wrote:
>> Hi Joel,
>> Le 10/09/2014 17:01, Joel Madero a écrit :
>>> https://drive.google.com/file/d/0B2kdRhc960qdMlFhVzAtTllETEU/edit?usp=sharing
>>>
>>> There is one example file. Go to the very end, push enter a couple
>>> times, and then set the style to Heading 3. If you look at the actual
>>> style it's supposed to be bolded but it retains non bold from the
>>> previous line when you start typing.
>> It's strange because if you insert a Title3 before the last paragraph,
>> it's bold. It's only if you add it at the very end that it's corrupted.
>> You found a bug I guess ;)
> \O/ Sweet! One point for me :-D That being said, it's actually not just
> the end - that's just one of the obvious ways to trigger the issue. I'd
> have to play around with the document to find another consistent place
> where it happens. I shall report the bug, quite minor I suppose since
> you can always just select and bold the text - just styles should be
> consistent all the time (as this is their entire point). Thanks Sophie
> for confirmation that I'm not going crazy.
> 
> 
> Best,
> Joel

Don't be in too much of a rush to post a bug Joel. Wherever I type on a
blank line in your example file and set "Heading 3" (either before or
after typing) I get 14pt Bold Liberation Sans text in a "User Defined"
colour. Which in my assessment is the correct behaviour.

Setting existing manually formatted text to "Heading 3" is an issue, if
the formatting is not completely cleared first.

Version: 4.3.1.2
Build ID: 958349dc3b25111dbca392fbc281a05559ef6848
Win 7 x64

If it would help I can test a few other versions and Linux later.

Best
Dave




-- 
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: Generate a column of times

[Dave Barton]

Also the data acquisition software. I have written a few data
acquisition programs and in some cases the sample rate was extremely
high over an extended period of time. To keep the file sizes down to
something reasonable I stored the captured data with a compression
algorithm which, amongst other things, eliminated most of the time
stamps. I then provided an user option in the UI to either
display/export the raw data or a representation of the full details.

What the OP describes is simple raw data and maybe there is a similar
display/export option in the capture software being used here.

Dave

Paul D. Mirowsky wrote:
> It might also be helpful if you mentioned your data acquisition hardware.
> 
> It might be that using a standard interval reading is possible and you
> don't have to guess about the readings at all.
> 
> Start 00:00:00, first interval 00:01:00, second interval 00:02:00 etc...
> 
> 
> On 9/10/2014 7:45 AM, William Drago wrote:
>> It might be helpful if you post the actual start/stop times for the
>> 2026 samples. There's more than one way to skin this cat and I'd only
>> look for solutions outside of Calc as a very last resort.
>>
>> -Bill
>>
>> On 9/9/2014 8:22 PM, office76#xt wrote:
>>> Thanks for the replies.
>>>
>>>My earlier example was a
>>> simplified version of the data I'm working with. When Brian & Wdragos
>>> technique is applied to the 2026 samples I really have, it sort of
>>> works so
>>> I can see what your talking about. I keep altering the incrementation
>>> that
>>> takes place in this technique to try to get the last cell to say the
>>> stop
>>> time.  It comes pretty close but is always off by a few minutes. The
>>> reason
>>> for this is theres a limit to the precision you can do with Times in
>>> OpenOffice Calc. Using the hr/mn/sec format you can't generate small
>>> enough
>>> increments to get the generated times to match the stop time. If
>>> there was a
>>> hr/mn/sec/fraction of a second format you could do it. In Calc theres  a
>>> time format that looks like this, but in practice it doesn't 'roll over'
>>> like say minutes or seconds.
>>>
>>> It looks like Calc's stock functions won't do the job. I'm thinking of
>>> getting around this by finding some source for a stopwatch program, and
>>> maybe modifiying it to do something similar, but with a greater
>>> precision of
>>> incrementation.


-- 
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 Form and JRE

[Dave Barton]

Rafnews wrote:
> Hi,
> 
> i want to use Base database for first time and i got the following
> error: "no java installation was found", while i'm trying to create a form.
> http://prntscr.com/4sb7mc
> 
> However i have JRE installed as v1.8.x as you can see on the screenshot
> http://prntscr.com/4sb79j
> 
> so where is the problem ?
> is LibreOffice not compatible with JRE 1.8 ?
> 
> thx.
> 
> A.

You have the 64bit JRE installed. LO for Windows is a 32bit program, so
you need to add the 32bit JRE to your system.

Dave



-- 
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] Printing serial letters

[Dave Barton]

Heinrich Stöllinger wrote:
> Hello,
> A long time ago (REALLY long ago!) I complained that LO does not print
> serial letters correctly.
> I think I also filed a bug report with (in MY opinion!) the right test
> data. I just tried to
> print such serial letters again today. Unfortunately the problem still
> exists. As you can maybe
> see from the enclosed pdf-file, only the FIRST letter prints correctly,
> while ANY letters after
> the first one miss out lines of text (e.g. the place and date near the
> top on the right),
> drawn lines (near the bottom). Even though I use a MySQL database as
> "supplier" of DB-fields,
> I don't think this has anything to do with Base.
> It should be easy enough to put together a test for this issue, but I
> include the respective
> .odt-file in any case. Again, I don't think a DB-table is necessary for
> testing.
> Regards
> Heinrich

Heinrich,
Is https://bugs.freedesktop.org/show_bug.cgi?id=76257 the bug report you
are referring to? If so, I will take a look and see if I can replicate
and confirm it.

Gary,
Please add a reproducible example to Heinrich's report. This will:
a) Assist QA in assessing if it is the same bug or not.
b) Add more weight to the issue, which in turn is more likely to attract
a developer's interest.
If you know it's not the exactly the same issue and your reference to
"messing up colors" suggests that it may not be, please find and
contribute to an existing report, or open a new one.
Nobody (developer, QA or other) "denies the existence of an issue", but
no issue can be effectively resolved if it cannot be replicated and it's
cause determined. Which is where we come in with accurate reports and
reproducible examples.

This list is a great place to vent our frustrations about our "pet"
issues, but at the end of the day our "rants" here do nothing, only our
contributions (ie. bug reports and reproducible examples) will help to
get anything done.

Dave




-- 
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] Printing serial letters

[Dave Barton]

 Original Message   From: Heinrich Stöllinger
 To: Dave Barton
hc.stoellin...@aon.at Date: Sat, 11 Oct 2014 23:25:45 +0200

> Dave Barton schrieb:
>> Heinrich Stöllinger wrote:
>>> Hello,
>>> A long time ago (REALLY long ago!) I complained that LO does not print
>>> serial letters correctly.
>>> I think I also filed a bug report with (in MY opinion!) the right test
>>> data. I just tried to
>>> print such serial letters again today. Unfortunately the problem still
>>> exists. As you can maybe
>>> see from the enclosed pdf-file, only the FIRST letter prints correctly,
>>> while ANY letters after
>>> the first one miss out lines of text (e.g. the place and date near the
>>> top on the right),
>>> drawn lines (near the bottom). Even though I use a MySQL database as
>>> "supplier" of DB-fields,
>>> I don't think this has anything to do with Base.
>>> It should be easy enough to put together a test for this issue, but I
>>> include the respective
>>> .odt-file in any case. Again, I don't think a DB-table is necessary for
>>> testing.
>>> Regards
>>> Heinrich
>> Heinrich,
>> Is https://bugs.freedesktop.org/show_bug.cgi?id=76257 the bug report you
>> are referring to? If so, I will take a look and see if I can replicate
>> and confirm it.
>>
>> Gary,
>> Please add a reproducible example to Heinrich's report. This will:
>> a) Assist QA in assessing if it is the same bug or not.
>> b) Add more weight to the issue, which in turn is more likely to attract
>> a developer's interest.
>> If you know it's not the exactly the same issue and your reference to
>> "messing up colors" suggests that it may not be, please find and
>> contribute to an existing report, or open a new one.
>> Nobody (developer, QA or other) "denies the existence of an issue", but
>> no issue can be effectively resolved if it cannot be replicated and it's
>> cause determined. Which is where we come in with accurate reports and
>> reproducible examples.
>>
>> This list is a great place to vent our frustrations about our "pet"
>> issues, but at the end of the day our "rants" here do nothing, only our
>> contributions (ie. bug reports and reproducible examples) will help to
>> get anything done.
>>
>> Dave
>>
>>
>>
>>
> Yes it is

OK! Give me a few days to check it out and I will post my findings on
Bugzilla.

> and - looking at it again I can see that I DID add attachments
> for testing.

Yes, I know you did. My comments about attachments were in response to
Gary's part of this thread.

> Regards
> Heinrich

Regards
Dave



-- 
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] Printing serial letters

[Dave Barton]

 Original Message   From: Gary Dale
 To: Dave Barton  Date: Sun, 12 Oct
2014 00:14:10 -0400

> On 11/10/14 04:59 PM, Dave Barton wrote:
>> Heinrich Stöllinger wrote:
>>> Hello,
>>> A long time ago (REALLY long ago!) I complained that LO does not print
>>> serial letters correctly.
>>> I think I also filed a bug report with (in MY opinion!) the right test
>>> data. I just tried to
>>> print such serial letters again today. Unfortunately the problem still
>>> exists. As you can maybe
>>> see from the enclosed pdf-file, only the FIRST letter prints correctly,
>>> while ANY letters after
>>> the first one miss out lines of text (e.g. the place and date near the
>>> top on the right),
>>> drawn lines (near the bottom). Even though I use a MySQL database as
>>> "supplier" of DB-fields,
>>> I don't think this has anything to do with Base.
>>> It should be easy enough to put together a test for this issue, but I
>>> include the respective
>>> .odt-file in any case. Again, I don't think a DB-table is necessary for
>>> testing.
>>> Regards
>>> Heinrich
>> Heinrich,
>> Is https://bugs.freedesktop.org/show_bug.cgi?id=76257 the bug report you
>> are referring to? If so, I will take a look and see if I can replicate
>> and confirm it.
>>
>> Gary,
>> Please add a reproducible example to Heinrich's report. This will:
>> a) Assist QA in assessing if it is the same bug or not.
>> b) Add more weight to the issue, which in turn is more likely to attract
>> a developer's interest.
>> If you know it's not the exactly the same issue and your reference to
>> "messing up colors" suggests that it may not be, please find and
>> contribute to an existing report, or open a new one.
>> Nobody (developer, QA or other) "denies the existence of an issue", but
>> no issue can be effectively resolved if it cannot be replicated and it's
>> cause determined. Which is where we come in with accurate reports and
>> reproducible examples.
>>
>> This list is a great place to vent our frustrations about our "pet"
>> issues, but at the end of the day our "rants" here do nothing, only our
>> contributions (ie. bug reports and reproducible examples) will help to
>> get anything done.
>>
>> Dave

> I've already done everything you asked and more,

No, I have not asked you to do anything, except provide a pointer to the
location where the details of the issue could be found.

> including sending screen shots to demonstrate that the problem is with 
> LibreOffice and not something else.

Where are these screen shots? There are no attachments to bug 83346.

> If you look in the print dialogue, it shows that
> LibreOffice thinks it is printing 2N-1 pages instead of N pages. And no,
> this is not the "print automatically inserted blank pages" "feature".

There is no way for others to determine if this is true without details
(eg. samples, screen shots, etc.)

> The reason I think it is probably the same bug is that in both cases
> LibreOffice doesn't initiate the new page properly. I guess in
> monochrome it chews up some text while in colour it mangles the colour
> coding.

It does not necessarily follow that similar issues come from the same
section of the (very large) code base. I have seen numerous examples
where changes to one part of the code has an unexpected impact on an
apparently unrelated function.

> My latest bug report on it was 83346. I sent the samples to Cor Nouws
> who closed the bug after deciding that it was a "feature" that no sane
> person would ask for - the mangling of colours. Apparently he didn't
> note that "feature" he thought it was, was actually a symptom of the
> problem I was reporting.

There is no way of determining if Cor was right or wrong if the samples
you refer to are not made publicly available (eg. Bugzilla).

At this stage I am not going to reopen the report, but if you want to
reply to https://bugs.freedesktop.org/show_bug.cgi?id=83346#c2 I am
prepared to work with you on this. Please do not send anything directly
to me.

I am not an active developer, but if this can be demonstrated as an
issue that needs fixing, it can be brought to the attention of the
developers.

> BTW: I also fail to see why anyone would think that inserting blank
> pages between form letters is a feature that should be on by default. I
> print a lot of different types of form letters and have never found any
> use for it. If it's useful to someone, leave it in but don't enable it
> by default.

Re: [libreoffice-users] Printing serial letters

[Dave Barton]

 Original Message  
From: Heinrich Stöllinger 
To: Dave Barton 
Date: Sun, 12 Oct 2014 09:35:30 +0200>

> Hello Dave,
> I have just tested printing under Windows/Vista (don't laugh -- I won't
> follow M$ any further!) and
> LO 4.3.2. Hooray -- it works just fine in THAT environment.
> Regards
> Heinrich
> 
> correctly. So it must have somehow have to do with the Linux version.

 Original Message  ---- From: Heinrich Stöllinger
 To: Dave Barton  Date: Sun, 12 Oct
2014 10:07:11 +0200

> Hello Dave,
> Well - here comes the latest! Printing works correctly also on
> Linux/Mint, but ONLY with LO 4.3.2 (not LO 4.2.7.1).
> As far as I personally am concerned, this is o.k. for me, it may not be
> for other more "conservative" users! I
> suppose the same might be true for the respective Windows versions, but
> I did not test earlier Windows versions...
> Thanks for your cooperation - and have a good Sunday.
> Regards
> Heinrich

Hi Heinrich,

That's good news. Are you using a distro repository edition of the
program, or have you installed the "official" edition from the
LibreOffice website?

Regards
Dave




-- 
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] Printing serial letters

[Dave Barton]

Gary Dale wrote:
> On 12/10/14 06:27 AM, Dave Barton wrote:
>>>> Gary,
>>>> Please add a reproducible example to Heinrich's report. This will:
>>>> a) Assist QA in assessing if it is the same bug or not.
>>>> b) Add more weight to the issue, which in turn is more likely to
>>>> attract
>>>> a developer's interest.
>>>> If you know it's not the exactly the same issue and your reference to
>>>> "messing up colors" suggests that it may not be, please find and
>>>> contribute to an existing report, or open a new one.
>>>> Nobody (developer, QA or other) "denies the existence of an issue", but
>>>> no issue can be effectively resolved if it cannot be replicated and
>>>> it's
>>>> cause determined. Which is where we come in with accurate reports and
>>>> reproducible examples.
>>>>
>>>> This list is a great place to vent our frustrations about our "pet"
>>>> issues, but at the end of the day our "rants" here do nothing, only our
>>>> contributions (ie. bug reports and reproducible examples) will help to
>>>> get anything done.
>>>>
>>>> Dave
>>> I've already done everything you asked and more,
>> No, I have not asked you to do anything, except provide a pointer to the
>> location where the details of the issue could be found.
> Actually you asked for a reproducible example, which I've already
> provided, along with screen shots showing the bug.

No, at that time you had given no information about any report you may
have made. Only later did you come forward with a bug report number.

>>> including sending screen shots to demonstrate that the problem is
>>> with LibreOffice and not something else.
>> Where are these screen shots? There are no attachments to bug 83346.
> That's because bugzilla refuses to take e-mail from me. I can send bug
> reports via reportbug but it doesn't want to take e-mail sent via
> icedove, probably due to the way it reads addresses - ignoring the
> reply-to and only using the from field.

I don't understand what you mean about emailing into Bugzilla. I have
been using the Bugzilla software for over a decade and to the best of my
knowledge it does not accept email input. If you know differently please
enlighten me.

>>> If you look in the print dialogue, it shows that
>>> LibreOffice thinks it is printing 2N-1 pages instead of N pages. And no,
>>> this is not the "print automatically inserted blank pages" "feature".
>> There is no way for others to determine if this is true without details
>> (eg. samples, screen shots, etc.)
> You can get them directly from developer Cor Nouws. The fact that he
> failed to attach them to the bug report suggests that he doesn't see the
> problem.

No I can't get them from Cor. I don't know if he is a developer or not,
but either way it is your issue and you opened the report, so if you
wanted to get your issue resolved it is your responsibility to make the
necessary information available on Bugzilla where others can evaluate it.

>>> The reason I think it is probably the same bug is that in both cases
>>> LibreOffice doesn't initiate the new page properly. I guess in
>>> monochrome it chews up some text while in colour it mangles the colour
>>> coding.
>> It does not necessarily follow that similar issues come from the same
>> section of the (very large) code base. I have seen numerous examples
>> where changes to one part of the code has an unexpected impact on an
>> apparently unrelated function.
> Perhaps but the odds are against the same effect having two separate
> causes.

The odds are very much in favour of it having a separate cause, because
Heinrich now reports that his issue has been resolved in a more recent
version.

>>> My latest bug report on it was 83346. I sent the samples to Cor Nouws
>>> who closed the bug after deciding that it was a "feature" that no sane
>>> person would ask for - the mangling of colours. Apparently he didn't
>>> note that "feature" he thought it was, was actually a symptom of the
>>> problem I was reporting.
>> There is no way of determining if Cor was right or wrong if the samples
>> you refer to are not made publicly available (eg. Bugzilla).
>>
>> At this stage I am not going to reopen the report, but if you want to
>> reply to https://bugs.freedesktop.org/show_bug.cgi?id=83346#c2 I am
>> prepared to work with you on this. Please do not send anything directly
&

Re: [libreoffice-users] no numbering for first pages

[Dave Barton]

Thomas Blasejewicz wrote:
> Good evening
> I am sure, this has been asked (and answered!) before, but I cannot find
> it in the archives.
> 
> I have a (actually 3) book, where I would like to have NO page numbering
> for the first 3 pages and then start with "1".
> Conversion to "title page" seems to work only for the first page.
> Attempts at assigning a self-made "front matter" page style to the first
> pages fails too. They are and remain "default style".
> 
> Trying to temper with "text flow" under paragraph styles does not help
> either.
> Either I DO get page numbers, or I DO NOT.
> But so far all attempts (reading through the official documentation) at
> setting the said numbering have failed.
> 
> I assume, there is a little trick to achieve that and I am just too
> stupid to see it.
> Therefore, I would be grateful, if someone could give me one or two
> pointers.
> 
> Thank you.
> Thomas

Hi Thomas,

Take a look at the Writer Guide chapters 4 & 5 available from here:
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide

Regards
Dave



-- 
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] no numbering for first pages

[Dave Barton]

anne-ology wrote:
>and page numbering is where ???

Writer Guide 4.2 Chapter 4 Page 35 has a very obscure, unrelated &
meaningless heading called "Page Numbering".


> From: Dave Barton 
> Date: Mon, Oct 13, 2014 at 10:22 AM
> Subject: Re: [libreoffice-users] no numbering for first pages
> To: users@global.libreoffice.org
> Cc: ny...@hb.tp1.jp
>
> Thomas Blasejewicz wrote:
>> Good evening
>> I am sure, this has been asked (and answered!) before, but I cannot find
>> it in the archives.
>>
>> I have a (actually 3) book, where I would like to have NO page numbering
>> for the first 3 pages and then start with "1".
>> Conversion to "title page" seems to work only for the first page.
>> Attempts at assigning a self-made "front matter" page style to the first
>> pages fails too. They are and remain "default style".
>>
>> Trying to temper with "text flow" under paragraph styles does not help
>> either.
>> Either I DO get page numbers, or I DO NOT.
>> But so far all attempts (reading through the official documentation) at
>> setting the said numbering have failed.
>>
>> I assume, there is a little trick to achieve that and I am just too
>> stupid to see it.
>> Therefore, I would be grateful, if someone could give me one or two
>> pointers.
>>
>> Thank you.
>> Thomas
>
>
> Hi Thomas,
>
> Take a look at the Writer Guide chapters 4 & 5 available from here:
> https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide
>
> Regards
> Dave
>


-- 
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] How to use Writer for creating surveys and multiple choice questions

[Dave Barton]

 Original Message 
From: Daniel 
To: users@global.libreoffice.org
Date: Wed, 15 Oct 2014 05:40:46 +0200

> Sorry for not being very clear in my request. I was looking for
> something like this page..
>
> http://www.questionpro.com/a/TakeSurvey?id=3372860
>

Chapter 15 "/Using Forms in Writer/" of the Writer Guide might be helpful.
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide

Dave




-- 
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] Extensions Basic Runtime Error

[Dave Barton]

I have searched Bugzilla and haven't found anything that comes close to
the issue I am experiencing. So before I start destroying & rebuilding
my extensive profile and maybe filing a new bug, I thought I would ask here.

I have 35 extensions (including 2 special dictionaries) installed.
Roughly 12 of them call oLibContainer.LoadLibrary(LibName) which
terminates with a "BASIC runtime error. Type:
com.star.container.NoSuchElementException" error. See:
http://www.mediafire.com/view/1ddd9fd2gkwa4ie/BRT_Error.png This screen
capture is just an example of the error from the "Alternative searching
1.4" extension.

Now the really weird thing is that if I keep LO (any module) open and
reinstall those same extensions they work perfectly, until the next time
I start LO.

This started happening when I first moved up to 4.3.0 and continues
through to 4.3.3  on a Win 7 Ult-x64 box. I am not so much looking for a
fix or work-around, more to find out if anyone else has experienced
anything like this.

TIA
Dave (miserably looking forward to rebuilding his precious profile) Barton



-- 
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: Support options

[Dave Barton]

Cor Nouws wrote:
> Hi Andreas,
> 
> Andreas S�ger wrote on 16-01-15 14:48:
> 
>> As far as content matters,
>>> https://forum.openoffice.org/en/forum/index.php
>>
>> is the major resource of user knowledge for both OpenOffice and
>> LibreOffice users. 
> 
> Maybe it's a good idea if that forum also announces the new versions of
> LibreOffice, and not only those of AOO ?
> 
> Cor

The solution is simple. Just log in to the forum and post the announcement.

The administrators have worked hard to keep the forum open and welcoming
for _ALL_ reasonable ODF related issues, not just AOO.
The forum title clearly states:
"User community support forum for Apache OpenOffice, LibreOffice and all
the OpenOffice.org derivatives"

Plus we have http://en.libreofficeforum.org/ While this is not TDF
hosted, it does form part of our wider ecosystem.

Dave




-- 
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] Writer: Why does adding a table border change the cell margins?

[Dave Barton]

 Original Message  
From: Alan Mead 
To: Dave Barton 
Date: Mon, 19 Jan 2015 12:49:42 -0600

> Why does adding a border to a table in Writer change the cell margins?
> 
> I paste RTF tables into Writer documents a lot.  If you compare the top
> (unformatted) and bottom (borders added) tables, you can see that the
> first row and the bottom row are slightly indented the "C" in
> "Construct" and in "Cautiousness" have been moved slightly to the right
> (which has caused the word "Cautiousness" to wrap) while the other two
> rows are flush against the left border.  This looks tacky.  How to I
> prevent LO from changing the cell margin when I add borders?
> 
> FWIW, here are some things I've tried.  I have no idea how to affect the
> cell margins, because if I go Table -> Borders, the "Spacing to
> contents" is all zero's.  The style of a regular table is "Table
> Contents" but changing the style to "Table Contents" has no effect. 
> Also, highlighting the text and selecting "Remove direct formatting" has
> no effect.
> 
> I think you can duplicate this with a regularly-created table by
> creating the table, removing all borders, changing the spacing to
> contents to zero, then adding borders.
> 
> -Alan

Your email suggests that you _may_ have attached images to your post. If
so, the list servers have removed them so we can't compare what you are
describing.

I tried unsuccessfully to duplicate the issue with LO 4.4.0.2 on Win 7
x64. Can you tell us which version of LO you are using, upload an
illustration to a file sharing service and post the link back to the list.

Dave



-- 
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: Calc issue: green display bug

[Dave Barton]

 Original Message  
From: Xbot 
To: users@global.libreoffice.org
Date: Mon, 19 Jan 2015 17:02:44 +0100

> Sorry I didn't knew:
> 
> - here is the xlsx file:
> http://demo.ovh.eu/download/a148c18ea657f9a5a1cf506f7fc4a5e7/green.xlsx
> - here is the screenshot: http://i.imgur.com/x7KafJZ.png
> 
> Hope it works now :)
> 
> Best regards

As you say opening the xlsx file in LO does produce the green splash
caused by multiple renderings of an embedded image.

I ran two alternative tests:

1. Opened the file in Excel 2013 and (as expected) it displayed
correctly. However, there was no visual evidence of the image. I then
extracted the contents of the file and removed the image.
When I reopened the modified file in Excel the file still displayed
correctly, which suggests that the image served no useful purpose, or
Excel somehow auto-adjusted to the image's removal.
When I reopened the modified file in LO the green splash was gone, but
LO interpreted the file structure by replacing what was the image with
multiple place holders. While the green splash is inconvenient and
annoying, my main concern would be that, with or without the embedded
image, LO did not render the drop-down list boxes in column B.

2. Opened a fresh copy of the file in Excel 2013 and saved it in ods
format. Opened the ods file (which still contained the embedded image)
in LO and the file displayed correctly, including the the drop-down list
boxes in column B.

I don't know what, if any, purpose the embedded image serves, but it
seems like it would be worthwhile filing a bug report.

If it would be of any assistance, I can send you repaired copies of the
file in both ods & xlsx format.

Dave



-- 
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: Printing from Linux, Kubuntu/Ubuntu

[Dave Barton]

My responses are given in-line with your original message.

 Original Message  
From: Philip Jordan 
To: users@global.libreoffice.org
Date: Tue, 27 Jan 2015 13:51:18 +

> Sorry to interrupt, but I've no idea how this forum or whatever it is works

This is a user support mailing list for LibreOffice.
For a definition of what an electronic mailing lists is see:
https://en.wikipedia.org/wiki/Electronic_mailing_list

> & similarly, I've no idea how to utilise i.e. actually set up LibreOffice
> albeit that I've sent the following yesterday

We are all volunteers located in numerous time zones around the world.
Which means that it can take a little time for your fellow users to see
your request and reply if they think they can possibly assist.

> please I really do need your basic help e.g.
> 
> having downloaded OfficeLibre yesterday (sunday)

The software is called LibreOffice (Libre = freedom), not OfficeLibre
and you should only download from the official website:
https://www.libreoffice.org/download/

> I'm afraid I'm unable to make it work i.e.
> 
> on this Toshiba Laptop
> via it's Windows 8.1 OS
> 
> e.g. there seems to be no installation wizard
>nor a suitable app
>& anyway I just got a message to say
>I could not install it* on this computer
> 
> * that's the app/icon, or do they mean the
>   the whole OfficeLibre?!

Unfortunately, people are being indoctrinated into this "App" nonsense.
You download the installation file from the above link and install the
software as per the instructions shown here:
https://www.libreoffice.org/get-help/install-howto/windows/

Once you have installed the software it will appear in your list of
available programs (What MS calls your Apps).

> Perhaps I'm doing something wrong
> but I've already wasted several hours
> & have bought an icon, as confirmed
> by Microsoft in an email (I can't reply to)

This does not make sense. You should _NOT_ buy anything from anyone,
including Microsoft, in order to use LibreOffice.

> Hope someone there can help please
> 
> Philip Jordan of Dorchester, Dorset UK

You also will find it very helpful to read the "Getting Started" and
"User" guides, available from:
http://www.libreoffice.org/get-help/documentation/

Dave




-- 
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] Is This Possible In Calc?

[Dave Barton]

I don't believe the following is possible, but I hope some Calc guru
(Brian?) here can prove me wrong.

To have a formula in cell A which evaluates the contents of cell B and
changes the style, but NOT the content, of cell C.
eg. A1=contains the formula, B1=0, C1=20
Pseudo Code for cell A1: =IF(B1=10;C1=STYLE(whatever);"")
Changing B1 from 0 to 10 would result in the content of C1 still being
20 with the "whatever" style.

Any thoughts or pointers would be welcome.

Regards
Dave



-- 
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] Is This Possible In Calc?

[Dave Barton]

First a big thank you to all who took the time to answer.

I started out (many hours ago) trying unsuccessfully to work out a
solution with conditional formatting, which is why I changed direction
to the IF formula in cell A1.

The real world situation is way more complex than I previously
explained, but thanks to all your pointers I have conditional formatting
working correctly and should now be able to work out the rest for myself.

Brian: In my book, you definitely do qualify.

Best Regards
Dave


-- 
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] Fwd: shortcut pdf does not respect settings

[Dave Barton]

Guy Voets wrote:
> Hello there,
> 
> The version I use at present is LO 4.4.1.2, with a Dutch interface, om Mac.
> When I use the PDF shortcut in the Standard toolbar (between Save and Print
> icons), the text in the resulting pdf file isn't justified, while it is
> justified in the original odt.
> From the top left menu File > Export as PDF produces the same error.
> I need to make the detour of the Print dialog > PDF > Save as PDF to get it
> right.
> 
> I suppose this is a -new- bug, because in my previous version of LO
> (Feb'15) the pdf text was justified just as its odt original.

Hi Guy,

It might be a Mac and/or a Version 4.4.1.2 issue only, because I cannot
reproduce with 6 different documents (ODT, DOC & DOCX) on Linux &
Windows with Version: 4.4.2.2 from both the toolbar or the menu.

Is it possible for you to update to 4.4.2 ?

Dave



-- 
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] Users support via Twitter

[Dave Barton]

anne-ology wrote:
>Well, if I knew what this twitter was ... how it actually operated,
> ... ... ... etc. ... ... ...
>I would appreciate your response.
> 
>But I guess since I don't know the basics of this 'latest
> phenomenon',
>   I'll remain in the dark a mite longer.
> 
>BTW - I'm reminded of 'Jabberwocky' now ... ... ...

Read all about it:

https://en.wikipedia.org/wiki/Twitter

https://about.twitter.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] Font Settings For Comments?

[Dave Barton]

Under "Options -> LO Writer -> Changes" there are some user configurable
options, but these do not include an option to change the comment font.
Neither does it appear to be possible to apply a character, paragraph or
frame style to comments. (eg. Comments default to a Serif font and
cannot be changed if a user prefers say a Sans font)

The closest thing (Feature Request) I can find in Bugzilla is:
https://bugs.documentfoundation.org/show_bug.cgi?id=91518

An unacceptable "work-around" would be to use the GLOBAL font
replacement table. Does anyone know of an alternative?

Dave


-- 
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] Font Settings For Comments?

[Dave Barton]

Under "Options -> LO Writer -> Changes" there are some user configurable
options, but these do not include an option to change the comment font.
Neither does it appear to be possible to apply a character, paragraph or
frame style to comments. (eg. Comments default to a Serif font and
cannot be changed if a user prefers say a Sans font)

The closest thing (Feature Request) I can find in Bugzilla is:
https://bugs.documentfoundation.org/show_bug.cgi?id=91518

An unacceptable "work-around" would be to use the GLOBAL font
replacement table. Does anyone know of an alternative?

Dave


-- 
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: LibreOffice's documentation (pdf and online)

[Dave Barton]

 Original Message  
From: Dallen
To: users@global.libreoffice.org
Date: Wed, 24 Jun 2015 11:18:26 -0700 (MST)

> I have joined the documentation team already and am working with
> them. What I'm looking for is feedback from users. It's easy for
> writers to write what they want to write or what they find useful.
> What I want to know is how users feel about the documentation.

Ding! Ding! Hello!
Who the heck do you think has been writing this stuff since 2001?
Short answer: USERS!!!

There is no "Documentation Team", only a tiny handful of USERS, who
occasionally step up to the plate and try to contribute something that
may be of help to our fellow USERS. Be assured that none of those
contributors only "write what they want to write or what they find
useful" and if they wanted "easy" they would not write anything.

To the best of my knowledge, only one of those USERS has professional
writing skills and without her tireless input from day one neither the
previous OOo project or LO would not have any usable documentation.

Of course it's possible to create documentation in the form of videos,
epub, slide presentations or any other "all-singing, all-dancing,
lights-bells-whistles-and-buzzers" media form anyone wants to add to
their wish list. There is just one tiny trivial problem, finding the
army willing volunteers to take on these tasks. Research is good, but
the research priority should be how to find and keep documentation
contributors.

Regards
Dave






-- 
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] Europass docs

[Dave Barton]

 Original Message  
From: Tanstaafl
Date: Wed, 15 Jul 2015 09:10:09 -0400

> On 7/15/2015 2:54 AM, Malgosia Askanas  wrote:
>> I am using Libre Office Writer 4.4.2.2 under Ubuntu 15.04 to read some 
>> (externally created) Europass CVs (with extension .doc), but LibreOffice 
>> makes an unreadable mess of them, overlaying lines over one another, 
>> etc.  Can anybody suggest a remedy?  The obsolete Word on my MacOS 10.4 
>> system displays them perfectly...
> 
> What is a 'Europass CV'?

https://europass.cedefop.europa.eu/en/home
https://europass.cedefop.europa.eu/editors/en/cv/compose

> That said, you should always try the latest version... so, try
> installing 4.4.4.3...

The ".doc" files generated by Europass CV are a mess when opened in LO,
no matter which version is used, including 5 RC3. They render almost
perfectly in AOO 4.1.1, go figure.

Assuming Malgosia asked candidates for Europass submissions, it would
have been wise to specify the ODF ".odt" or PDF option Europass offers.

Dave



-- 
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] Question about LO Writer and "complex documents"

[Dave Barton]

 Original Message  
From: Anne-ology
Date: Fri, 24 Jul 2015 16:08:53 -0500

>Maybe someone would be so kind as to explain the difference between
> .ODT & .OTT;
>   when is the latter used & how does it differ?

ODT (OpenDocument Text) = Writer Document
OTT (OpenDocument Template) = Writer Template

Opening a OTT file in Writer will create a new blank ODT document with
the attributes/styles contained in the OTT template. The OTT template is
not altered by anything added to the new ODT document.

An ODT document can be used to create an OTT template.

Suggest you read the "Styles" & "Templates" chapters of the Writer User
Guide for more detailed information:
https://wiki.documentfoundation.org/Documentation/Publications



-- 
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] Question about LO Writer and "complex documents"

[Dave Barton]

anne-ology wrote:
>I still don't understand that problem of opening at the beginning
> only;
>   my documents always re-open at the spot where last saved.


That's because you have put a/your name in the "User Data" section of
the "Options" dialog.
This is one of the program's little peculiarities :)



-- 
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: Unable to Protect/Unprotect cells in Libreoffice 5

[Dave Barton]

 Original Message  
From: Tanstaafl
Date: Fri, 28 Aug 2015 07:17:31 -0400

> On 8/28/2015 1:44 AM, Denis Navas  wrote:
>> I copied a table from calc to write.
> 
> This bug isn't about embedded spreadsheets, it is about WRITER TABLES.
> They are two totally different things.
> 
> To reproduce:
> 
> 1. Open new blank Writer document.
> 2. Click on the Table menu, click on 'Insert Table'.
> 3. Click inside a cell.
> 4. Click the 'Table' menu, click on 'Protect Cells'
> 
> Now try to unprotect the cell you just protected. There is no way to do it.
> 
> Protecting/Unprotecting the entire Table using the Navigator does NOT
> unprotect the cell that you protected.

There are a few ways to make the "Unprotect Cells" option visible:

  o Customize the Table menu by adding the "Unprotect Cells" entry.

  o With the "Tables" toolbar visible, right click on the toolbar and
select "Unprotect Cells" from the context menu.

  o Customize the "Tables" toolbar by adding the "Unprotect Cells"
button.

HTH

Dave



-- 
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: Unable to Protect/Unprotect cells in Libreoffice 5 (Correction)

[Dave Barton]

 Original Message  
From: Dave Barton
Date: Fri, 28 Aug 2015 14:01:37 +0200

>   o Customize the "Tables" toolbar by adding the "Unprotect Cells"
> button.

Sorry this should have read:

  o Right click on the "Tables" toolbar & select "Unprotect Cells"
from the "Visible Buttons" list.

Dave



-- 
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 5.0.1.2 Writer: Tab icon pixels do not refresh

[Dave Barton]

 Original Message  
From: Daibutsu
Date: Thu, 10 Sep 2015 10:44:31 -0700 (MST)

> Hi,
> 
> hope this helps ... please have a close look at the tab icon on the left end
> of the ruler. From left to right: After 1st click, after 2nd click and after
> 3rd click. 
> 
>  

Yes, this is an irritating little regression introduced in version 5.
Have you submitted a bug report? If not use the following link:
https://bugs.documentfoundation.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] Conditional Formatting On Date

[Dave Barton]

In Calc I have column with a series of calculated dates (ie. the result
of a formula). I am looking to find a way of using conditional
formatting to set the background colour (eg. green) for those dates
which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5
sets Format: Cell Background = Green)
Can anyone offer any pointers to a solution?
TIA
Dave



-- 
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] Conditional Formatting On Date [SOLVED]

[Dave Barton]

 Original Message  
From: Brian Barker
Date: Mon, 14 Sep 2015 06:15:32 +0100

> At 22:10 13/09/2015 +0200, Dave Barton wrote:
>> In Calc I have column with a series of calculated dates (ie. the
>> result of a formula). I am looking to find a way of using conditional
>> formatting to set the background colour (eg. green) for those dates
>> which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5
>> sets Format: Cell Background = Green)
>>
>> Can anyone offer any pointers to a solution?
> 
> I think you have (almost?) answered your own question.
> 
> o Select *one* cell of your range - e.g. your A2.
> o Go to Format | Conditional Formatting... .
> o With "Condition 1" ticked, select "Formula is".
> o In the Cell Value Condition box, enter: WEEKDAY(A2;2)>5
> o For Cell Style, select Green. You need either already to have defined
> a "Green" cell style or else to create one on the fly using the New
> Style... button.
> o Now copy that formatting to other cells in your range. You can do this
> either by using the Format Paintbrush or by copying A2 and pasting it
> over the range, but using Paste Special... and selecting *just* Formats
> in the Paste Special dialogue.
> 
> Alternatively there is a quite different technique using the STYLE()
> function. Modify your original formulae to read:
> =+STYLE(IF(WEEKDAY(CURRENT();2)>5;"Green"))
> 
> I trust this helps.
> 
> Brian Barker

Yes, Thank you Brian. I knew where I wanted to go, but took a wrong turn
and got lost. I now have no idea why I missed the obvious.
Also, thanks for reminding me about the "+STYLE(IF" alternative.
Guess I was having a brain deadlock day. :(

Regards
Dave



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

[Dave Barton]

 Original Message  
From: Dave Boland
Date: Mon, 14 Sep 2015 15:03:39 -0400

> Brian,
> 
> Well, I tried that.  The problem was all the marks and words I made on
> the monitor (crib notes) - they ruined my monitor :-)) .

Soft felt tip pens are not so damaging :-))

> Actually, that is the point.  I tend to write things in the margins to
> clarify a point, or an example, etc.  Tough to do that with the PDF
> version.

Seriously, grab the ODT editions from
https://wiki.documentfoundation.org/Documentation/Publications
then you can add all the notes you want. Maybe you could even finish up
contributing your edits to the doc project. :) Yes?

> In any event, the Ver. 5 docs. are not out yet, so we come back to my
> question - how close are the 4.2 docs?  I looked at the change log, but
> I never get a good feel for the changes until I start using something. 
> In the case of Calc, the changes to areas I need seem to be minor.

The number of changes vary from module to module. Unfortunately, it's
not just a case of "plonking" new bits of text into revisions of the
existing documents. There are a number of other aspects that slow down
the editing/reviewing process, such as screen captures for interface
changes and revised instructions for default menu/toolbar items that
have been moved, added and removed. Compared to previous documentation
revisions there have been massive changes in these areas and there are
more to come in the next releases.

In addition to the above, the main reason for the delay in docs for
version 5 is the tiny number of (overworked) people working on them. We
have been very fortunate to have the "Base Handbook" for 5 near
completion, thanks to the German language project (mainly Robert
Großkopf), who not only created the original, but also did most of the
"heavy lifting" translating it into English.

The short answer to your question is that the 5 docs are not much more
that a dot on the horizon, so go with the 4.2 docs for now.

> Dave
> --
> The world is my coloring book; I just can't stay within the lines.
> 
> 
> On Mon, Sep 14, 2015, at 02:50 PM, Brian Barker wrote:
>> At 13:58 14/09/2015 -0400, Dave Boland wrote:
>>> ... would it be worth going to the bother of printing the 4.2 docs 
>>> for Calc and Base?
>>
>> Why print them? Do you have access to a computer? If so, you can 
>> search the documentation and read it on your display!
>>
>> 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: MS Word compatability

[Dave Barton]

 Original Message  
From: Esjworks
Date: Thu, 01 Oct 2015 15:08:28 -0400

> 
> 
> On Thu, Oct 1, 2015 at 1:39 PM, Tom Davies  wrote:
>> Hi :)
>> +1
>> It is still important for LibreOffice to improve compatibility with
>> certain
>> secretive and constantly changing formats.  Our devs do a fantastic job
>> with this but this is one area where even fairly normal point&click users
>> (such as me) can actually help them directly.
> 
> maybe we should make a word plugin that reads LO format files. ;-)

Sun did that years ago for MS Office pre-2007 SP1. Since then MS Office
has been able to (somewhat perversely) open/edit/save ODF files.



-- 
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: MS Word compatability

[Dave Barton]

 Original Message  
From: Andreas Säger
Date: Thu, 1 Oct 2015 21:54:24 +0200

> Am 01.10.2015 um 21:08 schrieb esjworks:
>>
>>
>> On Thu, Oct 1, 2015 at 1:39 PM, Tom Davies  wrote:
>>> Hi :)
>>> +1
>>> It is still important for LibreOffice to improve compatibility with
>>> certain
>>> secretive and constantly changing formats.  Our devs do a fantastic job
>>> with this but this is one area where even fairly normal point&click users
>>> (such as me) can actually help them directly.
>>
>> maybe we should make a word plugin that reads LO format files. ;-)
>>
> 
> It is more or less OpenOffice 3 with no GUI:
> 
>> http://www.softpedia.com/get/Office-tools/Other-Office-Tools/Sun-ODF-Plugin-for-Microsoft-Office.shtml

That is version 3.1 released around June 2009. The improved version 3.2
was released just before Oracle acquired Sun.




-- 
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] Incorrect PDF export of SVG in Calc headers

[Dave Barton]

 Original Message  
From: Laurent Larsonneur
Date: Fri, 2 Oct 2015 12:22:51 +0200

> Hello,
> Thanks for the reply.
> I'll find a workaround for the moment, but I understand that this is a
> bug, that needs to be corrected.
> Anyone knowing the appropriate way to pass the information of this bug
> to the developers?

https://wiki.documentfoundation.org/QA/BugReport



-- 
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: Tooo many messages on this mailing list?? How to avoid being swamped ...

[Dave Barton]

 Original Message  
From: M Henri Day
Date: Sun, 18 Oct 2015 14:47:01 +0200

> 2015-10-18 13:49 GMT+02:00 Tim---Kracked_P_P---webmaster <
> webmas...@krackedpress.com>:
> 
>> On 10/17/2015 10:39 AM, Andreas Säger wrote:
>>
>>> Am 16.10.2015 um 18:45 schrieb anne-ology:
>>>
 curiously wondering what gmane is ...
curiously wondering what else I'll be a-learnin' today ...
   curiously wondering what the newest computer gadget'll be
 ...
  curiously wondering ... curiously wondering ...
 curiously
 wondering  ;-)

 very interesting indeed;
and remember'g how file folders expanded to hold letters by
 same
 case ...
   ah, times ... they've been a-changin'  ;-)



 Mailing lists and aggregators are tools of the 90ies. Almost forgotten
>>> in the twitter age.
>>>
>>
>> Not everyone like to use Twitter or Facebook.
>>
>> I have not used Twitter in years, and the only reason I have a Facebook
>> account is for connecting with family and friends worldwide [that share
>> photos and such on Facebook].
>>
>> Most communications, that are not face-to-face or over the phone, are done
>> via email.  I prefer this.
>>
>> "tools of the 90ies"?  Well so are desktops, laptops, web servers, and
>> other tech that is the foundation of what we use today.
>>
>> As for "Twitter", well the national news has stated that Twitter, and some
>> other social media outlets, are downsizing due to the lack of use.
>>
>> Also, a case for email lists, it is hard to keep out the "trolls" on
>> social media than it is on an email list.  There has been many cases of
>> misinformation placed on social media just to cause trouble for individual,
>> organizations, and businesses.  I really do not want to see something like
>> that for our "help services".
>>
>> I may be wrong, by the opinions of others, but I trust managed/monitored
>> email help lists over "social media" sites for helping me with any problems
>> I may have with LibreOffice.
>>
> 
> ​Strongly agree with your points above, Tim
> 
> Henri​

+1

Dave




-- 
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] LEBRE VERSION STILL

[Dave Barton]

 Original Message  
From: Vermas Chandigarh
Date: Tue, 3 Nov 2015 22:56:16 +0530

> Have said this earlier also – the software does not work with nitro pdf 
> writer 8 and beyod. The office software just hangs.
> Sorry but this bug is not taken care of by you guys
> Regards
> Sanjay verma

Hi Vermas,

There appears to be something misconfigured on your system. I have just
test printed several files from Writer/Calc 4.4.6 & 5.0.3 using Nitro
Pro 10.5.1.17 as a printer on Win 7 Ult. x64 and Win 10 Pro x64 with no
problems.

Italo has already pointed out there is no advantage to using the Nitro
printer, because the quality of the output from the in-built PDF export
(which is what I routinely use) is equal to, or (arguably) better, than
Nitro printer.

As Joel has indicated, it would be wise to first canvas the experience
of other users before unilaterally declaring a failing of your own
system as a bug in the LO software. If such a bug exists, might it not
be in Nitro's printer software? Sorry, but I am unable to revert back to
my old Nitro version 8 to try and prove/disprove your assertions.

Regards
Dave



-- 
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] Uninstalling incompatible extension

[Dave Barton]

 Original Message  
From: Jwkokc
Date: Wed, 3 Feb 2016 15:35:25 -0700 (MST)

> After installation of version 5.03, I found that the 'AltSearch" extension
> that I had installed for version 4.x is apparently incompatible with the
> newer version, but I have not yet located any instructions for removing such
> an extension. Now, each time I save a document while exiting from Writer, I
> get an error message that files are damaged and will be reconstructed next
> time I open them.
> 
> No damage is evident, and no files are listed in the message. I renamed my
> user profile as per the on-line instructions, and the message went away, so
> I presume it's connected somehow to the presence of the incompatible
> extension. However I have customized my system to such an extent that I need
> to return to the original user profile to be able to work comfortably.
> 
> Is there a process for removing such material, or must I bite the bullet,
> blow away my entire installation (which is on Xubuntu 14.04.3) and install
> version 5 anew from the PPA?

Jim,

I am not an Xubuntu user, but I am using the vanilla LO 5.1.0.3RC3 x64
on PCLinux and Windows 7 with the AltSearch extension version 1.4.1
which is working perfectly for me. I did experience a problem with macro
errors (no crashes) in a previous LO version (4.?), but this was
resolved by removing and reinstalling the extension.

Where did you hear that the extension was incompatible with the 5.x
versions of LO?

Dave



-- 
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] Problem with Document- Bad Behavior

[Dave Barton]

 Original Message  
From: Piet Van Oostrum
Date: Fri, 5 Feb 2016 18:28:55 +0100

> rgarcia7 wrote:
> 
>  > Greetings.
>  > 
>  > https://cloud.openmailbox.org/index.php/s/4ulZUqq3zP3Ewye
>  > 
>  > This document gets a blinking white box on pages 60-63,
>  > but i don't know if this a bug or a error in the file structure.
>  > 
>  > Document exported from Google Drive (It was uploaded as PDF) as .docx .
>  > 
>  > Tested on:
>  > - LibreOffice 5.0.3.2 (Fresh) on Linux Ubuntu
>  > - LibreOffice 4.4.7.2 (Still) on Windows 7 64-bit
>  > 
>  > Thanks for your Help.
> 
> No problem with LO 5.1.0.3 (RC3) on Mac OS X 10.10.5

Not an issue with LO 5.1.0.3 (RC3) on Win 7x64 or PCLinuxOS x64.



-- 
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: How to find out which fonts are used in an Open Document?

[Dave Barton]

 Original Message  
From: Pedro
Date: Sat, 6 Feb 2016 02:57:13 -0700 (MST)

> Hi Jonathon
> 
> 
> toki wrote
>> I _think_ that the TestFonts extension works for Impress.
>>
>> It was designed for Write.
> 
> Brilliant!

Yep! Just like most of Tom Bilek's extensions.

> It was exactly something like this I was looking for (how stupid
> of me not to remember looking in OpenOffice Extensions where there are many
> more extensions available...)
> 
> BTW the extension works perfectly in LibreOffice 4.4.7 and 5.0.4.2 but
> doesn't work in 5.1.0.3

Which OS? The extension works perfectly for me in Writer LibreOffice
5.1.0.3 x64 on Window 7 & PCLinuxOS.

> Unfortunately you are right. It only works in Write. I will ask the author
> if he is willing to adapt it to Impress (and Draw), where I believe they are
> _very_ useful.

You might find that Tom is overloaded with other commitments at the
moment, but I feel sure he would be open to a RFE.

> Thank you for your valuable answer!
> 
> Thank you to all that contributed to this discussion!
> 
> Warm regards from
> Pedro

Regards
Dave



-- 
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: How to find out which fonts are used in an Open Document?

[Dave Barton]

Hi Robert,

This is one of the AOO extensions:
http://extensions.services.openoffice.org/en/project/testfonts
which redirects to SourceForge.

Regards
Dave

 Original Message  
From: Robert Funnell
Date: Sat, 6 Feb 2016 07:34:01 -0500 (Eastern Standard Time)

> I don't know what I'm doing wrong but I can't find the TestFonts
> extension at http://extensions.libreoffice.org/. Could someone please
> provide a direct link or some other pointer?
> Thanks.
> 
> - Robert
> 
> On Sat, 6 Feb 2016, Pedro wrote:
> 
>> Hi Jonathon
>>
>>
>> toki wrote
>>> I _think_ that the TestFonts extension works for Impress.
>>>
>>> It was designed for Write.
>>
>> Brilliant! It was exactly something like this I was looking for (how
>> stupid
>> of me not to remember looking in OpenOffice Extensions where there are
>> many
>> more extensions available...)
>>
>> BTW the extension works perfectly in LibreOffice 4.4.7 and 5.0.4.2 but
>> doesn't work in 5.1.0.3
>>
>> Unfortunately you are right. It only works in Write. I will ask the
>> author
>> if he is willing to adapt it to Impress (and Draw), where I believe
>> they are
>> _very_ useful.
>>
>> Thank you for your valuable answer!
>>
>> Thank you to all that contributed to this discussion!
>>
>> Warm regards from
>> Pedro



-- 
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: Broken .docx

[Dave Barton]

 Original Message  
From: Andrea Venturoli
Date: Tue, 23 Feb 2016 10:51:03 +0100

> On 02/22/16 10:42, Pedro wrote:
>> Hi Andrea
>>
>>
>> Andrea Venturoli wrote
>>> What surprised me is that both LO 5.0.5 and OpenOffice were able to open
>>> all of them without any trouble on FreeBSD.
>>>
>>> If any developer is interested I can send one file to check.
>>
>> Maybe you can report this bug on Bugzilla and include the file?
>> https://bugs.documentfoundation.org/
> 
> Done:
> https://bugs.documentfoundation.org/show_bug.cgi?id=98105
> 
>  bye & Thanks
> av.

I don't have access to an earlier version at the moment, but your
example bug attachment opens perfectly with Version: 5.1.1.1 (x64)
Build ID: c43cb650e9c145b181321ea547d38296db70f36e
also MS Word 2013 & AOO 4.1.2 on Win 7 Ult. x64

Will check with earlier versions on Linux, Win XP, 7 & 10 later.

Regards
Dave


-- 
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: No access to character accent menu in LO 5.0.0.5 under OSX 10.11

[Dave Barton]

Which suggests that none of the users mailing list subscribers knows the
answer to the question. If you want to bring this to the developers
attention submit a Bugzilla report:
https://wiki.documentfoundation.org/QA/BugReport


 Original Message  
From: Marcgrober
Date: Thu, 25 Feb 2016 10:55:31 -0700 (MST)

> Not even a response to whether this is a feature or a bug?
> 
> 
> marcgrober wrote
>> A great OSX feature  is the character accent menu available in OSX (you
>> can set the OS so that holding down a key pops up a menu with special
>> characters, instead of just endlessly repeating the key).  With the roll
>> out of ElCap (OSX 10.11.3), Apple made repeating letters the default.
>> While one can reset the default to the pop-up accent menu,  this reset
>> does NOT work in LO (one has to manual enter the Special Character menu).
>>
>> Is this rejection of the OS setting a 'feature' of LO (5.0.0.5) or a
>> bug, and in either case is there a way to implement the  OS setting?
>>


-- 
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] Sidebar Survey

[Dave Barton]

For those who do not subscribe to the design mailing list, or follow the
project's design blog, a new survey has been produced to ascertain what
users want/expect from the sidebar in future developments.

The blog post explanation, together with a link to the survey, can be
found here:
https://design.blog.documentfoundation.org/2016/02/26/what-do-you-expect-from-the-sidebar-in-libreoffice/
In case the above link structure is broken by the list server, I have
created a shortened link: http://bit.ly/1oH2Lql

The survey is open now and will run until 18th. March.

As the blog post indicates, it will be of great assistance to those who
directly contribute to the software's design to get answers to this
survey from as many users as possible. So please spread the word.

Dave


-- 
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] Sidebar Survey

[Dave Barton]

 Original Message  
From: Tanstaafl
Date: Sun, 28 Feb 2016 07:31:33 -0500

> On 2/28/2016 5:44 AM, Dave Barton  wrote:
>> For those who do not subscribe to the design mailing list, or follow the
>> project's design blog,
> 
> Wasn't aware of either...
> 
> Links?

https://www.libreoffice.org/get-help/mailing-lists/

Main Blog: https://blog.documentfoundation.org/

Design Blog: https://design.blog.documentfoundation.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

Re: [libreoffice-users] View / edit control points in Impress and Draw

[Dave Barton]

-- Original Message --
Subject: [libreoffice-users] View / edit control points in Impress and Draw
Date: Mon, 16 May 2016 09:52:07 +0200
From: Leo Moons 

> 
> Hello,
> In the release notes for LibreOffice 5.1
> https://wiki.documentfoundation.org/ReleaseNotes/5.1 it is mentioned
> that the control points can be adjusted manually by inserting the X and
> Y values. Right clicking on the figure and choosing Position and size
> opens the dialog but it does not work for me as these spin boxes are
> greyed out. Am I doing something wrong or is it a bug? I am working
> under Windows 7 with LibreOffice 5.1.2.2
> Many thanks
> Best regards
> Leo Moons
> LibreOffice/nl

Have you unintentionally set protection of the position in that dialog?
Look for a tick/check mark in the "Protect -> Position" box. (Bottom
left hand corner of the dialog)

Regards
Dave



-- 
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] Default font in LO calc

[Dave Barton]

On 21.02.2017 03:56, Ian Whitfield wrote:
> *Thanks Everyone*
> 
> I seem to have stirred-up a real Hornets Nest here - but to me it just
> shows how badly this part of LO is!!! It's a GREAT program except for
> this problem and of course the orphan child Base!!
> 
> Anyway - still no luck here - I tried the Side-Bar method first of all
> but my version has no such option as Cell Styles - so no joy there!!
> 
> Next I tried starting a new Spreadsheet, changing to the Font and size I
> want, (which is what I've been doing for a couple of years or so), and
> then saving this as a Template with the name 'Default'. I then close
> down the program and re-start it and it comes up with Liberation Sans 10
> still *GRR!!!*
> 
> This should be one change in the Options Menu - "Set Default Font and
> Size". Why all these hoops to jump through!
> It's no wonder some people leave LO for other programs!!
> 
> But thank you all for trying - appreciated. (back to the repetitive
> manual method I guess!)
> 
> IanW
> Pretoria RSA.

Hi Ian,

I cannot understand why this is not working for you. The simple one time
method of creating a default Calc template described in my previous
email works perfectly for me and 14 others here all using PCLinuxOS and
LO version 5.3.0.3

My guess is the problem is either an issue with your user profile, or
something else in your setup that we are not picking up from your
description.

Try directly opening the attached sample template and you should see a
single sheet with Bold 14pt. Liberation Serif font. If not there is
something "adrift" in your setup.

Regards
Dave



-- 
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] Documentation Team Call For Help

[Dave Barton]

In the world of open source software LibreOffice has one of the shortest
time based release cycles. One downside of this schedule is that the
Documentation Team has been unable keep pace with the release frequency
for publication of the User Guides. With the release of LO Version 6.0
targeted for Q1 of 2018
,
the Documentation Team is attempting to proactively begin work on the
“/Getting Started/” guide now, in order to have at least the basic guide
ready for publication by the time version 6.0 is released.

To achieve this target the Documentation Team is seeking the help of new
and past authors/reviewers. While skilled technical authors will always
be welcome, anyone, regardless of their writing skills and knowledge of
the software, can contribute to this effort. The only requirements are,
a reasonable ability to read and write in English. Users with little or
no previous experience can make a valuable contribution, by carefully
following the revised guide chapters and reporting anything that does
not agree with the actual software, or is not sufficiently clear for
inexperienced users to understand.

If you would like to help in any way, please email a request for more
information to the Documentation Team: documentat...@libreoffice.org


Your assistance will be greatly appreciated.

Regards

Dave



-- 
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 Scolling problems under Windows.

[Dave Barton]

On 23.07.2017 11:23, Pedro wrote:
> Dave-3 wrote
>> Is anyone else experiencing a similar issue, or is there a known
>> rendering problem in recent versions of LO?
> 
> LibreOffice has switched (don't know exactly which version) to OpenGL
> rendering which is on by default in recent versions.
> 
> Go to Tools > Options and select on the left listing LibreOffice, View and
> then uncheck "Use OpenGL for all rendering"
> 
> If this doesn't help, can you report a bug and append to it  one of the
> documents that causes problems?

Hi Pedro,

Yes, I was aware of this change and I always disable OpenGL rendering.

The issue is the same if the option is checked or not.

Regards
Dave

-- 
Please address any reply to the mailing list only. Any messages sent to
this noreply@ address are automatically deleted from the server and will
never be read.

-- 
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: Fixing 5.0 appearance

[Dave Barton]

On 22.12.2017 03:07, Virgil Arrington wrote:
> On 12/21/2017 04:00 PM, V Stuart Foote wrote:
>> Either case you can select the Styles and Formatting content panel--and
>> at the 6.0.0 beta2 build the selected Sidebar deck will reopen when the
>> module opens.
>>
>>
> Yay!
>
> I've hated the Sidebar deck ever since it was introduced. I had 
> previously had my styles list docked to the side all by itself, but with 
> with Sidebar deck, I have had to navigate through other layers of stuff 
> I never use to get to my styles list.
>
> In fact, by defaulting to the Properties sidebar, the program encourages 
> direct formatting rather than styles-based formatting.
>
> I'll be thrilled when I can choose to have it default to the styles list.
>
> Virgil

+1000

Even better if the day ever comes when we can have styles list undocked
from the sidebar, in the same way as Navigator.

Dave



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO not finding my scanner

[Dave Barton]

After seeing Tim's post I checked and Insert > Media > Scan > Select
Source... opens an empty dialog and Insert > Media > Scan > Request...
silently fails.
Version: 6.0.0.3 (x64) Build ID:
64a0f66915f38c6217de274f0aa8e15618924765 CPU threads: 8; OS: Windows
6.1; UI render: GL;

No issues with scan in either AOO or MS Office on the same machine.

Dave

On 07.02.2018 22:50, Joe Conner wrote:
> Did you use the menu tree INSERT -> MEDIA -> SCAN?
>
>
> On 02/07/2018 02:25 PM, Tim-L wrote:
>>
>> I just installed 6.0.0.3 64-bit DEB for Ubuntu MATE 16.04LTS.
>>
>> I was looking at some things and I went to "Insert/Media/Scan/Select
>> Source".  LO could not find my Canon TS9020 printer/scanner. I even
>> opened the printer's scan utility and still LO could not find the
>> scanner.
>>
>> This is the first time I looked into using a scanner withing LO, so I
>> do not know if it is a 6.0.0 issue or 5.4.4 or earlier issue.
>>
>> Any ideas?



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO not finding my scanner

[Dave Barton]

This appears not to be a Linux specific issue. I can't speak for macOS
users, but it is definitely a problem with LO 6.0.1.1 on all of my WIN 7
and Linux boxes, where I have zero scanning issues using LO 5.4 or other
office software.

Has anyone entered a bug report yet?

Dave

On 08.02.2018 16:45, Tim-L wrote:
>
> Yes, I tried Insert > Media > Select Source.  It does not show my
> print/scan/copy - Canon TS9020.
>
> Canon's Linux driver for scanning does not work with xsane.  They call
> their interface "scangearmp2".  This has hardly and options compared
> to "scangearmp" which was use for the previous printer/scanners I have
> had [all dead now].
>
> Yes, I have 64-bit Ubuntu Mate, LibreOffice, and Canon drivers.
>
>
> 
>
> On a side note:
>
> This is the first Canon printer that I bought that has Linux drivers
> in their USA web site.  I always had to go to the UK site to get the
> drivers. At least Canon is starting to get the picture that a lot of
> people in the USA are Linux users.
>
>
>
> On 02/07/2018 07:32 PM, Dave Howorth wrote:
>> On Wed, 7 Feb 2018 15:27:33 -0800
>> Girvin Herr  wrote:
>>> Another datapoint:
>>>
>>> I tried it with LO 5.3.4.2 under xfce and Slackware 14.2 Linux with
>>> my Epson 1660 Photo USB scanner and it worked fine with Insert >
>>> Media > Scan > Select Source.
>>>
>>> Girvin Herr
>> And another datapoint:
>>
>> I tried with LO 5.4.4.2 under LXDE on openSUSE Leap 42.3 with an Epson
>> Stylus Photo RX620 and got a 'Due to an unexpected error, LibreOffice
>> crashed.' (It's one of those annoyingly unhelpful error dialogs that
>> won't let you copy the text. GRR!)
>>
>> After restarting LO, it scanned fine. I'll still prefer to use xsane.
>>
>>> On 02/07/2018 03:12 PM, Dave Barton wrote:
>>>> After seeing Tim's post I checked and Insert > Media > Scan > Select
>>>> Source... opens an empty dialog and Insert > Media > Scan >
>>>> Request... silently fails.
>>>> Version: 6.0.0.3 (x64) Build ID:
>>>> 64a0f66915f38c6217de274f0aa8e15618924765 CPU threads: 8; OS: Windows
>>>> 6.1; UI render: GL;
>>>>
>>>> No issues with scan in either AOO or MS Office on the same machine.
>>>>
>>>> Dave
>>>>
>>>> On 07.02.2018 22:50, Joe Conner wrote:
>>>>> Did you use the menu tree INSERT -> MEDIA -> SCAN?
>>>>>
>>>>>
>>>>> On 02/07/2018 02:25 PM, Tim-L wrote:
>>>>>> I just installed 6.0.0.3 64-bit DEB for Ubuntu MATE 16.04LTS.
>>>>>>
>>>>>> I was looking at some things and I went to
>>>>>> "Insert/Media/Scan/Select Source".  LO could not find my Canon
>>>>>> TS9020 printer/scanner. I even opened the printer's scan utility
>>>>>> and still LO could not find the scanner.
>>>>>>
>>>>>> This is the first time I looked into using a scanner withing LO,
>>>>>> so I do not know if it is a 6.0.0 issue or 5.4.4 or earlier issue.
>>>>>>
>>>>>> Any ideas?
>>>>   
>>>
>>
>
>

-- 
Please address any reply to the mailing list only. Any messages sent to
this noreply@ address are automatically deleted from the server and will
never be read.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO not finding my scanner

[Dave Barton]

Hi Jorge,

What you propose may work for a Linux installation, but does not explain
why I am seeing the same issue on Windows machines.

Best Regards
Dave

On 12.02.2018 14:44, jorge Rodríguez wrote:
> Hi Tim and all:
>
>     I'm not an expert on computer science, ... but sometimes, it is
> possible to keep install both version of a program. Why not probe to
> install "scangearmp" in parallel to "scangearmp2" ? It would solve
> your problem.
>
> Regards,
>
> Jorge Rodríguez
>
>
> El 11/02/2018 a las 10:59, Tim-L escribió:
>>
>> Just to throw more issues - LO 5.4.x still does not find my Canon
>> printer's scanning service.
>>
>> So, it could be the Scanner drivers for Ubuntu.  The "scangearmp2"
>> package does not have all of the options as the "version 1" did. To
>> bad.  Now I have to do all of the cropping, etc., via GIMP instead at
>> the scanning level.
>>
>>
>> On 02/11/2018 11:30 AM, Tim-L wrote:
>>>
>>> To be honest, I had never tried to use my scanning option with 5.4
>>> or earlier.  I was just going through the different drop-down menus
>>> after I installed 6.0.0.3.
>>>
>>> I see 6.0.1.x is online for download.  I will install it within a
>>> few days.
>>>
>>> 2 of my 3 laptops have both Windows 10 and Ubuntu Mate 16.04
>>> installed.  The newest laptop is a Ubuntu Mate only box. Right now,
>>> the second oldest laptop is my default one and is the only one
>>> running 6.0.x.x.
>>>
>>> I will look into the uses of the scanning options with one of those
>>> other laptops to see if it scanning works.
>>>
>>>
>>> On 02/10/2018 08:04 AM, Dave Barton wrote:
>>>> This appears not to be a Linux specific issue. I can't speak for macOS
>>>> users, but it is definitely a problem with LO 6.0.1.1 on all of my
>>>> WIN 7
>>>> and Linux boxes, where I have zero scanning issues using LO 5.4 or
>>>> other
>>>> office software.
>>>>
>>>> Has anyone entered a bug report yet?
>>>>
>>>> Dave
>>>>
>>>> On 08.02.2018 16:45, Tim-L wrote:
>>>>> Yes, I tried Insert > Media > Select Source.  It does not show my
>>>>> print/scan/copy - Canon TS9020.
>>>>>
>>>>> Canon's Linux driver for scanning does not work with xsane. They call
>>>>> their interface "scangearmp2".  This has hardly and options compared
>>>>> to "scangearmp" which was use for the previous printer/scanners I
>>>>> have
>>>>> had [all dead now].
>>>>>
>>>>> Yes, I have 64-bit Ubuntu Mate, LibreOffice, and Canon drivers.
>>>>>
>>>>>
>>>>> 
>>>>>
>>>>> On a side note:
>>>>>
>>>>> This is the first Canon printer that I bought that has Linux drivers
>>>>> in their USA web site.  I always had to go to the UK site to get the
>>>>> drivers. At least Canon is starting to get the picture that a lot of
>>>>> people in the USA are Linux users.
>>>>>
>>>>>
>>>>>
>>>>> On 02/07/2018 07:32 PM, Dave Howorth wrote:
>>>>>> On Wed, 7 Feb 2018 15:27:33 -0800
>>>>>> Girvin Herr  wrote:
>>>>>>> Another datapoint:
>>>>>>>
>>>>>>> I tried it with LO 5.3.4.2 under xfce and Slackware 14.2 Linux with
>>>>>>> my Epson 1660 Photo USB scanner and it worked fine with Insert >
>>>>>>> Media > Scan > Select Source.
>>>>>>>
>>>>>>> Girvin Herr
>>>>>> And another datapoint:
>>>>>>
>>>>>> I tried with LO 5.4.4.2 under LXDE on openSUSE Leap 42.3 with an
>>>>>> Epson
>>>>>> Stylus Photo RX620 and got a 'Due to an unexpected error,
>>>>>> LibreOffice
>>>>>> crashed.' (It's one of those annoyingly unhelpful error dialogs that
>>>>>> won't let you copy the text. GRR!)
>>>>>>
>>>>>> After restarting LO, it scanned fine. I'll still prefer to use
>>>>>> xsane.
>>>>>>
>>>>>>> On 02/07/2018 03:12 PM, Dave Barton wrote:
>>>>>>>> After seeing Ti