[libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?

2014-07-06 Thread Philip Ward
Hi Guys, Running 4.1.3.2 Libreoffice, on Win 7 64Bit, and having a few annoyances?? i have a multi sheet document, page one has some dates on it, and these dates are then grabbed by the following sheets to make the dates work on them etc?? sometimes i load up the document, and the formula's all

Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?

2014-07-06 Thread Philip Ward
Hi Tom i forgot to add, the first time i saw the corruption was on OSX 10.6.8 running LO 3.X (cant remember), but that was only opening the file, not saving, so i decided not to use that one again... do you save locally or Dropbox or somthing else? cheers Phil On 6 July 2014 13:44, Tom Cloyd

[libreoffice-users] Re: Can I do this in Calc?

2014-07-06 Thread Luuk
On 5-7-2014 22:58, Pikov Andropov wrote: Luuk has written on 7/5/2014 5:01 AM: On 5-7-2014 00:08, Pikov Andropov wrote: I have a list of names in column A. I would like like to click something and produce a list of random pairs, say in col B. For example, suppose I have Jack Jill Sam Susan B

Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?

2014-07-06 Thread Tom Cloyd
Phil, Yeah. I sure do know this problem, too. For many months. I can't see the pattern. I can't seem to reduce the matter to a simple demonstration so I can file a bug report. I've simply given up for now. I just fix things and keep on sailing. Whatever it is is pervasive, highly corrupting,

Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?

2014-07-06 Thread Tom Cloyd
UPDATE: So sorry. I stupidly forgot to include info. about my operating environment - it's Kubuntu Linux 14.04 and I'm running LO Version: 4.3.0.2 Build ID: 14ed55896fdfcb93ff437b85c4f3e1923d2b1409. We are, of course, talking about Calc. t. On 07/06/2014 06:12 AM, Philip Ward wrote: Hi Guys,

[libreoffice-users] LOBase - Hyperlinks in Tables

2014-07-06 Thread Pat Brown
Hi, I am very comfortable with most aspects of LO except Base. I am now starting to use this option and I find it rather daunting compared to MS Access (simply because I have used this for years). I am busy with my first table design and I would like to create two fields as hyperlinks to externa

Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?

2014-07-06 Thread Brian Barker
At 13:12 06/07/2014 +0100, Philip Ward wrote: ... and now i went in to alter the format of the cell ie Date details "D " giving me "Monday 6 October 2014" but now want to shorten the date down to "mon 6 oct 2014", but its now telling me options for jewish?? ie " [~jewish]D MMM

Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?

2014-07-06 Thread Tom Cloyd
I save to my Dropbox. Don't think that's relevant, though. Can't figure how it would be. Tom On Sun, Jul 6, 2014 at 6:49 AM, Philip Ward wrote: > Hi Tom > > i forgot to add, the first time i saw the corruption was on OSX 10.6.8 > running LO 3.X (cant remember), but that was only opening the

Re: [libreoffice-users] LOBase - Hyperlinks in Tables

2014-07-06 Thread Tom Davies
Hi :) Errr, i'm not an expert in Base btw. I implied that in my last post but it is not so. Regards from Tom :) On 6 July 2014 17:35, Tom Davies wrote: > Hi :) > Published Guides are at; > > https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook > At the bo

[libreoffice-users] base error - no SDBC drive

2014-07-06 Thread Tom Cloyd
I don't understand why this is happening. I've never seen it before. I depend on base for a few things, but weeks or even months can go by with my not using it. In recent times, I've installed a number of copies of the Master version of LO. I'm now using this version: 4.3.0.2 Build ID: 14ed5589

Re: [libreoffice-users] LOBase - Hyperlinks in Tables

2014-07-06 Thread Tom Davies
Hi :) Published Guides are at; https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook At the bottom of each book is a link for purchasing a paper-back copy from Lulu Bookstores = or print the whole book or relevant chapters for 'free' (errr, excluding costs of pape

Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?

2014-07-06 Thread Phil
Hi Brian I have just opened the file in question on my Imac at home 10.6.8 running LO 4.2.4.2. The default User interface is English USA, Local Setting is UK, and default currency is GBP, ill check the laptop & works imac tomorrow for specifics etc The alterations i did earlier after i sent

Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?

2014-07-06 Thread Brian Barker
At 00:05 07/07/2014 +0100, Philip Ward wrote: On 06/07/2014 17:01, Brian Barker wrote: At 13:12 06/07/2014 +0100, Philip Ward wrote: ... and now i went in to alter the format of the cell ie Date details "D " giving me "Monday 6 October 2014" but now want to shorten the date down

[libreoffice-users] hatching in Writer

2014-07-06 Thread Thomas
Good morning I just tried to apply "hatching" to an empty space (just marked by an underline and when printed to be filled by an amount on a receipt). It seems to be not possible, unless you create an "object" first. from the help documentation: "Set the properties of a hatching pattern, or save a

Re: [libreoffice-users] hatching in Writer

2014-07-06 Thread Brian Barker
At 11:30 07/07/2014 +0900, Thomas Blasejewicz wrote: I just tried to apply "hatching" to an empty space (just marked by an underline and when printed to be filled by an amount on a receipt). It seems to be not possible, unless you create an "object" first. Do you for some reason not want to cr