Hello James and Harold, In my early days of using Open Office I found that if I had a spreadsheet and changed something in a cell and left the cursor there, and asked the printer to print it the original text would be printed - not the updated information. Whenever I have given help or instruction about Open Office Spreadsheets I have always included the caution that you need to click outside the cell where you have made a change or entry to 'set' the contents of the cell. To check this out before sending I opened a spreadsheet and put a couple of words in each of two cells but in the second cell did not move the cursor out of it. When I printed it the first cell only was printed. I then moved the cursor out of the second cell and did another print and the both cells were then printed. This is one of those things that no one tells you about. [email protected]
On Fri, Sep 4, 2009 at 2:40 AM, Harold Fuchs <[email protected] > wrote: > James Elliott wrote: > >> Since up grading to OOo 3.1 (running under Windows XP) Copy and Paste is >> not working properly, in some instances. >> >> When I copy the contents of a 'name and address' cell in a Calc worksheet, >> into text box in a Draw document: >> >> 1. the first line copies across as font size 12pt >> 2. the second line copies across as font size 18pt >> 3. the third line copies across as font size 18pt >> >> In the original Calc worksheet, all three lines were font size 10.5 pt >> >> Can anyone explain to me what is happening and how to recitfy it, please. >> >> Many thanks, James >> >> >> I'm using 3.1 on Vista and what you report does not happen for me. What I > did was as follows: > > 1. Open a new spreadsheet > 2. Enter a 3-line address into A1 using Ctrl-Enter to force line-breaks > 3. Copy the contents of this cell > 4. Open a new text document > 5. Create an empty text box > 6. Paste [the contents of the clipboard] into the text box > > The pasted text was all the same size as the original. > > I also tried changing (made bigger) the font size of the middle line in my > spreadsheet's A1 and copy/pasting the result into a new text box in the same > Writer document. The result was correct - the text box's middle line was > the right [bigger] size. > > I think that the precise details of what you are doing are different from > what I am doing. > > Ahhh. I changed the larger text in cell A1 back to its original size, > copied the cell and pasted it into the Writer document. The result was that > the middle line was the *bigger* size. I conclude that I had not actually > copied the cell. I went back to it, selected all its text (Ctrl-A while the > cursor is in the cell), copied it and now the paste is OK. > > Further experimentation shows that if you change the text size in the cell > and then immediately copy, the result is the *old* size. After changing the > cell contents, you need to click outside it and then back in again before > copying. > > Does this solve your problem? > > > -- > Harold Fuchs > London, England > Please reply *only* to [email protected] > >
