[libreoffice-users] Question on MAXIF()

2014-04-25 Thread Rob Jasper
I have a (generated) sheet with 5000 entries where in column H is a book number between 1 and 7, and in column D there are years between 1852 and 2014. Both the booknumbers and the years are not sorted, and are expanded over time. I want to have the min and max year of each individual book. In

Re: [libreoffice-users] Question on MAXIF()

2014-04-26 Thread Rob Jasper
Great, thank you for your elaborate answer It works as expected. Rob. Op 26 apr. 2014, om 07:46 heeft Brian Barker het volgende geschreven: > At 01:50 26/04/2014 +0200, Rob Jasper wrote: >> I have a (generated) sheet with 5000 entries where in column H is a book >> number

[libreoffice-users] Formatting in LO spreadsheet

2014-06-28 Thread Rob Jasper
Hi all, maybe I am just not doing things right, but I have a weird problem. I have a calc spreadsheet (.ods) and I have 2 (F&G in the following example) columns which represent a Dutch Florin/Euro value. Therefore I want the value to show at least 1 digit, and 2 digits behind the decimal point

Re: [libreoffice-users] Formatting in LO spreadsheet

2014-06-30 Thread Rob Jasper
2014, om 10:39 heeft Brian Barker het volgende geschreven: > At 19:42 28/06/2014 +0200, Rob Jasper wrote: >> I have a calc spreadsheet (.ods) ... >> So I select the columns and change the formatting to #.##0,00# >> This works as expected. Above values are still displayed as before

Re: [libreoffice-users] Formatting in LO spreadsheet

2014-07-02 Thread Rob Jasper
23:16 30/06/2014 +0200, Rob Jasper wrote: >> Indeed when I look at the formatting after saving and reopening the file, >> the formatting changed from #0,00# to #0,000 . >> >> All predefined number formats are saved, and restored upon reopening. If I >> define a us

Re: [libreoffice-users] Question about viewing cell formulas in Writer

2014-07-12 Thread Rob Jasper
If you select a cel you should see the formula in the topin the line containing the selected cell, just after fx ∑ = If you want to see ten all, go to preferences > LibreOffica Calc > View and tick Formulas Success, Rob. Op 12 jul. 2014, om 20:59 heeft Tom Williams het volgende geschreven: >

[libreoffice-users] Problem with standard filter

2014-07-15 Thread Rob Jasper
Hi, I hope someone can help me with this... I have a spreadsheet with around 4000 rows in it. It has an autofilter in de co;umn headings. In column B I have some 10 fields containing aaa, and 3 fields bbb. Now I filter on bbb I clear the 3 fields If I mark all (it is not marked upon opening) in

Re: [libreoffice-users] Problem with standard filter

