Re: [libreoffice-users] Pasting data from LO Calc to BricsCAD

[Bruce Hohl]

You might try this:
Tools > Options > Calc > View then Under "Display" set X = Formulas
Now perform the copy and paste.

Or you can save the Calc sheet as a CSV with formulas.
File > Save As (select Text CSV) and set X = Edit filter settings
In the next pop-up set X = Save cell formulas instead of calculated values


On Mon, Jul 10, 2017 at 9:02 PM, Brian Barker 
wrote:

> At 23:52 10/07/2017 +0200, Wiebe van der Worp wrote:
>
>> I was watching this video: https://blog.bricsys.com/tutor
>> ials/bricscad-spreadsheet-import/ It describes two methods to get data
>> from a spreadsheet to a CAD table entity. The first method uses csv from
>> Calc, imported to CAD. The second method is a paste special procedure with
>> Excel (viewer) with preservation of (a limited set of) formulas. The
>> question concerns the second method: Is there an easy way to achieve this
>> with Calc without an Excel viewer?
>>
>
> Surely the answer is just to suck it and see? You can copy a range of a
> spreadsheet sheet from Calc just as you could from Microsoft Excel or the
> Excel Viewer. The question then is what your other product makes of that in
> pasting it in. Try Paste and try Paste Special, and try whatever options
> that offers. The copy from Calc will carry formulae; the only question is
> whether your other product can use this properly. I'd guess it probably
> would, but I don't have it to try.
>
> I trust this helps.
>
> Brian Barker
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Fwd: + session of Calc: everything scares frightfully.

[Bruce Hohl]

By "rebuild" I mean that the worksheet is manually recreated starting with
a blank worksheet.  As much as practical enter again formulas.  Data can be
copied from the original worksheet but use "Edit > Paste Special as Text,
Numbers or Date & time".  Add needed formatting to the new worksheet (do
not copy formatting from the old worksheet).   There is no guarantee this
will solve the problem.  Consider this to be a test.  Be happy if this
works!

On Mon, Jul 10, 2017 at 1:46 PM, Paolo Del Romano 
wrote:

> Try to explain me better.
>
> If I open two or three sheets of calc at the same time, everything slows
> down
>
> Paolo
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Fwd: + session of Calc: everything scares frightfully.

[Bruce Hohl]

Just a few general comments:

LibreOffice is a relative large desktop application so if you have a low
resource computer (old or very low cost) performance will be slower with
more open worksheets.

Performance is affected by the "size" of each worksheet.  "Size" somewhat
difficult to measure but more cells used, more formulas used and more
formatting used affect performance.

I have a few large worksheets for which I uncheck "Menu > Data >
AutoCalculate".  I must then press F9 to update the formulas.

Several times on this mailing list people have reported slow performance
related to cell formatting.  Some worksheets converted from Excel include
formatting "baggage" which can slow performance.  Sometimes I rebuild these
worksheets in LibreOffice to leave this "baggage" behind.

On Mon, Jul 10, 2017 at 1:46 PM, Paolo Del Romano 
wrote:

> Try to explain me better.
>
> If I open two or three sheets of calc at the same time, everything slows
> down
>
> Paolo
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] + session of Calc: everything scares frightfully.

[Bruce Hohl]

Paolo,  Regarding your problem, please provide more information.

On Mon, Jul 10, 2017 at 6:02 AM, Paolo Del Romano 
wrote:

