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

[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 Sys.Admins  rather than being completely 
unpredictable.  Patches and updates do sometimes break things so it's nice to 
know when they are going to happen.  Obviously if there is a really serious 
threat that they develop a patch for they sometimes release it asap rather than 
waiting but for the most part they stick to holding patches back until the next 
Tuesday.  

I suspect it's more to do with rebooting, or perhaps just restarting just LO 
after turning off the auto back-ups.  
Anyway, congrats and regards from 
Tom :)  





>
> From: William Drago 
>To: users@global.libreoffice.org 
>Sent: Wednesday, 24 April 2013, 2:51
>Subject: Re: [libreoffice-users] How to downgrade from 4.0.2. to 3.6.6
> 
>
>The problem is solved. I increased memory as was suggested 
>and that fixed it. The strange thing is, I reverted back to 
>the old memory settings and it's still fixed. Don't know 
>why. There was a Windows update this evening. I wonder if 
>that had anything to do with it and it wasn't a LO issue at all?
>
>-Bill
>
>
>On 4/23/2013 4:50 PM, Upscope wrote:
>> On Tuesday, April 23, 2013 08:10:49 PM Tom Davies wrote:
>>> Hi :)
>>> Steve!  I think that was the trick the Docs Team mentioned!  Turn off
>>> the auto-back-ups and stuff.  Just remember to save often and make
>>> your own back-ups.  Regards from
>>> Tom :)
>> Turned off everything on the options/load-save/general page, still no
>> help.
 

 From: Steve Edmonds 

 To: William Drago 
 Cc: users@global.libreoffice.org
 Sent: Tuesday, 23 April 2013, 19:58
 Subject: Re: [libreoffice-users] How to downgrade from 4.0.2. to
 3.6.6


 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
 Options>Load/Save>General>Save auto recovery information.
 Just a suggestion, you could give it a try.
 Steve

 On 2013-04-23 22:21, William Drago wrote:
> Well, I may wait for 4.0.3 and see if that fixes anything. I did
> check the bugs list and I don't see my specific bug mentioned, but
> it may manifest itself in different ways, so maybe it will be
> fixed in 4.0.3.
>
> The bug that makes LO 4 unusable for me is drawings no longer save
> when pasted into Writer (exit LO, re-open the document, and the
> drawings are gone). A significant amount of my work involves making
> drawings in LO Draw and using them in Writer documents. What I have
> been doing as a workaround is pasting screenshots of the drawings
> into Writer.
>
> Thanks for all the replies...
>
> -Bill
>
> On 4/23/2013 4:58 AM, Tom Davies wrote:
>> Hi :)
>> I found this link on the official website
>> http://www.libreoffice.org/download/pre-releases/
>> I got there from the main website
>> http://www.libreoffice.org/
>> then the trail
>> "Main website" - "Get involved" - "QA"
>>
>> got me to
>>
>> http://www.libreoffice.org/get-involved/qa-testers/
>>
>>
>>
>> Hmm, you caught me out.  What i described is what i wish i did and
>> i
>> keep promising myself i will do next time, this time, each time
>> but
>> never quite get around to it.  Errr, well tried the 4.0.0 fairly
>> early but really liked it and stuck with it.  I was going to hunt
>> around the different articles published at the time to solve
>> problems
>> raised in their various lists of comments.  A few seemed so very
>> trivial that it made me wonder if the commenter had ever installed
>> anything before.  Sadly i didn't even get through that let alone
>> helping with testing out listed bugs.  So, this time i really have
>> downloaded the beta. Hopefully my good intentions wont get so
>> side-tracked this time!
>>
>>
>> Regards from
>>
>> Tom :)
>>
>>> 
>>> From: Upscope 
>>> To: users@global.libreoffice.org
>>> Sent: Tuesday, 23 April 2013, 1:27
>>>
>>> 
>>>
>>>
>>> Do you have a link to the beta versions? I have the opensuse
>>> version of 4.0.2 with latest update (yesterday) and 4.0.2 from
>>> LibreOffice parallel
>>> installed. Both had same two major problems for me since my
>>> cleints now usually send .docx documents and I do alot of table
>>> formatting with the number formatting columns, some of it
>>> doesn't work again.
>>>
>>> If I could get a hold of 4.0.3 and if it still has the problems
>>> I'll
>>> report them again as bugs.
 --
>>>

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

