[libreoffice-users] caption numbering positioning
Readers, The default behaviour of the 'caption' feature is to place the category text ('illustration') after the numbering symbol (arabic number). How to change so that the category text is by default before the numbering symbol? 'Figure 1' is preferred to '1 Figure' ! :) -- 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] caption numbering positioning
At 10:07 21/12/2012 +0200, Nobody Noname wrote: The default behaviour of the 'caption' feature is to place the category text ('illustration') after the numbering symbol (arabic number). Is it? How to change so that the category text is by default before the numbering symbol? 'Figure 1' is preferred to '1 Figure' ! :) Are you using AutoCaption? If so, go to Tools | Options... | LibreOffice Writer | AutoCaption and change the selection in the drop-down list for Caption order. Are you adding captions manually? In the Caption dialogue, click Options... and again change the selection in the drop-down list for Caption order.. I trust this helps. 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] caption numbering positioning
Indeed the example is the preferred version. The other one doesn't really make sense. On 2012-12-21 17:07, e-letter wrote: Readers, The default behaviour of the 'caption' feature is to place the category text ('illustration') after the numbering symbol (arabic number). How to change so that the category text is by default before the numbering symbol? 'Figure 1' is preferred to '1 Figure' ! :) -- 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] bugzilla report emails are including HTML
Hi, On Fri, Dec 21, 2012 at 2:43 AM, NoOp wrote: No response on the discuss list, so I'll try here. Why are the emailed bug reports also including HTML? [...] Bugzilla (log in) → (User) Preferences → General Preferences → Preferred email format - Site Default (HTML) - HTML - Text Only → Submit Changes mjk -- Logic Boat http://xkcd.com/1134/ -- 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] caption numbering positioning
Brian, thanks for the hint on where the setting needs to be done. On 2012-12-21 17:34, Brian Barker wrote: At 10:07 21/12/2012 +0200, Nobody Noname wrote: The default behaviour of the 'caption' feature is to place the category text ('illustration') after the numbering symbol (arabic number). Is it? How to change so that the category text is by default before the numbering symbol? 'Figure 1' is preferred to '1 Figure' ! :) Are you using AutoCaption? If so, go to Tools | Options... | LibreOffice Writer | AutoCaption and change the selection in the drop-down list for Caption order. Are you adding captions manually? In the Caption dialogue, click Options... and again change the selection in the drop-down list for Caption order.. I trust this helps. 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] Styles and regular expression in libreoffice
Hi all Thanks for your suggestion but it isn't a way I can walk. I have documents of more than 500 pages, if I must reformat all I never end I can't remove all formatting and start from scratch because it take too many time. I can't remove all blank paragraphs because many of them are useful. I can't use regex for automatize the work. It's really a sin. So well, I must work on Office Word first for formatting document and then convert it. I would want to work totally on libreoffice but it isn't possible evidently. Thanks to all Il 21/12/2012 02:27, anne-ology ha scritto: When I do this, nothing is lost except the formatting ... merely 'select all' - copy - paste to notepad - all the text will be there; just re-format everything and place back in line ;-) On Thu, Dec 20, 2012 at 10:56 AM, VA cuyfa...@hotmail.com wrote: This may not be much help, but when I have been faced with a converted file that was such a formatting mess, I would just save it as a plain text file and format from scratch, creating and applying the specific Styles I wanted. There are drawbacks to this, as you will lose some of your content, such as footnotes. Good luck. Virgil From: lordmax tdf Sent: Thursday, December 20, 2012 10:58 AM To: users@global.libreoffice.org Subject: [libreoffice-users] Styles and regular expression in libreoffice Hi all I'm on libreoffice 3.6 italian version I'm working on many ebook in epub format. Fortunately libreoffice has a great extension, writer2epub, who's wonderful My problem is that original files (word exported by indesign) are a mess with styles, fonts, etc Really a chaos. I need some way to get some works on styles via reg ex but I've found nothing, nor in the help, nor in the wiki, nor of useful on internet My first need is to modify lines before and after the chapter title. In my doc I've a blank line, a line with the chapter title and one or more blank lines all in header1 style I haven't found a way to select styles via regex and I can't simply change all the blank lines because they are in many different styles I've already searched on internet and in the libreoffice/openoffice forum but I haven't find any solutions. Can you help me? Thanks -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f Sponsor: Vuoi fare un regalo davvero originale? Su MisterCupido.com troverai centinaia di IDEE REGALO per tutte le tasche! Consegne in tutta Italia in soli 2-3 giorni Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=12387d=21-12 -- 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: typographic freaks: footnotes not vertically aligned to last line of body text in following page (as in good typographic style)
Hi :) It does take a while to get used to the lists. Odd weirdnesses are difficult to avoid especially at first. I missed the screenshot in the other part of the thread but probably it's just because i haven't got that far back yet. Regards from Tom :) From: NoOp gl...@sbcglobal.net To: users@global.libreoffice.org Sent: Friday, 21 December 2012, 1:47 Subject: [libreoffice-users] Re: typographic freaks: footnotes not vertically aligned to last line of body text in following page (as in good typographic style) On 12/20/2012 12:27 AM, siren wrote: On 20/12/12 Dan Lewis wrote: I thought I had seen something about this some time ago either on this mailing list of the A00 mailing list. The topic was Register true. [...] unfortunately, *register true* does not work in this case and can't help to preserve the right alignement of footnotes with last line of body test in following page. Try to believe current *register true* feature, only helps to keep together aligned between pages, BODY TEXT in page (only 1 paragraph style). Register true is calculated on a SINGLE PARAGRAPH STYLE, (this is a defective behavior, since if you write citations in smaller body, applying REGISTER TRUE, line spacing will be not coherent with font size) It's too bad that you couldn't manage to keep this in a single thread. I responded in the other thread provide a screenshot that shows the footnote in line with the page two text. -- 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
Re: [libreoffice-users] Styles and regular expression in libreoffice
Hi :) Styles and Templates are a really fast way of imposing new formatting after you have converted it all into plain text. It might sound like something that is going to take ages but you would be surprised at how fast you can get through it the way people are recommending. It surprised me! With Word i had often spent hours trying to un-mess documents from other people but Writer's use of styles makes it fast and simple. Another advantage with Writer's use of styles is that you can change the font throughout a document really quickly. Just right-click on the text body style and change the font there. Same with the default style and then as you go through other styles you have used you may find some have already changed automatically. I sometimes select a large area of text and force it to change style between a few different styles that i don't want the text to appear in and then settle it all as text-body. That usually clears a lot of the messes. Then just go through and select headings and sub-headings and set their style as heading1 or heading 2 or whatever is the appropriate level. See Chapter 3 in the Getting Started Guide as it probably has even faster ways of getting through the document https://wiki.documentfoundation.org/Documentation/Publications Good luck and regards from Tom :) From: lordmax tdf lordmax-...@email.it To: Cc: users@global.libreoffice.org Sent: Friday, 21 December 2012, 10:13 Subject: Re: [libreoffice-users] Styles and regular expression in libreoffice Hi all Thanks for your suggestion but it isn't a way I can walk. I have documents of more than 500 pages, if I must reformat all I never end I can't remove all formatting and start from scratch because it take too many time. I can't remove all blank paragraphs because many of them are useful. I can't use regex for automatize the work. It's really a sin. So well, I must work on Office Word first for formatting document and then convert it. I would want to work totally on libreoffice but it isn't possible evidently. Thanks to all Il 21/12/2012 02:27, anne-ology ha scritto: When I do this, nothing is lost except the formatting ... merely 'select all' - copy - paste to notepad - all the text will be there; just re-format everything and place back in line ;-) On Thu, Dec 20, 2012 at 10:56 AM, VA cuyfa...@hotmail.com wrote: This may not be much help, but when I have been faced with a converted file that was such a formatting mess, I would just save it as a plain text file and format from scratch, creating and applying the specific Styles I wanted. There are drawbacks to this, as you will lose some of your content, such as footnotes. Good luck. Virgil From: lordmax tdf Sent: Thursday, December 20, 2012 10:58 AM To: users@global.libreoffice.org Subject: [libreoffice-users] Styles and regular expression in libreoffice Hi all I'm on libreoffice 3.6 italian version I'm working on many ebook in epub format. Fortunately libreoffice has a great extension, writer2epub, who's wonderful My problem is that original files (word exported by indesign) are a mess with styles, fonts, etc Really a chaos. I need some way to get some works on styles via reg ex but I've found nothing, nor in the help, nor in the wiki, nor of useful on internet My first need is to modify lines before and after the chapter title. In my doc I've a blank line, a line with the chapter title and one or more blank lines all in header1 style I haven't found a way to select styles via regex and I can't simply change all the blank lines because they are in many different styles I've already searched on internet and in the libreoffice/openoffice forum but I haven't find any solutions. Can you help me? Thanks -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f Sponsor: Vuoi fare un regalo davvero originale? Su MisterCupido.com troverai centinaia di IDEE REGALO per tutte le tasche! Consegne in tutta Italia in soli 2-3 giorni Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=12387d=21-12 -- 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
Re: [libreoffice-users] huge print jobs for MS Publisher Imagesetter printer
I reproduced the descripted situation in two different environments: 1) Windows 7 and LibreOffice 3.6.4.3 2) Linux thin client + freerdp.+ terminal server Windows 2008 Enterprise, Libreoffice 3.6.3.2 To be honest, I don't know if the driver MS Publisher Imagesetter is a part of Microsoft Office, but I suppose, that not. Because this driver is associated by default with printers redirected to RDP terminal session even when MSO is not installed (and if Easyprint technology is disabled). 2012/12/20 Tom Davies tomdavie...@yahoo.co.uk Hi :) I thought it was just me not understanding printers and having set-up ours badly in GnuLinux but i might have had a similar issue with a Ricoh photocopier. My company paid 'an expert' for about 2 hours on 2 separate occasions to set-up the Ricoh for Windows. So, i figured it was just me and our amazing printer. Now that i think about it i haven't tried printing from any other program so it could possibly be partly a LO issue. Which OS are you using btw? I would assume Windows but with the rise of mobile platforms that is never certain these days. Regards from Tom :) -- *From:* Anna Martynova terrible.br...@gmail.com *To:* users@global.libreoffice.org *Sent:* Thursday, 20 December 2012, 13:12 *Subject:* [libreoffice-users] huge print jobs for MS Publisher Imagesetter printer Hello. I noticed a strange thing in Windows version of Libre Office. When I print to printer that is configured with driver MS Publisher Imagesetter, sometimes print files are really huge. For testing purpose I used Print to file option. For example I attached a 13 kilobyte odt file that turns into 48 megabytes print file. It contains several lines of letters and numbers, and then broken link to image (copied from web browser). If I print this document to another printer (with different driver, for example, HP LaserJet 2050) the size of print jobs is quite reasonable (less than 1 megabyte). Is it normal behavior? Have anyone else noticed that? We met with it when we were trying to understand why printing from Libre Office takes so much time in RDP terminal session. :) (We had files that produced even 250 Mb of print data, of course it took much time to send it to terminal client's printer). Thanks in advance. -- 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] unsubscribe
-- vriendelijke groeten Jaap Bosman -- http://softskills.kennisnet.nl/ http://dutchinamerica.com http://jjbs.wordpress.com/ http://twitter.com/JaapSoft http://connectiv.wordpress.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] unsubscribe
Hi :) These instructions might help http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Good luck and regards from Tom :) From: Jaap Bosman j...@xs4all.nl To: users@global.libreoffice.org Sent: Friday, 21 December 2012, 11:35 Subject: [libreoffice-users] unsubscribe -- vriendelijke groeten Jaap Bosman -- http://softskills.kennisnet.nl/ http://dutchinamerica.com http://jjbs.wordpress.com/ http://twitter.com/JaapSoft http://connectiv.wordpress.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
Re: [libreoffice-users] [Calc] Data sorting
Hi :) I just tend to add an extra 2 spaces in front of single-digit numbers. If/when that doesn't work i use a leading 0. Like so ... TheSameStreetName 7/3 TheSameStreetName 12/1 TheSameStreetName 15/1 TheSameStreetName 19A m21 TheSameStreetName 25A/2 or TheSameStreetName 07/3 TheSameStreetName 12/1 TheSameStreetName 15/1 TheSameStreetName 19A m21 TheSameStreetName 25A/2 The leading zero looks dumb but it solves the problem. Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Thursday, 20 December 2012, 21:52 Subject: Re: [libreoffice-users] [Calc] Data sorting At 21:57 20/12/2012 +0100, Gordom Noname wrote: Let say I have a list of my customers. Each raw consist of his/her name and the postal address (separate columns). The address is a mixture of letters and numbers. Now I would like to sort this list according to customers [location]. As the result I get something like this (1): TheSameStreetName 12/1 TheSameStreetName 15/1 TheSameStreetName 19A m21 TheSameStreetName 25A/2 TheSameStreetName 7/3 Do I make something wrong? Why the list is sorted in that way (odd to me :-)? The cell contents are text, so they are sorted alphabetically, character by character. 1 comes before 2, which comes before 7, so the three numbers starting with 1 come first. These are then sorted by the next character: 2 comes before 5, which comes before 9. But I would rather expect to get this kind of list (2): TheSameStreetName 7/3 TheSameStreetName 12/1 TheSameStreetName 15/1 TheSameStreetName 19A m21 TheSameStreetName 25A/2 Is it possible to get the result according to list number 2? Probably. But you have to sort numerically, so you will either have to separate the numbers from the street names (into separate cells: you can then sort by those cells after sorting by street name) or else keep the cells as they are but extract the number part into a separate cell (which you can hide if you prefer) and then sort by those cells. I trust this helps. 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 -- 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] [Calc] Data sorting
On 12/20/2012 03:57 PM, Gordon wrote: Hallo everyone. Let say I have a list of my customers. Each raw consist of his/her name and the postal address (separate columns). The address is a mixture of letters and numbers. Now I would like to sort this list according to customers lactation. As the result I get something like this (1): TheSameStreetName 12/1 TheSameStreetName 15/1 TheSameStreetName 19A m21 TheSameStreetName 25A/2 TheSameStreetName 7/3 But I would rather expect to get this kind of list (2): TheSameStreetName 7/3 TheSameStreetName 12/1 TheSameStreetName 15/1 TheSameStreetName 19A m21 TheSameStreetName 25A/2 Do I make something wrong? Why the list is sorted in that way (odd to me :-)? Is it possible to get the result according to list number 2? Thanks in advance for all your help. Regards, gordom Gordon The sorting you are doing is by character order. Because of the '/' and letters in the numbers the entry is treated as text. People can easily sort this correctly but is often a pain to sort this correctly by a computer. You would need to create a column for sorting that some pulls the leading numbers out of the text or using a leading 0 for the text sorting to be correct. A related issue is when the leading 0 should be included in a string of numbers (US Zip Codes). If the computer believes the the data to be numbers the leading 0 are dropped. For example the zip code 08540 would become 8540. -- 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
[libreoffice-users] Merry Christmas and Happy New Year
Hi all, Merry Christmas and Happy New Year! A git for you TDF, thanks for all you do for us! http://blog.pt-br.libreoffice.org/2012/12/21/feliz-natal-e-prospero-2013/ From Brazilian LibreOffice Community!!! Best -- Eliane Domingos de Sousa Comunidade LibreOffice Brasil Liberte-se, para editar textos, planilhas e apresentações use http://pt-br.libreoffice.org/ é totalmente de graça. -- 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] LibreOffice 4.0.0.0 Beta1 Crash
Hi! I submitted a bug in the past hour: https://bugs.freedesktop.org/show_bug.cgi?id=58621 It is about the crash when installing LibO-Dev_4.0.0.0.beta1_Win_x86_install_multi.msi. Is there anything I need to add to make the bug report complete? I am new to the bug reporting system. Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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: typographic freaks: footnotes not vertically aligned to last line of body text in following page (as in good typographic style)
On 21/12/2012 at 01:03, NoOp gl...@sbcglobal.net wrote: Sorry, but I'm not seeing what you are. My screenshot: http://img15.imageshack.us/img15/6830/libreofficefootnotewrit.png They are not aligned vertically. Last line of text on right page is about 3-4 points higher that last line of footnote on left page. Take a ruler and check for yourself. -- Best regards Mirosław Zalewski -- 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] Styles and regular expression in libreoffice
Maybe I'm not understanding your problem, but ... it should take less time to 'select all' - paste into notepad [thereby removing all formatting] - 'select all' and paste into a new LO blank document. At this point, 'select all' and click on the formatting you desire; then scan through to catch the footnotes to place them back in line. I've done this a few times; time is about 15 minutes; having to scan through those footnotes which have become out of line ;-) save time at this point by 'find'ing each by number ;-) On Fri, Dec 21, 2012 at 4:13 AM, lordmax tdf lordmax-...@email.it wrote: Hi all Thanks for your suggestion but it isn't a way I can walk. I have documents of more than 500 pages, if I must reformat all I never end I can't remove all formatting and start from scratch because it take too many time. I can't remove all blank paragraphs because many of them are useful. I can't use regex for automatize the work. It's really a sin. So well, I must work on Office Word first for formatting document and then convert it. I would want to work totally on libreoffice but it isn't possible evidently. Thanks to all Il 21/12/2012 02:27, anne-ology ha scritto: When I do this, nothing is lost except the formatting ... merely 'select all' - copy - paste to notepad - all the text will be there; just re-format everything and place back in line ;-) On Thu, Dec 20, 2012 at 10:56 AM, VA cuyfa...@hotmail.com wrote: This may not be much help, but when I have been faced with a converted file that was such a formatting mess, I would just save it as a plain text file and format from scratch, creating and applying the specific Styles I wanted. There are drawbacks to this, as you will lose some of your content, such as footnotes. Good luck. Virgil From: lordmax tdf Sent: Thursday, December 20, 2012 10:58 AM To: users@global.libreoffice.org Subject: [libreoffice-users] Styles and regular expression in libreoffice Hi all I'm on libreoffice 3.6 italian version I'm working on many ebook in epub format. Fortunately libreoffice has a great extension, writer2epub, who's wonderful My problem is that original files (word exported by indesign) are a mess with styles, fonts, etc Really a chaos. I need some way to get some works on styles via reg ex but I've found nothing, nor in the help, nor in the wiki, nor of useful on internet My first need is to modify lines before and after the chapter title. In my doc I've a blank line, a line with the chapter title and one or more blank lines all in header1 style I haven't found a way to select styles via regex and I can't simply change all the blank lines because they are in many different styles I've already searched on internet and in the libreoffice/openoffice forum but I haven't find any solutions. Can you help me? Thanks -- 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] Styles and regular expression in libreoffice
thanks; some more good tips. On Fri, Dec 21, 2012 at 5:07 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Styles and Templates are a really fast way of imposing new formatting after you have converted it all into plain text. It might sound like something that is going to take ages but you would be surprised at how fast you can get through it the way people are recommending. It surprised me! With Word i had often spent hours trying to un-mess documents from other people but Writer's use of styles makes it fast and simple. Another advantage with Writer's use of styles is that you can change the font throughout a document really quickly. Just right-click on the text body style and change the font there. Same with the default style and then as you go through other styles you have used you may find some have already changed automatically. I sometimes select a large area of text and force it to change style between a few different styles that i don't want the text to appear in and then settle it all as text-body. That usually clears a lot of the messes. Then just go through and select headings and sub-headings and set their style as heading1 or heading 2 or whatever is the appropriate level. See Chapter 3 in the Getting Started Guide as it probably has even faster ways of getting through the document https://wiki.documentfoundation.org/Documentation/Publications Good luck and regards from Tom :) From: lordmax tdf lordmax-...@email.it To: Cc: users@global.libreoffice.org Sent: Friday, 21 December 2012, 10:13 Subject: Re: [libreoffice-users] Styles and regular expression in libreoffice Hi all Thanks for your suggestion but it isn't a way I can walk. I have documents of more than 500 pages, if I must reformat all I never end I can't remove all formatting and start from scratch because it take too many time. I can't remove all blank paragraphs because many of them are useful. I can't use regex for automatize the work. It's really a sin. So well, I must work on Office Word first for formatting document and then convert it. I would want to work totally on libreoffice but it isn't possible evidently. Thanks to all Il 21/12/2012 02:27, anne-ology ha scritto: When I do this, nothing is lost except the formatting ... merely 'select all' - copy - paste to notepad - all the text will be there; just re-format everything and place back in line ;-) On Thu, Dec 20, 2012 at 10:56 AM, VA cuyfa...@hotmail.com wrote: This may not be much help, but when I have been faced with a converted file that was such a formatting mess, I would just save it as a plain text file and format from scratch, creating and applying the specific Styles I wanted. There are drawbacks to this, as you will lose some of your content, such as footnotes. Good luck. Virgil From: lordmax tdf Sent: Thursday, December 20, 2012 10:58 AM To: users@global.libreoffice.org Subject: [libreoffice-users] Styles and regular expression in libreoffice Hi all I'm on libreoffice 3.6 italian version I'm working on many ebook in epub format. Fortunately libreoffice has a great extension, writer2epub, who's wonderful My problem is that original files (word exported by indesign) are a mess with styles, fonts, etc Really a chaos. I need some way to get some works on styles via reg ex but I've found nothing, nor in the help, nor in the wiki, nor of useful on internet My first need is to modify lines before and after the chapter title. In my doc I've a blank line, a line with the chapter title and one or more blank lines all in header1 style I haven't found a way to select styles via regex and I can't simply change all the blank lines because they are in many different styles I've already searched on internet and in the libreoffice/openoffice forum but I haven't find any solutions. Can you help me? Thanks -- 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] Styles and regular expression in libreoffice
At 09:58 21/12/2012 -0600, Anne McGinnis wrote: ... it should take less time to 'select all' - paste into notepad [thereby removing all formatting] - 'select all' and paste into a new LO blank document. You've said this a couple of times now, so it is worth pointing out (perhaps for other readers' benefit) that this is an unnecessarily complicated technique. Use of Edit | Paste Special... | Unformatted text (or Ctrl+Shift+V | Unformatted text) in LibreOffice is all that is required. No need for Notepad or any other separate software. 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
[libreoffice-users] Re: bugzilla report emails are including HTML
On 12/21/2012 12:45 AM, Manfred J. Krause wrote: Hi, On Fri, Dec 21, 2012 at 2:43 AM, NoOp wrote: No response on the discuss list, so I'll try here. Why are the emailed bug reports also including HTML? [...] Bugzilla (log in) → (User) Preferences → General Preferences → Preferred email format - Site Default (HTML) - HTML - Text Only → Submit Changes Thanks Manfred, I'll reset it. However, I don't recall making any changes to my bugzilla account. All of the messages were in plain text up until sometime in November. -- 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] Styles and regular expression in libreoffice
The KeepItSimpleS method is the way I've always found most effective; saves having to memorize all those short-cuts - acronyms - ... ... ... On Fri, Dec 21, 2012 at 10:11 AM, Brian Barker b.m.bar...@btinternet.comwrote: At 09:58 21/12/2012 -0600, Anne wrote: ... it should take less time to 'select all' - paste into notepad [thereby removing all formatting] - 'select all' and paste into a new LO blank document. You've said this a couple of times now, so it is worth pointing out (perhaps for other readers' benefit) that this is an unnecessarily complicated technique. Use of Edit | Paste Special... | Unformatted text (or Ctrl+Shift+V | Unformatted text) in LibreOffice is all that is required. No need for Notepad or any other separate software. 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
[libreoffice-users] Re: record changes weakness compared to m$
On 12/20/2012 10:25 PM, e-letter wrote: On 19/12/2012, NoOp gl...@sbcglobal.net wrote: On 12/19/2012 12:26 AM, e-letter wrote: Readers, Have done a bug report on both LO and AOO, about the 'changes' feature of the word processor. (It's excellent that there are multiple ... And the link to that bug report is... ? For LO (RSS feed): https://www.libreoffice.org/bugzilla/buglist.cgi?bug_status=UNCONFIRMEDbug_status=NEWbug_status=ASSIGNEDbug_status=REOPENEDbug_status=VERIFIEDcomponent=Writerproduct=LibreOfficequery_format=advancedshort_desc=changesshort_desc_type=allwordssubstrtitle=Bug%20Listctype=atom For OO: (RSS feed): https://issues.apache.org/ooo/buglist.cgi?bug_status=UNCONFIRMEDbug_status=CONFIRMEDbug_status=ACCEPTEDbug_status=REOPENEDbug_status=VERIFIEDcomponent=editingproduct=word%20processorquery_format=advancedresolution=---short_desc=changesshort_desc_type=allwordssubstrtitle=Bug%20Listctype=atom I certainly would have been willing to try to assist if you could have pointed me to *your* bug report. But it appears that *you've* not actually filed a report as stated... right? -- 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: typographic freaks: footnotes not vertically aligned to last line of body text in following page (as in good typographic style)
On 12/21/2012 07:08 AM, Mirosław Zalewski wrote: On 21/12/2012 at 01:03, NoOp gl...@sbcglobal.net wrote: Sorry, but I'm not seeing what you are. My screenshot: http://img15.imageshack.us/img15/6830/libreofficefootnotewrit.png They are not aligned vertically. Last line of text on right page is about 3-4 points higher that last line of footnote on left page. Take a ruler and check for yourself. Cleans eye glasses... Measures. Yep you are correct. Mea culpa thanks for pointing that out - I should have looked closer. -- 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] LibreOffice 4.0.0.0 Beta1 Crash
This is a known issue. Install latest version of .net framework and it should be solved :) Regards, Joel On Fri, Dec 21, 2012 at 6:49 AM, webofht-libreoffice...@yahoo.com.hkwrote: Hi! I submitted a bug in the past hour: https://bugs.freedesktop.org/show_bug.cgi?id=58621 It is about the crash when installing LibO-Dev_4.0.0.0.beta1_Win_x86_install_multi.msi. Is there anything I need to add to make the bug report complete? I am new to the bug reporting system. Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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 -- *Joel Madero* LibO QA Volunteer jmadero@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
Re: [libreoffice-users] Merry Christmas and Happy New Year
Me too for you and all Regards, Jorge Rodríguez - Mensaje original - De: Eliane Domingos de Sousa elianedomin...@libreoffice.org Para: users@global.libreoffice.org Enviados: Viernes, 21 de Diciembre 2012 7:59:50 Asunto: [libreoffice-users] Merry Christmas and Happy New Year Hi all, Merry Christmas and Happy New Year! A git for you TDF, thanks for all you do for us! http://blog.pt-br.libreoffice.org/2012/12/21/feliz-natal-e-prospero-2013/ From Brazilian LibreOffice Community!!! Best -- Eliane Domingos de Sousa Comunidade LibreOffice Brasil Liberte-se, para editar textos, planilhas e apresentações use http://pt-br.libreoffice.org/ é totalmente de graça. -- 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
Re: [libreoffice-users] Merry Christmas and Happy New Year
On 12/21/2012 01:46 PM, RODRIGUEZ FONSECA JORGE ALBERTO wrote: Me too for you and all Regards, Jorge Rodríguez - Mensaje original - De: Eliane Domingos de Sousa elianedomin...@libreoffice.org Para: users@global.libreoffice.org Enviados: Viernes, 21 de Diciembre 2012 7:59:50 Asunto: [libreoffice-users] Merry Christmas and Happy New Year Hi all, Merry Christmas and Happy New Year! A git for you TDF, thanks for all you do for us! http://blog.pt-br.libreoffice.org/2012/12/21/feliz-natal-e-prospero-2013/ From Brazilian LibreOffice Community!!! Best That tree would make a good image to be placed on next year'sLibreOffice.org's opening page. -- 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] LO not starting after installation Fixed
I tried several things including trying to install Java and visual c++. This is a new computer with Windows 7 professional. Some programs would install with on problem. Others would not install at all. The final clue was trying to install Java. The error message stated that it could not find the install program, even though I started it from the Downloads folder. The reason that these program were failing to install is that the user folder was named with Georgian keyboard and language enabled. This made the user folder name in a foreign language and the user was setup to use US English and keyboard. I created a new administrator user with US English and keyboard settings. Now I was able to install all the programs that would not install before and the programs that installed. And reloading programs that would not work after installation now worked after reinstalling including LO. -- 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] Calc: Text Columns Not Quoted When Saving .csv
I've been going around in circles on this issue for most of today without finding the solution. The context: I have several large data files provided in .csv format that need to be edited and have column formats made explicit. These files are recognized by LO/Calc as spreadsheets when I open them and I change the field separator from a tab to a comma. They display correctly in the spreadsheet. I explicitly format text, integer, and floating point columns by highlighting the column(s) and selecting Format - Cells and selecting the appropriate choice. The problem comes when I save the explicitly-formatted file: the text fields are quoted only when they have content, not when they are blank. This, of course, prevents correctly reading the files into database tables or R data frames. I have tried all sorts of kludges to force Calc to display the .csv dialog box where I can tell it to quote all text fields, but those cells without content are saved as ,, rather than ,'',. What do I do so that blank cells in text-formatted columns are quoted in the saved (or saved-as) .csv file? TIA, Rich -- 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] Styles and regular expression in libreoffice
At 12:24 21/12/2012 -0600, Anne Noname wrote: On Fri, Dec 21, 2012 at 10:11 AM, Brian Barker wrote: Use of Edit | Paste Special... | Unformatted text (or Ctrl+Shift+V | Unformatted text) in LibreOffice is all that is required. No need for Notepad or any other separate software. The KeepItSimpleS method is the way I've always found most effective; saves having to memorize all those short-cuts - acronyms - ... You think it is simpler to start a separate piece of software, copy and paste some text out of one program into the other, and copy and paste it back again, than just copy-and-pasting it back over itself in the original document? Pardon me, but Ho, ho! You are very welcome to do this, of course. (I was evidently more right than I knew when I added perhaps for other readers' benefit!) 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] Styles and regular expression in libreoffice
If you merely copy paste over the initial file, then the messed-up formatting may still exist; in order to be sure of eliminating whatever might be causing the 'kink', the document needs to be fresh ;-) I learned this when that silly .rtf was around ... I had a great letter ready to print out then mail off; I printed the first one to re-edit for any typos I might have missed to discover that intermingled among the text was all this gobbledegook ;-) After trying 3 times, I switched to notepad; this cleared the formatting ... then I placed the text around the images in OO [yes, it was a while back ;-) ] and it printed out as it appeared on the monitor :-) On Fri, Dec 21, 2012 at 5:28 PM, Brian Barker b.m.bar...@btinternet.comwrote: At 12:24 21/12/2012 -0600, Anne Noname wrote: On Fri, Dec 21, 2012 at 10:11 AM, Brian Barker wrote: Use of Edit | Paste Special... | Unformatted text (or Ctrl+Shift+V | Unformatted text) in LibreOffice is all that is required. No need for Notepad or any other separate software. The KeepItSimpleS method is the way I've always found most effective; saves having to memorize all those short-cuts - acronyms - ... You think it is simpler to start a separate piece of software, copy and paste some text out of one program into the other, and copy and paste it back again, than just copy-and-pasting it back over itself in the original document? Pardon me, but Ho, ho! You are very welcome to do this, of course. (I was evidently more right than I knew when I added perhaps for other readers' benefit!) 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] Calc: Text Columns Not Quoted When Saving .csv
Hi :) My ham-fisted kludge would probably be to save the Csv and then open it in a text-editor, such as Kate, Gedit, Notepad or whatever and then do searchreplace to look for , , and replace with , , Perhaps in Calc add an unusual combination of characters in thse empty cells. Actually i have just tried this in Calc and Gnumeric. Text cells didn't get any nor ' marks around them except cells with just spaces in them and formatted as text but only in Gnumeric, not in Calc. Then i noticed that when you Save As ... there is a tick-box to Edit filter preferences and that gives a pop-up dialogue-box with a tick-box to Quote all text fields. Only then it starts putting around spaces and letters. Empty cells still have nothing. Is that something to do with Utf8 coding? Regards from Tom :) From: Rich Shepard rshep...@appl-ecosys.com To: users@global.libreoffice.org Sent: Friday, 21 December 2012, 21:52 Subject: [libreoffice-users] Calc: Text Columns Not Quoted When Saving .csv I've been going around in circles on this issue for most of today without finding the solution. The context: I have several large data files provided in .csv format that need to be edited and have column formats made explicit. These files are recognized by LO/Calc as spreadsheets when I open them and I change the field separator from a tab to a comma. They display correctly in the spreadsheet. I explicitly format text, integer, and floating point columns by highlighting the column(s) and selecting Format - Cells and selecting the appropriate choice. The problem comes when I save the explicitly-formatted file: the text fields are quoted only when they have content, not when they are blank. This, of course, prevents correctly reading the files into database tables or R data frames. I have tried all sorts of kludges to force Calc to display the .csv dialog box where I can tell it to quote all text fields, but those cells without content are saved as ,, rather than ,'',. What do I do so that blank cells in text-formatted columns are quoted in the saved (or saved-as) .csv file? TIA, Rich -- 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
Re: [libreoffice-users] Styles and regular expression in libreoffice
At 18:14 21/12/2012 -0600, Anne Noname wrote: If you merely copy paste over the initial file, then the messed-up formatting may still exist; That's why that wasn't my suggestion! in order to be sure of eliminating whatever might be causing the 'kink', the document needs to be fresh ;-) That's not true. But in any case, you are presumably suggesting that a fresh document would anyway be necessary with your round-the-houses route via other software. Again, you are very welcome to go the long way around if you prefer. You will not be the only person to do 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] Calc: Text Columns Not Quoted When Saving .csv
At 13:52 21/12/2012 -0800, Rich Shepard wrote: The problem comes when I save the explicitly-formatted file: the text fields are quoted only when they have content, not when they are blank. I don't think that's true: I think empty cells are output as nothing, but blank cells - those in which the text string is one or more blanks - are output correctly in quotes. This, of course, prevents correctly reading the files into database tables or R data frames. I have tried all sorts of kludges to force Calc to display the .csv dialog box where I can tell it to quote all text fields, but those cells without content are saved as ,, rather than ,'',. What do I do so that blank cells in text-formatted columns are quoted in the saved (or saved-as) .csv file? Could you convert your empty cells to blank, output as CSV, read this into your other program, and then - only if necessary - edit the blanks back to null? This might be more difficult is you have both genuinely empty and blank cells and if these are significantly different; in that case, could you put some other string into the empty cells and edit these out in the destination program? Can your other programs cope only with CSV files? Not spreadsheet document files? I trust this helps. 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
[Solved] Re: [libreoffice-users] LO not starting after installation Fixed
Hi :) Blimey!!! I guess a question we should ask early on in the future, if people have trouble installing, is whether there has been trouble doing the same thing with other programs. Thanks for getting back to us with the answer!! It sounds like quite a strange set-up for a freshly bought machine. If it was bought in a shop is there any mileage in having a grumble at them? Maybe they don't realise what they are doing and a friendly grumble might help them avoid the problem for other people? Sometimes it's easier to get bits of hardware such as a newish mouse, usb-hub, simple things or software than compensation for your time. Good luck and congrats on finding that!! Also thanks for letting this list know :) Many regards from Tom :) From: David Moeser dpmoe...@gmail.com To: users@global.libreoffice.org; tomdavie...@yahoo.co.uk Sent: Friday, 21 December 2012, 21:24 Subject: [libreoffice-users] LO not starting after installation Fixed I tried several things including trying to install Java and visual c++. This is a new computer with Windows 7 professional. Some programs would install with on problem. Others would not install at all. The final clue was trying to install Java. The error message stated that it could not find the install program, even though I started it from the Downloads folder. The reason that these program were failing to install is that the user folder was named with Georgian keyboard and language enabled. This made the user folder name in a foreign language and the user was setup to use US English and keyboard. I created a new administrator user with US English and keyboard settings. Now I was able to install all the programs that would not install before and the programs that installed. And reloading programs that would not work after installation now worked after reinstalling including LO. -- 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
Re: [libreoffice-users] Calc: Text Columns Not Quoted When Saving .csv
On Sat, 22 Dec 2012, Tom Davies wrote: My ham-fisted kludge would probably be to save the Csv and then open it in a text-editor, such as Kate, Gedit, Notepad or whatever and then do searchreplace to look for Tom, I use emacs for almost all my writing. , , and replace with , , The problem with searching for ,, and replacing them with ,'', is that blank number cells are also quoted. SQL does not like that. :-) Perhaps in Calc add an unusual combination of characters in thse empty cells. The first thing I did was save the freshly-opened .csv as .ods. I get client data as exports from their Excel spreadsheets (sigh) which I save as .ods, then clean up. When I save the .ods file as .csv the text fields -- even the blank ones -- are quoted. That's not working with these files. I'm trying (with C-h) to replace all blank cells with NA. However, with 105000 rows and about 50 columns it takes a very long time ... I gave up for today. But, I'll try again tomorrow. Then I can block number columns and replace the NA with blanks. Quite the hassle, Rich -- 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] Calc: Text Columns Not Quoted When Saving .csv
On Sat, 22 Dec 2012, Brian Barker wrote: Could you convert your empty cells to blank, output as CSV, read this into your other program, and then - only if necessary - edit the blanks back to null? Brian, One does not 'read' the file into a SQL database such as postgres. When a column attribute type is text SQL wants to see it quoted; when it's numeric (INTEGER, REAL) it cannot be quoted. For the record, DATE attributes, even in ISO format (-mm-dd) must be quoted for SQL to properly interpret it. Can your other programs cope only with CSV files? Not spreadsheet document files? Nope. SQL wants certain formats, and R might be able to read spreadsheets but I work with plain ASCII text files for almost everything. Rich -- 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] Calc: Text Columns Not Quoted When Saving .csv
On 12/21/2012 04:52 PM, Rich Shepard wrote: I've been going around in circles on this issue for most of today without finding the solution. The context: I have several large data files provided in .csv format that need to be edited and have column formats made explicit. These files are recognized by LO/Calc as spreadsheets when I open them and I change the field separator from a tab to a comma. They display correctly in the spreadsheet. I explicitly format text, integer, and floating point columns by highlighting the column(s) and selecting Format - Cells and selecting the appropriate choice. The problem comes when I save the explicitly-formatted file: the text fields are quoted only when they have content, not when they are blank. This, of course, prevents correctly reading the files into database tables or R data frames. I have tried all sorts of kludges to force Calc to display the .csv dialog box where I can tell it to quote all text fields, but those cells without content are saved as ,, rather than ,'',. What do I do so that blank cells in text-formatted columns are quoted in the saved (or saved-as) .csv file? TIA, Rich Rich, In a csv file the field delimiter is usually a comma and to denote what is a string that may contain a comma quotation marks are used. If the cell in the original format was empty or NULL in a database nothing is exported. For example the export from a database might look like this: 1,text string, test,,,the last two were NULLs in the database,34 2.another string,3,3,,57 For the exported value to an empty string () the original value must be an empty string not an empty cell. When importing into a database is it often better to have the equivalent to a NULL value because the each column in the database will have an assigned data type and the empty string will cause an import error if there is data type mismatch. The empty string will cause problems with numeric data. -- 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
Re: [libreoffice-users] Calc: Text Columns Not Quoted When Saving .csv
Hi :) Errr, have you tried reading the Sql tables directly with LO? Base is best when used as a front-end for an existing back-end and i think Postgres is one that Base works particularly well with at the moment. I think the Base - Postgre connector was at least partly developd by people from the Postgre project fairly recently (within the last year i think) If the connector lets you use the Postgre database then it should be possible to edit the tables in Calc dynamically without having to go through any Csv file import/export processing. Regards from Tom :) From: Rich Shepard rshep...@appl-ecosys.com To: users@global.libreoffice.org Sent: Saturday, 22 December 2012, 1:21 Subject: Re: [libreoffice-users] Calc: Text Columns Not Quoted When Saving .csv On Sat, 22 Dec 2012, Brian Barker wrote: Could you convert your empty cells to blank, output as CSV, read this into your other program, and then - only if necessary - edit the blanks back to null? Brian, One does not 'read' the file into a SQL database such as postgres. When a column attribute type is text SQL wants to see it quoted; when it's numeric (INTEGER, REAL) it cannot be quoted. For the record, DATE attributes, even in ISO format (-mm-dd) must be quoted for SQL to properly interpret it. Can your other programs cope only with CSV files? Not spreadsheet document files? Nope. SQL wants certain formats, and R might be able to read spreadsheets but I work with plain ASCII text files for almost everything. Rich -- 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: huge print jobs for MS Publisher Imagesetter printer
On 12/20/2012 05:12 AM, Anna Martynova wrote: Hello. I noticed a strange thing in Windows version of Libre Office. When I print to printer that is configured with driver MS Publisher Imagesetter, sometimes print files are really huge. For testing purpose I used Print to file option. For example I attached a 13 kilobyte odt file that turns into 48 megabytes print file. It contains several lines of letters and numbers, and then broken link to image (copied from web browser). You can't attach files here. You either need to post them on a site somewhere, or use Nabble to attach. As a test I installed MS Publisher Imagesetter, on a WinXP virtual machine (on a linux host). I then printed a 13K two page .odt file from LO Version 3.6.3.2 (Build ID: 58f22d5); the first page is all text, the second page is an EPS graphic. Printed to MS Publisher Imagesetter and the result is a 107K postscript file that I opened in Ghostscript to ensure it worked properly. The PS heading on the print file: %!PS-Adobe-3.0 %%Title: eps-example %%Creator: PScript5.dll Version 5.2.2 %%CreationDate: 12/21/2012 17:28:40 %%For: G %%BoundingBox: (atend) %%Pages: (atend) %%Orientation: Portrait %%PageOrder: Special %%DocumentNeededResources: (atend) %%DocumentSuppliedResources: (atend) %%DocumentData: Clean7Bit %%TargetDevice: () (52.3) 320 %%LanguageLevel: 1 %%EndComments %%BeginDefaults %%PageBoundingBox: 21 54 582 774 %%ViewingOrientation: 1 0 0 1 %%EndDefaults If I print this document to another printer (with different driver, for example, HP LaserJet 2050) the size of print jobs is quite reasonable (less than 1 megabyte). I suspect that you have an issue with the MSPI driver. You might want to install a second one and see if it acts the same. Is it normal behavior? Have anyone else noticed that? We met with it when we were trying to understand why printing from Libre Office takes so much time in RDP terminal session. :) (We had files that produced even 250 Mb of print data, of course it took much time to send it to terminal client's printer). If you'd like to send me your file directly, I'll see if I can recreate the problem. Thanks in advance. -- 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] LO cannot read XLS export from Apple Numbers
Hello, All: I recently received several *.xls files that could not be read by LibreOffice 3.6.2.2 (Build ID: da8c1e6). I read them using R (r-project.org, package gdata), so they are a reasonable approximation to MS Excel. I received them from someone who exported them from Apple Numbers 9 version 2.3(554). He said, 'I don't remember whether I had on include preview'. Might someone else be able to test this and enter a bug report if appropriate? Thanks, Spencer Graves -- 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] LibreOffice 4.0.0.0 Beta1 Crash
Thank you. The installation of LibreOffice 4.0.0.0 Beta1 was complete after installing .Net Framework. I think that somebody like me will find it hard to know that .Net Framework is a must. Please state the link in the visible space to let more people know this requirement and to let them install LibreOffice 4.0.0.0 Beta1 easily. -- Proposed note: Tip: LibreOffice 4.0.0.0 Beta1 requires .Net Framework. Please install it before installing this version of LibreOffice. .Net Framework can be found here: http://www.microsoft.com/net -- Please put similar messages here: http://www.libreoffice.org/download/pre-releases/ Thank you. Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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