2014-07-23 Thread Rob Jasper
ened [Bug 81577] for this. Op 23 jul. 2014, om 23:38 heeft Mark Bourne het volgende geschreven: > Urmas wrote: >> "Rob Jasper": >> >>> If I unselect ALL, aaa gets unselected too (reasonable, since that the >>> gebaviour for more the one slection val

Re: [libreoffice-users] Problem with standard filter

2014-07-25 Thread Rob Jasper
two seemingly identical entries - one to filter for > blank cells and one for cells containing the string "(blanks)" - or is the > one for blank cells unambiguously different in some way? > > Mark. > > > Rob Jasper wrote: >> The same inconsistency also makes th

Re: [libreoffice-users] Problem with standard filter

2014-07-25 Thread Rob Jasper
Mark, forgot to mention that, although the reported problems are different, bugs 81577 and 46062 are very related. They might be solved by one solution.. Rob. Op 26 jul. 2014, om 00:14 heeft Rob Jasper het volgende geschreven: > Mark, > > I tested that briefly in Excel. Excel doen&

Re: [libreoffice-users] Chart data

2014-07-26 Thread Rob Jasper
In MS Excel one can select a full column by just leaving off the rownumber, example: MAX(B:B). If I open the .xls file with LibreOffice this formula gets translated in MAX(B$1:B$983040) Tried to enter the original formal but that responds #NAME?. Apparently LibreOffice does not have the functio

Re: [libreoffice-users] scale a Writer document to print on one page

2014-07-26 Thread Rob Jasper
The ISO-269 standard specifies the following: Format A B C Sizemm × mm in × in mm × mm in × in mm × mm in × in 0 841 × 1189 33.1 × 46.8 1000 × 1414 39.4 × 55.7 917 × 12

Re: [libreoffice-users] IF statement question

2014-07-31 Thread Rob Jasper
Hi Gordon, You didn't specify what the value of col. C shou;d be if both A and B are blank. Using =IF(ISBLANK(A2);"Y";IF(A2=B2;"";"X")) will put "Y" in there for above case. Success, Rob. Op 31 jul. 2014, om 12:03 heeft Gordon Burgess-Parker het volgende geschreven: > Sorry that's all mu

Re: [libreoffice-users] IF statement question

2014-07-31 Thread Rob Jasper
Gordon, Working the other way around blanks C in case both A & B are blank. =IF(A2=B2;"";IF(ISBLANK(A2);"Y";"X")) Rob. Op 31 jul. 2014, om 12:42 heeft Rob Jasper het volgende geschreven: > > Hi Gordon, > > You didn't specify what the val

Re: [libreoffice-users] Base questions

2014-07-31 Thread Rob Jasper
If the normal Base file is not reliable, why do we have it in the first place? Either we (the community) must make it reliable, or we should abandon it and come with a reliable alternative. Not reliable is in fact not very acceptable. The documentation should describe when to use, and when not t

Re: [libreoffice-users] Base questions

2014-08-05 Thread Rob Jasper
Op 4 aug. 2014, om 20:23 heeft Jean-Francois Nifenecker het volgende geschreven: > Le 04/08/2014 18:59, dave boland a écrit : >> >> I'm getting a little confused. My understanding is that there are >> really two issues here. One is that LO Base is RAM resident - all >> updates are held in RAM

Re: [libreoffice-users] Base questions

2014-08-06 Thread Rob Jasper
The weird thing is that Java is havely used in the Oracle databases. How com they can have quite reliable databases... Op 5 aug. 2014, om 15:35 heeft Tom Davies het volgende geschreven: > Hi :) > +1 > > I think Base nearly does do the best way around. The only problem is that > the easiest thi

Re: [libreoffice-users] Re: [tdf-announce] LibreOffice Conference 2014: the program of a landmark event

2014-08-14 Thread Rob Jasper
Agree, same here Rob. Op 14 aug. 2014, om 12:32 heeft Paul het volgende geschreven: > Just a lone voice, but as Tom pointed out, I am only on this list, and > not on either the discuss or announce lists. > > Now, I don't really have much interest in the Conference, so Tom > posting that here do

Re: [libreoffice-users] Re: [tdf-announce] ...

2014-08-15 Thread Rob Jasper
you > don't, don't. If you want to borrow books, join the library; don't expect > others to borrow them for you. > > At 12:37 14/08/2014 +0200, Rob Jasper wrote: >> Agree, same here > > I'm sure the other lists would welcome you too. If you like conce

Re: [libreoffice-users] Printing Checks

2014-08-23 Thread Rob Jasper
Well, this is argument covering English versus new world English (which I prefer to call American). The spelling checkers do make a difference between English, US English, Australian English, South African English, etc. for good reasons. No reasons to argue about that. Those languages are differ

[libreoffice-users] Link in calc

2014-08-24 Thread Rob Jasper
Hi, I have a list of names, for which I want to reference AND link to other names. Think about: — A B C 1 NameParent1 Parent2 2 John 3 Eve 4 Chris JohnEve --- Where the parent is both to link the value and a hyperlink to the respective cell

Re: [libreoffice-users] Link in calc

2014-08-27 Thread Rob Jasper
r idea for this but even that > would be quite messy. > > Apols and regards from > Tom :) > > > > > On 24 August 2014 19:51, Rob Jasper wrote: > >> Hi, >> >> I have a list of names, for which I want to reference AND link to other >> names.

Re: [libreoffice-users] mongodb and base

2014-11-22 Thread Rob Jasper
Nice list of things to work on :-)) Wile in the metric system, you might add paper sizes (A4, A3, etc.) and the perforation of paper.. I used to work for Bell Labs, and they had as standard (!) perforation the US 3 + the US 4 holes, and we just added Europe's 4 holes, so in total there were 11

