On Jan 22, 2010, at 17:00 , Luis P. Mendes wrote: > Hi all, > > Today I found out this weird behavior of Calc that I had never seen before. > > In a new spreadsheet, when I try to copy a simple formula, let's say > '=A1+B1' to cells D2 to F2, Calc doesn't copy the formulas. > ^C and ^V don't work, and as menu commands don't work either. > What happens is that a window pops up that has as title 'Text Import'! > > I can only past cells one at a time! > It seems that Calc is calling Writer functions of copy & paste. > Please see http://img190.imageshack.us/img190/2052/errocalc.jpg > > Not sure what you're trying to do here, Luis. Looking at your picture you have 1 in A1 and 2 in B1 and your formula =A1+B1 should place the sum, 3, in the relevant cell (say, D2).
However, if you try to post it to a number of cells at the same time, I would expect a relative positioning in each cell. You say you want to post the sum to cells D2 to F2. In this case I would expect D2 to show the sum of 3 (A1+B1) E2 to show the sum of 5 (B1+C1) and F2 to show the sum of 7 (C1+D1) since what you are placing in D2 is the sum of (3 cells right and 1 cell up) which is A1 plus (2 cells right and 1 up) which is B1. Applying this formula to E2, you will add B1and C1, and so on. I can't see how you can create a formula in three cells simultaneously. As far as I know, you create it in one cell (say D2) and copy it to the others. If you change your formula to =$A1+$B1 I would expect the result you want, since the $ sign in front of A means absolute A and not relative A, This formula would not work, of course, in D3 to F3 since you haven't said $A$1 in the formula (= absolute column A and absolute row 1). When I create this fomula in D3 I can copy it to E3 and F3 (I used D2 to F2 for your example). I have not been able to call up the window you show in your web page. Can you explain in more detail what you are trying to achieve and the exact steps you take to create it. //James --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
