Re: Calc: can the whole row be highlighted automatically when focus on a cell?

2012-10-17 Thread Brian Barker
Paintbrush in the Standard toolbar. o Drag the (paint bucket) cursor down additional rows to repeat the pattern of coloured rows. o Again, use Format | Default Formatting to remove the striping after use. I trust this helps. Brian Barker

Re: Calc: can the whole row be highlighted automatically when focus on a cell?

2012-10-17 Thread Brian Barker
At 05:06 18/10/2012 +0200, Haim (Howard) Roman wrote: On Thu, Oct 18, 2012 at 5:03 AM, Brian Barker wrote: At 10:05 18/10/2012 +0800, Lou QingLe wrote: I am editing a calc file, and have to change data in discontinuous cells row by row. In order to avoid changing data of another row, I

Re: Calc: can the whole row be highlighted automatically when focus on a cell?

2012-10-17 Thread Brian Barker
tick mark next to the Input Line. This confirms the edit without moving focus away from the cell being edited, thus again keeping focus in the same row. Then use right-arrow as before. I trust this helps. Brian Barker ---

Re: OpenOffice being sold on EBay for GBP 3.49

2012-10-15 Thread Brian Barker
ftware [...] can be downloaded free from the internet". Brian Barker - To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org For additional commands, e-mail: ooo-users-h...@incubator.apache.org

Re: SPLIT TABLE WITH FIXED HEIGHT ROW

2012-10-01 Thread Brian Barker
ossibly outside and before the second frame - when the frame text overflows into the second frame. If you really do need that table, there is no reason why either or both frames should not be embedded in table cells. I trust this helps

RE: openoffice glitch ?

2012-09-16 Thread Brian Barker
How so? I don't want to offer such an arrangement, but it is up to me and other individuals to decide whether or not to do so. Brian Barker - To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org For addit

Re: openoffice glitch ?

2012-09-16 Thread Brian Barker
stance of the program. Logging out and in again or restarting will clear this. Do you have anybody who can access my computer remotely & see if they can determine if something has happened to cause this ? I hope not! Brian Barker --

Re: Links to other spreadsheet not always working?

2012-09-16 Thread Brian Barker
ovide someone with copies of files which actually show the problem if someone is to be able to confirm that what you are seeing is a bug. Brian Barker - To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org For additional commands, e-mail: ooo-users-h...@incubator.apache.org

Re: automatically fixing imported quote marks

2012-09-15 Thread Brian Barker
her style changes to your material, so you will want to do this before you attend to formatting generally. I trust this helps. Brian Barker - To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org For additional comma

Re: openoffice glitch ?

2012-09-12 Thread Brian Barker
s should not be your problem. Another possibility is that you have a print range defined on your first sheet. If so, this will prevent the printing of anything from other sheets unless print ranges are defined on those other sheets to include required cells there too. I trust this helps. Brian

Re: Links to other spreadsheet not always working?

2012-09-10 Thread Brian Barker
At 18:37 10/09/2012 +0200, Ennio Sr wrote: On Mon, Sep 10, 2012 at 8:41 AM, Brian Barker wrote: At 16:26 08/09/2012 +0200, Ennio Sr wrote: Sorry to come back to an issue already raised in a post a few days ago, but either I'm doing something very stupid or it might be a bug. Working wit

Re: Links to other spreadsheet not always working?

