Re: [users] Calc, delete specified range of rows or columns

Use the 'Name Box' to select the range, rows, or columns you want to delete. I have managed to create a name for a range. But How can I delete the range? TomW - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For

Re: [users] Calc, delete specified range of rows or columns

Fantastic, Thanks!! 2009/11/10 Johnny Rosenberg gurus.knu...@gmail.com: Select it in the Name Box (the one to the left of the formula field). Then hit the Delete button (or Backspace). Johnny Rosenberg -- Zhengquan - To

[users] Calc, delete specified range of rows or columns

Hello Openoffice community! How could I delete specified range(eg, from row 20 to row 6200) of rows or columns? sometimes my spreadsheet has thousands of rows and select and delete them is a pain. Thanks! -- Zhengquan - To

[users] Calc merge two columns

Hello, openoffice community, I have two columns of text, they look like string1 | string2 | - | string1 | string2 | - | string1 | string2 | - how can I merge them to one column string1 string2 | -| string1

[users] Re: Calc merge two columns

google helped me find this http://www.oooforum.org/forum/viewtopic.phtml?t=41040 THanks OO! 2009/11/3 Zhengquan Zhang zhang.zhengq...@gmail.com: Hello, openoffice community, I have two columns of text, they look like string1 | string2 | - | string1 | string2

[users] Calc shortcuts for italicizing and decreasing font size?

Hello openoffice list: I am in search of a shortcut for both italicizing the selected text and decreasing the fontsize to 1 size smaller. I wonder who can point me to some info about that. I tried customizing keyboard shortcuts but it seems that it is not adequate for this task. Thanks and Have

[users] [Calc] looking for a macro or something like it

Hi, openoffice list, I have got a column of cells which contains contents like: sentence(explanation); the fonts in and out of the parenthesis are the same, both are aria 12; Now I would like to change the fonts in the parenthesis(the explanation part) to italics and to smaller fonts, say aria

[users] Calc keyboard shortcut for adding background color?

Hello, openoffice list, I need to frequently add background color for cells and I was wondering if who has keyboard shortcuts for doing this job. I also need keyboard shortcuts for getting text bold, italics, etc. It would be great if who can point to a list of openoffice shortcuts for this kind

Re: [users] Calc keyboard shortcut for adding background color?

On Thu, Jun 25, 2009 at 06:35:14PM +0200, Johnny Rosenberg wrote: 2009/6/25 Zhengquan Zhang zhang.zhengq...@gmail.com: Hello, openoffice list, I need to frequently add background color for cells and I was wondering if who has keyboard shortcuts for doing this job. I also need keyboard

Re: [users] Calc keyboard shortcut for adding background color?

On Thu, Jun 25, 2009 at 11:24:00AM -0400, Keith Clark wrote: On Thu, 25 Jun 2009 10:24:32 -0500, Zhengquan Zhang zhang.zhengq...@gmail.com wrote: Hello, openoffice list, I need to frequently add background color for cells and I was wondering if who has keyboard shortcuts for doing

[users] auto save in openoffice calc does not change the time stamp of the file?

Hello OO users, I use a backup program to automatically backup my document folder every ten minutes which contains a few OO spreadsheets and I found that although I set the auto save recovery information every 5 minutes, and I can see every 5 minutes OO would save my spreadsheet, when I check the

Re: [users] auto save in openoffice calc does not change the time stamp of the file?

On Tue, May 26, 2009 at 11:13:56PM +0100, Brian Barker wrote: At 16:41 26/05/2009 -0500, Zhengquan Zhang wrote: I use a backup program to automatically backup my document folder every ten minutes which contains a few OO spreadsheets and I found that although I set the auto save recovery