Re: [libreoffice-users] What version?

2014-08-10 Thread Errol Goetsch
to a free cuisine. Thank you to the developers who have given so much to so many for so little. Errol Goetsch On 07/08/2014 15:42, Tom Davies wrote: Last but not least, positive feedback is rare compared to negative - here, in FOSS or in any customer service. I'd be shocked it we experienced

Re: [libreoffice-users] My computer | Text off centre over-large

2013-09-02 Thread Errol Goetsch
Hi there Tricia, good to see you here. The good fellows at Shaw|your computer store knew enough to load a substitute for MS Office that didn't cost you anything. They put you on the right road. There isn't a number to phone and don't wait for a call because the price of LibreOffice - zero -

Re: [libreoffice-users] Calc - Matching Up Text Fields

2013-08-03 Thread Errol Goetsch
On 2013/08/03 02:12 AM, Brian Barker wrote: No - as you'll know, I wrote none of that. Please take care when replying not to misattribute contributions. Thanks. Brian Barker I'm sorry for offending you Brian. I looked at the many contributions you have made on this list (and others)

Re: [libreoffice-users] writer macro record function missing

2013-08-03 Thread Errol Goetsch
On 2013/08/03 07:17 PM, Johnny Rosenberg wrote: 2013/8/3 MissKeating misskeat...@comcast.net: Using LO-writer Version 3.6.1.2 (Build ID: e29a214), the unhelpful help says that in order to record a macro, one should: Choose *Tools - Macros - Record Macro*. Under *Tools - Macros -- *there are

Re: [libreoffice-users] Calc - Matching Up Text Fields

2013-08-02 Thread Errol Goetsch
On 2013/08/01 11:31 AM, Don Parris wrote: Unfortunately, one bank throws everything except for the date and the amount into a single description column. It would still be simpler if they did not include the actual transaction date in that column, as it means the description changes... well...

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-18 Thread Errol Goetsch
Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? Yes, using conditional formats. First create

Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-18 Thread Errol Goetsch
On 2013/07/18 04:47 PM, Tanstaafl wrote: Hello, Microsoft Excel has the ability to allow users to apply formatting changes to protected cells when a sheet is protected. Is there any possible way to do this in Calc? Thanks Yes, using conditional formats. Protecting the cell _and_ the

Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?

2013-07-11 Thread Errol Goetsch
Hi all You can get to a auto-sorted table in 4 steps without macros by using vlookup, hlookup, count, max and min. Ive sent Charles a working example for 20 salespeople over 12 months, where the duplicate list re-sorts as soon as the YTD total changes. I couldn't bear the thought of Charles

Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?

2013-07-11 Thread Errol Goetsch
https://docs.google.com/file/d/0B6LXy9sguZVkSXVqdnBWd0tVWUk/edit?usp=sharing 2 ways to auto-sort a numerical table using simple formulae when cells in a totals column are modified On 2013/07/11 06:00 PM, Dave Barton wrote: Johnny Rosenberg wrote: 2013/7/11 Errol Goetsch er...@xe4.org: Hi

Re: [libreoffice-users] Info from 3 cells merged into 1

2013-07-08 Thread Errol Goetsch
err501 means the formula was written incorrectly. here is a working example of what Steve and Carl said Errol On 2013/07/08 09:57 PM, Marino / WellnessWebshop.se wrote: Thanks Steve! Ive tried this now, but I got Err:501 for this. Any idea why? Best regards, Marino -Ursprungligt

Re: [libreoffice-users] Info from 3 cells merged into 1

2013-07-08 Thread Errol Goetsch
oops, perhaps attachments get stripped out on this list. I've now sent the example direct to Marino. Errol On 2013/07/08 10:10 PM, Errol Goetsch wrote: err501 means the formula was written incorrectly. here is a working example of what Steve and Carl said Errol On 2013/07/08 09:57 PM, Marino