Re: [libreoffice-users] a little math problem with Calc

2012-07-06 Thread alex sato
Regina. I'm writing this email just to say "thank you" again. About the idea of rewriting math function using string. I may do it but just for fun, not for a serious use. ;-) Regards Alex Mitsio Sato On Fri, Jul 6, 2012 at 10:13 AM, Regina Henschel wrote: > But can you tell me how to call Ca

Re: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread alex sato
error because I remembered BCD. :-) Regards Alex Mitsio Sato On Thu, Jul 5, 2012 at 8:27 PM, Regina Henschel wrote: > Hi, > > alex sato schrieb: > > Hi, >> >> I have a problem with functions I made. >> >> Let's say I create the function: >> &g

Re: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread alex sato
gt; Subject: Re: [libreoffice-users] a little math problem with Calc > > Hi. > I tried your function but made the last line Test = r(3). > It does return 17. > > My guess is that by the completion of r(2)=r(1)*100 the value is very > slightly less than 18 and int then produces 17.

[libreoffice-users] a little math problem with Calc

2012-07-04 Thread alex sato
Hi, I have a problem with functions I made. Let's say I create the function: Function Test (n) dim r(3) r(0)=int(n) r(1)=n-r(0) r(2)=r(1)*100 r(3)=int(r(2)) Test = r End Function Then, in a empty spreadsheet take the following steps: -select A1:D1 -press [F2] -Insert the formula =TEST(E1) -pres

[libreoffice-users] Is "^" different in Mac??

2012-05-23 Thread alex sato
A friend downloaded and installed Mac version of LibreOffice (he has a Mac). He told me that he can't use "^" simbol to calculate exponentiation in ooBasic b ecause always get syntax error or something like that. At work, using Windows version of LibreOffice everything works fine. Any ideia about w

Re: [libreoffice-users] LibreOffice is listed as an educational software for math

2012-05-23 Thread alex sato
On Wed, May 23, 2012 at 12:41 PM, Doug wrote: > (Back in the "dark ages" of the 70s or so, kids learned BASIC on Commodore > and Amiga computers. Real programmers hated BASIC, > but you could do a lot with it, in spite of the professionals' disdain. > Unfortunately, the "easy" BASIC of those da

[libreoffice-users] Question about CALC

2012-04-30 Thread alex sato
Can anyone tell me why when making a "freezeable" (not sure if this word really exist :-) ) operation in one CALC windows, like saving a large/complex spreadsheet, freeze (while operation is running) all openned CALC windows? Thanks Alex Mitsio Sato -- For unsubscribe instructions e-mail to: u

Re: [libreoffice-users] Question about Calc and Annotations

2012-01-23 Thread alex sato
Hi Cor! I'm using Calc to manage documents from job where each row correspond to a document and has information like dates, values, names, etc., and one historic description that some times takes very long. I made a test inserting historic as annotation and the result looks very good, except the s

Re: [libreoffice-users] Question about Calc and Annotations

2012-01-19 Thread alex sato
Hi Cor, I'm writing this just to say "thanks". Sorry for my poor english that sometimes turn me incapable to say exactly what I want. Regards Alex Mitsio Sato On Thu, Jan 19, 2012 at 8:19 PM, Cor Nouws wrote: > Hi Alex, > > alex sato wrote (19-01-12 01:04) &

Re: [libreoffice-users] Question about Calc and Annotations

2012-01-19 Thread alex sato
i.documentfoundation.org/ReleasePlan > (6th Feb but out as beta already i think) and that can handle JRE 7 > > http://www.oracle.com/technetwork/java/javase/downloads/index-jsp-138363.html#javasejdk > > The devs are working hard at writing out any need for java but Base is > tr

Re: [libreoffice-users] Question about Calc and Annotations

2012-01-19 Thread alex sato
entfoundation.org/Documentation/UserProfile > > Regards from > Tom :) > > --- On Thu, 19/1/12, alex sato wrote: > > From: alex sato > Subject: [libreoffice-users] Question about Calc and Annotations > To: users@global.libreoffice.org > Date: Thursday, 19 January, 2012, 0:

[libreoffice-users] Question about Calc and Annotations

2012-01-18 Thread alex sato
Is it normal Calc to freeze some minutes when resizing the width of a column in a blank sheet that only has a column filled with 18000 cells with annotation?? Nothing abnormal happens here when the sheet has 18000 cell with normal data instead annotation. Just opening the file take long time too he

Re: [libreoffice-users] Re: CALC - current row/column highlight

2012-01-08 Thread alex sato
I don't use styles. (I need to learn how to use) By the way... Is there any reason for this feature not be implemented in LO-Calc, even as option? Alex Mitsio Sato On Sat, Jan 7, 2012 at 3:23 PM, Andreas Säger wrote: > http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=43531 >

Re: [libreoffice-users] CALC - current row/column highlight

2012-01-07 Thread alex sato
told me that wished such feature too. regards Alex Mitsio Sato On Sat, Jan 7, 2012 at 10:14 AM, alex sato wrote: > Hi Miguel, > > Thank you! > It worked. > > > By the way, wouldn't be great if it was a native feature? ;-) > > regards > > Alex Mitsio Sat

[libreoffice-users] Calc - comments / macro

2012-01-07 Thread alex sato
Hi! I wish to know how to change the size of the box where the cells comments is displayed using macro. Is it possible? Thanks in advance Alex Mitsio Sato -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] CALC - current row/column highlight

2012-01-07 Thread alex sato
Hi Miguel, Thank you! It worked. By the way, wouldn't be great if it was a native feature? ;-) regards Alex Mitsio Sato On Sat, Jan 7, 2012 at 5:36 AM, MiguelAngel wrote: > El 07/01/12 8:16, alex sato escribió: > >> Hi! >> >> I have a question about the CA

[libreoffice-users] CALC - current row/column highlight

2012-01-06 Thread alex sato
Hi! I have a question about the CALC. There is a way to make highlighted the row and/or the column of the current cell to make easier to input data in a cell which is far from another cell used as reference? I know that "selecting" the row/column do it, but I mean a way which keep the row/column o