[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 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?


Thanks for any help, because it will be important to get this right as I 
have just (successfully) advocated that the charity she works for adopts 
LibO in favour of MS Office. If the HMRC cannot read CSV files saved in 
LibO, then this will be a deal breaker for the charity as they have to 
submit such files regularly.


Cheers

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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?



Sorry if I appear a bit dim, but CSV literally stands for Comma 
Separated Values, with a line feed/carriage return symbol at the end of 
each line. Unix and MS-DOS line feeds/newline commands are different, 
e.g. Unix relies on \n to indicate a newline, whereas MS-DOS (and 
Windows) relies on \n\r (or LF/CR). Is this the type of formatting you 
are looking for ?


What exactly are the errors that your wife sees when opening the CSV 
file in Excel ?



Alex


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Tom]

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 change it back.  Mostly
that is not a worry because , is the most commonly used delimited.  Tabs or
spaces are sometimes used but then it's usually called a tsv. 
csv = comma separated values
tsv = tab separated values

For "Text delimiter" the usual standard choice is ".  If it's not then that
might be seen as an error.  That might also need you to tick the box "Quote
all text cells" which is not set by default so that is possibly the most
likely problem you are having. 

Given that it's an English government bureaucracy it is highly likely that
they are asking for one thing but expecting something completely different. 
Also it is quite possible that your local version of Excel is misbehaving. 
It offers similar choices but the crucial one that goes wrong there is
"Character Set" needs to be "Unicode Utf-8", i think, at least in our
country most of the time. 

Given that the file is going to HMRC i guess you can't upload a copy to
Nabble to let us have a look but is it possible to give us a small test-file
just to see if we can spot what's going wrong?


The line-ending issue might be a red herring if you are using Windows.  It
only comes into play if you are using LibreOffice on Gnu&Linux (such as
Ubuntu/Mint, openSUSE, Mageia, Fedora, Android or whatever version).  Are
you using something other than Windows?  
Regards from
Tom :)  



--
View this message in context: 
http://nabble.documentfoundation.org/csv-formats-and-MS-DOS-CSV-formats-tp4052046p4052070.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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_ShowContent&id=HMCE_PROD_010685&propertyType=document


gives a list on how to structure the file and hints on what to do if 
your CSV submission fails, e.g. if leading zeroes get dropped or if 
NULL/0 values get replaced with nothing (as is the case with 
LibreOffice). The solution to those particular problems is to enter the 
data as a text string (by putting a leading apostrophe, for example).


That same page also recommends not working on your CSV file directly, 
and in particular not to re-open it in your spreadsheet program (Excel 
cited in that particular case) !!



Alex


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 procedure
that she needs to attend to?



Sorry if I appear a bit dim, but CSV literally stands for Comma 
Separated Values, with a line feed/carriage return symbol at the end 
of each line. Unix and MS-DOS line feeds/newline commands are 
different, e.g. Unix relies on \n to indicate a newline, whereas 
MS-DOS (and Windows) relies on \n\r (or LF/CR). Is this the type of 
formatting you are looking for ?


What exactly are the errors that your wife sees when opening the CSV 
file in Excel ?



Alex



Hi Alex

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.


