On Wed, Nov 28, 2012 at 1:24 PM, MARC BERTHOUD <[email protected]> wrote: > Hello Andrea > > I did attached you the file with 2 very strange BUG in the vlookup function. > > On sheet 1 I have the resulting table, that referes to the numbers in sheet > 2 (tablas). > > The 2 VERY strange BUGS are: > > 1. If in sheet1/Col.A I put a month that starts with the letter A, B or C > the vlookup does not work and gives me a no solution. > > 2. WORSE If I put what ever kind of text in A3:A11, the vlookup still works, > evnen though that text is not in the vlookup range ?!? > > I am provicient in worksheets since Visical (30+ years ago) and I use > Openoffice since version 1.1 - but I never have seen something like that. >
Hi Marc, Take a look at the SortOrder parameter for VLOOKUP(). You are omitting it, so it is assuming a value of TRUE, that the data is sorted. But it really isn't. The values are strings, so Jan, Feb, Mar, Apr, etc., are out of order. (You need to think alphabetical order. Calc doesn't know these are dates). Since the data is not sorted, this breaks the assumptions of the function and results are not going to be pretty. Try again, but set the SortOrder parameter to FALSE> > Even tough I am an entrepreneur I took some spare time and went through the > Apache manuales on Sunday and then suscribed to a mailing list. The result > was, that on Tuesday I had some extra 40 emails in my Inbox. > I can not handle 40 extra emails / day, since I have to answer already 40-50 > emails every day and had to put unfortunately your collegues to my spam > list. So it is in your hands what happens with this strange bug. > I'd hope you can fix it > > As soon as I know, that these bugs are taken care of, I will unsubscribe from > your mailing list. > > Have a good day and kind regards > > Marc Berthoud > Terraplata SA de CV > ProPlaneta SA de CV > +52 777 145 23 55 > +52 739 393 09 02 > > > > > De: "Andrea Pescetti" [email protected] > Para: [email protected] > Cc: > Fecha: Wed, 28 Nov 2012 18:50:41 +0100 > Asunto: Re: OpenOffice Calc > >> On 27/11/2012 Mark Garcia wrote: >> > Didn't know where else to post this question but, as a non-technical >> > question, is there a stand-alone installation for OpenOffice Writer so >> > that >> > ONLY Writer would be installed on a PC? >> >> No. And it wouldn't actually save space, since almost all of the package >> is common to all applications (i.e., packaging only Writer you would be >> closer to 90% of the full size than to 25%). >> >> > I ask this because I wanted to propose to my manager to add OpenOffice >> > Writer as a word processor on our company's software program disc. >> >> You may consider the live/portable version that can be run directly from >> the disc without installation. See X-ApacheOpenOffice at >> http://www.openoffice.org/porting/ >> >> Regards, >> Andrea.