Re: [libreoffice-users] Comments on pdf file size in 4.4 alpha; and a new bug?

2014-11-23 Thread Rob Jasper
Tom, I think this is really well explained. I've been professionally involved in defect reporting for years, and the problems seem to be the same in all organisations. Problems in defect reporting: 1- Qualification of type (A bug is unexpected behaviour which does not comply to the requirement

Re: [libreoffice-users] PDF export checking whether the file is locked (opened) by another program before starting exporting over it

2014-12-01 Thread Rob Jasper
Op 1 dec. 2014, om 06:35 heeft Brian Barker het volgende geschreven: > At 19:56 30/11/2014 +0100, Jaroslaw Staniek wrote: >> On Sunday, 30 November 2014, Brian Barker wrote: >>> At 13:55 30/11/2014 +0100, Jaroslaw Staniek wrote: Google for "acrobat reader file locking" and you'd notice that

Re: [libreoffice-users] Time-lag response in v. 4.4.0.1 Writer

2015-01-08 Thread Rob Jasper
Now you mention it.. I've had this both on my slow PC and on my Mac. However, I now realize that since I changed my disk for a SSD I never had it again (even while working on a very old Mac: 24 ", end 2006, 2,16 GHz Intel Core 2 Duo) Rob Op 8 jan. 2015, om 16:09 heeft Oogie McGuire het volgende

Re: [libreoffice-users] Security check and 2 questions

2015-01-09 Thread Rob Jasper
I use LO on a Mac for several years now. The main reason being that the only crashes I ever had were all related to MS Word... So yes, I still have Word on my Mac, but I never use it. As for the original question- I didn't see anything else installed besides LO. Op 8 jan. 2015, om 18:01 heeft

Re: [libreoffice-users] File-Send-Document As doesn't!

2015-01-12 Thread Rob Jasper
I'm running LO 4.3.5.2 on my Mac, and all send options open up my email client with an new message with the appropriate file included. So, for me the functionality works. Rob. Op 11 jan. 2015, om 21:49 heeft Gordon Burgess-Parker het volgende geschreven: > LO 4.3.5.2 on Ubuntu 14.04 with Thunde

Re: [libreoffice-users] Support options