2012-09-09 Thread Brian Barker
e supplied is (as you say) actually titled bank_short.ods. The reference is also to the containing folder instead of to the folder of the other files, but it may be that this is where your file resides. (You didn't explain that.) I trust this helps

Re: #VALUE! warning in spreadsheet

2012-08-26 Thread Brian Barker
easy: o Select the relevant range of cells. o Go to Data | Validity... . o On the Criteria tab, for Allow select Date. o On the Error Alert tab, tick "Show error message when invalid values are entered" and for Action select Stop. I trust this helps

Re: Macro or its equivalent to replace double spaces with single space.

2012-07-17 Thread Brian Barker
of a paragraph and the dollar sign to the end of a paragraph - so the pair with nothing in between match only an empty paragraph. I trust this helps. Brian Barker - To unsubscribe, e-mail: ooo-users-unsubscr...@incubator

Re: Establish some rules of conduct

2012-07-07 Thread Brian Barker
onic connection. The idea is preposterous. Lest anyone should believe this, it may be important to remark that this suggestion is, of course, complete rubbish. See http://en.wikipedia.org/wiki/Cyberbullying . Brian Barker - To

Re: Bug

2012-06-14 Thread Brian Barker
he LOOKUP must be sorted ascending, otherwise the search will not return any usable results." Your search vector (4, 3, 1, 2) is not sorted in ascending order, which explains the problem. If you sort the data table B5:D8 by column D ascending, your formulae work as you would expect

Re: Calc: kb shortcut to select entire line?

2012-05-31 Thread Brian Barker
column. I haven't done any customizations, but mine does not show for column select -- it's empty. That's because Select Column is Ctrl+Shift+space. I trust this helps. Brian Barker - To unsubscribe, e-

Re: [Calc] Why do numbers get aligned to the right?

2012-05-26 Thread Brian Barker
vertically aligned, that is - and likewise the tens and hundreds and tenths and hundredths, and so on. For the same reason, digits are usually of constant width even in fonts which have variable-width characters. I trust this helps. Brian Barker

Re: Feature request: "Insert Rows..."

2012-05-24 Thread Brian Barker
th new empty ones, moving existing rows down. I trust this helps. Brian Barker - To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org For additional commands, e-mail: ooo-users-h...@incubator.apache.org

Re: OO spreadsheet question

2012-05-02 Thread Brian Barker
oes; if instead you delete column C itself, the D values will be rendered as #REF! . That could be just as frustrating. Brian Barker - To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org For additional comman

Re: small caps

2012-04-03 Thread Brian Barker
n't toggle the effect, but you could use Ctrl+M to cancel its effect. I trust this helps. Brian Barker - To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org For additional commands, e-mail: ooo-users-h...@incubator.apache.org

Re: A moderator's view of this list [was: Re: I Hate Your Product]

2012-03-31 Thread Brian Barker
lly it was to shout or not to quote version numbers or operating system. Oh, and a long interaction (also shouted, of course) about how to get off this list. Once they are gone, it leaves the list to discuss more important topics, such as top-posting, anti-Microsoft propaganda, how non-s

Re: A moderator's view of this list [was: Re: I Hate Your Product]

2012-03-31 Thread Brian Barker
At 16:15 31/03/2012 +0100, Mike Scott wrote: And I've not found a way on the new list of seeing who's subscribed, and who not. Look for the header: Delivered-To: moderator for ooo-users@incubator.apache.org I trust this helps. Br

Re: countif on multiple items

2012-01-26 Thread Brian Barker
="x") The conditions are either TRUE or FALSE. When interpreted as numbers, these values are 1 and 0 respectively. The product gives 1 only if both components are 1, so it effectively ANDs the two conditions. The resulting true (=1) values are then summed. I trust this

Re: DDE linked cells fool the "=0" test, and dismay paintbrush

2011-12-12 Thread Brian Barker
At 21:24 11/12/2011 -0800, Terry Noname wrote: What I tried before that was: [...] =IF(TEXT(A3;"###.##")="";"value";"zero") which returns "zero" regardless That's not surprising: TEXT(;"###.##") is ".", not the em

Re: Writer: Separate tables after merge

2011-12-11 Thread Brian Barker
At 01:27 12/12/2011 +0200, Dotan Cohen wrote: I accidentally merged two tables, how can I now separate them? o Put the cursor into the row that you want to be the first row of the second table. o Go to Table | Split Table (or right-click | Split Table). I trust this helps. Brian Barker

Re: Export as PDF

2011-11-14 Thread Brian Barker
ctangle including your elements. o Go to Modify | Convert > | To Bitmap (or right-click | Convert > | To Bitmap). o Now go to right-click | Save as Picture... .You can save the collected elements with the minimum of surrounding space in a wide range of formats - including P

Re: Question Restrict Cell entry to width of cell

2011-11-10 Thread Brian Barker
in any page layout, you can define a print range. o If it worries you, you can even hide the column without upsetting its function. I trust this helps. Brian Barker - privately - To unsubscribe, e-mail: ooo-users-unsubscr