The file was originally saved on a Windows machine as a *.csv dos 
format, and was opened in LibO which was fine (except the worksheet tab 
wasn't named as it had been in the original and instead labelled it 
merely as "Sheet 1"). Then she saved the same file from LibO using the 
*csv save option (because LibO doesn't give any further *csv options) 
and tested it by opening it up in Excel. At that point, she saw that 
some of the text in the file was now represented by squares, but overall 
the text wasn't separated out (i.e. NOT comma separated) and the fields 
ran together as one paragraph, including headers and content.


So it could be that LibO is not saving the DOS newline formatting, in 
which case I need to brief her on how she can set that up when saving in 
LibO and (preferably even) to automate that. I've reviewed the Calc 
extensions and don't see anything - so is this an opportunity for a hack 
perhaps?


Anyway, I hope all of this makes some kind of sense?

Cheers

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 done on Windows as
the LF/CR is usually the default for all applications that have to
insert linefeeds into files. You can sometimes run into problems when
saving from other OSes, e.g. Mac OSX or Linux, as the default linefeed
newline commands are different.

> 
> The file was originally saved on a Windows machine as a *.csv dos
> format, and was opened in LibO which was fine (except the worksheet tab
> wasn't named as it had been in the original and instead labelled it
> merely as "Sheet 1"). Then she saved the same file from LibO using the
> *csv save option (because LibO doesn't give any further *csv options)
> and tested it by opening it up in Excel. At that point, she saw that
> some of the text in the file was now represented by squares, but overall
> the text wasn't separated out (i.e. NOT comma separated) and the fields
> ran together as one paragraph, including headers and content.

This sounds pretty grim. As Tom has mentioned, select only the comma
separator for the values when you "save as" CSV, there is an option for
this in the save dialog called "Edit Filter Settings". This brings up a
dialog called "Export Text File", where you can play around with the
export filter settings. This might solve your wife's problem. If not,
then there is a possibility that the problem is indeed a bug in
LibreOffice or a missing feature in the filter export settings.



Alex














-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 change it back.  Mostly
that is not a worry because , is the most commonly used delimited.  Tabs or
spaces are sometimes used but then it's usually called a tsv.
csv = comma separated values
tsv = tab separated values

For "Text delimiter" the usual standard choice is ".  If it's not then that
might be seen as an error.  That might also need you to tick the box "Quote
all text cells" which is not set by default so that is possibly the most
likely problem you are having.

Given that it's an English government bureaucracy it is highly likely that
they are asking for one thing but expecting something completely different.
Also it is quite possible that your local version of Excel is misbehaving.
It offers similar choices but the crucial one that goes wrong there is
"Character Set" needs to be "Unicode Utf-8", i think, at least in our
country most of the time.

Given that the file is going to HMRC i guess you can't upload a copy to
Nabble to let us have a look but is it possible to give us a small test-file
just to see if we can spot what's going wrong?


The line-ending issue might be a red herring if you are using Windows.  It
only comes into play if you are using LibreOffice on Gnu&Linux (such as
Ubuntu/Mint, openSUSE, Mageia, Fedora, Android or whatever version).  Are
you using something other than Windows?
Regards from
Tom :)




Hi Tom

My wife sent me the file in question, saved on a MS machine as a CSV DOS 
format file.


I opened it LibO on a GNU/Linux machine and saved as a *csv file. The 
only change I made was to its name, I renamed it.


I sent this file back. She opened it on a MS machine using Excel and the 
initial problem was repeated.


When saving it in LibO, there is no option to specify any parameters as 
your reply suggested (although there was when I opened it in LibO). When 
she opens it in Excel, there is no options about parameters, nor are 
there any once the file is opened.


The file (MS readable) becomes MS-unreadable once it has been opened and 
saved in LibO (on a GNU/Linux machine) although I think also on a MS 
machine running LibO, so I'm not sure about the platform, but think 
rather that it has to do with some parameter MS DOS CSV format imposes 
that LibO doesn't allow for.


Cheers

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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_ShowContent&id=HMCE_PROD_010685&propertyType=document 




gives a list on how to structure the file and hints on what to do if 
your CSV submission fails, e.g. if leading zeroes get dropped or if 
NULL/0 values get replaced with nothing (as is the case with 
LibreOffice). The solution to those particular problems is to enter 
the data as a text string (by putting a leading apostrophe, for example).


That same page also recommends not working on your CSV file directly, 
and in particular not to re-open it in your spreadsheet program (Excel 
cited in that particular case) !!



Alex




Hi Alex & list

I got it wrong - this was a pensions trust submission, not HMRC. My bad.

In any event - I think I may have solved this.

My test was this:

My wife sent me the file created and saved on MS as *.csv DOS. I opened 
it on GNU/Linux LibO. This opened a dialogue box and I ensured that the 
UTF-8 was the default encoding, and under the section that reads 
Separated By, all boxes were blanked except for comma, and that the text 
delimiter is ".


I edited this file, saved it under a new-name.csv and selected Edit 
Filter Settings in the Save As dialogue box, reviewed my selection and 
saved.


My wife opened this new-name.csv file in Windows Excel and it was fine 
... so I guess that the changes need to be made at the front end when 
opening the file in LibO and then double checked at the time of saving.


This sounds like this will work for the charity concerned, so hopefully 
this will be the solution that satisfies the Pensions Trust as well.


Cheers all - appreciate the promptness of your replies and the quality 
of your help.




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 release it asap rather than waiting ...


The update to some versions of Windows yesterday (er, that was 
Tuesday but not Patch Tuesday) was to replace one that was issued two 
weeks earlier (on Patch Tuesday - are you following?) but was 
withdrawn two days later when it was found to be defective.  Hence 
the current out-of-band publication.


... but for the most part they stick to holding patches back until 
the next Tuesday.


Er, the next *Patch* Tuesday.


I suspect it's more to do with rebooting, ...


Exactly so.

Brian Barker


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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_ShowContent&id=HMCE_PROD_010685&propertyType=document 




gives a list on how to structure the file and hints on what to do if 
your CSV submission fails, e.g. if leading zeroes get dropped or if 
NULL/0 values get replaced with nothing (as is the case with 
LibreOffice). The solution to those particular problems is to enter 
the data as a text string (by putting a leading apostrophe, for example).


That same page also recommends not working on your CSV file directly, 
and in particular not to re-open it in your spreadsheet program (Excel 
cited in that particular case) !!



Alex


Reading the link, I second the procedure of working on the spreadsheet 
format then saving as csv. I suspect they are uploading to a database 
using a script that expects a Windows end-of-line only (or they think it 
will only take a Windows end-of-line).


Try passing the spreadsheet back and forth they due a final save to csv 
on the Windows machine.


I have see the character encoding go wacky and have to be reset to 
properly import a csv into Calc on occasion. Excel may be expecting a 
different character set than UTF-8.


--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 than when it's 
actually in front of you.  Either way it's fairly easy to deal with.  

Mailing lists are quite variable.  You caught us at a good time with a good 
topic, although i guess that does happen a lot so thanks for the thanks :)    
Regards from 
Tom :)  





