Thank you James for your answer, I'll try to be more explicit. I have maybe twenty years of experience in using spreadsheets, so I can assure you that it's not some kind of misuse by me.
Let's consider this situation. In a new spreadsheet, please enter values: 1 in A1, 2 in B1, 3 in C1, 4 in D1. In cell B2, enter formula '=B1+A1'. It should show value 3. Now, select cell B2, copy the value, either with ^C or with menu option Edit | Copy, select C2 and D2 and when I try to paste it in these two cells, nothing happens! When I try to do a paste special, the usual paste special of calc doesn't show up. Instead, there's a window that only permits to paste 'Unformatted text' from 'Unknown Source'! You can see it here: http://img64.imageshack.us/img64/1282/problemacalc2.jpg If for example, I press the arrow on the right of the paste button in the standard toolbar, I only get the same 'Unformatted text' option. Sometimes I get other options like: GDI metafile Bitmap calc8 dde unformatted text DIF formatted text RTF HTML This is some kind of misconfiguration or is it a bug? It's really strange. I'd love to read some solution from you. Luis 2010/1/22 James Wilde <[email protected]>: > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