2015-01-15 Thread Rob Jasper
Please keep the 'old' stuff also. I am worried about privacy and therefore I do not have a facebook account (and in fact I almost don't have any accounts on more or less public things like that). So, fully changing to whatever new things is in my opinion not a good idea. Any system which requir

Re: [libreoffice-users] Merging columns, not cells

2015-01-28 Thread Rob Jasper
Mark, With merging I assume you mean concatenating the strings into one column... I generally put a concatenate formula in a separate column, then select cut that complete column and special past values to the desired column. Rob. Op 28 jan. 2015, om 15:44 heeft Mark Howe het volgende geschre

Re: [libreoffice-users] [tdf-announce] Alternative download for LibreOffice 4.4

2015-01-31 Thread Rob Jasper
Tom, thank you, but the needed file is just not there The file I need is de x86 version that should be on the location: http://download.documentfoundation.org/libreoffice/stable/4.4.0/mac/x86/ That directory is completely empty, though. Rob. Op 30 jan. 2015, om 18:13 heeft Tom Davies het vo

Re: [libreoffice-users] Languages Settings

2015-02-28 Thread Rob Jasper
Go to menu LibreOffice -> Preferences -> Language Settings -> Languages Success Op 28 feb. 2015, om 12:57 heeft Jasmine Bader het volgende geschreven: > Hello > > I need help in changing the languages from the unser interface. How can i > change it to German? I can choose only between English U

Re: [libreoffice-users] Calc, selecting from a list ? vlookup maybe ?

2015-03-24 Thread Rob Jasper
Hi Graham, I experimented a little and found the following solution for you: In added 2 columns before the one with the heading C/M. In col G I put the following formula: =IFNA(VLOOKUP($G$13,INDIRECT("B"&(14+E13)&":C$40"), 2, 0),"") In col E I put: =MATCH(G14,INDIRECT("$C"&14+E13):$C$39,0)+E13

[libreoffice-users] LOOKUP with 2 values in 2 columns

2015-06-08 Thread Rob Jasper
Hi, I have a list of music numbers for our choir in calc. Each number is identified by a number in col A, and sometimes a sub-number or letter in col B. Someting like: 296 title1 ComposerArr.textpublisher 297 a title2 C2 297 b title3 C3

Re: [libreoffice-users] LOOKUP with 2 values in 2 columns

2015-06-08 Thread Rob Jasper
Agh, I should have thought of this myself. Simple and elegant... Thanks Brian, Rob. On 8 jun. 2015, at 14:58, Brian Barker wrote: > At 13:56 08/06/2015 +0200, Rob Jasper wrote: >> I have a list of music numbers for our choir in calc. Each number is >> identified by a numbe

Re: [libreoffice-users] LOOKUP with 2 values in 2 columns

2015-06-08 Thread Rob Jasper
Agree with that! I have no experience with base in combination with the built-in or other dbms's. I do have quite some xperience with various dbms's and SQL though. So, one of these days I'll try it.. Thanks, Rob. On 8 jun. 2015, at 14:58, Brian Barker wrote: > At 13:56 08/

[libreoffice-users] Conditional formatting question

2015-07-03 Thread Rob Jasper
Hi, I am looking on a way to set the background color of a full row if one specific field in the row has a value. So, if the value is in col C, this would be the result: A B C D E 1 x y 8 p 2 x2 y2 6 c

Re: [libreoffice-users] Conditional formatting question

2015-07-03 Thread Rob Jasper
it has de correct background but the numberformat displayed is now n.nn If Fx has the value n.nn the background is gone Am I missing something here? Is this expected behavior? Thanks, Rob. On 3 jul. 2015, at 19:17, Brian Barker wrote: > At 16:23 03/07/2015 +0200, Rob Jasper wrote: >> I am l

Re: [libreoffice-users] Conditional formatting question

2015-07-04 Thread Rob Jasper
, Rob Jasper wrote: > Andreas & Brian, > > thanks, that works great! > > Now I have another followup question: > > I already had a formatting for 2 colums where I set the number of digits > behind the decimal based on the formula MOD(F2,0.01)=0. > This to make a Euro/

Re: [libreoffice-users] VAR, STDEV, CHISQ.INV

2015-07-09 Thread Rob Jasper
Joel, just read the MS-Excel explanation you are referring to. Great explanation. Thanks for pointing to this. Rob. On 8 jul. 2015, at 20:42, Joel Madero wrote: > Sounds to me like normal floating number behavior. I know someone is trying > to document this and explain why it happens (it's a te

Re: [libreoffice-users] Open LO files via IE Explorer

2015-07-14 Thread Rob Jasper
Is this the same problem as described in the following thread? http://listarchives.libreoffice.org/global/users/msg45235.html Rob. On 14 jul. 2015, at 13:20, Thomas Blasejewicz wrote: > I have another question. > I noticed, since I am using Windows 8.1 (2-3 months ago), currently LO > Version:

Re: [libreoffice-users] Linux alternative

2015-07-19 Thread Rob Jasper
Tim, agree with you there- Cobol was considered e great modern productivity improvement. I started in assembly. Getting a system running by inserting the bootstrapper papertape on the first punched holes, ste the start address through phisical switches and press the start butten. Only after the

[libreoffice-users] Calc- how to edit a link to a file

2015-08-18 Thread Rob Jasper
Env: Mac OS X Lion 10.7.5 LibreOfiice:4.3.6.1 Hi, I inserted a link to another pdf file. That works, if I click the link the other file is opened. Question1: Here's the weird thing. I don't seem able to edit the text value, nor the path. If I right click there's not something as edit (the link

Re: [libreoffice-users] Calc- how to edit a link to a file

2015-08-18 Thread Rob Jasper
e right. Next time no assumptions, just test first! Thank you for your clear answer, Rob. On 18 aug. 2015, at 21:58, Brian Barker wrote: > At 20:57 18/08/2015 +0200, Rob Jasper wrote: >> I inserted a link to another pdf file. That works, if I click the link the >> other file is

Re: [libreoffice-users] Re: LibreOffice 5.0 Review & Rating | PCMag.com

2015-08-21 Thread Rob Jasper
Nice article indeed. I personally like the structured way of the menus. I am a long time user of OpenOffice, and later LibreOffice. When MS started with the ribbon, I just didn't use MS office anymore, and on my newer systems (Mac's and PCs) I only install LO. Recently I experienced that I ca

Re: [libreoffice-users] user's profile on an iMac

2015-09-08 Thread Rob Jasper
Guy, library is standard invisible in Finder. How to see the contents: open finder On the menu bar- Go -> Go to folder Enter in the pop-up window: ~/library/application support/libreoffice/4 (tilde means current user home directory) The directory "4" will open... If you want to show hidden fol

Re: [libreoffice-users] Find & Replace in Calc

2015-10-05 Thread Rob Jasper
Try: Select whole column Edit -> find&replace enter in "search for" : [0-9]+,[0-9]+, Leave "replace with" blank Click "other options" mark "regular expressions" click "replace all" The reg expression above expects at least 1 digit before the first comma and between the commas. If this is not t

[libreoffice-users] How to know if a value passes a filter in a formula?

2015-10-09 Thread Rob Jasper
Hi, I have a list of music pieces with dates they are, or will be handed out. The format looks like: 26-10-1511A Stille Nacht 26-10-1512A Bethlehem 26-10-1528 Ere zij God 24-08-15242 Jacob's Ladder 26-10-15265 See amid the winter's snow

Re: [libreoffice-users] How to know if a value passes a filter in a formula?

2015-10-13 Thread Rob Jasper
n > SUBTOTAL(4;) > instead of MAX. See help on SUBTOTAL. > > Kind regards > Regina > > Rob Jasper schrieb: >> Hi, >> >> I have a list of music pieces with dates they are, or will be handed out. >> The format looks like: >> >> 26-10-15 11

Re: [libreoffice-users] Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-14 Thread Rob Jasper
reading with my standard iMac email client set to "organize by Conversation", and this bundels all mails of one thread into one entry, so, after the discussion tread calmes down (does not pop to the top of my unread email list anymore) I just delete the whole thing in one go. I'm sure other ma

Re: [libreoffice-users] Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-15 Thread Rob Jasper
any way, it starts a > new thread. > > > > From: Tom Davies > Date: Wed, Oct 14, 2015 at 2:52 PM > Subject: Re: [libreoffice-users] Tooo many messages on this mailing list?? > How to avoid being swamped ... > To: Rob Jasper > Cc: "users@global.libreoffice.org

Re: [libreoffice-users] Threading

2015-10-16 Thread Rob Jasper
hers me re. this threading, >> is that if the subject line is changed in any way, it starts a >> new thread. >> >> >> >> From: Tom Davies >> Date: Wed, Oct 14, 2015 at 2:52 PM >> Subject: Re: [libreoffice-users] Tooo many messages on

Re: [libreoffice-users] Shortcut changes

2015-10-20 Thread Rob Jasper
+1 Agree. On 20 okt. 2015, at 04:36, tonybsa wrote: > >> On 18/10/2015, at 08:17, James E. Lang wrote: >> >> PLEASE, developers, think about the impact your change will have on existing >> users. The longer a shortcut has existed the more attention should be given >> should be given to the

Re: [libreoffice-users] Re: precision of Draw dimensions - 3 place

2015-11-20 Thread Rob Jasper
Mike, Well done! I fully agree with you- I opened a new calc document, changed the measurement unit from cm to inches. That marked my document as being changed! As far as I see there's nothing changed in the document Then I changed a column width to 1 (inch) and saved I took another documen

Re: [libreoffice-users] Re: Writer: Cannot access files I just created!??

2015-11-30 Thread Rob Jasper
Hello Hylton, You could execute the following to find any lock files on a Mac: - First make sure LibreOffice is not running (no dot in your menu bar). if there is a dot, right click and select "quit" - Open a terminal session You could run the following commands to find lockfiles: cd / find .

Re: [libreoffice-users] Java broke on LO 5.1 on Macs

2016-02-12 Thread Rob Jasper
The goal of the JRE is, as the name Java Runtime Environment says, that it should be sufficient to run Java functionality. In all discussions I miss why LO needs more then the runtime environment... We should work to bring LO in the boundary of of the JRE. Rob. On 12 feb. 2016, at 14:09, Alexand

Re: [libreoffice-users] Calc- How to count selected lines

2016-03-30 Thread Rob Jasper
24-03-14396 Geef aan de wereld vrede 7 04-04-16433SAan de Voorthuizense dreven 8 M 453 Dank zij U Heer On 30 mrt. 2016, at 16:30, Rob Jasper wrote: > Hi all, > > maybe I have a blind spot, but I don't see the solution.. > >

[libreoffice-users] Calc- How to count selected lines

2016-03-30 Thread Rob Jasper
Hi all, maybe I have a blind spot, but I don't see the solution.. I have a long list (in my case of music numbers, with titles, dates, and admin stuff. it looks like: Nr Sub ID Pgs Beg Map Aktie Titel 1 1 Volk'ren, hoort! 2 2 Heer,

Re: [libreoffice-users] Calc- How to count selected lines

2016-03-30 Thread Rob Jasper
Pedro, In the 'derived' view in the second tab (example 2) the empty fields under heading Nr do contain a formula to display the number only if something is specified in the 'map' column in the main list (example 1). COUNTA also counts cells when they only contain a formula that returns an empt

Re: [libreoffice-users] Writer Hyperlink Oddity

2016-05-15 Thread Rob Jasper
Spaces in a filename are a pain in all Unix/Linux command line actions. This is because a space is a delimiter, unless within quotes or escaped. In shell scripts quotes and escapes (\ ) are interpreted, so any sub script does not get them, unless specific actions are taken, e.g. un Unix use sin

Re: [libreoffice-users] Where is everyone?

2016-07-24 Thread Rob Jasper
Tere is a nice description on actions for the list owner on what to do to circumvent this in http://www.spamresource.com/2014/04/run-email-discussion-list-heres-how-to.html On 23 jul. 2016, at 20:50, Girvin Herr wrote: > On 07/22/2016 09:12 PM, Felmon Davis wrote: >> On Fri, 22 Jul 2016, Girvin

Re: [libreoffice-users] libreoffice developers please answer my question about security!

2016-10-18 Thread Rob Jasper
On 18 okt. 2016, at 17:14, Italo Vignoli wrote: > On 18/10/2016 15:38, nasrin khaksar wrote: > >> does it mean that libreoffice which is one branch of openoffice, is >> extremely secure and it does not have any security Vulnerability to >> fix in the every new release version? > > LibreOffice i

Re: [libreoffice-users] libreoffice developers please answer my question about security!

2016-10-18 Thread Rob Jasper
Well, it installs, but when I try to start it it comes back with: You can't use this version ofthe application LibreOffice.aoo with this version of Mac OS X. You have Mac OS X 10.7.5. The application requires Mac OS X 10.8 or later. Although it is a nice message, I woyld prefer to get it BEFOR

Re: [libreoffice-users] libreoffice developers please answer my question about security!

2016-10-18 Thread Rob Jasper
OK, I now succesfully installed the 32 bit vwrsion- Thanks for the suggestion. On 18 okt. 2016, at 20:37, V Stuart Foote wrote: > Rob wrote >> I am still using LibreOffice 4.3.6.1 since LO makes it impossible for me >> to upgrade in my OS (Mac OS X Lion 10.7.5). >> My iMac 24", although old, fun

Re: [libreoffice-users] Increase spacing after bulletpoint

2016-10-24 Thread Rob Jasper
Axel, with the bullet list selectted, go to Format -> Bullets and Numbering in pop-up click on tab Position You can set "With of Numbering" here success, Rob On 24 okt. 2016, at 16:43, Axel Braun wrote: > Hi, > > I have an urgent problem - I have a textbox with some bullet points in it >

Re: [libreoffice-users] LO 5.3 glitches

2017-02-04 Thread Rob Jasper
Having spent a lifetime in problem handling and feature request I do not agree with Tom. Here's my take- Bugs: - Anything that used to work and doesn't anymore is a bug (introduced by an update). Of course set aside features which are announced to be obsolete. - Anything not working which is s

Re: [libreoffice-users] Question on wildcards

2017-02-06 Thread Rob Jasper
17 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) >>> E