>
> From: sun shine 
>To: users@global.libreoffice.org 
>Sent: Wednesday, 24 April 2013, 15:41
>Subject: Re: [libreoffice-users] Re: *.csv formats and MS DOS CSV formats
> 
>
>
>
>
>
>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_ShowContent&id=HMCE_PROD_010685&propertyType=document
>>  
>>
>>
>>
>> gives a list on how to structure the file and hints on what to do if 
>> your CSV submission fails, e.g. if leading zeroes get dropped or if 
>> NULL/0 values get replaced with nothing (as is the case with 
>> LibreOffice). The solution to those particular problems is to enter 
>> the data as a text string (by putting a leading apostrophe, for example).
>>
>> That same page also recommends not working on your CSV file directly, 
>> and in particular not to re-open it in your spreadsheet program (Excel 
>> cited in that particular case) !!
>>
>>
>> Alex
>>
>>
>
>Hi Alex & list
>
>I got it wrong - this was a pensions trust submission, not HMRC. My bad.
>
>In any event - I think I may have solved this.
>
>My test was this:
>
>My wife sent me the file created and saved on MS as *.csv DOS. I opened 
>it on GNU/Linux LibO. This opened a dialogue box and I ensured that the 
>UTF-8 was the default encoding, and under the section that reads 
>Separated By, all boxes were blanked except for comma, and that the text 
>delimiter is ".
>
>I edited this file, saved it under a new-name.csv and selected Edit 
>Filter Settings in the Save As dialogue box, reviewed my selection and 
>saved.
>
>My wife opened this new-name.csv file in Windows Excel and it was fine 
>... so I guess that the changes need to be made at the front end when 
>opening the file in LibO and then double checked at the time of saving.
>
>This sounds like this will work for the charity concerned, so hopefully 
>this will be the solution that satisfies the Pensions Trust as well.
>
>Cheers all - appreciate the promptness of your replies and the quality 
>of your help.
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 contains TRUE

Surely A3 and A4 should be the same, since A1 contains the null string.

I have tried reporting the behaviour of LO in this area before(bug 
58838), with the reply below.

>>>

mariosv 2012-12-29 01:06:05 UTC
Hi David,

I think for this and other cases is there the EXACT() function, which is 
always false comparing any character against null, except with a blank cell.
I guess the soft hyphenation has a special meaning, so it is treated as 
null.

I do not think this is a bug.

>
According to the documentation for function CHAR, A2=CHAR(127) should be 
a text character which
doesn't depend on the system mapping. This appears to work and 
ISTEXT(A2) returns TRUE.


My questions are:

1. Is the behaviour above a bug?
2. If some character codes have a "special meaning" (as suggested by 
Mariosv), is this documented? If so, where? The ODF documentation copied 
below (ver 1.2) seems to imply that there are no special meanings and 
that in the above example A4 should be FALSE, and LO is violating the 
ODF specification.

>


 6.4.7Infix Operator "="

Summary: Report if two values are equal

Syntax: Scalar Left = Scalar Right

Returns: Logical

Constraints: None

