Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-09-13 Thread Paul
Hi Don, Thanks for the input. Is this also using a string literal after the format string, like / hour ? And if so, even if the formatting isn't messed up, is there a space between the number specifier and the string literal, like #,###.00 / hour or has the space been put inside the string

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-09-13 Thread Paul
Hi Tom, Thanks, I think I'll try add a bug report about this. Was hoping to have some verification of this error, but it doesn't seem to be something many people have run into. Paul On Fri, 13 Sep 2013 12:23:36 +0100 (BST) Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) The 2nd one

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-09-12 Thread Paul
Hi Regina, All, I've finally (finally!) updated LO, and checked this problem again, and it still manifests. I can confirm that it manifests with the following LO versions: 4.0.3.3 4.0.5.2 4.1.1.2 This is with a locale of South Africa, but I think that just makes the problem worse by confusing

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-09-12 Thread Don Myers
Hi, I'm running LO 4.1.1.2 (Document Foundation Version) in Ubuntu 13.04. After reading about this issue, I tried some spreadsheets going back a number of years, mostly .ods, and one .sxc, and all of the formulas saved in them are working perfectly. This is in the US. I also tried some new

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-07-19 Thread Paul
Hi All, Haven't had a chance to test in LO 4.1 beta, but I was hoping someone could at least confirm that they are getting the same results in 4.0 or prior, and maybe even someone with 4.1 could comment on if it is still happening. Anybody? Regina, you said you weren't getting the weird

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-07-09 Thread Paul
Hi Regina, Terribly sorry about the delay in following up on your suggestions. I didn't mean to just disappear like that. It's been a bit hectic here, and I haven't had time to try with LibreOffice 4.1 beta yet, but I've tried a couple of other things. Firstly, I tried formatting the cell as a

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-07-09 Thread Carl Paulsen
I sent the following, but apparently not to the list: Well, if all you need is to manually copy and paste, then copy the cells, move to the other spreadsheet, then select the starting cell, select Edit-Paste Special, then uncheck the Formulas option (you may first need to uncheck the Paste

Re: Re: [libreoffice-users] Re: Info from 3 cells merged into 1 - was [libreoffice-users] Error in Calc custom formats between closing and opening a file -

2013-07-09 Thread Carl Paulsen
Arrgghhh. This was supposed to be a reply to the Re: Info from 3 cells merged into 1 thread. Sorry! On 7/9/13 8:31 PM, Carl Paulsen wrote: I sent the following, but apparently not to the list: Well, if all you need is to manually copy and paste, then copy the cells, move to the other

Re: [libreoffice-users] Re: Info from 3 cells merged into 1 - was [libreoffice-users] Error in Calc custom formats between closing and opening a file -

2013-07-09 Thread Marino / WellnessWebshop.se
Works perfect - thanks! Marino -Ursprungligt meddelande- From: Carl Paulsen Sent: Wednesday, July 10, 2013 3:57 AM To: users@global.libreoffice.org Subject: Re: Re: [libreoffice-users] Re: Info from 3 cells merged into 1 - was [libreoffice-users] Error in Calc custom formats between

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-06-23 Thread Paul
Bump? Or is this the wrong mailing list to ask such questions on? On Tue, 18 Jun 2013 14:42:38 +0200 Paul paulste...@afrihost.co.za wrote: Hi All, I'm running LibreOffice Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539) on Windows 7 64-bit. Files are saved in native

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-06-23 Thread Regina Henschel
Hi Paul, Paul schrieb: Bump? Or is this the wrong mailing list to ask such questions on? It is the right mailing list. But sometimes an email slipped through. I cannot reproduce the problem with LibreOffice 4.1. Please try it with the LO4.1 beta. If you see the problem there too, it

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-06-23 Thread Regina Henschel
Hi Paul, Paul schrieb: Hi Regina, Thanks for your response. If I install the 4.1 beta, will it install side by side with the existing stable, or replace it? If it replaces it, can I revert to stable easily? Do I just re-install with the stable download? It will not install side-by-side but

[libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-06-18 Thread Paul
Hi All, I'm running LibreOffice Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539) on Windows 7 64-bit. Files are saved in native ods format. I'm using a custom format code on a cell in Calc to get a value displayed as a rate per hour. This is the format code I want: [$R-1C09]