Re: [libreoffice-users] Embedding Video Files

2017-06-09 Thread Rob Jasper
For this reason I always have a usb stick with LibreOffice as portable app. This can fe found on https://portableapps.com/apps/office/libreoffice_portable I've done this for years now, since Powerpoint different versions played tricks on me displaying black characters on black background.

Re: [libreoffice-users] Re: Letter page format size prints portrait pages as landscape on OS X

2017-07-31 Thread Rob Jasper
Tim, Well, of course this is what one is used to.. Here in the Netherlands (Europe) if one would need different sizes then A1 - A5 one has to specially order it. All is standardized to the A sizes, with the added advantage that if A5 is needed, and you don't have it on stock, you just cut A4 i

Re: [libreoffice-users] How many of you deal with the Linux Users Group [Facebook]?

2018-04-30 Thread Rob Jasper
If they have a recent version of ms-word they should be able to read odt files into word without problem.. So, using odt, doc or docx should be transparent (I hope) On 30 apr. 2018, at 14:32, Virgil Arrington wrote: > >> You are trying to find a solution to a problem. >> The problem is the wr

Re: [libreoffice-users] Date number has 5 digits

2020-12-29 Thread Rob Jasper
Peter, Not sure what you are trying to accomplish. 1- The date in January.$A5 is 12/27/2021. You can see that by formatting cell January.$A5 as date. 2- The date is internally represented as number 44557. You can see this by formatting January.$A5 as number. 3- To get the day of the month us