Semantics: Returns TRUE if two values are equal. If the values differ in 
type, return FALSE. If the values are both Number, return TRUE if they 
are considered equal, else return FALSE. If they are both Text, return 
TRUE if the two values match, else return FALSE. For Text values, if the 
calculation setting HOST-CASE-SENSITIVE is false, text is compared but 
characters differencing only in case are considered equal. If they are 
both Logicals, return TRUE if they are identical, else return FALSE. 
Error values cannot be compared to a constant Error value to determine 
if that is the same Error value.


Evaluators may approximate and test equality of two numeric values with 
an accuracy of the magnitude of the given values scaled by the number of 
available bits in the mantissa, ignoring some least significant bits and 
thus providing compensation for not exactly representable values.


The result of “1=TRUE()” is FALSE for evaluators that implement a 
distinct Logical type and TRUE if they don't.






David Lynch





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Johnny Rosenberg]

2013/4/24 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
> ?

I am not sure, but I have four of these files, one for each year (one
year is about 3000 rows in average and the whole thing were just too
slow for using the same file for many years), so the first one was
made in 2010, and I think it was LibreOffice, but I'm not sure. If
LibreOffice, it must have been one of the first versions, which one
was that? 3.2?

> - the cells that show Err 522, do they have a particular formula that
> requires recalculation ?

I'll open it and have a look…
Okay, it's open and now I can see that all my formatting of column A
is… gone?? Thank you, LibreOffice, or maybe Apache OpenOffice? I
fiddled with the file with both suites yesterday, but I think I used
LibreOffice last time I opened it…
I'll open it with Apache OpenOffice… Done. Column A formatted OK. Strange…

I know I have had that problem before with LibreOffice, that some
formatting (conditional formatting) are suddenly gone, so I guess I
should stay with Apache OpenOffice for at least that file…