> users@global.libreoffice.org
>
>
>
> I have the following problem.
> When launching more Libreoffice scales at the same time, everything
> scares frightfully.
>
> I use linux and then paste my software versions.
>
> Greetings
> Paolo
>
>
>
>
> ***
>
> Versione: 5.1.6.2
> Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
> Thread CPU: 4; Versione SO: Linux 4.4; Resa interfaccia: predefinito;
> Versione locale: it-IT (it_IT.UTF-8); Calc: group
>
> **
>
>
> paolo@paolo-PC686:~$ uname -a
> Linux paolo-PC686 4.4.0-83-generic #106-Ubuntu SMP Mon Jun 26 17:54:43
> UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
>
>
> 
>
> paolo@paolo-PC686:~$ cat /etc/*release
> DISTRIB_ID=Ubuntu
> DISTRIB_RELEASE=16.04
> DISTRIB_CODENAME=xenial
> DISTRIB_DESCRIPTION="Ubuntu 16.04.2 LTS"
> NAME="Ubuntu"
> VERSION="16.04.2 LTS (Xenial Xerus)"
> ID=ubuntu
> ID_LIKE=debian
> PRETTY_NAME="Ubuntu 16.04.2 LTS"
> VERSION_ID="16.04"
> HOME_URL="http://www.ubuntu.com/";
> SUPPORT_URL="http://help.ubuntu.com/";
> BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/";
> VERSION_CODENAME=xenial
> UBUNTU_CODENAME=xenial
>
>
> **
>
> --
> Paolo Del Romano
> delrom...@gmail.com
> PEC: paolo.delrom...@pec.commercialisti.it
> cell. 327-3504844
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Creating a custom label problem

[Bruce Hohl]

If you go to the Avery.com site and create an account you can use their
online label tool.  It's fairly easy to use and allows you to save your
"projects" for future use.  I printed the result to PDF and used the PDF to
create labels as needed.  It's helpful to have access to a high end printer
(like at work) which can feed the label stock more precisely than the
inexpensive printers typically used at home.

On Sat, Jun 24, 2017 at 10:32 PM, Ken Springer  wrote:

> Hi, gordon,
>
> Thanks for the suggestion.
>
> I just looked, and there is no Mac specific download for it.  I have the
> impression that a lot of Linux/Unix software will run on the Mac, but I
> don't know how to do that level of installations.
>
> Doing it doesn't really turn me on anyway.  LO
>
>
> On 6/22/17 10:46 PM, gordon cooper wrote:
>
>> Hi Ken,
>>
>> Unsure if 'glabels' will run on your Mac but it have does templates
>> for the Avery 15 x 4  series.
>>
>> Goer
>>
>>
>> On 23/06/17 14:25, Ken Springer wrote:
>>
>>> Hi, Remy,
>>>
>>> Or, you could just create a table of 15 rows, and do the height
>>> adjustment for all rows at once.  
>>>
>>> Then, there's the option of using the Avery template that's available,
>>> but I think it requires the Avery software.  I did not investigate
>>> that option.
>>>
>>> Or, you can do what I did.  I used a different program that had one of
>>> the Avery labels in the list, and got it done.  
>>>
>>>
>>>
>>>
>>> On 6/22/17 6:57 PM, Remy Gauthier wrote:
>>>
 HI,

 You are right. The fields for user-defined layouts seem to adjust
 themselves randomly (looks like a validation problem where the value
 that is entered is validated before the cursor leaves the field). The
 only way I was able to create something that looks like what you are
 looking for is to:

 1) Create an empty document.
 2) Adjust the page margins to match the cutout locations of your Avery
 label sheet (Format -> Page -> Page).
 3) Insert a 1 row/4 column table that has no headers and no borders; if
 your margins are correctly set, the table should now occupy the full
 usable width of the page and each cell should be of the correct width.
 4) Adjust the height of your row by right-clicking in a cell and
 selecting "Size" -> Row Height. Set it to 0.67 inch.
 5) Once this is done, go to the rightmost cell and insert a new row by
 hitting TAB (the new row will be of the same height as the first one).
 Do this until you have the correct number of rows on your page.

 You may need to play with the Spacing to Content (Table -> Properties
 -> Borders) of the cells to position the text inside the cells so it
 stays clear of the cutout lines.

 Not fantasticly user friendly but it should do the job.

 I hope this helps.

 Rémy Gauthier.

 Le mercredi 21 juin 2017 à 10:28 -0600, Ken Springer a écrit :

> LO 5.2.7.2
>
> I cannot find a way to create a label on 8.5 X 11 page labels, where
>>
> the

> label height is .67".  The sheet of labels is 15 rows by 4 columns.
>
> Such a template would be compatible with the following Avery labels:
> 18195, 42895, 5155, 5195, 8195, 15695, 18695, 88695, 48335, 38667,
> 42995, 18294
>
> Adding to this difficulty is the fact that when you try to type into
>>
> the

> input fields, apparently random numbers simply appear.
>
> Known problem?
>
>
>>>
>>
>>
>
> --
> Ken
> Mac OS X 10.11.6
> Firefox 53.0.2  (64 bit)
> Thunderbird 52.0
> "My brain is like lightning, a quick flash
>  and it's gone!"
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] saving as csv newline inserted

[Bruce Hohl]

It appears that the actual contents of Field2 = 05329954A\n where '\n' is a
RETURN (not a TAB).  I was able to remove the \n by (1) select/highlight
the column containing Field2, (2) open Data > Text to Columns, (3) Under
'Separator Options' set Y=Separated by, Y=Other as \n then click 'OK'.  Now
save as CSV.

On Wed, Jun 21, 2017 at 8:52 AM, Uwe Brauer  wrote:

>
> Hi
>
> I have an excel (xls) file which I open with scalc (5.3)
> and save it as csv
>
> Unfortunately it looks like
>
> Field1,Field2,Field3,Field4,Field5
> "Name","05329954A
>",0.55,0.75,1.3
>
> Instead of
>
> Field1,Field2,Field3,Field4,Field5
> "Name","05329954A ",0.55,0.75,1.3
>
>
> The reason is that in the first column there is a after name a space
> which is translated to a newline when exporting.
>
> How can I get rid of this unwanted newline?
> I tried to format the cells but it seemed not to have worked.
> Thanks
>
> Uwe Brauer
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Libre Writer - special characters

[Bruce Hohl]

The hexidecimal unicodes can also be used in Windows with a registry edit:
   Add HKEY_Current_User/Control Panel/Input Method, set EnableHexNumpad to
"1"
   If adding use New > String Value, Type = REG_SZ.

After the registry change
   Press & hold Alt; Press '+' on number pad; enter code; release Alt.

Probably a web search would provide a better explanation.
The main thing is that the same codes can be used on both platforms.

On Sat, May 6, 2017 at 12:38 PM, Dave  wrote:

> On 06.05.2017 17:38, charles meyer wrote:
> > In MS Word the prescription symbol is 211E.
> >
> > In special characters I typed in 211E in the Decimal box but did not get
> > the prescription symbol.
> >
> > Aren’t hexicodes standard so Libre Writer should match MS Word?
> >
> > Is there a quick way when you’re in a document you can type something
> like
> > hold down the Alt key and type in 211 on the numeric pad and get the
> > prescription symbol?
> >
> > Not using a search engine (Google, Yahoo), is there a way in Libre Writer
> > to type in the words “prescription symbol” and it will find the symbol?
> >
> > Or when you’re looking for an unusual symbol, you must Google it to
> > ascertain it’s hexicode unicode, etc.?
> >
> > Otherwise, you’d had to scroll through every symbol chart to find it.
> >
> > Thanks.
> >
> > Charles.
>
> See the answer to your question here:
> https://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=87787
>
> Basically, Writer (just like Word) uses the fonts installed on your
> system. If the font you are using contains the required character,
> Writer will display the 211E symbol in exactly the same way as Word.
>
> 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
>

-- 
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] Formula calculation differences between LO 5.3 and Excel

[Bruce Hohl]

This is not really an answer but you might search bugzilla to get an idea
of what types of differences exist and if any such differences are relevant
to your use.  https://bugs.documentfoundation.org/

On Wed, Mar 22, 2017 at 1:44 PM, bunk3m  wrote:

> When I open most Excel documents I get a message (as per attached
> screenshot) that says
>
> "This document was last saved by Excel. Some formula cells may produce
> different results when recalculated.  Do you want to recalculate all
> formula cells now?"
>
> Where do I find out what these calculation difference might be?
>
> Is there a document that outlines what incompatibilities exist between the
> calculation engines?
>
> If not, can someone summarize what potential issues I need to take into
> account when using LO?
>
> I am on digest mode so please cc me directly in any responses.
>
> Thank you in advance for your help.
>
> B.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] no access to styles in calc

[Bruce Hohl]

Format > Styles > Styles and Formatting (or F11 by default as mentioned)

If you do not want spreadsheet headers & footers by default you can create
a template without headers & footers and set that as your default template.

On Thu, Mar 16, 2017 at 4:21 PM, Steve Edmonds 
wrote:

> Header and footer are in Format>Page.
> What version of Libreoffice. My F11 works ok in 5.2 and has done all the
> way up to 5.2. Can't remember 5.3 as I went back because of a PDF
> generation bug.
> Steve
>
>
> On 2017-03-17 08:10, marianne-x wrote:
>
>> List Ahoy:
>>
>> This is mostly a low-priority enquiry, rather than one of serious
>> aggrevation.
>>
>> Gaining access to “Styles & Formatting” via F11, and the alternatives,
>> works as expected in Writer.
>>
>> But not so in Calc. F11 produces no visible result; alt-O/Y likewise;
>> mouse selection of Format/“Styles and Formatting” is equally inactive.
>>
>> Is there some control somewhere that I have missed, that blocks access to
>> this function?
>>
>> The reason for exploring these nether regions: in Calc, the apparent
>> default is to enable Headers and Footers. I have to say “apparently” since
>> I can't bring up the Styles &c window to see what style is being applied.
>>
>> I want those two additions (header/footer) turned off by default, as they
>> are in Writer, and if I had access to the default Page style control I
>> would change the default page margins also.
>>
>> Curtains 7 — Version: 4.4.7.2
>>
>> Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
>>
>> Locale: en_GB
>>
>> The above data was copied from “About — Libreoffice”, and that “en_GB”
>> gives a bit of pause. Everything seems to function as expected for a USA
>> locale, and we certainly never deliberately changed the locale.
>>
>> Indeed, “Options — Language Settings — Languages” shows:
>>
>> User interface: Default – English (USA)
>>
>> Locale setting: English (USA), &c.
>>
>> There is no apparent deleterious effect, but the appearance of “en_GB”
>> remains an unexplained oddity.
>>
>>
>> for: Miss Keating
>>
>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Wanted: KB shortcut to Calc Name Box

[Bruce Hohl]

Regina & Stuart,  Many thanks.  I did not expect the name of this function
to be "Sheet Area Input Field".  The ease and flexibility of creating LO
Keyboard shortcuts is an outstanding feature that enhances my
productivity.  BH

On Fri, Mar 17, 2017 at 10:19 AM, V Stuart Foote 
wrote:

> It already exists:
>
> +F5  or +T
>
> But if you want to use the F3 key it is available to be assigned from the
> Customize dialog, Keyboard tab
>
> Category -- Application
> Function -- Sheet Area Input Field
>
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/Wanted-
> KB-shortcut-to-Calc-Name-Box-tp4210407p4210412.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

[libreoffice-users] Wanted: KB shortcut to Calc Name Box

[Bruce Hohl]

In Calc I would like to set F3 as a KB shortcut which moves the focus to
the "Name Box" (1st control on formula bar).  This would provide navigation
equivalent to a 'go to cell' command which would be useful for my very
large spreadsheets (without having to reach for the mouse).  I don't see an
option for that under Tools > Customize > Keyboard.  Does anyone know if
such a KB shortcut can be set?

-- 
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] regular expression for calc

[Bruce Hohl]

If the code you are looking for only occurs once per cell you could use
find() or search() against each cells to determine if the code is present
then countif() the results where greater than zero.

On Sun, Mar 12, 2017 at 1:50 PM, Regina Henschel 
wrote:

> Hi Gary,
>
> find the option "Search criteria = and <> must apply to whole cells" in
> Tools > Options > Calc > Calculate. Try it with disabled option.
>
> Kind regards
> Regina
>
> Gary Collins schrieb:
>
>> Hi Brian
>> I wish i could say it did help but unfortunately not. It works with the
>> whole cell contents but doesnt seem to pick out a word within the cell. For
>> instance, one of my list has contents "X1 G43". Now if I have "X1 G43" in
>> the cell Xn (using your example) i get count 1 returned which is correct;
>> but if i have "X1" in cell Xn it returns 0, which is clearly wrong (at
>> least as far as my requirements are concerned). And yes, i do have regular
>> expressions enabled in Calc >  Calculate. My version is 5.2.2.2 x64 and im
>> using 64bit windows 7.
>>
>> G.
>>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Printing selected text to PDF

[Bruce Hohl]

In 5.2.x File > Export as PDF then click the "Selection" radio button.
This will print selected cells or selected sheets. For 5.3.x the wording
might be slightly different and this might become the default.  See:
https://bugs.documentfoundation.org/show_bug.cgi?id=90436
https://bugs.documentfoundation.org/show_bug.cgi?id=105965


On Tue, Mar 7, 2017 at 5:34 PM, Pat Brown  wrote:

> With most documents it is usually not a problem to select the PDF option
> and have it go straight to the printer. However, in Calc especially, one
> often wants to only send selected cells to PDF. However there does not seem
> to be an option to do this in the same way that one has if one selects the
> Print option. Or am I missing something.
>
> Paddy
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Linux User Groups

[Bruce Hohl]

Lots of good stuff here:  https://ubuntuforums.org/

On Fri, Mar 3, 2017 at 4:13 PM, MR ZenWiz  wrote:

> I can't speak for Knoppix, but Ubuntu has a users' group and email
> list at "Ubuntu user technical support, not for general discussions"
> .
>
> They do not like top-posts (like this one), so be aware.
>
> MR
>
>
> On Fri, Mar 3, 2017 at 12:48 PM, charles meyer 
> wrote:
> > Hi esteemed mates,
> >
> > Pardon my off-topic post, but has anyone found a good Linux forum to
> > discuss Ubuntu and/or Knoppix issues?
> >
> > I'm trying to make RecordMyDesktop work on a Knoppix Live distribution
> on a
> > flash drive.
> >
> > I emailed Klaus Knopper (Knoppix creator) but I just got a robo
> > response that he can't respond to emails.
> >
> > Thanks so much.
> >
> > Charles.
> >
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> deleted
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Default font in LO calc

[Bruce Hohl]

I can always open a new spreadsheet equipped with Arial by selecting File >
New > Templates > spreadsheet tab > My Templates > select the template >
click Open.  That is a lot of clicks and so in practice, it is easier just
to do File
> New > Spreadsheet and then change the font from Liberation to Arial.

You can use:
Ctrl+Shift+n to open the Templates window.
Then double click the desired template.

On Mon, Feb 20, 2017 at 4:55 PM, Philip Jackson 
wrote:

> On 20/02/17 21:49, leleu wrote:
> > Under Ubuntu 16.10 a command with the entry
> > libreoffice --calc /home/leleu/.config/libreoffice/4/user/template/
> essai.ots
> > does open a unnamed sheet conform to the model essai.ots
> >
> > Robert Leleu
>
> Yes it does under. And if the OP creates his template and modifies the
> command line above accordingly, he will be able to make a small script
> tied to a keyboard shortcut which would make it very simple to create a
> new spreadsheet.
>
> Philip
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Default font in LO calc

[Bruce Hohl]

To the right of 'Properties' there is a drop down icon which if you
mouse-over has the tag 'Side bar setting'.  Click that icon to select
'Styles and Formatting'.  (If someone knows another way please chime-in.)

On Mon, Feb 20, 2017 at 9:06 AM, Ian Whitfield 
wrote:

> *Thanks Bruce*
>
> BUT that does not work!!
>
> Top Right Icon is 'Properties' not 'Styles and Formatting' and it is
> showing the Font and Size I want.
>
> But when I select 'New Spreadsheet' the "default" Liberation Sans 10 still
> comes up!!
>
> I don't want or need a Template I just want the Font and size that I
> selected to be the Default for all new Spreadsheets!!
>
> IanW
> Pretoria RSA
>
>
>
> On 02/20/2017 03:22 PM, Bruce Hohl wrote:
>
>> View > Sidebar
>> Use top right icon to switch to "Styles and Formatting
>> Right click "Default" and select "Modify"
>> Under the Font tab select your desired font.
>>
>> You might want to save this as a template and use as your default
>> template.
>>
>>
>>
>> On Mon, Feb 20, 2017 at 7:52 AM, Ian Whitfield 
>> wrote:
>>
>> *Hi All*
>>>
>>> _PLEASE_ can someone tell me how to change the *&%$# Default Font in
>>> Calc!!
>>>
>>> I have tried many times to do this, Googled lots of suggestions but
>>> NOTHING WORKS!! And there are many different sets of instruction on how
>>> to
>>> do this. It is one of the most frustrating things in LO Calc and there
>>> has
>>> to be a basic simple way to do this - all I need is for someone to teach
>>> me
>>> how!!
>>>
>>> I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit.
>>>
>>> Thanks a lot
>>>
>>> IanW
>>> Pretoris RSA
>>>
>>>
>>>
>>> --
>>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Default font in LO calc

[Bruce Hohl]

View > Sidebar
Use top right icon to switch to "Styles and Formatting
Right click "Default" and select "Modify"
Under the Font tab select your desired font.

You might want to save this as a template and use as your default template.



On Mon, Feb 20, 2017 at 7:52 AM, Ian Whitfield 
wrote:

> *Hi All*
>
> _PLEASE_ can someone tell me how to change the *&%$# Default Font in Calc!!
>
> I have tried many times to do this, Googled lots of suggestions but
> NOTHING WORKS!! And there are many different sets of instruction on how to
> do this. It is one of the most frustrating things in LO Calc and there has
> to be a basic simple way to do this - all I need is for someone to teach me
> how!!
>
> I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit.
>
> Thanks a lot
>
> IanW
> Pretoris RSA
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Start Center

[Bruce Hohl]

You can simply open only the component you want (Writer, Calc, etc.) from
the menu, a desktop icon or a desktop tray icon.

Or, if the list of previously open files in start center is unwanted those
can turned off here:
Tools > Options > LO > Advanced :: Expert Configuration | Set PickListSize
to Zero

On Fri, Feb 17, 2017 at 7:58 PM, Michael Reich 
wrote:

> Is there a way to shut off the Start Center?  I know it’s a new “feature”
> but I really don’t like it and would prefer to simply click file-open to
> access files.
>
> Using LO 5.1.5.2 on Mac Sierra
>
> Michael Reich
> Glendale Heights, IL  60139
> reich.mi...@gmail.com
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Problem with LO 5.3

[Bruce Hohl]

Paolo, you can add your email address to the bug CC list (top right of bug
report) and you will get an email whenever someone makes a comment on the
bug.  That makes it easy to follow the bug and give additional data or
testing as needed.  BH

On Sat, Feb 11, 2017 at 11:56 AM, Paolo Debortoli  wrote:

> Hi.  Thank you for testing. I uploaded a working file (copia 1) on the bug
> report, you can use that for test.  Paolo
>
>
>
>
> On Friday, February 10, 2017 1:49 PM, Bruce Hohl 
> wrote:
> I saw your bug report.  I did a quick test and also was unable to get
> "Sheet > Like to External Data" working correctly in 5.4.0.0 alpha.  I will
> check more carefully against 5.3 this weekend and comment on your bug
> report.
>

-- 
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: Problem with LO 5.3

[Bruce Hohl]

I saw your bug report.  I did a quick test and also was unable to get
"Sheet > Like to External Data" working correctly in 5.4.0.0 alpha.  I will
check more carefully against 5.3 this weekend and comment on your bug
report.

On Thu, Feb 9, 2017 at 6:15 PM, Paolo Debortoli 
wrote:

> Thanks.   It's done:   Bug 105907.   Paolo
>
>
>
>
>
> On Thursday, February 9, 2017 1:18 AM, Bruce Hohl 
> wrote:
> With respect to the problem you found with 5.3 you can file a bug report
> here: 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

Re: [libreoffice-users] Re: Problem with LO 5.3

[Bruce Hohl]

With respect to the problem you found with 5.3 you can file a bug report
here: https://bugs.documentfoundation.org/

On Wed, Feb 8, 2017 at 5:54 PM, Paolo Debortoli 
wrote:

> I downgraded to LO5.2, but the calc file had lost links to intwernet pages
> (LO 5.3 hasn't written data in the cells and the data could not be
> downloaded thereafter).  I rebuildt the calc sheet and links  using LO 5.2
> and everythings works again now.
>
>
>
>
> On Wednesday, February 8, 2017 1:33 AM, Paolo Debortoli <
> paolo_debort...@yahoo.com> wrote:
> Hi.  I was using LO 5.2 till 2 days ago and I think I am going to
> downgrade to 5.2.
>
> Problem is:  I have a sheet which download every 5 minutes stock market
> data (prices) from internet in html format. Data are inserted in cells and
> used for simple calculations.   Since I updated to LO 5.3,  the software
> downloads just two lines in about 70 (and sometimes writes: unable to
> connect)  and leaves the cells empty.  The sheet worked fine in LO 5.2  for
> more than one year... I tried to insert manually again the links: first
> insertion works fine, but when it tries to update, cells remain empty.  Boh!
>
> In case I can send a copy of the sheet to try.
>
>
> Paolo
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Calc ABORTS

[Bruce Hohl]

>
> Does that result occur just for that particular worksheet or any worksheet
> on your computer?
>
It takes down all open calc windows.

Just for clarification, if you create a new spreadsheet file and delete
cells in the same manner does Calc crash?  (I.E. is the crash specific to
that operation in that particular file or occurs with any file.)


On Mon, Feb 6, 2017 at 1:49 PM, Jay Ridgley  wrote:

> Thanks Bruce,
>
> On 02/06/2017 06:43 AM, Bruce Hohl wrote:
>
>> Does that result occur just for that particular worksheet or any worksheet
>> on your computer?
>>
> It takes down all open calc windows.
>
>> Which delete option are you using: Shift cells up, Etc?
>>
> Shift cells up
>
>> What is the file format and origin of the worksheet?
>>
> The files are all .ods The spread sheets have been around in there present
> format for several years (OpenOffice and before). It has not been a problem
> until recently.
>
> Cheers,
> Jay
>
>
>
>> On Mon, Feb 6, 2017 at 6:30 AM, Jay Ridgley 
>> wrote:
>>
>> Good Morning,
>>>
>>> If I try to delete cells (Sheet--> Delete Cells), Calc crashes and the
>>> file is not recoverable. Is there a fix?
>>>
>>> I am using Ubuntu 16.04 LTS and LibreOffice 5.1.4.2
>>>
>>> Thanks,
>>> Jay
>>> --
>>> Jay Ridgley
>>> jridgley2 at austin.rr.com
>>> Registered Linux User ID - 9115
>>> https://linuxcounter.net/cert/9115.png
>>> Registered Ubuntu User ID - 23320
>>>
>>> --
>>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
>>> ubscribe/
>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and cannot be
>>> deleted
>>>
>>>
>>
>
> --
> Jay Ridgley
> jridgley2 at austin.rr.com
> Registered Linux User ID - 9115
> https://linuxcounter.net/cert/9115.png
> Registered Ubuntu User ID - 23320
>

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

[Bruce Hohl]

For more compactness, maybe you could create a maxifs() pointed to each
sheet then a maxifs() against those maxifs() results.  I agree with Brian
on the point of keeping all data in one sheet if practical.  With that
approach it's still possible to have separate tabs for each year for the
analysis and calculation.

On Sun, Feb 5, 2017 at 7:03 PM, Brian Barker 
wrote:

> At 22:46 05/02/2017 +0100, Rob Jasper wrote:
>
>> I am looking for a way to use MAXIFS over the equivalent ranges in
>> multiple tabs. Something like:
>> =COUNTIF('2*'.E$2:E$200;C2)
>> Explanation: For all ranges in tabs with name 2.* (2002, 2003, 2004,
>> etc.), range E2:E200 give me the number of occurrences of the value define
>> in C2. Is this at all possible?
>>
>
> A simple workaround is to assemble copies of the relevant ranges from
> multiple sheets on a single summary sheet. (After all, the value you are
> trying to derive definitely relates to the data generally, not to any
> specific year.) Then the function reference is simple. Instead of simply
> copying values, you will want to create formulae in the summary sheet to
> harvest values from the individual sheets. That way, the values on the
> summary sheet will automatically update as you work on the individual
> sheets.
>
> Or you could use one sheet instead of multiple, yearly sheets in the first
> place. After all, 1 January 2003 comes as soon after 31 December 2002 as 31
> December 2002 did after 30 December 2002. Contrary to the theories of some
> partygoers, nothing particularly discontinuous happens to time at the new
> year!
>
> I trust this helps.
>
> Brian Barker
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Calc ABORTS

[Bruce Hohl]

Does that result occur just for that particular worksheet or any worksheet
on your computer?
Which delete option are you using: Shift cells up, Etc?
What is the file format and origin of the worksheet?

On Mon, Feb 6, 2017 at 6:30 AM, Jay Ridgley  wrote:

> Good Morning,
>
> If I try to delete cells (Sheet--> Delete Cells), Calc crashes and the
> file is not recoverable. Is there a fix?
>
> I am using Ubuntu 16.04 LTS and LibreOffice 5.1.4.2
>
> Thanks,
> Jay
> --
> Jay Ridgley
> jridgley2 at austin.rr.com
> Registered Linux User ID - 9115
> https://linuxcounter.net/cert/9115.png
> Registered Ubuntu User ID - 23320
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Verified fatal error

[Bruce Hohl]

This is not really an answer but ... sometimes I have a problem with my
Windows PC at work, and the IT person confirms the problem, but trouble
shooting the problem will take longer than reinstalling ... so by analogy I
suggest you rebuild the spreadsheet starting with File > New >
Spreadsheet.  Bring all you data and formulas into the new spreadsheet by
Edit > Paste Special without Formats or Objects.  Better yet just Paste
Special "Values" (Text, Numbers, Date & Time) and recreate the formulas.
Copy & Paste Special selected blocks of cell never entire columns.
Recreate ALL formatting in the new spreadsheet.  End by saving in ODS
format.  I know this might seem like overkill but sometimes particular
spreadsheets "acquire" unique problems which are most easily resolved with
a rebuild (reinstall).  Consider it an opportunity to improve the worksheet
with better functions available more clear layout & formatting.



On Sat, Feb 4, 2017 at 9:48 PM, John R. Sowden 
wrote:

> Why has my message regarding a "Fatal Error" as indicated by LibreOffice,
> not been responded to?
>
> I have done a further test to find that even if I perform an F9 AND a
> save, it still crashes.  This seemed to have started when I turned off
> "auto calc".  Haven't tested by turning autocalc back on.
>
> John
>
>
>
> On 02/02/2017 07:14 PM, John R. Sowden wrote:
>
>> I have a 5 page spreadsheet, one page that gets used ofter, the others
>> are not used much.  Page 2 is a chart of accounts that a column in page 1
>> refers to often.  Page 1 is about 400 lines long, maybe 10 columns wide.
>> There is a date column, but I do not do date math, and no other cells refer
>> to the date column.  That said, after December, through April (FY),
>> entering data takes about 30 seconds per cell (a long time in computer
>> years).  The solution I received from this list was to turn off all
>> formatting (font, bold, not much more).  That was unacceptable, so recently
>> I tried turning off auto-calc, requiring I use F9 to recalc the sheet after
>> additions/changes.  It didn't help much.  And, in the process, I found the
>> following.
>>
>> On to the "verified fatal error":
>>I have a group of about 10 lines that I want to delete.
>>Lines above and below are referenced in page 3.
>>I select and delete the lines and get the following fatal error:
>> (three times (verified))
>>  Fatal Error (title in a window)
>>  multi_type_vector::position#1321:block position not found!
>>  (logical pos=4294967275, block size=9. logical size=1048575)
>>
>> I had 5 sheets open, all 5 were damaged, and all 5 were recovered upon
>> reentry.
>>
>> Ubuntu 16.04 and LO version 5.1.4
>>
>> What I have not tried is to F9 and/or save before the delete.
>>
>> John
>>
>>
>>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] LibreOffice Help in version 5.3.0.3

[Bruce Hohl]

Did you install the separate help package for 5.3.0.3?
http://www.libreoffice.org/download/download/?type=deb-x86_64&version=5.3.0&lang=pick

On Sat, Feb 4, 2017 at 12:47 PM, M Henri Day  wrote:

> ​After upgrading recently to (the Swedish version of) LibreOffice 5.3.0.3,
> I find that I can no longer access LibreOffice Help - clicking on the
> Help-button and then LibreOffice Help (F1) instead opens a new browser
> window. This in contrast to the situation in LibreOffice 5.2.4.2, in which
> the same procedure opens, as expected, to the help pages
>
> A bug ? Has anyone else experienced this ?...
>
> Henri
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Help with applying filters please.

[Bruce Hohl]

Another way to keep unwanted columns or rows from printing is to Group
those columns or rows (Data > Group and Outline > Group) .  Before printing
use the "Minus" icon to collapse.  After printing use the "Plus" sign to
expand.  This method provides a fast clickable control which is also a
vise-able reminder of the Group when collapsed.


On Tue, Jan 31, 2017 at 5:36 AM, Brian Barker 
wrote:

> At 22:46 30/01/2017 +, Budge Noname wrote:
>
>> On 30/01/17 15:25, Brian Barker wrote:
>>
>>> At 13:21 30/01/2017 +, Budge Noname wrote:
>>>
 I am trying to hide some columns when printing.

>>>
>>> You can hide entire columns using Format | Column > | Hide (or
>>> right-click | Hide on the column header).
>>>
>>
>> When I did this the space occupied by the hidden columns was still in the
>> print layout so objective not achieved.
>>
>
> You may need to close the file and reopen it to sort things out. Very easy.
>
> o Create a separate sheet for printing purposes, containing only the
>>> required columns. You need to create *formulae* referring to your original
>>> sheet on that sheet, not just to paste values - so that values there update
>>> automatically as you work on your main sheet.
>>>
>>
>> I refer to this as a brute force approach but it is what I ended up doing.
>>
>
> Nothing brutish I can see.
>
> In fact I copied only the wanted columns to next sheet and printed from
>> that.
>>
>
> If you copied values, you didn't do what I suggested - which may be less
> brutish than what you did. If you create *formulae* instead of values, you
> need do this only once. The second sheet used for printing will
> automatically update as you work on your editing sheet and can always be
> what you print.
>
> Brian Barker
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

[libreoffice-users] Re: Calc Selection Count in v5302 Win

[Bruce Hohl]

Well ... Calc's Count Selection feature also does not work in version
5.3.0.2 on Linux.  I will file a bug report.

On Tue, Jan 24, 2017 at 12:47 PM, Bruce Hohl  wrote:

> Hello All,
> I installed version 5.3.0.2 / Win64 this morning but found that in Calc
> the Selection Count option in the status bar did not work (nothing
> displayed).  If anyone has this version installed please check this and
> reply.  If confirmed, I will add a bug report.  I use selection count
> frequently so I went back to version 5.2.5.1 where this feature is working.
>

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

[libreoffice-users] Calc Selection Count in v5302 Win

[Bruce Hohl]

Hello All,
I installed version 5.3.0.2 / Win64 this morning but found that in Calc the
Selection Count option in the status bar did not work (nothing displayed).
If anyone has this version installed please check this and reply.  If
confirmed, I will add a bug report.  I use selection count frequently so I
went back to version 5.2.5.1 where this feature is working.

-- 
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] i of the most disturbing things about 5.0 libreoffice

[Bruce Hohl]

fudmer,
You can find LibreOffice documentation and help sites from the links on
this page:  http://www.libreoffice.org/get-help/community-support/  A
modern Office Suite like LO has a huge number of features but you need only
study and understand the features needed for their requirements.


On Mon, Dec 12, 2016 at 10:16 AM, fudmer rieley 
wrote:

>
>
> thanks for the reply..
> When in 16.04 I pushed  f4 or attempted data> Relative/absolute References
> I got 5.1.4.2 no references found.. reply..
> nothing else..
>
> copy from one sheet to another sheet in the same and only open
> my installed Libre office calc spreadsheet session still gives a full cell
> by cell
> reference to the cells in the original copied from sheet..
>
> The newly created by copy sheet its almost as it the reference is working
> in reverse..  When i want something from another sheet i just type
> =(sheet name, and then I find the cell in the external sheet and click on
> it
> and hit return.  ON return I examine the formula content of the cell
> in my working sheet and find it is referenced to the copied from cell in
> the external sheet..
>
> virtually the copy mechanism for my purposes remains useless. While
> i like some features of 5.1.4.2, it is not stable and things have been
> moved
> around quite a bit. OK, but more documentation is needed on the help
> keys and i would be glad to help with some of that,, if needed.
>
> What I think is needed is standard training program.. not help in
> this place or that but in a standard place. using a standard spreadsheet
> populated with a standardized set of data.
> Every cell is has the standard known content; that would allow all
> help and training to be done by example.. as the frustrated learners
> become familiar with the standard content they will grasp
> much quicker the instructional intent of the words and the numbers of
> words needed to explain will be reduced by a lot as everyone will
> understand and have loaded for the instruction the standard content
> training module.
>
> this would be extremely useful when upgrades and version changes
> move things around .. It would also make it possible fore everyone to
> understand where to send persons looking for answers.. for example
>
> got to standard training module 9ll that explains what to do or how
> to and that training modules always works with the standard
> content spread sheet..
>
>
>
>
>
> 
> On Sun, 12/11/16, Bruce Hohl  wrote:
>
>  Subject: Re: [libreoffice-users] i of the most disturbing things about
> 5.0 libreoffice
>  To: "users@global.libreoffice.org" 
>  Date: Sunday, December 11, 2016, 9:05 AM
>
>  fudmer,
>  The copy and paste results you experienced are likely due to
>  the formula
>  "anchoring" feature which can be set under "Sheet >
>  Relative/Absolute
>  References" or pressing the F4 key.  Try "un-anchoring"
>  or setting cells to
>  "Relative References" (no "$" in the formulas) before copy
>  & paste.
>
>  Absolute references ($'s) can be set for the row, column and
>  /or sheet in a
>  formula.  This impacts the results of copy and paste
>  within a sheet,
>  between sheets and between files / workbooks.  This
>  feature can be quite
>  useful but is a bit hard to explain so search the
>  LibreOffice help for
>  "relative addresses" for more information and do some tests
>  to see how it
>  works.
>
>
>
>  On Fri, Dec 9, 2016 at 12:39 PM, Paolo Debortoli <
> paolo_debort...@yahoo.com>
>  wrote:
>
>  > It doesn't happen to me in LibreOffice 5.2.3.3.
>  may be you can
>  > right-click destination and choose 'paste special',
>  then choose from the
>  > menu.  Hope this help.  Paolo
>  >
>  >
>  >
>  >
>  >
>  > On Friday, December 9, 2016 2:33 PM, Tanstaafl <
> tansta...@libertytrek.org>
>  > wrote:
>  > On 12/9/2016 12:13 AM, fudmer rieley 
>  wrote:
>  > > so on sheet one you do a bunch of calculations
>  > > and decide to copy that part of your work to the
>  next sheet sheet 2
>  > > then you look at the stuff in the cells on sheet
>  two and they are
>  > > referenced back to the sheet 1.  making
>  working on sheet 2
>  > > slow, difficult and rendering calc nearly
>  inoperative and virtually
>  > useless..
>  > >
>  > > LO 3.5.7.2 does not do that.. and it should not be
>  done that way
>  > > the sheets should be able to be copied and made
>  independent of
>  > > each other. Is there some wa

Re: [libreoffice-users] i of the most disturbing things about 5.0 libreoffice

[Bruce Hohl]

fudmer,
The copy and paste results you experienced are likely due to the formula
"anchoring" feature which can be set under "Sheet > Relative/Absolute
References" or pressing the F4 key.  Try "un-anchoring" or setting cells to
"Relative References" (no "$" in the formulas) before copy & paste.

Absolute references ($'s) can be set for the row, column and /or sheet in a
formula.  This impacts the results of copy and paste within a sheet,
between sheets and between files / workbooks.  This feature can be quite
useful but is a bit hard to explain so search the LibreOffice help for
"relative addresses" for more information and do some tests to see how it
works.



On Fri, Dec 9, 2016 at 12:39 PM, Paolo Debortoli 
wrote:

> It doesn't happen to me in LibreOffice 5.2.3.3.  may be you can
> right-click destination and choose 'paste special', then choose from the
> menu.  Hope this help.  Paolo
>
>
>
>
>
> On Friday, December 9, 2016 2:33 PM, Tanstaafl 
> wrote:
> On 12/9/2016 12:13 AM, fudmer rieley  wrote:
> > so on sheet one you do a bunch of calculations
> > and decide to copy that part of your work to the next sheet sheet 2
> > then you look at the stuff in the cells on sheet two and they are
> > referenced back to the sheet 1.  making working on sheet 2
> > slow, difficult and rendering calc nearly inoperative and virtually
> useless..
> >
> > LO 3.5.7.2 does not do that.. and it should not be done that way
> > the sheets should be able to be copied and made independent of
> > each other. Is there some way to do that?
>
> You'll need to explain your problem better. Can you provide a concrete
> example?
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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] Column width not shown when resizing column

[Bruce Hohl]

Version: 5.2.3.2, Build ID: 1:5.2.3~rc2-0ubuntu1~xenial1, which I currently
have installed does show column width when resizing.  You might check/test
the Graphics Output setting under Tools > Options > LibreOffice > View.

On Thu, Dec 1, 2016 at 11:31 AM, dave boland  wrote:

> Previous versions showed the column width when the column was resized.
> Version: 5.2.2.2 does not do that.  Is there a fix?
>
> Dave,
> Ubuntu mate 16.10
> --
>   dave boland
>   dbola...@fastmail.fm
>
> --
> http://www.fastmail.com - Email service worth paying for. Try it for free
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Speed up RTF to PDF (headless) conversions

[Bruce Hohl]

If the QuickStarter is available for Mac, perhaps that would make a
difference.

On Tue, Nov 29, 2016 at 9:14 AM, Paquin, Brian 
wrote:

>
> > On Nov 28, 2016, at 11:24 AM, Cley Faye  wrote:
> >
> > 2016-11-28 16:55 GMT+01:00 Paquin, Brian :
> >
> >> The initial conversion is about 5-10 seconds.
> >> If we process a second document (all RTFs about the same), it is less
> than
> >> a second.
> >> If we then wait a couple minutes and process a third document, it goes
> >> back to the 5-10 seconds...
> >>
> >
> > ​To me, it sounds like libreoffice just shut down when it have nothing to
> > do, and so needs to start up again.
> >
> > Depending on the way you do this, you could fiddle with the --accept
> option
> > to keep LibreOffice listening, or pre-start it with --invisible, keeping
> it
> > open.
> >
>
> The --invisible flag did not work.
> It opens LibreOffice (can be seen in the Dock (Mac)).
> But when I use the soffice command, it does not perform the conversion.
> (We get the same behavior if we open LibreOffice from the gui and then run
> the command)
>
> I was able to use some examples I found to get --accept running, but I
> don’t know what to do next...
> /Applications/LibreOffice.app/Contents/MacOS/soffice
> "--accept=socket,host=127.0.0.1,port=2003,tcpNoDelay=1;urp;" --headless
> --nodefault --nofirststartwizard --nolockcheck --nologo --norestore
> I see LibreOffice in the Dock, and I can telnet to localhost 2003...
> /Applications/LibreOffice.app/Contents/MacOS/soffice --convert-to pdf
> /Users/itsme/Desktop/testOpNote1.rtf   produces a brief 2nd LibreOffice
> in the Dock, but no PDF is created...
>
> What command should I use once LibreOffice is running to get the
> convert-to flag to function (it only seems to work if LibreOffice is NOT
> running)?
>
> Thank you,
>
> 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
>

-- 
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] Help with LOCalc formula

[Bruce Hohl]

I think VLOOKUP might work. In cell X1 try this:  =VLOOKUP(B1,B$20:C$22,2,0)
Copy down as needed; Adjust 2nd parameter (B$20:C$22) as needed.

On Mon, Nov 7, 2016 at 10:58 AM, Pertti Rönnberg  wrote:

> Best Spreadsheet Experts,
> May I ask for help having a more elegant formula in LOCalc (v.5.0.3; win10)
>
> Description
> I try to get a little extra to my pension savings by experimenting on the
> share market and follow up the results using Calc (not a database).
> I have a spreadsheet with two ranges – range(1) directly above range(2).
>
> r(1) specifies per row every specific purchase/sell event (date, company
> name, amount, etc).
> To calculate the actual "to-day"-result for this specific event (row) we
> need the "to-day"-value for this company's share (in e.g. column X), which
> value is taken from respective company's row in col.Z in r(2).
> r(1) has yearly 100-130 rows (events)
>
> Range(2) lists each company named in the above Range(1) and has in col.Z
> the corresponding share's "to-day"-value. These inserted share values
> varies from one day to the next.
> There are now 10-15 companies (rows) listed in r(2) – not in alphabetic
> order.
> r(2) sums the up-to-date result per company and the total result.
>
> Problem
> The belowe example simplified to 5 events concerning 3 companies may
> clearify the problem with the formula in X1 copied down col.X:
> =if(B1=$B$20;$Z$20;if(B1=$B$21;$Z$21;(ifB1=$B$22;$Z$22;0)))
>
> As you can see: with 15 (or more) companies (and >100 events) the formula
> will grow and become very long and sensitive for mistakes.
> VLOOKUP does not seem to be an option, at least it requires a completely
> new setup of the page.
>
> Range(1) - events
> A   B C…. X
> 1. nokia   5,o
> 2. kone 41,o
> 3. nokia   5,o
> 4. fiskars 12,o
> 5. kone41,o
>
> Range(2) - companies
> A B C... Z
> 20 nokia   5,o
> 21 fiskars   12,o
> 22 kone 41,o
>
> Any suggestion will be very interesting.
> Thank you in advance
> Pertti Rönnberg/Finland
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: How do I install the current Linux version

[Bruce Hohl]

Those PPA's work fine with Mint.  You can also select another version, for
example 5-2.  This method will replace your current version.  Updates to
your selected version (5.1.x or 5.2.x, etc) are provided through the
package system.  This is more convenient versus manually downloading and
installing each new version.  This link describes these PPAs:
https://launchpad.net/~libreoffice/+archive/ubuntu/ppa


On Mon, Oct 31, 2016 at 8:45 PM, Virgil Arrington 
wrote:

> Here's how I did it with Ubuntu 14.04LTS. I imagine it might work with
> Mint, which is based on Ubuntu.
>
>
> Method 1
>
> I opened a command line terminal (With Ubuntu, it's Ctrl-Alt-t).
>
> I typed in the following commands, hitting  after each line.
>
> sudo add-apt-repository ppa:libreoffice/libreoffice-5-1
>
> sudo apt-get update
>
> After typing in the first line, you'll be prompted for your user password.
> The first line adds the repository for LO 5.1.x. The second line
> automatically updates your system to use it.
>
>
> Method 2
>
> You can do the same thing through Synaptic Package Manager. Open Synaptic
> and click on Settings and then Repositories. In the Repositories dialog,
> click on Other Software, then click Add. Then type in
> ppa:libreoffice/libreoffice-5-1 and click Add Source. You will be
> prompted to reload your software sources. Once you do that, you can click
> Mark All Upgrades. Synaptic will mark the LO packages that are to be
> updated. Click Apply and you'll be upgraded.
>
> Again, I've used both methods with Ubuntu. That said, I am not by any
> means an experienced Linux user. I tend to use Synaptic for all my software
> installation needs. I've never downloaded and installed a *.deb file.
> Instructions for these methods are found at:
>
> https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-5-1.
>
> I don't know enough about Mint to know if it will work properly, but since
> Mint is based on Ubuntu, I tend to believe it will.
>
> Virgil
>
>
>
>
> On 10/31/2016 06:53 PM, gordon cooper wrote:
>
>
> On 01/11/16 09:16, Robert Großkopf wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Tim,
> What I do is unpack the install files [I use .deb files] and place
> them all in a temporary folder I call "lib".  Nice and simple, I
> have that folder in the "home" folder called "timothy".
>
> This will give me "/home/timothy/lib" while using the file manager
>   package [on Mint] called "Caja".
>
>
> Then I use the "Mate Terminal" [default command line for the MATE
> desktop GUI]
>
> This is my starting point for this laptop - yours will look
> different since you will not have the same laptop and user name.
> This is the default user folder for my laptop.
>
> timothy@Gateway-NE56R12u:~$
>
> I type in "cd lib"
>
> timothy@Gateway-NE56R12u:~$ cd lib
>
> I get this folder shown
>
> timothy@Gateway-NE56R12u:~/lib$
>
> At this point I use this command to install all of the .deb files
> from that folder. I tend to place both the language and help .deb
> files - if needed - in a different folder like lib2.
>
> sudo dpkg -i *.deb
>
> This will prompt me to five my superuser password.  Then it will
> start a "long" install process for all of the .deb files in the
> folder. The RPM system would have some different names for the
> commands I use for the DEB based Linux OS [ I use Ubuntu with Mate
> desktop]
>
> So, if you have a folder off your home folder [or directory] with
> the name of "lib" [home/timothy/lib], the command line is a very
> easy route.
>
> cd lib
>
> sudo dpkg -i *.deb
>
> After looking for this in the web I would make it the same way you
> have described here. It's a little bit different to the tool, which is
> delivered with OpenSuSE for system-managing with YAST, but it will
> work well.
> Don't know how to add a dircetory as repository in other sytems. But
> with OpenSUSE it works well.
>
> Regards
>
> Robert
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJYF6a7AAoJELDKYwaoS9AI8moP/A2yuXifFabBdnXBSwAEABtJ
> jhQfL8toi78UWYHKOTiAZ+eb4gRWjnq50SPjanxoako43ogYG8nNHqsIhEavsUta
> TBbYXRRvoJBAnPOf7sxqOnwGzg2fbH5LvfDnAZ1WXXqUgYiPU+2eEzDJDT2keeDi
> jTJJ2LloO8qUE//BLYp/FjJDzyGWohLM7wbobPul76lydRAO4uEL/uRwEJT7avxH
> d7LuGm6QDfsmcSW/9Es4e60lBuLehYQ8w4K1JAbhiDrhmn0qLR8ITw3iwuOCl5pe
> 3M0gOJwPqqGdYmhG3eOyBbwDzsl2nNXhXWwKV+QmhoPFQqxtIR6NqAyDs+9phmLA
> RkjU2J9qoInFoijgnI+TST7KQcS64a5IZFLfjde+JIZvXQ2KENxXm4Sfqtwu2meP
> J7ezu4E4QixGDHT31hSeQef7haO4jjt4jw87qPtZEE697QRYqTnHwKN4+BtYDWjH
> RM5xQzvLhe/ZwjrukD9w6hSKvdSZ40fdHzNJ8clgm7TI5ZWUI9T4gMQnmYmBP9/7
> Kuw8IT7TQw0D+f0ED6XFCQznJ3Zqbb6zlVaZlMLq2TjCtppoTX7wjnJMtQiys3ZC
> BV9JaahIxvGzJmKqaO081MPR2tL1U2T/Ilif23itpmXo3WTqXanQU3K0/8HoKR9E
> hwpgDjhkMMTnNGkNqAGn
> =ZRW9
> -END PGP SIGNATURE-
>
>
> This installation method all looks overly complicated to me, and is one
> of the reasons that I swapped over to MX-Linux where the system comes
> as a package with installation instructions/prompts included. Plus the
> bonus
> that the User 

Re: [libreoffice-users] Calc - Page number and printing page range

[Bruce Hohl]

Have you tried:  View > Page Break  or   File > Print Preview

On Thu, Oct 27, 2016 at 5:35 PM, charles meyer 
wrote:

> Hi All,
>
> Is there a way to detect how many pages there are in a Calc file?
>
> I just see columns, row,  etc but not pages?
>
> Once I can establish which columns and rows are on which pages how can I
> set the page range to print just those pages with those columns and rows?
>
> Thank you.
>
> Charles.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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] Help Please with Printing Ranges

[Bruce Hohl]

> I found that hiding the unwanted columns (which I tried first) did not
solve the problem either.
For that approach to work you must hide (or group) the unwanted columns AND
clear the multiple print ranges.

On Thu, Oct 27, 2016 at 1:07 PM, Budge  wrote:

> Hi, Regina,
> On 26/10/16 19:24, Regina Henschel wrote:
>
>> Hi,
>>
>> ajebay schrieb:
>>
>>> Hi Bruce,
>>> Defined the ranges as before and Edit shows Print Range, User defined
>>> as:-
>>>
>>> $A$1:$C$165,$I$1:$I$165,$K$1:$K$165
>>>
>>> Which is what I want.  My problem is getting the range on to paper
>>> without big spaces because I need to be able to read across on a line.
>>> Hope that is clear.
>>>
>>
>> Each print range is printed on its own page and uses further pages, if
>> the content of the range does not fit on one page. So you will get first
>> some pages for $A$1:$C$165, after them some pages for $I$1:$I$165 and
>> last some pages for $K$1:$K$165.
>>
>> If you want to show columns A,B,C,I,K together, you need to add a sheet
>> with a copy of this columns being adjacent. If you use references the
>> sheet will update, if you alter the original data. You will have
>> in A1 =Orig.A1, in B1 =Orig.B1, in C1 =Orig.C1, in D1 =Orig.I1, and in
>> E1 =Orig.K1. Of cause you need your own sheet name instead of "Orig".
>>
>> Then you do not define your print range on the original data but on the
>> copy, which would give you the one print range $A$1:$E$165.
>>
>
> Many thanks.  I had no idea that each print range was printed on it's own
> page.  The wiki/help pages should really be edited to make that clear.  It
> would have saved me a good deal of time.
>
> I found that hiding the unwanted columns (which I tried first) did not
> solve the problem either.  I understand your suggestion; it does have the
> benefit of being more "wysiwyg" and safer. Will try next time. Meanwhile I
> had to use Pritt stick to assemble 3 x 5 sheets so I could read them as I
> needed.
>
>>
>> Sometimes you have to print one column which is small but very long and
>> you want to print all of it on one paper sheet. In such cases I use a
>> trick. I define a page size, which is as wide as the column. And in the
>> print dialog, I use the dialog page "Page Layout" to put several of this
>> small "pages" together on one paper sheet. Most printers need the
>> setting "Use only paper size from printer preferences" in such case and
>> you have to set the actual paper size in the printer settings.
>>
>
> Fortunately not had this problem but many thanks for the tip.
> Many thanks again for your reply.
> Regards,
> Budge
>
>
>
>
> Kind regards
>> Regina
>>
>>
>>
>>
>>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Help Please with Printing Ranges

[Bruce Hohl]

Well ... Calc is "adding" vertical page breaks between each of your defined
ranges ... I did not expect that.  Due to this instead of using a Print
Range I suggest that you group or hide columns D-H and J.  I prefer to
group: Data > Group & Outline > Group as it provides check boxes above row
1.  You will need to clear the defined print range.

On Wed, Oct 26, 2016 at 12:18 PM, ajebay  wrote:

> Hi Bruce,
> Defined the ranges as before and Edit shows Print Range, User defined as:-
>
> $A$1:$C$165,$I$1:$I$165,$K$1:$K$165
>
> Which is what I want.  My problem is getting the range on to paper without
> big spaces because I need to be able to read across on a line. Hope that is
> clear.
>
>
> On 26/10/2016 17:06, ajebay wrote:
>
>> Hi Bruce,
>> Thanks for the quick reply.  I haven't used the Edit, just defione and
>> add.  Will now try Edit option and report back.
>>
>> On 26/10/2016 16:22, Bruce Hohl wrote:
>>
>>> What is included at Format > Print Ranges > Edit for
>>> (1) Print Range, (2) Rows to Repeat, and (3) Columns to Repeat?
>>>
>>> On Wed, Oct 26, 2016 at 10:50 AM, ajebay  wrote:
>>>
>>> I am trying to print only selected columns which I have defined using
>>>> Format>Print Range>Define and Format>Print Range>Add.
>>>>
>>>> When I check using View>Page Break all the correct columns are shown but
>>>> with large vertical gaps so what should fit on one landscape sheet is
>>>> taking three with large parts of the page left white.
>>>>
>>>> I have tried moving breaks by dragging but get in a mess.  Also the
>>>> preview always assumes portrait format until I set the printer to
>>>> landscape
>>>> and then take paper size from printer.
>>>>
>>>> There must be a better way but I am too dumb to find it.  Can somebody
>>>> give me help please?
>>>>
>>>> --
>>>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>>>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
>>>> ubscribe/
>>>> Posting guidelines + more: http://wiki.documentfoundation
>>>> .org/Netiquette
>>>> List archive: http://listarchives.libreoffice.org/global/users/
>>>> All messages sent to this list will be publicly archived and cannot be
>>>> deleted
>>>>
>>>>
>>>
>>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Help Please with Printing Ranges

[Bruce Hohl]

What is included at Format > Print Ranges > Edit for
(1) Print Range, (2) Rows to Repeat, and (3) Columns to Repeat?

On Wed, Oct 26, 2016 at 10:50 AM, ajebay  wrote:

> I am trying to print only selected columns which I have defined using
> Format>Print Range>Define and Format>Print Range>Add.
>
> When I check using View>Page Break all the correct columns are shown but
> with large vertical gaps so what should fit on one landscape sheet is
> taking three with large parts of the page left white.
>
> I have tried moving breaks by dragging but get in a mess.  Also the
> preview always assumes portrait format until I set the printer to landscape
> and then take paper size from printer.
>
> There must be a better way but I am too dumb to find it.  Can somebody
> give me help please?
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Libra Office and MS Word compatibility query

[Bruce Hohl]

"with no glitches"

I think this can only be achieved if everyone can agree to only use a
specified file format (.doc, .docx, .rtf) and only [basic] features known
to work the same in both programs.  Perhaps one of the many online [basic]
word processors would be a better fit this situation.

On Sat, Oct 15, 2016 at 8:28 AM, m.a.riosv 
wrote:

> Since LibreOffice 5.0 can be opened page files
> https://wiki.documentfoundation.org/ReleaseNotes/5.0#New_import_filters
> but don't expect warranties about everything will be perfect.
>
> Every time that a file is converted, increase the options for issues, as
> LibreOffice is available for Mac, IMO install LibreOffice on the Mac it's
> the option to achieve the lower amount of issues.
> Miguel Ángel.
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/Libra-
> Office-and-MS-Word-compatibility-query-tp4197150p4197182.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Observations on LO v5.2.1.2

[Bruce Hohl]

> the icons in the menu bars are terrible!  Way too large
Tools > Options;  Left panel: LibreOffice > View; Right panel: Set Icon
Size = Small
If desired, install and select an alternate icon style as well.

> as is the bar at the bottom with the "Find" window, which I can't find a
way to get rid of.
View > Tool bars > Find (un-check) (or click the X on the left side of the
Find bar)

> I'm not terribly happy with the new opening screen either, with all the
recent documents being displayed
Tools > Options > LO > Advanced :: Expert Configuration | Search for
PickListSize
Set to value desired (including zero).

> Keyboard shortcuts are changed
For maximum productivity set your own KB shortcuts under Tools > Customize.


On Fri, Oct 14, 2016 at 6:34 PM, Dave Liesse 
wrote:

> Okay, I'll take back part of what I said.  I just reinstalled, and the
> destination option does, indeed, appear.  It's just so unobtrusive that I
> didn't see it the first time.
>
>
>
>
> On 10/14/2016 13:01, Dave Liesse wrote:
>
>> As I might have said when I posted a question about opening a
>> password-protected Excel file, I updated LO to v5.2.1.2.  Still can't open
>> that file, but that's not what this post is about.
>>
>> One reason I delayed updating is what I read with regard to v4 -- the
>> icons in the menu bars are terrible!  Way too large, as is the bar at the
>> bottom with the "Find" window, which I can't find a way to get rid of.
>>
>> I also had some problems with the installation on Windows 7, although
>> they're different from the thread on that subject.  I chose Custom
>> installation, as always, but it didn't ask where I wanted to install it.
>> The installation just took place on drive C, which I reserve for system
>> files (programs go on P).  I was able to copy the installation to the
>> correct drive and change the various shortcuts, but for some reason I can't
>> change the address in the registry.  Fortunately, this doesn't seem to make
>> a difference.
>>
>> Of greater concern is that the new installation didn't maintain all my
>> settings, and every day I'm finding something I need to fix.  The
>> installation more or less deleted my old one, which I had expected, but all
>> the paths still point to the ones that were deleted.
>>
>> I'm not terribly happy with the new opening screen either, with all the
>> recent documents being displayed (and no way that I've yet found to reduce
>> the number shown).  Keyboard shortcuts are changed, and while they're now
>> consistent and make some sense they'll take some getting used to.
>>
>> I'm sure there are ways to fix some of the things I'm griping about and I
>> just need to keep looking, but it's sure putting a crimp in my productivity!
>>
>>
>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Strange pdf printout in Calc vs. Excel

[Bruce Hohl]

> You recognized Valter himself wrote this enhancement request four years
ago?
Actually, I did not notice that. I recently added myself to the CC list for
that bug as I agree that more control over PDF output from Calc would be
nice.

> ... Printing button is right beside this. Here you could print in a file and
the default here is pdf and selected sheet.
If I choose File > Print (Ctrl+P); then set "Printer" = "Print to File
..."; then click the "Pint to File..." button. The "Save As" window
appears. The only "Save as type" available is *.PRN. Thus, it does not
appear that a PDF can be produced from Ctrl+P. (Unless an 'PDF Printer' has
been separately installed on the computer.)

> And there will be not much people, who only want to export the selected
page.
My spreadsheets typically include one or more sheets for data and analysis
and a single summary sheet. I typically only distribute the summary sheet
in PDF format.  Thus, from my perspective it would be nice if the Calc
default for PDF creation was the same as for printing (Selected sheets) or
the PDF Export default could be configured in Options or under Expert
Configuration.



On Fri, Oct 14, 2016 at 2:51 AM, Robert Großkopf  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Bruce,
>
> > There is actually an enhancement request related to PDF export in
> > Calc: https://bugs.documentfoundation.org/show_bug.cgi?id=54052
>
> You recognized Valter himself wrote this enhancement request four
> years ago?
> >
> > I agree the default of printing the entire workbook is generally
> > unwelcome.
>
> The button is a button for "Export as PDF" - not for printing.
> Printing button is right beside this. Here you could print in a file
> and the default here is pdf and selected sheet.
>
> "Export as PDF" should work like it works in Writer, too. And there
> will be not much people, who only want to export the selected page.
>
> Regards
>
> Robert
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJYAIB0AAoJELDKYwaoS9AITHQP/3VdnomMtDFlzxw4jK5cG1UG
> l6UL7BuS6JImybIDZKutiiakF0nr0ZS859LyvhuQYrUDKyyMC0Miwr1SLTirbSYx
> s7N4ft1cNlQKSNTVikKoAVwHFgUtk/VPM89UO8aL4I5py1P2DVWP3KzZSTESGKn0
> akIxlKgiN8UFTA9ufQk2Cha0Kjc8MXsvbj5h5ro91K3iMa0KXfePPtzHwiIzZyyd
> vZVTSuWSFWf1/ax8Vf4iBK/WCbtaj464oNdqiRCoSBPISACWh94zh0MwK4U3JwIq
> k8/CFhK+8UAq7Pm6wQO6CcKoRMYKFKTe7AYUaQCaolji1OLru9eQFz9n6Txz156j
> Cp9V7Qxg3MWYf+7ExoOt6kYIz710gHI54tQQoJLLZu/5K3E/Xi9SRfLLtZfsC6WK
> AGHpPL/otMNcrBiMpKC2b8WQ6Sv8p/KzuGhwyirFQ/LgYneaKsbHfM+Xei7qdum5
> 1TKdGOaI1BmrD5LaxoO0SeZRACvIqKITzu6ezBzcfPYMNCqNXeIMWRjOwq2Ml36Z
> U6c2XM2P6U7lcoNrYQVMG/6KFm9zetfY8Sfb/cgFaRw2PcmAnhzBDD3jmyUvlMEP
> A7GFK1eY9IhLA4ivKpk4eaQiNvMUBaNIbq5+kJ7NNPdfXfgBJf5HVNqk3lOwaf2S
> 6z5XS/y/KnD8bkhfVY9Y
> =4DBx
> -END PGP SIGNATURE-
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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] Strange pdf printout in Calc vs. Excel

[Bruce Hohl]

@Valter
There is actually an enhancement request related to PDF export in Calc:
https://bugs.documentfoundation.org/show_bug.cgi?id=54052

I agree the default of printing the entire workbook is generally unwelcome.

On Thu, Oct 13, 2016 at 4:02 PM, Robert Großkopf  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Valter,
>
> >
> > I noticed that if I have a Calc file with multiple sheets, even if
> > with regular print area defined, if I click the "Print PDF
> > directly" button while positioned in a specific sheet, the command
> > prints out *all the sheets* I have in the file.
>
> Don't know where you get "Print PDF directly".
> There is a button "Export as PDF". With this button the whole document
> will be exported.
> Print > Print to File: Default is selected sheet for this function.
> The file will be a *.pdf, too.
>
> Regards
>
> Robert
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJX/+huAAoJELDKYwaoS9AIRLoP/1dABqRe5qWBlse41sWjQjaM
> NR18ILTxAox2GRfawAFRt8t9R3pE4HGOopUuQfy9KrK42hLi596wXQc0xozi6RYQ
> qADID4qf1FeDxxRufPOtv+g9aLLaBg8I5IGYHO+0jntBVbkHqCQaC96kWYycjoC2
> z17wVX/+nbw0d6chSrut9KLh6zhsruZlkGra5jQ3PuRrRUtjtbriDJGOOYq9D8P+
> jmOePPre6Y4iARRfp//ccRZnqHDwDmKj1g/i1agExd7rBEkholsKvny5TLqC46Sw
> NuFfzmPXo7EqXtnggal8PBsEFac9E6Ti9I78a97wc+mdQv49vp51xiZ4ZSyrmvCE
> /21rISrBfA+7u/EktzljEVl495BOBx1MOVV5t3zUf66IrVy/KKA8Zeg+wrAyrxXN
> CSqTUzNZoQD013v5wKFVI/Xs1nfPU0u0KU0cdxjjhk+PKnSSCjplOTXWIfonrIWh
> mxFONLwWHuR3p+IpvbEOPkc9rXQmJUDUAyevEPqiPfKLCe6XWHXbAJTMgaK3VAi1
> cWGlwQUTkp3n70lburjZofrgGiiSoRtBS6+GoAc0OSCr//IKm4gp4YvEnXaNSrkl
> G66BYeUel6fDl2SKAt43url5UDPvzpUcumQdS/5T5tXCwZnDs/UTm/ttyMnqwVFu
> 3ELPxiobUaQ1VLn56vRL
> =1Sr8
> -END PGP SIGNATURE-
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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] Downloads impossible and latest version of Firefox not recognized by captcha, connclusion: service level zero

[Bruce Hohl]

I just downloaded LO 5.2.2.2 for Windows from LibreOffice.org using Firefox
and installed on my Windows 7 (64 bit) notebook without problem.  The
program opens and appears to work correctly.

On Sun, Oct 9, 2016 at 12:23 PM, Jurriaan Nijkerk 
wrote:

> Hi there,
>
> I'd like to file serious complaints about Libre Office.
>
> A. The downloads
>  We've been users for several years of Open Office. When Libre Office
> started as a fork, we decided it was a wise thing to go on with Libre
> Office. We don't had any complaint about it until version 5.1.5 It was'nt
> possible to download a proper MSI file. We tried different mirrors, like
> Nluug.nl, Ut.twente.nl, mirrors.supportex.net and tu.chemnitz.de . All
> downloads were corrupted.
>
> We tried this with machines from two private networks, about  6 laptops
> and 4 workstations. With Vista 32 , win7 32 and 64, with win10 32 and 64.
>
> After this we tried 5.2.2 with the same result.: statements like "this is
> not a valid msi file", corrut installation file  or an halfway cut off
> installationprocedure. We tried to upgrade five times since the release of
> 5.2.2 on juli 28.
>
> We asked for help, the aswers came: Something like "you don't have the
> appropiate drivers or maybe an update of Win10 or bullshit like that.
>
> So  we installed version 5.1.4.2 again, a version  without those
> kindergartenbugs.
>
> We're not the only people who experienced the bug, there are more who have
> encountered this one.
>
> B.
> The community login.
> I tried again to log in on the Q and A site of the community. And then,
> the captcha widget didn't work. The program told us to use an updated
> browser. Very intelligent, maybe someone can tell me where to get a newer
> version of Firefox 49.0.1 ?
>
> My question is: How about quality control? Because if all stays the same
> we, and without any doubt a lot other users, will look for an alternative.
>
> Imho, it would  be a shame if this doesn't change. There's a lot of
> volontary work done, done by the people of the community, wich will go
> through the drain. I would call this respectless...
>
>
> grtz,
>
>
>
> --
> <../image001.jpg>
>
> 
>
>
>
> Jurriaan Nijkerk, Photographer
>
> Architecture & Industrial Photography
> Fine Art & Reproduction
> Wide-angle & Aerial Photography
> Consultancy
>
> Chief editor PhotonMagazine.eu
>
> Hobbemaweg 46
> 6562 CT Groesbeek
> Telefoon:   +31 (0)24 397 22 12
> GSM NL: +31 (0)622 49 50 58
> BE: +32 (0)495 44 59 05
> E-mail: i...@jurnijkerk.com
> Website:http://www.jurnijkerk.com 
>
>
>   Member of SOFAM
>
>
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: COUNTIFS with cells of yyyy-mm-dd

[Bruce Hohl]

And, for 2 criteria like this:
=SUMPRODUCT((YEAR(A1:A50)=2011)*(B1:B50="ZZZ"))

On Sat, Oct 8, 2016 at 9:38 PM, m.a.riosv 
wrote:

> Or
>
> =SUMPRODUCT(YEAR(A1:A50)=2011)
>
> Miguel Ángel.
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/
> COUNTIFS-with-cells-of--mm-dd-tp4195901p4196282.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] COUNTIFs with cells of yyyy-mm-dd

[Bruce Hohl]

Or, for example, for the year 2015 try this:
=COUNTIFS(A1:A50,">="&DATE(2015,1,1),  A1:A50,"<="&DATE(2015,12,31))

On Wed, Oct 5, 2016 at 9:55 PM, Brian Barker 
wrote:

> At 17:30 05/10/2016 -0600, F H Data wrote:
>
>> I have -mm-dd as my date format in Calc (libreoffice 5.1.5.2) . I
>> like to count number of cells for a certain year *only* 
>>
>> sample data :
>> 2011-03-28
>> [...]
>>
>> for any year, let say 2011, gives me err510
>> =COUNTIF(A1:A50,DATE(2011,*))
>>
>
> Ho, ho - you are making it up!
>
> o In B1, enter =TEXT(A1,"") and fill down the column.
> o Use =COUNTIF(B1:B50,"2011") .
>
> Or:
> o In B1, enter =VALUE(TEXT(A1,"")) and fill down the column.
> o Use =COUNTIF(B1:B50,2011) .
>
> Note that the column here suggested as B can be hidden or put away
> elsewhere on the sheet or even on another sheet.
>
> I trust this helps.
>
> Brian Barker
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Re: How to fill in "Read filter criteria from"

[Bruce Hohl]

> Is there some other way to get a check range?
Yes, to 'AND' setup your Advanced filter range like this:
date | check no | check no |
| >=1000   | <=1100   |

If you install the LO help there is good explanation and example of using
Advanced Filters.

On Mon, Sep 26, 2016 at 8:53 AM, Larry Evans 
wrote:

> On 09/25/2016 10:21 AM, Larry Evans wrote:
>
>> On 09/25/2016 09:39 AM, Larry Evans wrote:
>>
>>>
>>> On 09/24/2016 07:28 AM, jorge wrote:
>>>
 I'm sorry, ... it looks worst

 Jorge Rodríguez




 El sáb, 24-09-2016 a las 12:20 +, jorge escribió:

 Hi  again:
>
> I hope in this way you can see better my last e-mail:
>
> At first you have to copy the headers of your table at you side of you
>
 Ok.  Did that.  Those are shown in attached in E2:G2
>>>
>> OOPS.  I should have read:
>>
>> https://wiki.documentfoundation.org/Netiquette#Avoid_Attachments
>>
>> The .png file showing this, as well as the actual .odf file,
>> can be found at these links:
>>
>> https://www.dropbox.com/s/5uosutupnclnxrg/find_transaction.
>> advanced_filter.png?dl=0
>>
>>
>> https://www.dropbox.com/s/da11qtifkes1q01/find_transactions.ods?dl=0
>>
>> Hope this makes things clearer.
>>
>> [snip]
>>
>
> Googling for "libreoffice advanced filter" lead me to:
>
> https://help.libreoffice.org/Calc/Filter:_Applying_Advanced_Filters
>
> which was *much* more helpful than the help I got from pressing
> the help button on the "Advanced Filter" dialog, which, as mentioned
> in my OP, sent me here:
>
> https://help.libreoffice.org/index.php?title=5.1/Calc/Advanc
> ed_Filter&Language=en-US&System=UNIX&Version=5.1#bm_id3151113
>
> OOPS.  I see on that page, there's a link to "Applying Filters"
> and from there, a link to:
>
> https://help.libreoffice.org/5.1/Calc/Filter:_Applying_Advanced_Filters
>
> I should have persisted in reading the document :(
>
> Anyway, apparently there's no way to select a range of check numbers
> because the vertical conditions are OR'd together instead of AND'd
> together.  I've tried using the AND(>=1000,<=1200); however,
> that results in 0 selected rows.  Is there some other way to get
> a check range?
>
> I've uploaded a screen shot to:
>
> https://www.dropbox.com/s/piiuz5z1u7s14ch/find_transactions.
> advanced_filter.NoVerticalAnd.png?dl=0
>
> -regards,
> Larry
>
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Get number of items in a calc's sheet filtered list

[Bruce Hohl]

Make sure "View > Status Bar" is checked.  That information is displayed in
the second part of the status bar at the bottom of Calc but only when the
focus is within the range of data being filtered.  At the bottom you will
then see something like: | Sheet 3 of 4 | 55 of 1425 records found | etc.

On Sat, Sep 24, 2016 at 5:33 AM, Daniel A. Rodriguez <
daniel.armando.rodrig...@gmail.com> wrote:

> I've been asked about this and can't find an answer yet. The 'other'
> software shows something like "found X from Y records" and the need is
> to find something like that.
>
> Any clue?
>
>
>
>
>
>
> 
> Comunidad LibreOffice Argentina
> www.libreoffice.org.ar
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] trouble installing fonts to use with Libre Office

[Bruce Hohl]

You may be able to find (and install) desired fonts from the Synaptic
Package Manager.  After opening the Synaptic Package Manager, on the left
panel there are entries for Fonts, Fonts (multi-verse) and Fonts
(universe).   Or enter "font" in the Quick Filter search box.

On Sat, Sep 17, 2016 at 6:23 PM, Sigrid Carrera 
wrote:

> Hi,
>
> I have some trouble with LibreOffice recognizing the different weights for
> some fonts I have installed.
>
> Some basic info first:
> LibreOffice 5.2.1.2
> Ubuntu 2016.04
>
> I installed several fonts (otf / ttf files). I downloaded the fonts from
> either Google fonts or font squirrel and installed them all in the correct
> directory, where all the other fonts are as well.
>
> When I check in the Font Manager in Ubuntu, everything is ok, and all the
> different weights and styles are there. However, when I start LibreOffice,
> I see for some of those fonts only 1 style in the dropdown list, whereas
> for others I see all the different weights and styles. While in the font
> manager, I can't see any different behaviour between the affected fonts.
>
> Any ideas what I can try to solve the issue?
>
> Thanks for any ideas you might have.
>
> Sigrid
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

[libreoffice-users] Calc row height: Fixed versus Optimal

[Bruce Hohl]

Hello List,  Is there a way to see from *within* Calc if a spreadsheet row
is set to Fixed versus Optimal (That is, see the setting of
style:use-optimal-row-height = false | true.)

-- 
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: Looking for expert help

[Bruce Hohl]

I totally agree with Joe's comment.  LO including Calc has an excellent PDF
export feature with many options (review the various tabs at File > Export
to PDF).  Also, print ranges can be set by Tab/Sheet, cells set as
non-printable and Headers & Footers can be used to identify content, page
numbering, etc.  In fact, I use this capability routinely to prepare
professional quality PDF versions of financial reports.  It's much easier
for "top managers" to page through a PDF versus the "complex" navigation
required by a spreadsheet.

... and if your get carried away you can help toki with his "Abusing Calc"
users guide.  He plans 2 chapters on using Calc as a text editor :)
http://nabble.documentfoundation.org/Overly-aggressive-autofomatting-issues-in-LibreOffice-td4191792.html

Please excuse, the hot summer has caused high levels of sarcasm in my area.

On Mon, Aug 29, 2016 at 5:41 PM, Joe Conner  wrote:

> You can EXPORT PDF directly from CALC. Then you have no need to
> copy/paste, just attach the pdf.
>
>
> On 08/29/2016 12:57 PM, Katarina Behrens wrote:
>
>> Hi *,
>>
>> I can't really help you (I'm "just" a developer, not a Libreoffice user),
>> but
>> maybe someone on this list can ...
>>
>> I would rather discourage usage of DDE though, but that's just my personal
>> opinion
>>
>> --  Forwarded Message  --
>>
>> Subject: Looking for expert help
>> Date: Monday, August 29, 2016, 10:38:14
>> From: Parker Williams 
>> To: markus.mohrh...@googlemail.com, er...@redhat.com,
>> katarina.behr...@cib.de
>>
>> Hello,
>>
>> I am building a spreadsheet which performs numerous calculations related
>> to
>> solar energy performance and financial modeling. I need the calculations
>> and resulting charts to be compiled into a presentable format which can be
>> emailed as a PDF.
>>
>> Currently, I cannot seem to copy and paste a chart or graph from Calc into
>> Writer using DDE. The idea is to create multiple proposals using the Calc
>> spreadsheet and then individually save and email the essential information
>> in PDF format.
>>
>> I would greatly appreciate any assistance.
>>
>> Parker
>> Utah, USA
>>
>> ---
>> Simple living, high thinking. ~ Srila Prabhupada
>> -
>>
>
> --
> Blessings, Joe Conner
> Joshua 24:15 "...as for me and my house, we will serve the LORD."
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

[Bruce Hohl]

On form Form_Filter, is it possible to define the List Box using General -
List Entries and Data - ValuelList (without using the separate table Filter
and query Query_Filter)?  The Base Handbook has brief comments on the List
Entries & ValueList but only defining those items does not produce a
working List Box.

On Sun, Aug 28, 2016 at 3:23 AM, Robert Großkopf  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Alanon,
>
> could be you are looking for something like this:
>
> http://robert.familiegrosskopf.de/download/Filter_Database.odb
>
> One table "Table" with the content you will list, one other table
> called "Filter" with only one row. A query lists the content of
> "Table" dependent of the content of "Filter".
>
> In the form there are two separate forms - one for "Filter", one for
> the query. "Filter" will read out the value you have choosen from a
> listbox. The button refreshes the other form for the query. There are
> no macros needed.
>
> Regards
>
> Robert
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJXwpGJAAoJELDKYwaoS9AIIKcP/RpIgCBKZ6jtbSx8EudE9A4i
> SslUhyoPzIgAOSn3daOdOLq/jBTVEOo9hF24lwiu31tyuOU2/vTYvYsXe/0hpfUp
> ieJcr+jVMuVTEPIr7OtskgCkASlMDBnxe3vvzoorYSEr47xW+eczcfxINRH1r9FF
> PtKhI6RRcVYDzj3meUjBPHnVrE9Wh8/7RX9+GJPVcU/GtQE3Yps77FsOhwE/iQah
> q4q2wCjzYWgVTV7ls7YX1Em+dsXLuHsJtyqDaGnJr5U0hb10bLSL0D2ge8ujvMiQ
> ypizv/gaKD9D7SUkfHkrqyMkmx5PPbTX+BVX0P1AjHNCAj1P99T3Nt0bRYFbffVq
> 0x1a1Bt+68BZWI6sfKM6mr8fy3ZYSCdQ0uJhKklTke4ETR+2zXnLsNXUzWYJavrh
> bqED7tlXvh6e0KGRARBLHXxbwN2JJx2LuODs3n0wZtqsSJu5aWdNCPnvPV7QGaRQ
> dl585Kx3k73mn5iyWSnC8NSPsz7qZ6ypA8QJdPi6wy6pdfQ1tTopawqX0d+RTFBk
> DGN+Fo+zVifGGPYDcNWw0SxszGNi1JiuJL4ef2GwAmF6ctmFVhR6znE6UPF92uSY
> K81zrlgmqNRfVlpW1TpVPvE8gnCqakmNNVZGEZwI+S5umfMiOGjynmoWZDGgYHUk
> xxmRPkrgAPQTN/pr26w2
> =MDTk
> -END PGP SIGNATURE-
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

[Bruce Hohl]

> What would I need to write as a criteria so that when the QUERY is run, it
prompts the user to select from a listbox

You must create a form to use the List Box control.  If you really only
need a query you can add the choices to the query parameter name.  For
example: SELECT "F1", "F2" FROM "Table1" WHERE "F1" =
:enter_dog_cat_or_bird (see simple attached example).

From the installed help see: Contents > Database Functionality > General
Information > Working with Queries (Query Design / Parameter queries) and
Working with Forms (Form Controls / List Box).


On Sat, Aug 27, 2016 at 3:14 PM, alanon  wrote:

> Hi,
> Thank you in advance for your help!
> I'm trying to build a query that would list the records in a database where
> the user selects from an existing list of categories.
>
> IE
> there are 12 existing categories, each with a bunch of records.
> the user wants to review just the records under the category "gas", but he
> doesn't know that exact category name so he needs a listbox to show his
> existing categories to select from.
>
> What would I need to write as a criteria so that when the query is run, it
> prompts the user to select from a listbox so he can review the records for
> that said category?
>
> Thank you.
> Alanon
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/
> libreoffice-base-building-query-need-help-with-input-
> parameter-development-tp4191909.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] dsum

[Bruce Hohl]

There is an example in the installable help at:
Help > LibreOffice Help
Contents tab > Spreadsheets > Functions Types and Operators > Database
Functions

I just checked and that example works.

On Fri, Aug 26, 2016 at 2:25 AM, Istvan Toth  wrote:

> Guten Morgen,
> ich kann die dsum Function nicht richtig Parameter geben, immer kann ich
> Fehler bekomman,
> Was kann ich nicht richtig eingeben?
> Mfg
> ti
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/dsum-
> tp4191752.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] LibreOffice on a Chromebook?

[Bruce Hohl]

Suggest you read the following:
http://www.pcworld.com/article/2984834/chromebooks/installing-linux-on-a-chromebook-what-you-need-to-know.html
http://www.androidauthority.com/crouton-turn-your-chromebook-into-far-more-than-a-glorified-web-browser-663044/
https://github.com/dnschneid/crouton
So yes, with effort, it's possible but you will still be using a small KB &
screen.

On Thu, Aug 25, 2016 at 2:32 PM, Brian Barker 
wrote:

> At 14:07 25/08/2016 -0400, Kevin O'Brien wrote:
>
>> I have been thinking about getting a Chromebook, but the one thing
>> holding me back is that I need to be able to run LibreOffice. Is that
>> something I can do now?
>>
>
> I'm no expert, but ...
>
> That depends on its operating system. If it is really a Chromebook, it
> will be running the Google Chrome operating system - right? In that case, I
> suspect the answer is "No", but Wikipedia tells me that "Enabling developer
> mode allows the installation of Linux distributions on Chromebooks." If you
> do this, then the answer will presumably become "Yes", since there is an
> LibreOffice version for Linux - indeed, probably included in that
> distribution.
>
> But some of those Chromebooks are now actually "Cloudbooks" and are sold
> with Windows installed. In that case, the answer would be "Yes".
>
> And if so, how well does it run?
>>
>
> Dunno. May depend on *which* Chromebook ...
>
> I trust this helps.
>
> Brian Barker
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Re: Time Calculations in LOBase

[Bruce Hohl]

I can confirm as follows.

With this in table1:
ID time1 time2
1 01/01/16 11:30 PM 01/02/16 04:00 AM
2 01/02/16 01:30 AM 01/02/16 05:30 AM
This query:
SELECT "time1", "time2", DATEDIFF( 'minute', "time1", "time2" ) AS
"diff_minutes", DATEDIFF( 'minute', "time1", "time2" ) / 60.00 AS
"diff_hours" FROM "Table1"

Returns:
time1 time2 diff_minutes diff_hours
01/01/16 11:30 PM 01/02/16 04:00 AM 270 4.5
01/02/16 01:30 AM 01/02/16 05:30 AM 240 4
This might be helpful:
http://hsqldb.org/doc/guide/builtinfunctions-chapt.html#
bfc_datetime_functions

Be mindful of appropriate use of HSQLDB embedded:
https://wiki.openoffice.org/wiki/FAQ_(Base)


On Thu, Aug 25, 2016 at 3:29 PM, Robert Großkopf  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Don,
>
> > It occurs to me my OP may not have been as clear as it should be.
> > To clarify, I need to calculate the decimal value of the times
> > involved: (([day_end]-[day_start])-([lunch_end]-[lunch_start])) =
> > H.nn worked
> >
> > So, for example: ((17:00-08:00)-(13:00-12:00)) = 8.0
>
> This one works:
> SELECT "ID", "DayBegin", "DayEnd", "LunchBegin", "LunchEnd",
> DATEDIFF('hh',"DayBegin", "DayEnd")-DATEDIFF('hh',"LunchBegin",
> "LunchEnd") AS "Worked" FROM "Times"
>
> Examples I have written down in Base-Handbook. But the newer versions
> aren't translated yet from German to English.
>
> Be careful with the example. It does only work with the value for the
> hour. So you get the same with
> (17:00-08:00)-(13:00-12:00)
> and for example
> (17:10-08:00)-(13:00-12:00)
>
> So it would be better to write down the same code for minutes:
> SELECT "ID", "DayBegin", "DayEnd", "LunchBegin", "LunchEnd",
> DATEDIFF('mi',"DayBegin", "DayEnd")-DATEDIFF('mi',"LunchBegin",
> "LunchEnd") AS "Worked" FROM "Times"
>
> So you get the workingtime in minutes. Devide it with 60.00 (.00 for
> the decimal places) and you get a better diff for hours than in the
> first query.
>
> Regards
>
> Robert
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJXv0czAAoJELDKYwaoS9AI28IQAKRBFUlzHX28fOBjp+pAGWeH
> 9JnaNSJl0ao2bC1uKjpgI7dN/osbmA6Muj99RIdSpict6goXu+zIKNLTlzw/wSeO
> 6w3Xvk3HD/sr4ow4BTQV/2n8A05dHKsIaZnYB8YCjz6d7XEzwxdEyca2zM+3U9KU
> LuKNhvbPNpzzPq41p2dAWk8gA99fKEhhFpefsCk8FyW7d1+Rr/+DcqrYn+hY/qRo
> UVuNpxr0EOZT4Qa2/c5uXE9DPmKnjo2Q93rvrL1ROO3Xj/Tzi5JexDPaQ4f52YsI
> FXHQ6g7PxzDKM5NZ0pKlRlcJqg/9Sv01v75PuuQM9+Sq56LQpImyk99GTO0sJbsM
> Hu3bwnHzEy3Up+au0Ra7jJ/cPkkXdgrJYQUUZJ32CSWlaiFQK9PizsfnzlA4OWRn
> 6s9O1F3zoDhs50dsERsgLYn4oN0AfFocR4Np9jVPBgYKzhe2yhdem3nZjFwqCjeY
> z1L+sNtu6zTikqrGBem8+U14Ti7ogLRdF7pe7X4ONvYAiYP3PXd5DoOcFwr8MRVg
> 4BybEk8pOYzzzeGzrTKaJFA1ECQy/l8B0mS4CzKHlDeA5t9WxnuIr3TiCO0KaHya
> eTwdyxA5Mhv82t+Egptb/MP2kLArO9trHakM02QkbL64A3g1qlo8CIAzAudu9QrC
> KG5LqIEUIeMows6DOgKq
> =49Q8
> -END PGP SIGNATURE-
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Time Calculations in LOBase

[Bruce Hohl]

What type of database is used - HSQLDB embedded, HSQLDB, MySQL, PostgreSQL,
etc?

On Thu, Aug 25, 2016 at 11:54 AM, Don Parris  wrote:

> Hi all,
>
> I need to do some time calculations in LO Base queries - seems fairly
> straightfoward, but I can't seem to find any good info on how this is done.
>
> I am calculating hours worked in a day (could span midnight, but that is
> not normally the case).  In a certain app similar to Base, I can do:
> (([day_end]-[day_start])-([lunch_end]-[lunch_start]))
>
> In LO Base, the query fails on a wrong data type failure.  I am using the
> Date/Time data type (time stamp).  Can anyone point me to good information
> on how to perform this calculation in Base?
>
>
> Many thanks in advance!
> Don
> --
> D.C. Parris, FMP, Linux+, ESL Certificate
> Minister, Security/FM Coordinator, Free Software Advocate
> http://dcparris.net/ 
> 
> GPG Key ID: F5E179BE
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Need someone to check a 5.2.x regression

[Bruce Hohl]

Many thanks.  I hate to see regressions. And, since they can be used almost
entirely from the keyboard, I still prefer the multi-tabbed windows like
Format > Cells, Format > Page, Format > Character, Format > Paragraph, etc.
over all the other methods: tool bars, sidebars, ribbons :(

On Sat, Aug 20, 2016 at 5:06 AM, Pedro  wrote:

> Bruce Hohl wrote
> > In both cases the Format > Cells > Background > 'No Fill' did not work
> > correctly per this bug report:
> > https://bugs.documentfoundation.org/show_bug.cgi?id=101588 However,
> > another
> > tester did not find the problem on Windows 10. If you have 5.2.x install
> > can you please check this:
> >
> > To reproduce:
> > 1 - Add background color to cell A1 and A3 but not cell A2.
> > 2 - Select cells A1:A3
> > 3 - Format > Cells > Background tab, Click 'No Fill', Click 'OK'.
> > Cell background colors are not removed.
> > This works in 5.1.x versions.
>
> Answered and confirmed in the Bug Tracker.
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/Need-
> someone-to-check-a-5-2-x-regression-tp4191257p4191270.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

[libreoffice-users] Need someone to check a 5.2.x regression

[Bruce Hohl]

Hi All,
I installed 5.2.x on a Windows 7 and Linux from
ppa:libreoffice/libreoffice-5-2.
In both cases the Format > Cells > Background > 'No Fill' did not work
correctly per this bug report:
https://bugs.documentfoundation.org/show_bug.cgi?id=101588 However, another
tester did not find the problem on Windows 10. If you have 5.2.x install
can you please check this:

To reproduce:
1 - Add background color to cell A1 and A3 but not cell A2.
2 - Select cells A1:A3
3 - Format > Cells > Background tab, Click 'No Fill', Click 'OK'.
Cell background colors are not removed.
This works in 5.1.x versions.

-- 
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 formula tool tips - possible to turn off?

[Bruce Hohl]

Gordon, perhaps you could add your comment to the bug report, the
developers might appreciate the input / feedback.  I also prefer the second
choice and like your idea of a similar option for tool tips.

On Mon, Aug 15, 2016 at 12:10 AM, gordon cooper 
wrote:

> I like your second suggested option Bruce, i.e. None : Standard : Extended.
>
> It would be a good option for all tooltips.
>
> Gordon.
>
>
>
> On 15/08/16 13:04, Bruce Hohl wrote:
>
>> My search for a way to control the formula tips also was unsuccessful so I
>> added the following enhancement requests:
>> https://bugs.documentfoundation.org/show_bug.cgi?id=101512
>>
>> On Sun, Aug 14, 2016 at 7:00 PM, Remy Gauthier 
>> wrote:
>>
>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Calc formula tool tips - possible to turn off?

[Bruce Hohl]

My search for a way to control the formula tips also was unsuccessful so I
added the following enhancement requests:
https://bugs.documentfoundation.org/show_bug.cgi?id=101512

On Sun, Aug 14, 2016 at 7:00 PM, Remy Gauthier 
wrote:

> Hello,
>
> No, I do not know of any way to turn the formula tool tips off. I even had
> a look at the advanced settings (Tools... Options... LibreOffice...
> Advanced... Advanced Settings) and I could not find anything.
>
> Rgds,
>
> Rémy Gauthier.
>
> Le samedi 13 août 2016 à 15:42 -0400, Bruce Hohl a écrit :
>
> Does anyone know if it is possible to turn off the formula tool tips in
> Calc?
>
>
>

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

[libreoffice-users] Calc formula tool tips - possible to turn off?

[Bruce Hohl]

Does anyone know if it is possible to turn off the formula tool tips in
Calc?

-- 
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] Line spacing on Writer

[Bruce Hohl]

Go to "View > Non-Printer Characters".  This will show the paragraph
breaks, etc.
Position the cursor within a paragraph or select (highlight) desired
paragraphs.
Open "Format > Paragraph" and go to the "Indents & Spacing Tab".
You can view and change spacing setting here.

On Sat, Aug 6, 2016 at 11:49 AM, Richard Foulk 
wrote:

> I’m using LibreOffice Writer to write a novel and the line-spacing is all
> messed up. Single, 1.5, double-spacing all on the same page.
>
> I’ve tried Format-spacing, Windows-paragraph and everything else -- but
> nothing works.
>
> Can you please help me?
>
>  Thank you
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Compatibility of LO Base with Access databases

[Bruce Hohl]

Base and some of its limitations (including enbedded HSQLDB) are well
described here:
https://wiki.openoffice.org/wiki/FAQ_(Base)

The last two times I needed a multi user database accessible over the web I
went with a LAMP approach.  The *upfront* set up and learning curve was
higher but *less* time is required over the life of the project
(development & maintenance) as these tools have exceptional stability and
performance, have very few bugs, excellent documentation and require no
client side maintenance.  AND, it's far more rewarding developing the
application versus fighting the bugs and limitations of your tools ... as
often happens when using Access, Base and their like (been there, done
doing that).


On Wed, Aug 3, 2016 at 6:15 AM, Alexander Thurgood 
wrote:

> Le 02/08/2016 à 00:23, Ian Whitfield a écrit :
>
> Hi Ian,
>
>
> >
> > *Re: The LO Base discussion* - just my "Penny's Worth"!!!
> >
>
> > The only way I got any (sort of results) was by using MySQL as the
> > backend but it took a couple of months to get it working and after a few
> > months even that crashed on me. I recently had to re-build my computer
> > after a hardware failure and my OpSys upgraded to 64bit and since then I
> > can not even get the MySQL linking in LO Base to even start!!
> >
>
> It it is fairly rare for people to suffer from catastrophic failures and
> data loss using mysql - most of the time, it is usually possible to
> salvage most, if not all of one's data providing one takes an interest
> in the manuals on how to administer such a database server (and there
> are a plethora of them, not least Oracle's own documentation).
>
>
> > So if you are happy to keep lots and lots of backups, and spend lots and
> > lots of time re-building everything at almost monthly intervals - and by
> > re-building I mean the Database Tables, redesign all your Forms and
> > set-up all your Queries and Reports from scratch - then go with it,
> > otherwise give it a miss.
> >
>
> It is also not strictly necessary to keep backups of the mysql database,
> although it is indeed a recommended practice. Again, the documentation
> is replete on how to do this safely.
>
> From the interaction I've had with you on and off the list, I would say
> that you have been unfortunate with regard to some of your expectations,
> in that you did not wish to, or failed to, understand what it meant to
> have a database server, and didn't wish to spend time understanding how
> it worked in case things did go pear-shaped. I can understand this from
> a user perspective, and in that case, choosing mysql as your backend
> database engine was probably not a good idea, but as you found out for
> yourself, neither was the embedded hsqldb.
>
> My own experience with mysql databases has been rock solid in terms of
> data integrity now for more than 10 years, including various different
> types, from stock management, IP rights management, accounting, etc,
> although I will admit that interaction with StarOffice, OpenOffice.org
> and LibreOffice has caused some issues, but this mostly lies with
> limitations or bugs within those programs and not mysql itself (barring
> a few connector driver problems).
>
> Fact of the matter is that databases when used with LO, embedded or not,
> probably require more work than most "Access-users" are willing to put
> in. There is no "simple", "out-of-the-box" solution for such users when
> attempting to switch to LO, everything will be a compromise of sorts, be
> it form design, reporting, stability, multi-user access, etc.
>
> LOBase was always designed with the eye of a database administrator in
> mind, and the attempted switch to a user-centric orientation just didn't
> quite happen (for various reasons within Sun, and then Oracle). However,
> what we have got is not bad as things go, providing that one can accept
> its limitations (or alter one's work flow to work around them).
>
>
> Alex
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

[Bruce Hohl]

> I have recently read that Open Office no longer uses HSQL. Is that also
true of LO?
If a new Base is created in LO 5.1.x it will be default is "HSQLDB
Embedded" to store the data.

> is it really necessary to have another database product to do database
work in LO Base?
Not necessarily, but this is a feature which allows Base to be used as
front end to another database.  This might be done for various reasons like
(1) the other database already includes the needed data, (2) a concurrent
multi-user environment is wanted which is not available via HSQLDB embedded
but is possible with HSQL split , (3) a wanted feature is available in
another database but not in HSQL, (4) a preference for another database,
Etc.  Reference this: https://wiki.openoffice.org/wiki/FAQ_(Base)

On Sat, Jul 30, 2016 at 8:53 PM, Dale Erwin 
wrote:

> I have a question about Base:
>
> I used to work with standalone HSQLDB using Java on the OS/2 (eCS)
> platform.  During that time, it was announced that Sun's upcoming release
> of Open Office would include HSQL as the builtin database engine.  I have
> recently read that Open Office no longer uses HSQL. Is that also true of LO?
>
> If HSQL is indeed the builtin database engine, is it really necessary to
> have another database product to do database work in LO Base?
>
> I stopped using eCS a few years ago when the (at the time) latest version
> would not install on my new computer.  I am now using Windows 10 (which I
> literally despise).
>
> Dale Erwin
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Date field in a spreadsheet

[Bruce Hohl]

File > Print Preview,  Click 'Format Page', In the Header or Footer tab
click 'Edit'.  You can add the sheet name to the Left, Center or Right by
clicking the 'Sheet Name' icon near the bottom.

On Wed, Jul 27, 2016 at 7:23 AM, william drescher 
wrote:

> I have version Version: 5.0.5.2
>
> In writer I can insert a field that shows the current date whenever the
> document is opened.  I can't figure out how to do that in a spreadsheet.
> Help please.
>
> bill
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Keyboard shortcuts

[Bruce Hohl]

You can also use: Tools > Customize, Keyboard tab to set keyboard
shortcuts.  I use this to assign 'easy' shortcuts to features often used or
features in 'inconvenient' menu locations.  You can also save these
settings to a file - see buttons for Save and Load.

On Tue, Jul 26, 2016 at 3:12 AM, Regina Henschel 
wrote:

> Hi,
>
> Kevin O'Brien schrieb:
>
>> I was in LibreOffice 5.1.3.2 for Windows, and I wanted to insert a
>> field. Alt+i opens the Insert menu, and Field has the keyboard
>> shortcut alt+d. But so does Footnote and Endnote, and it comes first.
>> So pressing Alt+d goes to Footnote and Endnote, and there it stays.  I
>> have tried just d on its own after that, or Alt+d,d, but it doesn't
>> seem to do anything.
>>
>
> That is, because it has opened a sub-menu. You first need to leave the
> sub-menu by pressing Esc-key. Then the next D-key will get the Field item.
>
> The need to leave the sub-menu is unhandy. You can customize the menu and
> rename the entry Field so that you add a character after the text Field,
> that is not used by any other menu item. The automatic, which assigns the
> underline access, will use it then. The problem is, that _all_ characters
> of the word Field are already used for accessing other items.
>
> Kind regards
> Regina
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] If value is not present, count it.

[Bruce Hohl]

Perhaps one of these depending the content of Column E:
=COUNTIFS(E2:E160,"<>PO",  B2:B160,"Red",  D2:D160,"M")
=COUNTIFS(E2:E160,"",  B2:B160,"Red",  D2:D160,"M")

On Thu, Jul 14, 2016 at 8:36 PM, Wade Smart  wrote:

> This does not work but this is what Im thinking about.
>
> If a item in this range does not have PO, and is Red and is M
> then I want to count it.
>
> =IF( $E$2:$E$160 <> "PO",
> SUMPRODUCT($B$2:$B$160="Red",$D$2:$D$160="M"))
>
> This is for tracking our league jerseys and our inventory
> to be checked out seasonally to the players. I want to know
> how many of Medium shirts Red team has.
>
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Alt Key

[Bruce Hohl]

Thanks for the info and the links, two observations:

(1) The Windows behaviour of pressing and releasing the Alt key to activate
the text menu is a more "accessible" default behaviour for those who cannot
or have difficulty with pressing keys simultaneously (versus the Linux
behaviour which requires Alt+).

(2) As LO is cross platform I think the idea of a LO setting for choosing
the preferred Alt key behaviour is a good idea so that users can work with
LO in a consistent fashion regardless of the OS/DE/Theme of computer being
used.

On Sun, Jul 3, 2016 at 2:20 PM, V Stuart Foote 
wrote:

> @Bruce, *
>
>
> Bruce Hohl wrote
> > On Linux pressing and holding the Alt key "activates" text menu (File,
> > Edit, View, etc). On Windows pressing then releasing the Alt key
> "actives"
> > the text menu. Does anyone know how to get Linux to behave like Windows
> > for
> > the Alt key or vice versa?
>
> Unfortunately you can not.
>
> Recent work done to make the handling of Accelerators compliant with GTK+
> v3, on GTK+3 compliant desktop environments implemented a desired behavior
> or simply toggling the assigned mnemonic accelerators visible (e.g. the
> underlined character to be pressed to activate the action).
>
> https://bugs.documentfoundation.org/show_bug.cgi?id=92630
>
> But, on GTK+2 and Windows and OS X the adjustments have been somewhat
> unwelcome and cause disruption in the handling of the Accelerators.  As you
> note on Windows the  key moves focus to the main menu--and then the
> mnemonic key must be entered to navigate.  Previously they were handled as
> paired +key values.
>
> You can get some feel for the issue in the proposal to make the GTK+ toggle
> optional in non-GTK+3 Desktop Environments.
>
> https://bugs.documentfoundation.org/show_bug.cgi?id=99326
>
> So, the issue is still be kicked around.
>
> Stuart
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Alt-Key-tp4187824p4187831.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

[libreoffice-users] Alt Key

[Bruce Hohl]

On Linux pressing and holding the Alt key "activates" text menu (File,
Edit, View, etc). On Windows pressing then releasing the Alt key "actives"
the text menu. Does anyone know how to get Linux to behave like Windows for
the Alt key or vice versa?

-- 
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] Libre Office clc file not opening in MSO Excel 2007

[Bruce Hohl]

From LO to which file format (ods, xls, xlsx) do you save the spreadsheet?
What is "clc file"?
Do the files open if no password is used?

On Sat, Jul 2, 2016 at 6:41 AM, jinesh  wrote:

> Hi,
>
>
>
>
>
> I'm using Libre office 5.1, when i was send or share password protected or
> more formulas included clc file  to others that files are not opening in
> Excel 2007(they dont have Libre office they are opening in MSO excel 2007).
>
>
>
> At the time of file opening below error has occured.
>
>
>
>
>
>Untitled.jpg
>
>
>
>
>
> If click yes later file will open but a lot of contents and formulas are
> missing in that opened  file.
>
>
>
> How to fix this problem, pls help me
>
>
>
>
>
>
>
> Regards,
>
> Jinesh
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Re: LO Base - Dropdown boxes

[Bruce Hohl]

I have never done this but since it seems your data might fit within a
spreadsheet perhaps you can use the features in View > Tool bars > Form
Controls, Design, Navigation to create an input sheet / form.  Then another
sheet(s) for "output" via Data > Filters or Pivot Tables.  You might also
be able to use the spreadsheet protection features to keep the "design"
locked down.  I would guess this would be OK for 10,000 or fewer records,
could work with up to 100,000 records, but would run into spreadsheet
"practical limits" (performance, stability) beyond that ... in which case
you really would need a database!

On Wed, Jun 29, 2016 at 10:35 AM, Alexander Thurgood <
alex.thurg...@gmail.com> wrote:

> Le 26/06/2016 à 16:20, Ian Whitfield a écrit :
>
> Hi Ian,
>
>
> We need more info.
>
> > I'm trying to use LO Base - linked to a Spreadsheet and so far all is
> > going well.
>
>
> How is it linked ? What exactly do you mean by linked to a spreadsheet ?
>
>
>
> > However I don't seem to be able to get Dropdown Boxes to work. On my
> > 'User Form' they are greyed out and do not react when clicked. I have
> > set them to be Dropdown, entered the list of options and set the display
> > line number.
>
> If your spreadsheet is the datasource, and the properties of your form
> are read/write/add (data) then any form you make stored within an ODB is
> dependent on being able to make modifications to the underlying Calc
> sheet. As Calc sheets are read-only when attached to ODB files as
> datasources, it would not be surprising that you could not set the value
> via a dropdown menu, because doing so would attempt to write the chosen
> value into the cell of the sheet.
>
> A read-only setting on the form's properties might bring back the
> dropdown menus (haven't tried so don't know), but don't expect them to
> write anything to the spreadsheet.
>
>
> Alex
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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] change user interface

[Bruce Hohl]

"...  current user interface look like old office 2003.I need to change the
look like office 2007 or higher."

Firstly, quite a few people do *not* prefer the 'Ribbon' menu system
introduced with MSO 2007.  Google Docs features tool bars of icons but I
doubt anyone thinks it seems "old" and certainly Google knows a thing or
two about designing a clean and useable user interface.

In fact, I find LO's interface a great strength.  It provides many more
options for accessing features than MSO or Google docs including:

   1. The traditional and very browse-able Text Menu:  File, Edit, View,
   Etc.
   2. Tool bars of icons (which can be customized)
   3. A Sidebar (View > Sidebar) which is suspiciously similar to the MSO
   Ribbon :)
   4. Windowed Pallets (Format > Cells, Format > Character, Etc.)
   5. An extensive and easy to use customization feature under Tools >
   Customize which allows keyboard shortcuts, custom menus, etc.

Thus, each user can easily adjust the interface to their preference.  For
example, I hide all tool bars for maximum screen space and minimum
clutter.  I then use Tools > Customize to assign frequently used features
to key combinations (some are assigned by default).  More specifically, I
use F11 to insert spreadsheet rows, F12 to delete spreadsheet rows, F8 to
open the Sidebar, Ctrl+1 to open Format > Character, Ctrl+2 to open Format
> Paragraph, Ctrl+3 to open Numbers and Bullets, Etc.  These settings can
even be saved to a file.  I would say that LO offers the most flexible and
easy to customize user interface of the three.

On Thu, Jun 30, 2016 at 4:32 AM, jorge  wrote:

> Hi Jinesh:
>
> We understand that you are accustomed to use office from
> microsoft. It
> is normal to have to use a new program some days to get use to it. It is
> like to use a new car or a new house.
>
> Enjoy LibreOffice as is because it offers you almost feature that
> you
> can find in office.
>
> Please don't ask to van Gogh to paint like Miró because they are
> diferents, only enjoy theirs pictures.
>
> Regards,
>
> Jorge Rodríguez
>
>
> El mié, 29-06-2016 a las 19:02 +0530, jinesh escribió:
> > Hello,
> >
> >
> >
> > I'm using Libreoffice 5.1 its the best alternative for Microsoft office.
> >
> >
> >
> > I have a doubt please help me,
> >
> >
> >
> > How can i change the user interface in Libreoffice 5.1 current user
> > interface look like old office 2003.I need to change the look like office
> > 2007 or higher.
> >
> >
> >
> >
> >
> >
> >
> > Regards,
> >
> >
> >
> > Jinesh
> >
> >
>
> --
> Atentamente,
>
> Jorge Rodríguez
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] LO 5.1.4.2 calc consistently crashing on row deletion

[Bruce Hohl]

Tom,
I just updated to LO 5.1.4.2 from the Ubuntu PPA's on Ubuntu 14.04 (really
LXLE Posh).  I checked deleting rows from a few worksheets and encountered
no errors.  If you are using Ubuntu or an Ubuntu based OS you might try
getting LO from the PPAs per the links below as these are packaged for
Ubuntu.
https://wiki.ubuntu.com/LibreOffice
https://launchpad.net/~libreoffice/+archive/ubuntu/ppa

On Fri, Jun 24, 2016 at 6:54 PM, Tom Cloyd  wrote:

> I downloaded the *.deb installer yesterday, and installed it a little over
> an hour ago. It's crashed 6 times in the first hour. No matter how I try to
> delete a spreadsheet row, I get a modal window with an error message.
> Clicking that away leads to all of LO just disappearing.
>
> Here's my version:
>
>
>
>
> And the error message I keep seeing -
>
>
> ​
> I can't use this version if it acts like this, so I'm reverting to my
> previous one.
>
> Let me know if I can help any more.
>
> Tom
>
> --
>
> ~
> Tom Cloyd, MS MA LMHC (WA)
> Psychotherapist (psychological trauma, dissociative disorders)
> Spokane, Washington, U.S.A: (435) 272-3332
> << t...@tomcloyd.com >> (email)
> << TomCloyd.com >> (website)
> ~
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] How to learn Base & an external database program

[Bruce Hohl]

You could review this:
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook

If you think an external database is appropriate each will likely have it's
own documentation like this:
http://www.postgresqltutorial.com/

Access is unique.  On the plus side the front end offers a great deal of
functionality all within a single file DB.  On the minus side the back end
Jet database total size is limited to something like 4GB but you can attach
/ link to other Jet DBs, for some operations the performance can be
absolutely horrible, and file corruptions can be a risk.  So Access is
strong on the front side and weak on the back end.  Open source options
tend to strong on the back end with DB options like HSQL, MySQL and
PostgeSQL (I don't think SQLite can be used with Base).  Base as front end
has fewer features / less polish than Access which may or may not matter
depending on the scope of your needs.  You will likely just have to explore
a bit.

On Mon, Jun 20, 2016 at 10:30 AM, Tim Deaton  wrote:

> From 1987-2002 I used and developed applications in PC-File (a flat-file,
> dbf-based, shareware database) to help with my bookkeeping work and various
> other tasks in the company I worked for.  Then from 2002 I moved to Access
> 97 and developed dozens of (mostly relational) applications for the same
> job from 2002-2007.  Then I moved to a different state, and have not worked
> professionally with databases since.  However, I do still have 3 personal
> database applications that I use in what is now Access 2003.
>
> What I want to do is to migrate those applications to LibreOffice Base, or
> to another open-source database front-end.  From what I've read on this
> list, I gather that will basically mean re-creating them, almost from
> scratch. I also gather that I will want to use an external database program
> (HSQLDB? Firebird? SQLite? ..).  But I have no knowledge of those
> programs.  Is there a good tutorial somewhere for any of them?  Preferably
> one that goes thru the process of using Base as a front end for them?
>
> Thanks,
> -- Tim Deaton
> email: t...@timdeaton.org
> web: www.timdeaton.org
> ===
> I know the plans I have for you:
> Plans to prosper you and not to harm you;
> Plans to give you hope and a future.
>--- God (Jeremiah 29:11)
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: sumifs() with wildcard question

[Bruce Hohl]

Thanks for that link Miguel.  Looking forward to that feature.

On Fri, Jun 17, 2016 at 5:47 PM, m.a.riosv 
wrote:

> You need to wait a couple of months for the next release 5.2, it implements
> the option to use regular expressions or wildcard.
>
>
> https://wiki.documentfoundation.org/ReleaseNotes/5.2#Support_wildcards_to_be_compatible_with_XLS.2FXLSX_and_with_ODF_1.2
>
> Miguel Ángel.
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/sumifs-with-wildcard-question-tp4186442p4186487.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] sumifs() with wildcard question

[Bruce Hohl]

In this particular case I want to sumifs() with the * wildcard for
compatibility with Excel.
Regexp are not supported by Excel.

On Fri, Jun 17, 2016 at 9:13 AM, Brian Barker 
wrote:

> At 07:37 17/06/2016 -0400, Bruce Hohl wrote:
>
>> A B
>> 1 aa 1
>> 2 ab 2
>> 3 bb 10
>> 4 bc 10
>> 5 a* 0
>> Formula in cell B5 =SUMIFS(B1:B4,A1:A4,A5) should return 3 not 0.
>>
>> Tools > Options > LibreOffice Calc > Calculate Enable regular expressions
>> in formulas is *off* (I don't want regexp for this worksheet).
>>
>
> If you need this sort of thing, it may be that you *do* need regular
> expressions. Surely you can design other parts of your spreadsheet so that
> they will work correctly even with regular expressions allowed in such
> contexts? Remember that you can use the backslash to escape characters that
> would otherwise be interpreted as regular expressions.
>
> Alternatively, you could create an extra column, say D. (I'm assuming that
> your rightmost numbers are in column C, not part of the contents of column
> B, in fact.) Enter =LEFT(B1) into D1 and fill down; =SUMIF(D1:D4;"a";A1:A4)
> or =SUMIF(D1:D4;D5;A1:A4) or =SUMIF(D1:D4;LEFT(B5);A1:A4) will then achieve
> what you need. If preferred, column D can be hidden, excluded from a print
> range, or placed out of the way or even on another sheet.
>
> I trust this helps.
>
> Brian Barker
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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] sumifs() with wildcard question

[Bruce Hohl]

A B
1 aa 1
2 ab 2
3 bb 10
4 bc 10
5 a* 0
Formula in cell B5 =SUMIFS(B1:B4,A1:A4,A5) should return 3 not 0.

Tool > Options > LibreOffice Calc > Calculate
Enable regular expression in formulas is *off*  (I don't want regexp for
this worksheet).

I though there was a setting that controls how the * wildcard is
interpreted in Calc.
Can someone please help?

-- 
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 change dialog box font size?

[Bruce Hohl]

Edwar,
I have only used the LO Scaling feature to increase (on high resolution
monitors) or decrease (on low resolution monitors) the font size for the
menus.  I then use the View > Zoom feature for the main worksheet or text
document.  Otherwise the existing defaults were always readable.

On Sun, Jun 12, 2016 at 11:32 AM, Edwar Cifuentes 
wrote:

> Hi Bruce.
> Mint 17.3 comes with Libreoffice 5. I've also got an Ubuntu 16 install and
> it also came with LO 5, but it has the same problem.
> Can you change both the Menus and Dialog boxes font sizes in your Mint
> 17.3 installs without using scaling? or, can you change the size of the
> Dialog boxes fonts only?
>
> Bruce wrote:
> You could download Linux Mint 17.3 Rosa Xfce, install to USB as bootable,
> start your PC with this Live CD.  Then open LO to see if the default
> setting are OK for you.  If so you could look for the difference in
> settings or just reinstall.  On my 2 (default) installs of LM 17.3 Rosa.
> Xfce I don't have the small fonts issue ... and I hate small fonts!
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: How to change dialog box font size?

[Bruce Hohl]

You could download Linux Mint 17.3 Rosa Xfce, install to USB as bootable,
start your PC with this Live CD.  Then open LO to see if the default
setting are OK for you.  If so you could look for the difference in
settings or just reinstall.  On my 2 (default) installs of LM 17.3 Rosa
Xfce I don't have the small fonts issue ... and I hate small fonts!

On Sat, Jun 11, 2016 at 7:00 AM, Edwar Cifuentes 
wrote:

> Like I said in the OP I cannot use font scaling because my menu fonts are
> already bigger. If I increase the font scaling then my menu fonts become
> enormous
>
> Nino wrote:
> > did you try Tools->Options->LibreOffice->View and change the scaling >
> of the UI?
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Draw

[Bruce Hohl]

Robert,
Thanks for that comment on Evince for Windows.  It's "lighter" as in less
cluttered than Sumatra and includes a useful Annotations feature.

On Mon, Jun 6, 2016 at 7:45 PM, Robert Funnell 
wrote:

> David -
>
> Evince, mentioned by Bruce, also works under Windows.
>
> - Robert
>
>
> On Mon, 6 Jun 2016, DavidBTeagueAt Comporium.net wrote:
>
> Thank you Harvey, Stuart, and Bruce for useful information and suggestions.
>> I am a long time user of OO.org & LO, from the time of Star Office before
>> Sun. I am not a "power user" though I am a long time user.
>> I will investigate the pdf packages suggested.
>> With warmest regard
>> David
>>
>> On 6/6/2016 3:07 PM, Harvey Nimmo wrote:
>>
>>>  I find Master pdf Editor to be a useful tool. It is free form non
>>>  -commercial use. It can be a wee bit slow on my Linux openSUSE Leap
>>>  42.1 but has many features that you may have seen in Adobe Pro, and is
>>>  also available for Windows. See
>>>  https://code-industry.net/masterpdfeditor.
>>>  Cheers
>>>  Harvey
>>>  On Mon, 2016-06-06 at 11:49 -0700, V Stuart Foote wrote:
>>> >  DavidBTeagueAt Comporium.net wrote
>>> > >  In my search  for a cross platform (Linux/Windows) and preferably
>>> > >  GPL/free pdf reader.  I found that Draw does very well.
>>> > > > >  1) I would like an easy/easier way to move page to page in Draw.
>>> > > > >  2) Is there a way to do this?
>>> >  Draw is a component of the full LibreOffice suite, and  is not
>>> >  intended to
>>> >  be installed individually--although some Linux distros attempt to do
>>> >  that.
>>> > >  Draw is not a PDF editor or reader. It will perform a filter driven
>>> >  import
>>> >  of PDF as pages in a ODF Draw document converting content of the PDF
>>> >  to Draw
>>> >  objects.  Some PDF features implemented by Adobe are simply not
>>> >  implemented.
>>> > >  On export from Draw, or Writer or Impress or Math--filters are again
>>> >  used to
>>> >  render the content back into PDF--mostly compliant with PDF 1.5 spec
>>> >  with
>>> >  some additional options.
>>> > >  Once imported into LibreOffice (default is Draw, but filter import
>>> to
>>> >  Writer
>>> >  and Impress is also supported),  focus in the "Pages" frame allows
>>> >  movment
>>> >  between pages with PgDn and PgUp keys.
>>> > >  YMMV -- and please  accept this is the way LibreOffice (ApacheOpen
>>> >  Office
>>> >  and OpenOffice before) interact with PDF.
>>> > >  So if you can live with that, enjoy!
>>> > >  Stuart
>>> >
>>>
>>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Draw

[Bruce Hohl]

If you really only want a light/fast PDF *reader* than for Linux try Evince
and for Windows try Sumatra.

If you want some basic PDF tools (not a full PDF editor) than for Linux try
PDFshuffler and for Windows try PDFTK Builder for which you can find a link
on this page: http://www.angusj.com/pdftkb/.

On Mon, Jun 6, 2016 at 1:47 PM, DavidBTeagueAt Comporium.net <
davidbtea...@comporium.net> wrote:

> In my search  for a cross platform (Linux/Windows) and preferably GPL/free
> pdf reader.  I found that Draw does very well.
>
> 1) I would like an easy/easier way to move page to page in Draw.
>
> 2) Is there a way to do this?
>
> 3) Is there a smaller, faster loading, stand alone solution?
>
>-- David Teague
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] HP Officejet Pro 8630 overprinting lines in LO on Win 10

[Bruce Hohl]

You cite LO as the culprit yet the problem occurred after changing to
Win10.  I suggest you verify if the HP driver is at the correct version for
Win10.  Maybe use the 'DriverTalent' program to check all your drivers.
http://download.cnet.com/Driver-Talent/3000-2094_4-76219521.html

On Tue, May 24, 2016 at 5:35 AM, Rogier F. van Vlissingen <
vlisc...@gmail.com> wrote:

> Thanks for all the suggestions.
>
> All of them are too much effort, if need be I can do the PDF work around.
>
> For now what this means is I'll work with MSO, which I dislike intensely,
> but it can't be helped. I foresee in future running my main machine under
> Linux Mint entirely, and keeping a Win10 machine just for limited jobs
> where I absolutely must have it. This is all too much.
>
> If LO can't make a mainstream printer like this work, that is pretty
> devastating.
>
> *Rogier Fentener van Vlissingen
> <
> http://t.sidekickopen52.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4Rs8XWW8r4QYz1px7xYW5v_Sgz56dJpLf29LVkq02?t=http%3A%2F%2Fviz.me%2Fvliscony%2Ft%2F7&si=4817575424294912&pi=cb0b1d7c-ff80-4f89-aa71-8becc08c0128
> >*
> *About Me
> <
> http://t.sidekickopen52.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4Rs8XWW8r4QYz1px7xYW5v_Sgz56dJpLf29LVkq02?t=http%3A%2F%2Fabout.me%2Fvliscony&si=4817575424294912&pi=cb0b1d7c-ff80-4f89-aa71-8becc08c0128
> >
> *Schedule
> a phonecall here
> <
> http://t.sidekickopen52.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4Rs8XWW8r4QYz1px7xYW5v_Sgz56dJpLf29LVkq02?t=https%3A%2F%2Fcalendly.com%2Fdabxdssinc%2F15min&si=4817575424294912&pi=cb0b1d7c-ff80-4f89-aa71-8becc08c0128
> >
>
> On Tue, May 17, 2016 at 7:45 PM, anne-ology  wrote:
>
> >If you can switch back to WIN7, my suggestion would be to do so.
> >
> >
> >
> > From: Rogier F. van Vlissingen 
> > Date: Tue, May 17, 2016 at 6:05 AM
> > Subject: [libreoffice-users] HP Officejet Pro 8630 overprinting lines in
> LO
> > on Win 10
> > To: users@global.libreoffice.org
> >
> > Since switching to Windows 10, I've had to abandon LibreOffice, since my
> > printer inexplicably overprints lines in LO. This never happened in Win7.
> >
> > Anybody have any suggestions?
> >
> > At some point I am going to Linux Mint 17.3, but I will need to keep at
> > least one machine running Win10...
> >
> > But I have to say, I'd pick LO over MSO any day of the week.
> >
> > *Rogier Fentener van Vlissingen
> >
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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] HP Officejet Pro 8630 overprinting lines in LO on Win 10

[Bruce Hohl]

As a work-around perhaps you could print to PDF then print the PDF on the
HP8630.

On Tue, May 17, 2016 at 7:05 AM, Rogier F. van Vlissingen <
vlisc...@gmail.com> wrote:

> Since switching to Windows 10, I've had to abandon LibreOffice, since my
> printer inexplicably overprints lines in LO. This never happened in Win7.
>
> Anybody have any suggestions?
>
> At some point I am going to Linux Mint 17.3, but I will need to keep at
> least one machine running Win10...
>
> But I have to say, I'd pick LO over MSO any day of the week.
>
>
>
> *Rogier Fentener van Vlissingen
> <
> http://t.sidekickopen52.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4Rs8XWW8r4QYz1px7xYW5v_Sgz56dJpLf29LVkq02?t=http%3A%2F%2Fviz.me%2Fvliscony%2Ft%2F7&si=4817575424294912&pi=5b9d41d4-a2b6-4383-c700-5c61db38e1e7
> >*
> *About Me
> <
> http://t.sidekickopen52.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4Rs8XWW8r4QYz1px7xYW5v_Sgz56dJpLf29LVkq02?t=http%3A%2F%2Fabout.me%2Fvliscony&si=4817575424294912&pi=5b9d41d4-a2b6-4383-c700-5c61db38e1e7
> >
> *Schedule
> a phonecall here
> <
> http://t.sidekickopen52.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4Rs8XWW8r4QYz1px7xYW5v_Sgz56dJpLf29LVkq02?t=https%3A%2F%2Fcalendly.com%2Fdabxdssinc%2F15min&si=4817575424294912&pi=5b9d41d4-a2b6-4383-c700-5c61db38e1e7
> >
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

[Bruce Hohl]

Check cell formats and contents in B2:B8.  SUM() will not add numbers
within cells formatted as text or numbers preceded by a half quote.  Per
below the sum() result is 4 as such items are not summed.

4 '=SUM(B2:B8)
2 Cell number format with '2  (note the half quote)
3 Cell number format with '3  (note the half quote)
5 Cell formatted as text.
1 Cell number format with 1
1 Cell number format with 1
1 Cell number format with 1
1 Cell number format with 1


On Wed, May 11, 2016 at 12:03 PM, shirish शिरीष 
wrote:

> Hi all,
>
> I was trying a simple addition in column =SUM(B2:B8)
>
> but that didn't work . I am getting the output as zero.
>
> Could somebody look at it and share what is/was wrong ?
>
> Sharing an example worksheet for the same.
> --
>   Regards,
>   Shirish Agarwal  शिरीष अग्रवाल
>   My quotes in this email licensed under CC 3.0
> http://creativecommons.org/licenses/by-nc/3.0/
> http://flossexperiences.wordpress.com
> EB80 462B 08E1 A0DE A73A  2C2F 9F3D C7A4 E1C4 D2D8
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Number comparisons in conditional text

[Bruce Hohl]

A (more difficult) method to use the age ranges from their own table
(separate from the other data) would be to use a correlated subquery.  Then
you could have "cleaner" SQL.  You can find examples of this on the web.

OR I think there may be limited support for saving query formatting like
discussed here:
https://forum.openoffice.org/en/forum/viewtopic.php?f=61&t=39997
but I don't have any experience with how this works or its limitations.

On Mon, May 9, 2016 at 12:00 AM, Gary Dale  wrote:

> Thanks Bruce. I appreciate the help. I was trying values from a table that
> translates age ranges into text. I hate hard coding numbers, let alone the
> number of ranges, because I handle events for two different groups who have
> their own definitions. They used to be encoded in the different
> certificates...
>
> My sql was
>
> SELECT "results".*, "Categories".* FROM { oj "results" LEFT OUTER JOIN
> "Categories" ON "results"."age" BETWEEN "Categories"."low" AND
> "Categories"."high" }
>
> which doesn't work but does work when I use "results"."age" =
> "Categories"."low", leading to my complaint that BETWEEN doesn't work.
>
> Your use of a CASE statement with just the one table looks like it will do
> the trick, even if the code will be ugly. I'll need 2 different CASE
> statements with a total of 8 different cases to do the translations.
>
>
>
> On 08/05/16 09:43 PM, Bruce Hohl wrote:
>
>> Gary,
>> See attached for a working case when in LO Base.  You do have to be very
>> careful when using Base Queries (SQL) that everything is exactly correct
>> like where commas are placed (or not) and how quotes / half quotes are
>> used
>> (or not).  So setting this up in Base will likely take more time than in
>> Calc.  You will have to judge if the final result in Base is best for your
>> needs.  Good Luck!
>>
>> On Sun, May 8, 2016 at 4:31 PM, Gary Dale  wrote:
>>
>> The first option is what I have been doing - it uses a calc file to drive
>>> a mailing list. The logic is in the document, not in the calc file, so
>>> that
>>> I can bring in new data without a lot of effort - the raw data can just
>>> be
>>> a .csv file.
>>>
>>> The second option, using a "smart" calc file, moves the logic to the data
>>> file which is what I don't want to do. It means importing the data or
>>> calculation into a calc file each time. The second option, moving the
>>> logic
>>> into a base file seems more promising.
>>>
>>> However, after much wailing and gnashing of teeth, I have to question
>>> whether base can do what I want. I can't get it to take a query using a
>>> BETWEEN criterion (e.g., youth is AGE between 0 AND 18).
>>>
>>> It won't (apparently) do any queries on calc sheets. Fortunately
>>> copy/pasting to create a new base table is easy enough. Unfortunately
>>> without being able to match the main table (containing participant
>>> information) against age categories, etc., it's not much good.
>>>
>>> I suppose I can use a brute force technique and create a table row for
>>> every possible age (for example) but that seems like a ludicrous kludge
>>> when the basic problem is that Writer's form letter functions can't
>>> compare
>>> numbers.
>>>
>>>
>>> On 28/04/16 09:58 PM, Bruce Hohl wrote:
>>>
>>> Two more ideas for this problem:  (1) Do not use a Calc file - see
>>>> LO_Labels_howto.odt, (2) Move the logic from Writer into either Calc or
>>>> a
>>>> Base query.  While I can't explain how this might work for your
>>>> Certificate
>>>> mail merge I can show you through the attached examples how I used these
>>>> two ideas to solve my mail merge problem.  Good Luck and I hope you can
>>>> make this work for you in LO.
>>>>
>>>> On Wed, Apr 27, 2016 at 9:17 PM, Gary Dale >>> >>> garyd...@torfree.net>> wrote:
>>>>
>>>>  I can browse to a spreadsheet directly without first attaching it
>>>>  to a database, but that's just a kludge. LibreOffice creates the
>>>>  base file when you select the spreadsheet, which brings me back to
>>>>  the same problem.
>>>>
>>>>
>>>>
>>>>  On 27/04/16 07:24 PM, Bruce Hohl wrote:
>>>>
>>>&

Re: [libreoffice-users] Number comparisons in conditional text

[Bruce Hohl]

Gary,
See attached for a working case when in LO Base.  You do have to be very
careful when using Base Queries (SQL) that everything is exactly correct
like where commas are placed (or not) and how quotes / half quotes are used
(or not).  So setting this up in Base will likely take more time than in
Calc.  You will have to judge if the final result in Base is best for your
needs.  Good Luck!

On Sun, May 8, 2016 at 4:31 PM, Gary Dale  wrote:

> The first option is what I have been doing - it uses a calc file to drive
> a mailing list. The logic is in the document, not in the calc file, so that
> I can bring in new data without a lot of effort - the raw data can just be
> a .csv file.
>
> The second option, using a "smart" calc file, moves the logic to the data
> file which is what I don't want to do. It means importing the data or
> calculation into a calc file each time. The second option, moving the logic
> into a base file seems more promising.
>
> However, after much wailing and gnashing of teeth, I have to question
> whether base can do what I want. I can't get it to take a query using a
> BETWEEN criterion (e.g., youth is AGE between 0 AND 18).
>
> It won't (apparently) do any queries on calc sheets. Fortunately
> copy/pasting to create a new base table is easy enough. Unfortunately
> without being able to match the main table (containing participant
> information) against age categories, etc., it's not much good.
>
> I suppose I can use a brute force technique and create a table row for
> every possible age (for example) but that seems like a ludicrous kludge
> when the basic problem is that Writer's form letter functions can't compare
> numbers.
>
>
> On 28/04/16 09:58 PM, Bruce Hohl wrote:
>
>> Two more ideas for this problem:  (1) Do not use a Calc file - see
>> LO_Labels_howto.odt, (2) Move the logic from Writer into either Calc or a
>> Base query.  While I can't explain how this might work for your Certificate
>> mail merge I can show you through the attached examples how I used these
>> two ideas to solve my mail merge problem.  Good Luck and I hope you can
>> make this work for you in LO.
>>
>> On Wed, Apr 27, 2016 at 9:17 PM, Gary Dale > garyd...@torfree.net>> wrote:
>>
>> I can browse to a spreadsheet directly without first attaching it
>> to a database, but that's just a kludge. LibreOffice creates the
>> base file when you select the spreadsheet, which brings me back to
>> the same problem.
>>
>>
>>
>> On 27/04/16 07:24 PM, Bruce Hohl wrote:
>>
>> Reportedly, as of LO 5.1 you can create a mail merge without a
>> Base file -
>> reference this:
>> http://vmiklos.hu/blog/mail-merge-embedding.html You might
>> try to recreate your Certificate mail merge without the Base
>> file being
>> careful to select cell formats for your data that work with
>> Writer.  (If
>> you have good spreadsheet skills you could likely get the job
>> done entirely
>> in Calc.)
>>
>> On Wed, Apr 27, 2016 at 6:18 PM, Gary Dale
>> mailto:garyd...@torfree.net>> wrote:
>>
>> I've tried it with Debian/Stretch v5.1.2.2.0+ and Windows
>> 7 v5.1.3. If I
>> was running anything old or unusual, I would have noted
>> it. The document is
>> simple, as is the spreadsheet and the base file that
>> connects them.
>>
>> I tried changing the numbers to text but Base doesn't seem
>> to allow that.
>> It's decided that the columns for age and place are
>> decimal numbers.
>>
>> So far as I can see, either the number comparisons operate
>> differently
>> from the text comparisons (which the documentation doesn't
>> mention) or the
>> number comparisons are broken. Normally I'd consider that
>> unlikely, but my
>> past experience with printing "form letters" and labels is
>> that these areas
>> don't get a lot of attention.
>>
>>
>> On 27/04/16 03:32 PM, Bruce Hohl wrote:
>>
>> Can you give more details of your set-up.  What is in
>> the Writer, Calc
>> and / or Base components of LO.
>>
>> On Wed, Apr 27, 2016 at 11:44 AM, Gary Dale
>>  

Re: [libreoffice-users] Calc HH:MM:SS to decimal

[Bruce Hohl]

Great.  And, now we know from the collective knowledge of this mailing list
how dates are stored and that there are many good ways to solve this type
of problem besides what I suggested.  This list is like an ad hoc LO
training course.

On Sat, May 7, 2016 at 9:07 AM, John Meyer  wrote:

> This actually worked incredibly well for my problem.
>
>
>
> On 5/5/2016 10:52 AM, Bruce Hohl wrote:
>
>> Try this in cell A2 "=VALUE(A1)*24"
>>
>> On Thu, May 5, 2016 at 12:44 PM, Russell  wrote:
>>
>> does anyone know if there is a formula for a cell that will transform the
>>> HH:mm:ss from another cell into a decimal equivalent?
>>>
>>> example:
>>>
>>> Cell A1 has 10:45:20
>>>
>>> Cell A2 would change to 10.75
>>>
>>> or
>>>
>>> Cell A1 07:26:15
>>>
>>> Cell A2 would change to 7.44 (or round it up 7.5)
>>>
>>> Thanks
>>>
>>> Russell
>>>
>>>
>>>
>>> --
>>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>>> Problems?
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and cannot be
>>> deleted
>>>
>>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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 HH:MM:SS to decimal

[Bruce Hohl]

Try this in cell A2 "=VALUE(A1)*24"

On Thu, May 5, 2016 at 12:44 PM, Russell  wrote:

> does anyone know if there is a formula for a cell that will transform the
> HH:mm:ss from another cell into a decimal equivalent?
>
> example:
>
> Cell A1 has 10:45:20
>
> Cell A2 would change to 10.75
>
> or
>
> Cell A1 07:26:15
>
> Cell A2 would change to 7.44 (or round it up 7.5)
>
> Thanks
>
> Russell
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Bruce Hohl]

Perhaps LO Find & Replace using Regular expressions would work.
Not an LO solution but SED can be useful for such tasks.
Can you post a sample of the file contents?

On Tue, May 3, 2016 at 4:16 PM, Robert Funnell 
wrote:

> Walther -
>
> Could you open your content.xml with Emacs and record a macro to find and
> remove the hidden text? (I'm not sure that qualifies as simple.)
>
> - Robert
>
> On Tue, 3 May 2016, Walther Koehler wrote:
>
> Hallo,
>> Am Dienstag, 3. Mai 2016 schrieb Bruce Hohl:
>>
>>> > Do you have some advice how to remove the hidden (hard-)formatted text
>>> in
>>>
>>> a
>>>
>>> > simple way?
>>>
>>> File > Save :: Save as type = Text (.txt) OR Text - Choose Encoding
>>> (.txt)
>>> Thus, LO can be used to read, create and edit unformatted text files.
>>>
>>
>> Yes, you are right, but it does not solve my problem. The text file will
>> contain the hidden formated text.
>>
>> To make it very clear:
>> I do not care about the format information in the file.
>> I do not want the content (the hidden formated characters) in the file
>> before shipping.
>>
>> Using linux, the command line program xpath might do the job. It is
>> capable of removing certain xml tags in a file like
>>
>> blabla
>>
>> Regards
>>
>> Walther
>>
>> ...
>>
>> > > From: Walther Koehler 
>>> > > Date: Fri, Apr 29, 2016 at 5:54 AM
>>> > > Subject: [libreoffice-users] delete hidden formated text in odt
>>> > > To: users@global.libreoffice.org
>>> > >
>>> > >
>>> > > Dear LO users,
>>> > >
>>> > > I would like to give away *.odt files without hidden formated text.
>>> > > Do you have some advice how to remove the hidden (hard-)formatted
>>> text
>>> >
>>> > in a
>>> >
>>> > > simple way?
>>> > > Is it possible by a macro?
>>> > >
>>> > > (I am aware that you can make hidden text invisible and print the
>>> file
>>> > > without
>>> > > hidden text on paper. I also know how to remove properties)
>>> > >
>>> > > Thank you in advance
>>> > >
>>> > > Walther
>>>
>>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Bruce Hohl]

> Do you have some advice how to remove the hidden (hard-)formatted text in
a
> simple way?
File > Save :: Save as type = Text (.txt) OR Text - Choose Encoding (.txt)
Thus, LO can be used to read, create and edit unformatted text files.

On Tue, May 3, 2016 at 12:37 PM, anne-ology  wrote:

>Thanks for this information;
>   some on this list might enjoying knowing about it.
>
>Since I think you sent this to me by mistake, am sending on to the
> list;
>   I am not interested in changing.
>
>
>
> From: Tim Deaton 
> Date: Mon, May 2, 2016 at 9:44 PM
> Subject: Re: free text editor (was: [libreoffice-users] delete hidden
> formated text in odt)
> To: anne-ology 
>
>
> I've been using NoteTab (from Fookes Software, in Switzerland) for several
> years now as my text editor.  After using the free version (NoteTab Light)
> for a few years, I upgraded to the paid version.  I still don't use any
> features that aren't in the free version, but I figured the authors
> deserved something for their excellent work.
>
> You can find the free version here:
> http://www.notetab.com/notetab-light
>
> I think you'll really enjoy it.
>
> -- Tim Deaton
>
>
>
> On 4/29/2016 2:39 PM, anne-ology wrote:
>
> If you're referring to eliminating the formatting, then I think
> > you'll have a non-formatted document;
> >if so, then using a simple text document should do this.
> >
> > The only one I know that still exists is Notepad - once placed on
> > all MsFt machines, but now not;
> >I still have it - saved from my older machine - & would be
> glad
> > to upload to you if you so wish.
> >
> >
> >
> > From: Walther Koehler 
> > Date: Fri, Apr 29, 2016 at 5:54 AM
> > Subject: [libreoffice-users] delete hidden formated text in odt
> > To: users@global.libreoffice.org
> >
> >
> > Dear LO users,
> >
> > I would like to give away *.odt files without hidden formated text.
> > Do you have some advice how to remove the hidden (hard-)formatted text
> in a
> > simple way?
> > Is it possible by a macro?
> >
> > (I am aware that you can make hidden text invisible and print the file
> > without
> > hidden text on paper. I also know how to remove properties)
> >
> > Thank you in advance
> >
> > Walther
> >
> >
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: a question about libreoffice and my recent documents:

[Bruce Hohl]

Or use the Expert config option described here:
http://superuser.com/questions/726467/libreoffice-4-2-1-1-do-not-display-list-of-recent-documents


On Sun, May 1, 2016 at 1:06 AM, Pedro  wrote:

> https://ask.libreoffice.org/en/question/2298/suppress-recent-document-list/
>
> The download page is
> http://berma.pagesperso-orange.fr/HM/index2.html
>
> Please remember to search
>
> https://ask.libreoffice.org/en/questions/
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/a-question-about-libreoffice-and-my-recent-documents-tp4182459p4182461.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Number comparisons in conditional text

[Bruce Hohl]

Reportedly, as of LO 5.1 you can create a mail merge without a Base file -
reference this: http://vmiklos.hu/blog/mail-merge-embedding.html  You might
try to recreate your Certificate mail merge without the Base file being
careful to select cell formats for your data that work with Writer.  (If
you have good spreadsheet skills you could likely get the job done entirely
in Calc.)

On Wed, Apr 27, 2016 at 6:18 PM, Gary Dale  wrote:

> I've tried it with Debian/Stretch v5.1.2.2.0+ and Windows 7 v5.1.3. If I
> was running anything old or unusual, I would have noted it. The document is
> simple, as is the spreadsheet and the base file that connects them.
>
> I tried changing the numbers to text but Base doesn't seem to allow that.
> It's decided that the columns for age and place are decimal numbers.
>
> So far as I can see, either the number comparisons operate differently
> from the text comparisons (which the documentation doesn't mention) or the
> number comparisons are broken. Normally I'd consider that unlikely, but my
> past experience with printing "form letters" and labels is that these areas
> don't get a lot of attention.
>
>
> On 27/04/16 03:32 PM, Bruce Hohl wrote:
>
>> Can you give more details of your set-up.  What is in the Writer, Calc
>> and / or Base components of LO.
>>
>> On Wed, Apr 27, 2016 at 11:44 AM, Gary Dale > <mailto:garyd...@torfree.net>> wrote:
>>
>> I'm trying to print certificates for a group of athletes and need
>> to have them reflect their standing in the event. The certificate
>> has a number of conditional text fields, such as to translate
>> their gender from M/F to male/female, which are working.
>>
>> However the ones that are doing numeric comparisons aren't. The
>> comparison always seems to return "true" so the "then" condition
>> is printed. For example Run Results.Race.place == 1 is the
>> condition but the translation text is always "first place", never
>> empty. Since I have 5 different conditions (first 3 positions,
>> participate, supported), I get a lot of text printed that shouldn't.
>>
>> The slightly more complex Run Results.Race.age > 18 AND Run
>> Results.Race.age < 60 always prints adult. At one point I had it
>> print an else (senior) but that branch was never taken even when
>> the age was well past 60.
>>
>> I've checked the Run Results.odb file (which links to a
>> spreadsheet) and the age & place fields are both of type decimal.
>>
>> What am I doing wrong?
>>
>> -- To unsubscribe e-mail to:
>> users+unsubscr...@global.libreoffice.org
>> <mailto:users%2bunsubscr...@global.libreoffice.org>
>> Problems?
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more:
>> http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and
>> cannot be deleted
>>
>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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] Ubuntu 16.04 and LibreOffice

[Bruce Hohl]

At some point during the life of 16.04 you may want to move to a newer
version of LO.
See this link for information on how to accomplish that.
https://launchpad.net/~libreoffice/+archive/ubuntu/ppa

On Tue, Apr 26, 2016 at 7:34 PM, Tim Lloyd  wrote:

> Running Fedora with Gnome classic so no real correlation but...stoopid
> question...do you have LO & firefox running in the same workspace? EG. I
> have FF running in workspace 1 and LO in workspace 4. So when I need to
> switch between the 2 apps I change workspaces. Just wondering if the
> problem occurs if you have to switch workspaces?
>
> Cheers
>
>
>
> On 27/04/16 09:26, Tim---Kracked_P_P---webmaster wrote:
>
>>
>> I am currently running 64-bit Ubuntu 16.04LTS [with MATE desktop] on 2
>> laptops.  I am currently have issues with my install of LO 5.1.2.2 version
>> with areas in the "menu taskbars" graying out when I switch to its window
>> from a window like Firefox or other package that I am running.
>>
>> I did not have this running Ubuntu 15.10.
>>
>> I also wonder which version of LibreOffice Ubuntu 16.04 includes. I have
>> found that, in the past, no matter which LO version I have installed the
>> upgrading of Ubuntu removes my install and installs the one they have in
>> their repository. This did not happen this time, since my spare laptop had
>> LO 5.0.x and still has it.  The laptop I am typing from now has 5.1.2.2,
>> which I installed before I upgraded to Ubuntu 16.04.
>>
>> So which version is included with the newest version of Ubuntu?
>>
>> Since 16.04LTS will be supported through 2021, according to a e-news
>> report, will there be any "push" by LO/TDF to keep Ubuntu's repository
>> updated to the current LO versions from now till 2021 when this long term
>> supported Ubuntu OS will no longer be supported by Ubuntu's creators.
>>
>>
>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] function sumif question

[Bruce Hohl]

See attached example for a few ways to solve this problem.

On Thu, Apr 21, 2016 at 5:47 PM, John R. Sowden 
wrote:

> I have an accounting ledger in calc, with two columns in question.
>
> col 1 is credit (amount charged to account) and  col 2 is the account
> number (a 4 digit number currently formatted a  number with no decimal, but
> not text).
>
> My objective is to sum the amounts in column 1 if col 2=1234.  Not a
> problem.  Done.
>
> Now I want to sum the amounts in column 1 if the number in col 2 is 1234
> or 2345 or 6789)
> I tried just putting the numbers in the sumif field, I tried putting them
> in parentheses,  and finally I tried the OR() function by making the
> criteria field in sumif OR(1234,2345,6789).
>
> No dice.  Two questions:
> 1) what is the solution to my problem?
> 20 Where can I go for more reference material than the help screen to
> solve these little problems?
>
> thanks,
> John
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Importing CSV file into Calc with records determined by the number of field separators instead of Line Feeds

[Bruce Hohl]

Another useful tool for this type of clean-up is SED.  It can take some
trial & error and web searching if you're not familiar with sed or awk 
but it's good knowledge to have.

On Mon, Apr 11, 2016 at 2:02 PM, Paul D. Mirowsky 
wrote:

> This is more specific.
>
> I assume you have text delimited by double quotes.
>
>
> http://stackoverflow.com/questions/26406281/replace-new-line-character-between-double-quotes-with-space
>
>
> On 4/11/2016 11:35 AM, Paul D. Mirowsky wrote:
>
>> Are you using linux?
>>
>> On 4/11/2016 6:30 AM, Andreas Säger wrote:
>>
>>> Am 11.04.2016 um 06:26 schrieb Philip Rhoades:
>>>
 People,

 I need to import a CSV dump from an Android SMS Sqlite DB - the problem
 is, many of the SMSs have line breaks in the text body of the DB record
 and this messes up the import into Calc.  There does not seem to be any
 way of saying to Calc: "Count x fields for each record" instead of
 recognising a record by a LF . .

 Can anyone think of a nice, easy fix for this problem?

 Thanks,

 Phil.

>>> You should be able to connect a Base document to the SQLite DB. Then
>>> your spreadsheet can access the database directly.
>>>
>>> CSV is not a file format. It is mere convention. If you have multi-line
>>> filds, you've got to export with text delimiters (in most cases quotes).
>>> Everything between a pair of text delimiters can be treated as one text
>>> value.
>>>
>>>
>>>
>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Re: Calc method to change whole column cell content

[Bruce Hohl]

Method 1 - Using Value()
Use value() function to convert a text string into a number or date.
Copy the result; paste special as number or date.
---
Method 2 - Search & Replace
Select (highlight) a cell range then:
Using Search & Replace (Ctrl+H):
Search for = .*
Replace = &
Under Other Options:
Y = Current selection only
Y = Regular expressions
Click Replace All

For the csv file Open Calc then open the CSV file from Calc. You can set
you file associations on Windows, Linux, etc. so CSV files are always
opened by Calc.

On Thu, Apr 7, 2016 at 8:48 PM, Andreas Säger  wrote:

> Am 08.04.2016 um 01:35 schrieb MR ZenWiz:
> > I recently began to use the spreadsheet downloads from one of my
> > credit unions as it is so far superior to the home-grown method I have
> > been using it's not even funny.
> >
> > (I know, way late... Cries of "luddite" in the background, etc.)
> >
> > However, in the .csv file they send, the dollar transactions are all
> > given as text entries with ($xxx.xx) for negative entries and $xxx.xx
> > for positive entries.  I don't see a way inside calc either to simply
> > convert that to a currency amount or to strip out the leading
> > apostrophe/quote mark that inhibits proper evaluation of the field.
>
> Language = English(USA)
> [X] Detect Special Numbers
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] update

[Bruce Hohl]

For Linux Mint your LO install may receive patches (but not version
updates) when you run updates to Linux Mint.  Linux Mint can be updated via
an icon in the task bar or the 'Update Manager'.  If you are happy with
that version of LO and LM 17.2 then simply keep LM 17.2 updated.

If you move to LM 17.3 the included version of LO is 5.0.3.2.  Linux Mint
uses the Ubuntu packages for LO which I've found to include most important
bug fixes and various favorable tweaks to the default settings.

With extra effort you can install and use a newer version from
LibreOffice.org.  I do this when I want to use or check out new features:

To Add & Remove LO DEB packages on Linux:
To remove:
1 - user1:/opt$ sudo aptitude remove libreofficeX.X
libreofficeX.X-debian-menus libreofficeX.X-ure
2 - verify complete removal via: user1:/opt$ sudo aptitude search
libreoffice | grep ^i

To add:
1 - Get files from LibreOffice.org
LibreOffice_version_Linux_x86-64_deb.tar.gz
LibreOffice_version_Linux_x86-64_deb_helppack_en-US.tar.gz

2 - Extract each under /opt:
user1@PC:/opt$ sudo tar -zxvf [file1 | file2]

3 - Install program:
user1@PC:/opt/LibreOffice_version_Linux_x86-64_deb/DEBS$  sudo dpkg -i
*.deb
user1@PC:/opt/LibreOffice_version_Linux_x86-64_deb_helppack_en-US/DEBS$
 sudo dpkg -i *.deb

4 - Optionally, delete downloaded and extracted files (but do not delete
the program directory /opt/libreofficeX.X)

A command line approach is not necessary but I use it because it is easy to
show the steps.


On Sat, Apr 2, 2016 at 6:40 AM, M Henri Day  wrote:

> 2016-04-02 12:28 GMT+02:00 Thomas Blasejewicz :
>
> > Good evening
> > Questions about updating LibreOffice.
> > In the past I read somewhere that there is an option of "automatic"
> > (online) updating for Linux, but not for Windows.
> > In case of Windows I am "used" to download everything from scratch.
> >
> > However, trying to set up a Linux machine (Mint 17.2) for work, I
> noticed,
> > that the description of the
> > help documentation does NOT correspond to the actual situation:
> > https://help.libreoffice.org/Common/Online_Update
> > Choose Tools - Options - LibreOffice - Online Update
> >
> > On my LO 4.4 installation on the said Mint 17.2 machine there ***IS NO***
> > item called "online update".
> >
> > Is there a trick to do that?
> >
> > I also just downloaded the latest version 5.1, but that will not install
> > either.
> > I am supposed to:
> > Right-click within the directory and choose "Open in Terminal" ...
> > type:
> > sudo dpkg -i *.deb
> > but get the error:
> > "dpkg: error processing archive *.deb (--install):
> > cannot access archive: No such file or directory"
> >
> > Any trick to solve this problem?
> > Thank you.
> > Thomas
> >
>
> ​You might want to try installing a LibreOffice PPA (
> https://launchpad.net/~libreoffice/+archive/ubuntu/ppa), Thomas, works
> fine
> for me
>
> Henri
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Fwd: [libreoffice-users] In 5.1.0.3, where is the "Add Ons" menu?

[Bruce Hohl]

And, use Tools > Extension Manager shows the Add-on's install.

-- Forwarded message --
From: Bruce Hohl 
Date: Sun, Mar 27, 2016 at 8:31 PM
Subject: Re: [libreoffice-users] In 5.1.0.3, where is the "Add Ons" menu?
To: Joshua Kramer 


Add-on's is under the Tools menu but it may not appear unless you have an
add-on installed which allows user settings.  For example my LO 5.1.1.3
install has 5 bundled add-on's plus "History Master" which I added
separately, and only 'History Master' appears under Tools > Add-on's.

On Sun, Mar 27, 2016 at 8:06 PM, Joshua Kramer 
wrote:

> In 5.1.0.3 on Linux, where is the "Add Ons" menu that is supposed to
> be under Tools?
>
> Thanks!
> -JK
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

[libreoffice-users] OwnCloud link on LO site

[Bruce Hohl]

From the home page menu on the LO site:  Community > OwnCloud opens
https://owncloud.documentfoundation.org/ which requires a user & password.

Is this a LO OwnCloud demo?
If so, does anyone know how I can get credentials to check it out?

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