Re: [libreoffice-users] calc: index column A with column B

2021-01-24 Thread Rob Jasper
Is this what you mean: =INDIRECT("$A"&MATCH(MIN(B:B);B:B;0)) > Op 24 jan. 2021, om 23:14 heeft James het volgende > geschreven: > > I want to find the row in column A that corresponds to the row of a value in > column B. > > eg. > > rowAB > > 1 10 22 > > 2

Re: [libreoffice-users] calc: index column A with column B

2021-01-29 Thread Rob Jasper
James, Since a MINIF function does not exist you can use MINIFS. Change MIN(B:B) to MINIFS(B:B;B:B;">0”) Success, Rob > Op 29 jan. 2021, om 03:59 heeft James het volgende > geschreven: > >>I want to find the row in column A that corresponds to the row of a >> >> value in column B. >>

Re: [BULK] Re: [libreoffice-users] calc: index column A with column B

2021-01-30 Thread Rob Jasper
> Some of the numbers display as 0 but are calculated so have fractions like > 0.000812344372353 > I want to find the last row that displays as non-zero. > > > On 2021-01-29 6:30 a.m., Rob Jasper wrote >> James, >> >> Since a MINIF function d

Re: [libreoffice-users] How to ask a question on Ask LibreOffice?

2021-02-16 Thread Rob Jasper
Dave, I never had a problem with ask. I just get there the easy way by clicking Help -> Get help online. Type you question (or keyword) to find equivalent questions and answers, after that click the orange button to ask the question. Success, Rob. > Op 16 feb. 2021, om 13:52 heeft Dave Barton

[libreoffice-users] Question on INDIRECT()

2021-10-17 Thread Rob Jasper
Hi list-users, I have the following question: I have in column A value either a number, or string in the format +, in col B I want to calculate what’s in Col A e.g.: 1010 12+72 84 3333 66+72 138 So, I tired the formula =INDIRECT(“=“&A1) but I only get REF! What

Re: [libreoffice-users] How to print a section of a SS

2021-10-19 Thread Rob Jasper
Select the area before issuing the print command (Cntrl/P), and subsequently select “print selected area” in the print dialog should do what you want to do > Op 19 okt. 2021, om 12:53 heeft Dave Howorth het > volgende geschreven: > > On Mon, 18 Oct 2021 20:51:19 -0400 > Alan B wrote: > >> I

Re: [libreoffice-users] Open letter for revive LOOL, add your +1 if you agree

2022-07-11 Thread Rob Jasper
Daniel, I fully agree with your statement. I support LO from day one and try bro actively promote LO Is there a formal place to +1, or is this mail sufficient. Keep up the good work! Rob > Op 11 jul. 2022, om 00:42 heeft Daniel A. Rodriguez > het volgende geschreven: > > I've sent a messag

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-08 Thread Rob Jasper
For the following I assumed the “simple date” column is is date format.. If not you can get to that by entering the formula =IFERROR(DATEVALUE(LEFT($RAW.A3;10));"") and pull that down. On another sheet I entered the “query date” in B2 The next formula gives you the max temp on that date: =MAXIFS

Re: [libreoffice-users] text fields to time fields

2023-06-28 Thread Rob Jasper
James, Format thew column as time Select the column and query/replace a.m. with AM Select the column and query/replace p.m. with PM Thats all. Success, Rob > Op 28 jun. 2023, om 23:31 heeft James het volgende > geschreven: > > That seems to leave 11 pm as 11:00 (I expect 23:00). > Maybe I am

Re: [libreoffice-users] Is anyone using Libreoffice SYNCHED to Google drive or One drive or Soho Drive or similar online / cloud drives ?

2023-07-26 Thread Rob Jasper
I am using LO all the time using files on pCloud where pCloud is made available using “pCloud drive” on my MacBook Pro. The files are not physically available on my own machine.. never experienced any problems. > Op 26 jul. 2023 om 13:15 heeft Wade Smart het volgende > geschreven: > > Yes. J

Re: [libreoffice-users] Conditional Formatting Borders on cell that contains text

2023-09-14 Thread Rob Jasper
Rob Select 1 cell (just take an arbitrary one) Right click cell and go to “Format cells” Select tab “borders” Click “all for borders” (second from left, square) Click OK Select from toolbar: Styles -> New Style from Selection Name the style in the pop-up box (I named it mybox) Select from toolbar

Re: [libreoffice-users] Save and Edit Text document

2023-10-25 Thread Rob Jasper
My standard scanning on a Brother all-in-one does OCR. You’ll get the text, but not the formatting. > Op 25 okt. 2023, om 18:55 heeft Kenneth Groninga > het volgende geschreven: > > How do I scan a text document and save it and then later open it and edit > it? > > Kenneth Groninga > > -- >

Re: [libreoffice-users] I paid for my Libre Office

2023-11-13 Thread Rob Jasper
Jose, You don’t specify what OS your are using. This is not a problem of LO, but rather a file permission issue. I myself use a Mac and I assume it is the same on Linux. I see this if I try to edit a file that is sent to me through email if I open the file directly from mail (open the file by d

Re: [libreoffice-users] Help with conditional formatting (Calc)

2024-05-25 Thread Rob Jasper
Paul, Yes, you should use a formula as condition. To use a formula as condition: Go to Format -> Conditional -> condition -> More rules -> formula: $C$3=$Sheet1.$A$14 And use A5:J10 as range (if you select the range before defining the conditional formatting LO sets it automatically). Succes

Re: [libreoffice-users] calc

2024-06-06 Thread Rob Jasper
If I understand you correctly =VLOOKUP(A4;$A$1:$B$3;2;0) in B4 will do what you want > Op 6 jun. 2024, om 05:33 heeft James het volgende > geschreven: > > Say I have column A with the numbers 1, 2, 3: > A1 (1) > A2 (2) > A3 (3) > and column B with the numbers 11, 22, 33: > B1 (11) > B2 (22) >

Re: [libreoffice-users] calc

2024-06-07 Thread Rob Jasper
=VLOOKUP(A4;$A$1:$B$3;2;0) The last argument (0) makes VLOOKUP find an exact match to whatever is in A4. This means that if A4 is empty, or contains a value that does not exist in the range it will respond with N/A > Op 7 jun. 2024, om 19:11 heeft Ekerette Ekpo het > volgende geschreven: >

Re: [libreoffice-users] help with find

2024-07-19 Thread Rob Jasper
What about =ISERR(SEARCH("Nationwide";B1))+1 > Op 19 jul. 2024, om 23:30 heeft James het volgende > geschreven: > > I want to do something like this now: > =IF(FIND("Nationwide", B1)>0,1,2) > It works if "Nationwide" is found in B1 but I get #VALUE! if it is not found. > I'm guessing because t