You are viewing a plain text version of this content. The canonical link for it is here.
Posted to qa@openoffice.apache.org by MARC BERTHOUD <ad...@prodigy.net.mx> on 2012/11/28 19:17:45 UTC
2 very strange bugs in OO Calc, vlookup
Hello Andrea I did attached you the file with the strange BUG in the vlookup function. On sheet 1 I have the resulting table, that referes to the numbers in sheet 2 (tablas). There are 2 VERY strange BUGS: 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. 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 unsuscribe from your mailing list. Have a good day and kind regards Marc BerthoudTerraplata SA de CVProPlaneta SA de CV+52 777 145 23 55+52 739 393 09 02
De: "Andrea Pescetti" pescetti@apache.org
Para: qa@openoffice.apache.org
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.
Re: 2 very strange bugs in OO Calc, vlookup
Posted by Andrea Pescetti <pe...@apache.org>.
On 28/11/2012 MARC BERTHOUD wrote:
> I did attached you the file with the strange BUG in the vlookup function.
Hi Marc, I had a look and it seems a frequently reported non-bug: you
need to add a "0" as last parameter of VLOOKUP, otherwise it will assume
that the cells it is scanning are sorted. Doing this in cell J6 fixed it
for me.
> 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.
Please consider the digest option. It is quite convenient: you will
receive only one message per day, more or less, with all the mailing
list traffic from that day. You can unsubscribe from the normal list and
subscribe to the digest list using the addresses at
http://mail-archives.apache.org/mod_mbox/openoffice-qa/
Regards,
Andrea.