Anyway, back to your question…
The first cell with Err:522 when I open the file now, is G320. The
formula is (translated to English):
=IF($E320="";"";IF($B320=G$1;$C320+G319+STYLE("Time");IF(INTEGER($A320)>INTEGER($A319);0+STYLE("Hide");G319+STYLE("Hide"
”Hide” is a style that hides the text with white characters and
white background. It just make it look a lot better and easier to
follow.
”Time” is for displaying time correctly, in this case H:MM:SS. All
other settings are the same as the default style, I think.

All rows looks the same (except maybe the first one), here are the
rest of its columns, in this case one row 320:
A320: 2013-02-07 11:40:33
Just date and time following ISO-8601, which is very close to the
Swedish date- and time format.
B320: =WORK(A320;B319)
WORK looks like this:

REM * Basic *
Option Explicit

Function Work(CurrentTime As Date,PrevWork As String) As String
If CurrentTime=0 Then
Work=""
ElseIf TimeValue(CurrentTime)"Arrival" Then
Work="Arrival"
ElseIf TimeValue(CurrentTime)>TimeValue("10:40:00") And _
TimeValue(CurrentTime)"Lunch" Then
Work="Lunch"
ElseIf TimeValue(CurrentTime)>TimeValue("15:40:00") Then
Work="Going home"
ElseIf PrevWork<>"Transport" Then
Work="Transport"
Else
Work="Enter customer, supplier or place"
EndIf
End Function
REM * End of code *

C320: =IF(OR(A321=0;A321INTEGER(A320);"";A321-A320))
D320: 
The D column is for comments only, so most of the rows are empty,
the rest are pure text, no formulas.
E320: 
=IF(E319="";C320;IF(OR(DAY(A321)>DAY(A320);C320="");"";IF(OR(B320="Lunch";B320="Doctor's
appointment");E319;C320+E319)))
F320: 
=IF($E320="";"";IF($B320=F$1;$C320+F319+STYLE("Time");IF(INTEGER($A320)>INTEGER($A319);0+STYLE("Hide");F319+STYLE("Hide"
And finally, the already mentioned formula, in which the first
Err:522 occurs this time (not the same cell every time I open the
document):
G320: 
=IF($E320="";"";IF($B320=G$1;$C320+G319+STYLE("Time");IF(INTEGER($A320)>INTEGER($A319);0+STYLE("Hide");G319+STYLE("Hide"

Now, I select G320, Ctrl+ Ctrl+v. Poff – all error messages are gone…
(and replaced with the expected values).

Well, that's probably just about it.


> - if there is a formula in these cells, does it involve calculating strings
> with en empty, NULL or Zero value ?

I try to prevent that with the IF(SomeCell="";"";DoSomething), see the
formulas above. I think I covered all possible situations, but I'm not
100 % sure, of course.

>
>
> Alex

Thank you, for trying to help.


Johnny Rosenberg

>
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 and commit that to B320 ?

This may be where things are going cumulatively wrong in terms of
performance, as LO's behaviour was modified (some time after 3.3.x and
during 3.4.x development, I seem to recall) not to automatically update
cell calculations. So, and this is just a hypothesis, your reference to
the macro for the calculation may be causing the error message to
display until the sheet is either recalculated, or receives a redraw
call, which still always seems to happen whenever you copy/paste the
cell contents.

Note that you are not the first person to notice a degradation in Calc
performance/updating, so you are not alone, but the conditions under
which this can happen seem to vary quite widely.

Alex


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Steve Edmonds]

Hi.
On 2013-04-25 04:51, Johnny Rosenberg wrote:

2013/4/24 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
?

I am not sure, but I have four of these files, one for each year (one
year is about 3000 rows in average and the whole thing were just too
slow for using the same file for many years), so the first one was
made in 2010, and I think it was LibreOffice, but I'm not sure. If
LibreOffice, it must have been one of the first versions, which one
was that? 3.2?


- the cells that show Err 522, do they have a particular formula that
requires recalculation ?

I'll open it and have a look…
Okay, it's open and now I can see that all my formatting of column A
is… gone?? Thank you, LibreOffice, or maybe Apache OpenOffice? I
fiddled with the file with both suites yesterday, but I think I used
LibreOffice last time I opened it…
I'll open it with Apache OpenOffice… Done. Column A formatted OK. Strange…

I know I have had that problem before with LibreOffice, that some
formatting (conditional formatting) are suddenly gone, so I guess I
should stay with Apache OpenOffice for at least that file…

Anyway, back to your question…
The first cell with Err:522 when I open the file now, is G320. The
formula is (translated to English):
=IF($E320="";"";IF($B320=G$1;$C320+G319+STYLE("Time");IF(INTEGER($A320)>INTEGER($A319);0+STYLE("Hide");G319+STYLE("Hide"
 ”Hide” is a style that hides the text with white characters and
white background. It just make it look a lot better and easier to
follow.
 ”Time” is for displaying time correctly, in this case H:MM:SS. All
other settings are the same as the default style, I think.

All rows looks the same (except maybe the first one), here are the
rest of its columns, in this case one row 320:
A320: 2013-02-07 11:40:33
 Just date and time following ISO-8601, which is very close to the
Swedish date- and time format.
B320: =WORK(A320;B319)
 WORK looks like this:

REM * Basic *
Option Explicit

Function Work(CurrentTime As Date,PrevWork As String) As String
 If CurrentTime=0 Then
 Work=""
 ElseIf TimeValue(CurrentTime)"Arrival" Then
 Work="Arrival"
 ElseIf TimeValue(CurrentTime)>TimeValue("10:40:00") And _
 TimeValue(CurrentTime)"Lunch" Then
 Work="Lunch"
 ElseIf TimeValue(CurrentTime)>TimeValue("15:40:00") Then
 Work="Going home"
 ElseIf PrevWork<>"Transport" Then
 Work="Transport"
 Else
 Work="Enter customer, supplier or place"
 EndIf
End Function
REM * End of code *

C320: =IF(OR(A321=0;A321INTEGER(A320);"";A321-A320))
D320: 
 The D column is for comments only, so most of the rows are empty,
the rest are pure text, no formulas.
E320: 
=IF(E319="";C320;IF(OR(DAY(A321)>DAY(A320);C320="");"";IF(OR(B320="Lunch";B320="Doctor's
appointment");E319;C320+E319)))
F320: 
=IF($E320="";"";IF($B320=F$1;$C320+F319+STYLE("Time");IF(INTEGER($A320)>INTEGER($A319);0+STYLE("Hide");F319+STYLE("Hide"
 And finally, the already mentioned formula, in which the first
Err:522 occurs this time (not the same cell every time I open the
document):
G320: 
=IF($E320="";"";IF($B320=G$1;$C320+G319+STYLE("Time");IF(INTEGER($A320)>INTEGER($A319);0+STYLE("Hide");G319+STYLE("Hide"

Now, I select G320, Ctrl+ Ctrl+v. Poff – all error messages are gone…
(and replaced with the expected values).

Well, that's probably just about it.



- if there is a formula in these cells, does it involve calculating strings
with en empty, NULL or Zero value ?

I try to prevent that with the IF(SomeCell="";"";DoSomething), see the
formulas above. I think I covered all possible situations, but I'm not
100 % sure, of course.



Alex

Thank you, for trying to help.


Johnny Rosenberg




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
I am sure you have tried, but did F9  or Shift+Ctrl+F9 do the trick. A 
quick search shows some discussion on failure to recalculate.

Steve

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 things at 
> http://wiki.openoffice.org/wiki/Database
> that might be worth looking into
> Regards from 
> Tom :)
> 
> 
> 
> 
> 
> >
> > From: Dan Lewis 
> >To: users@global.libreoffice.org 
> >Sent: Monday, 22 April 2013, 11:37
> >Subject: Re: [libreoffice-users] Re: Using a Button to activate Subform. 
> >Relationships
> > 
> >
> >On 04/22/2013 03:26 AM, Ian Whitfield wrote:
> >1) Dan - can you give me an address/link for the "Base Tutorial" by Mariano 
> >Casanova you mention??
> >
> >
> >If you search for "Base Tutorial by Mariano Casanova" (without the quotes), 
> >you will get the link you need. When I did, the top link opened the PDF of 
> >this document.
> >
> >--Dan
> >
> >-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> >Problems? 
> >http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> >List archive: http://listarchives.libreoffice.org/global/users/
> >All messages sent to this list will be publicly archived and cannot be 
> >deleted
> >
> >
> >
> >
> -- 
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
  
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Happylibre]

Thanks for the help

Very kind of you to ask again

I am yet t get a completely satisfactory answer 



Regards

Date: Tue, 23 Apr 2013 03:55:42 -0700
From: ml-node+s969070n4051781...@n3.nabble.com
To: hisupiram...@hotmail.com
Subject: Re: How to grab web data into libre office calc ? Or Addons to grab
specific web data into libre calc



Hi :)

Did you ever get a satisfactory answer?  All my stuff seemed to be work-arounds 
or completely off-topic.  Hopefully helpful but not dealing with the original 
question.  

Regards from

Tom :)  






>

> From: Happylibre <[hidden email]>

>To: [hidden email] 

>Sent: Friday, 19 April 2013, 18:25

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

> 

>

>Just after posting the request I read the following page

>https://help.libreoffice.org/Calc/Inserting_External_Data_in_Table_WebQuery#Editing_the_external_data
>

>But that page is talking of entire pages 

>

>Not just a few cells for web pages 

>

>Or probably I haven't understood what's on

>https://help.libreoffice.org/Calc/Inserting_External_Data_in_Table_WebQuery#Editing_the_external_data
>

>

>

>

>--

>View this message in context: 
>http://nabble.documentfoundation.org/How-to-grab-web-data-into-libre-office-calc-Or-Addons-to-grab-specific-web-data-into-libre-calc-tp4051120p4051122.html
>Sent from the Users mailing list archive at Nabble.com.

>

>-- 

>For unsubscribe instructions e-mail to: [hidden email]

>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted

>

>

>

>
-- 

For unsubscribe instructions e-mail to: [hidden email]

Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted













If you reply to this email, your message will be added to the 
discussion below:

http://nabble.documentfoundation.org/How-to-grab-web-data-into-libre-office-calc-Or-Addons-to-grab-specific-web-data-into-libre-calc-tp4051120p4051781.html



To unsubscribe from How to grab web data into libre office calc 
? Or Addons to grab specific web data into libre calc, click here.

NAML
  



--
View this message in context: 
http://nabble.documentfoundation.org/RE-How-to-grab-web-data-into-libre-office-calc-Or-Addons-to-grab-specific-web-data-into-libre-calc-tp4052157.html
Sent from the Users mailing list archive at Nabble.com.
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 the Websites List 
here.
Apols and regards from 
Tom :)  





>
> From: Happylibre 
>To: users@global.libreoffice.org 
>Sent: Wednesday, 24 April 2013, 20:26
>Subject: [libreoffice-users] RE: How to grab web data into libre office calc ? 
>Or Addons to grab specific web data into libre calc
> 
>
>Thanks for the help
>
>Very kind of you to ask again
>
>I am yet t get a completely satisfactory answer 
>
>
>
>Regards
>
>Date: Tue, 23 Apr 2013 03:55:42 -0700
>From: ml-node+s969070n4051781...@n3.nabble.com
>To: hisupiram...@hotmail.com
>Subject: Re: How to grab web data into libre office calc ? Or Addons to grab   
> specific web data into libre calc
>
>
>
>    Hi :)
>
>Did you ever get a satisfactory answer?  All my stuff seemed to be 
>work-arounds or completely off-topic.  Hopefully helpful but not dealing with 
>the original question.  
>
>Regards from
>
>Tom :)  
>
>
>
>
>
>
>>
>
>> From: Happylibre <[hidden email]>
>
>>To: [hidden email] 
>
>>Sent: Friday, 19 April 2013, 18:25
>
>>Subject: [libreoffice-users] Re: How to grab web data into libre office calc 
>>? Or Addons to grab specific web data into libre calc
>
>> 
>
>>
>
>>Just after posting the request I read the following page
>
>>https://help.libreoffice.org/Calc/Inserting_External_Data_in_Table_WebQuery#Editing_the_external_data
>>
>
>>But that page is talking of entire pages 
>
>>
>
>>Not just a few cells for web pages 
>
>>
>
>>Or probably I haven't understood what's on
>
>>https://help.libreoffice.org/Calc/Inserting_External_Data_in_Table_WebQuery#Editing_the_external_data
>>
>
>>
>
>>
>
>>
>
>>--
>
>>View this message in context: 
>>http://nabble.documentfoundation.org/How-to-grab-web-data-into-libre-office-calc-Or-Addons-to-grab-specific-web-data-into-libre-calc-tp4051120p4051122.html
>>Sent from the Users mailing list archive at Nabble.com.
>
>>
>
>>-- 
>
>>For unsubscribe instructions e-mail to: [hidden email]
>
>>Problems? 
>>http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>List archive: http://listarchives.libreoffice.org/global/users/
>>All messages sent to this list will be publicly archived and cannot be deleted
>
>>
>
>>
>
>>
>
>>
>-- 
>
>For unsubscribe instructions e-mail to: [hidden email]
>
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
>    
>    
>    
>    
>
>    
>
>    
>    
>        If you reply to this email, your message will be added to the 
>discussion below:
>        
>http://nabble.documentfoundation.org/How-to-grab-web-data-into-libre-office-calc-Or-Addons-to-grab-specific-web-data-into-libre-calc-tp4051120p4051781.html
>    
>    
>        
>        To unsubscribe from How to grab web data into libre office calc ? Or 
>Addons to grab specific web data into libre calc, click here.
>
>        NAML
>                               
>
>
>
>--
>View this message in context: 
>http://nabble.documentfoundation.org/RE-How-to-grab-web-data-into-libre-office-calc-Or-Addons-to-grab-specific-web-data-into-libre-calc-tp4052157.html
>Sent from the Users mailing list archive at Nabble.com.
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Preparing mailing labels from list (database)

[Muriel Parker]

(no subject)





:
Preparing mailing labels from list

Tony and Steve-

I went to Tools, Options, Java -  the JRE is checked.  There is nothing in
the box below.  My list is in spreadsheet form - name, street, town -
LibreOffice calc.  I have it in both .odb and .ods.  Other suggestions?

Muriel

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Steve Edmonds]

On 2013-04-25 08:09, M Henri Day wrote:
2013/4/23 Steve Edmonds >


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
Options>Load/Save>General>Save auto recovery information.
Just a suggestion, you could give it a try.
Steve

On 2013-04-23 22:21, William Drago wrote:

Well, I may wait for 4.0.3 and see if that fixes anything. I
did check the bugs list and I don't see my specific bug
mentioned, but it may manifest itself in different ways, so
maybe it will be fixed in 4.0.3.

The bug that makes LO 4 unusable for me is drawings no longer
save when pasted into Writer (exit LO, re-open the document,
and the drawings are gone). A significant amount of my work
involves making drawings in LO Draw and using them in Writer
documents. What I have been doing as a workaround is pasting
screenshots of the drawings into Writer.

Thanks for all the replies...

-Bill


Disabling the Save auto recovery info option did the trick for me in 
Writer Version 4.0.2.2 (Build ID: 
4c82dcdd6efcd48b1d8bba66bfe1989deee49c3) on 64-bit Ubuntu 12.04. Nice !...


Henri
Do you think it should be in the manual as it seems to have been around 
since 2.4, I am sure it would help a lot of people to know.

Steve


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted