[libreoffice-users] Re: Am I the only one with Err 522 problems?

2013-04-24 Thread Alex Thurgood
Le 02/04/2013 19:48, Johnny Rosenberg a écrit : Hi Johnny, Just a few thoughts in an attempt to narrow down the problem : - which version of OpenOffice.org did you originally use to create the file ? - the cells that show Err 522, do they have a particular formula that requires recalculation

Re: [libreoffice-users] How to downgrade from 4.0.2. to 3.6.6

2013-04-24 Thread Tom Davies
Hi :) Congrats on fixing it! Now you see why it's so difficult to pin-down what the problem is.  Microsoft have every Tuesday as Patch Tuesday.  I think they copied the idea from Symantec (Norton) a few years ago.  Symantec use Thursdays.  It makes it easier and more predictable for

[libreoffice-users] *.csv formats and MS DOS CSV formats

2013-04-24 Thread sun shine
Hi list My wife needs to submit *.csv files to the UK HMRC dept however, they request that these are sent as *.csv ms-dos format. Having saved a calc sheet as a *.csv file, she tested this by opening it up with MS Excel, and found several errors that made the file unreadable. How can I

[libreoffice-users] Re: *.csv formats and MS DOS CSV formats

2013-04-24 Thread Alex Thurgood
Le 24/04/2013 14:36, sun shine a écrit : Hi, How can I advise her to save spreadsheets as *.csv formats in a way that HMRC can read these as if saved in the MS Dos CSV format (which LibO doesn't have the option to do)? Is there something in the save procedure that she needs to attend to?

[libreoffice-users] Re: *.csv formats and MS DOS CSV formats

2013-04-24 Thread Alex Thurgood
Le 24/04/2013 14:36, sun shine a écrit : Looking at this : http://customs.hmrc.gov.uk/channelsPortalWebApp/channelsPortalWebApp.portal?_nfpb=true_pageLabel=pageImport_ShowContentid=HMCE_PROD_010685propertyType=document gives a list on how to structure the file and hints on what to do if your

Re: [libreoffice-users] Re: *.csv formats and MS DOS CSV formats

2013-04-24 Thread sun shine
On 24/04/13 14:17, Alex Thurgood wrote: Le 24/04/2013 14:36, sun shine a écrit : Hi, How can I advise her to save spreadsheets as *.csv formats in a way that HMRC can read these as if saved in the MS Dos CSV format (which LibO doesn't have the option to do)? Is there something in the save

[libreoffice-users] Re: *.csv formats and MS DOS CSV formats

2013-04-24 Thread Alexander Thurgood
Le 24/04/13 15:35, sun shine a écrit : Hi again, This may well be what she needs - i.e. insert the additional \r value for formatting the line endings. I don't know and there's nothing that I can use from looking for this on the web. As such, this shouldn't be a problem if everything is

Re: [libreoffice-users] Re: *.csv formats and MS DOS CSV formats

2013-04-24 Thread sun shine
On 24/04/13 14:22, Tom wrote: Hi :) When saving as Csv you get various options. Probably the most crucial one is the Field delimiter drop-down which needs to be set to , It should start out being the default but if you change it then the new choice becomes the new default so you'll need to

Re: [libreoffice-users] Re: *.csv formats and MS DOS CSV formats

2013-04-24 Thread sun shine
On 24/04/13 14:26, Alex Thurgood wrote: Le 24/04/2013 14:36, sun shine a écrit : Looking at this : http://customs.hmrc.gov.uk/channelsPortalWebApp/channelsPortalWebApp.portal?_nfpb=true_pageLabel=pageImport_ShowContentid=HMCE_PROD_010685propertyType=document gives a list on how to

Re: [libreoffice-users] How to downgrade from 4.0.2. to 3.6.6

2013-04-24 Thread Brian Barker
At 11:19 24/04/2013 +0100, Tom Davies wrote: Microsoft have every Tuesday as Patch Tuesday. No: only the second Tuesday in each month is Patch Tuesday. (Otherwise they would be called Tuesday!) Obviously if there is a really serious threat that they develop a patch for they sometimes

Re: [libreoffice-users] Re: *.csv formats and MS DOS CSV formats

2013-04-24 Thread Jay Lozier
On 04/24/2013 09:26 AM, Alex Thurgood wrote: Le 24/04/2013 14:36, sun shine a écrit : Looking at this : http://customs.hmrc.gov.uk/channelsPortalWebApp/channelsPortalWebApp.portal?_nfpb=true_pageLabel=pageImport_ShowContentid=HMCE_PROD_010685propertyType=document gives a list on how to

[Solved] Re: [libreoffice-users] Re: *.csv formats and MS DOS CSV formats

2013-04-24 Thread Tom Davies
Hi :) Good work!  Nicely done!  Congrats and thanks for letting us know :) That checking process is really just a quick squizz after the first time or so.  It's not something to pause and read avidly.  You kinda become aware there might be a problem even before it pops up or well after rather

[libreoffice-users] When does one cell equal another?

2013-04-24 Thread david_lynch
I use Libreoffice to process files over which I have no control. These are text files but sometimes contain unusual codes. LO (3.6.5.2 on Vista) seems to handle some values in cells inconsistently ... open a new spreadsheet: set A2 =CHAR(127) set A3 =A1=A2 set A4 =A2= A3 contains FALSE A4

Re: [libreoffice-users] Re: Am I the only one with Err 522 problems?

2013-04-24 Thread Johnny Rosenberg
2013/4/24 Alex Thurgood alex.thurg...@gmail.com: Le 02/04/2013 19:48, Johnny Rosenberg a écrit : Hi Johnny, Just a few thoughts in an attempt to narrow down the problem : - which version of OpenOffice.org did you originally use to create the file ? I am not sure, but I have four of these

[libreoffice-users] Re: Am I the only one with Err 522 problems?

2013-04-24 Thread Alexander Thurgood
Le 24/04/13 18:51, Johnny Rosenberg a écrit : Hi Johnny, Thanks for the detailed input. I'm afraid I don't have the solution to your woes, but if I have understood correctly G320, where your error appears, relies on B320 which in turn relies on execution of a macro in order to update its value

Re: [libreoffice-users] Re: Am I the only one with Err 522 problems?

2013-04-24 Thread Steve Edmonds
Hi. On 2013-04-25 04:51, Johnny Rosenberg wrote: 2013/4/24 Alex Thurgood alex.thurg...@gmail.com: Le 02/04/2013 19:48, Johnny Rosenberg a écrit : Hi Johnny, Just a few thoughts in an attempt to narrow down the problem : - which version of OpenOffice.org did you originally use to create the

RE: [libreoffice-users] Re: Using a Button to activate Subform. Relationships

2013-04-24 Thread Supiramani Supiramani
Thanks !! You're a Samaritan !! Date: Mon, 22 Apr 2013 12:34:28 +0100 From: tomdavie...@yahoo.co.uk Subject: Re: [libreoffice-users] Re: Using a Button to activate Subform. Relationships To: elderdanle...@gmail.com; users@global.libreoffice.org Hi :) There seemed to be tons of

Re: [libreoffice-users] RE: How to grab web data into libre office calc ? Or Addons to grab specific web data into libre calc

2013-04-24 Thread Tom Davies
Hi :) Definitely ask the question again then so it gets back to the question you need rather than the confused tangle of tangents we went through there.  Also worth posting the same question in a few other forums or mailing lists if you can find any appropriate.  I would be tempted to ask on

Re: [libreoffice-users] How to downgrade from 4.0.2. to 3.6.6

2013-04-24 Thread Steve Edmonds
On 2013-04-25 08:09, M Henri Day wrote: 2013/4/23 Steve Edmonds steve.edmo...@ptglobal.com mailto:steve.edmo...@ptglobal.com Hi. I have had this with EPS drawings (with/without preview) for a long time. For those to not cause a problem I turn off OptionsLoad/SaveGeneralSave