Re: [libreoffice-users] Release Notes LibO 3.5.4.2

2012-05-31 Thread Michael Manning
Have a look at: http://wiki.documentfoundation.org/Releases/3.5.4/RC2 cheers Mike On Thu, May 31, 2012 at 1:58 PM, Daniel Gonzalez gonzale...@gmail.comwrote: Hello, Someone could tell me where I can see the list of fixes and new features in LibO 3.5.4.2 thanks --

Re: [libreoffice-users] Impress crashes when attempting to play video

2012-05-31 Thread Rev. Nick Sharp
On 30 May 2012 17:06, John Bijnens johnbijne...@gmail.com wrote: I have the same problem. I use LibreOffice together with PortableApps. I also use Windows 7 64-bit. I haven't tested it yet on another Windows version. My solution was to go back to OpenOffice 3.3. This solved my problem (at

[libreoffice-users] Re: Repeating Display of BASE Table entries in LO 3.5

2012-05-31 Thread Alexander Thurgood
Le 31/05/12 05:51, frofa a écrit : Hi Frofa, UPDATE: Looks like this bug will be fixed in LO 3.5.5 - see here... https://bugs.freedesktop.org/show_bug.cgi?id=48345 Yes, that is what one can infer from the bug report. We shall have to wait and see whether it causes a performance hit,

[libreoffice-users] LibreOffice Writer

2012-05-31 Thread Tim Moore
LibreOffice Writer wakes up huge displating about a 10ths of an A4 sheet and makes it unuseable. I'm using Mint 11 Linux Any thoughts on how to fix this ? A desperate, Tim -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Impress crashes when attempting to play video

2012-05-31 Thread Tom Davies
Hi :) If either of you have time then either of these 2 links can help you do a quick search to see if there is an existing bug-report. http://wiki.documentfoundation.org/BugReport https://www.libreoffice.org/get-help/bug/ If there isn't one it would be great if you can continue following either

Re: [libreoffice-users] embedded spreadsheets

2012-05-31 Thread Tom Davies
Hi :) Errr, i'm not clear on what you are doing!  Sorry!  At a guess you mean OpenDocument Format rather than OpenOffice format.  There are a lot of programs that use ODFs as their native format and many are nothing to do with the OO, LO, Go-oo, NeoOffice, StarOffice, Symphony family.  So,

[libreoffice-users] Re: Can't edit database connected to Access 2010 database?

2012-05-31 Thread Andreas Säger
Am 31.05.2012 02:48, Douglas Pope wrote: Yes, I have a test file. When I connect using the Microsoft Access 2007 option, I can open the table, but not edit it. 1) And the most likely reason is that your table has no primary key. 2) The second most likely reason is that your Access database

Re: [libreoffice-users] LibreOffice Writer

2012-05-31 Thread Tom Davies
Hi :) Sounds like something in the UserProfile.  Please can you try renaming your user-profile and see if that solves the problem? http://wiki.documentfoundation.org/Documentation/UserProfile It's a kinda magic cure-all for a variety of weirdnesses.  Note that renaming is better than deleting as

[libreoffice-users] Re: Can't edit database connected to Access 2010 database?

2012-05-31 Thread Tom
Hi :) You can always upload test-files to Nabble so that more than 1 person can test things out. Errr, obviously not files with confidential or sensitive information. When you upload to Nabble it put a clickable url link into the message portion of the message and you can write normally around

Re: [libreoffice-users] Release Notes LibO 3.5.4.2

2012-05-31 Thread Fabian Rodriguez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/30/2012 11:58 PM, Daniel Gonzalez wrote: Hello, Someone could tell me where I can see the list of fixes and new features in LibO 3.5.4.2 thanks Right from the announcement at

Re: off-list Re: [libreoffice-users] Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Tom Davies
Hi :) Dohhh!  That wasn't off-list after all! Apols and regards from Tom :) --- On Thu, 31/5/12, Tom Davies tomdavie...@yahoo.co.uk wrote: From: Tom Davies tomdavie...@yahoo.co.uk Subject: off-list Re: [libreoffice-users] Problem when exporting exporting from CALC to a fixed length csv To:

[libreoffice-users] Fonts: Not all installed fonts are listen at font selection drop list

2012-05-31 Thread Alon Bar-Lev
Hello, I opened an old document of mine which used the culmus fonts[1], more precisely the Frank Ruehl CLM font. So I guess it used to work back then in openoffice. Although the font is installed on the system, the document is not presented using that font, and the font not listed at the font

[libreoffice-users] Re: LibreOffice Writer

2012-05-31 Thread Andreas Säger
Am 31.05.2012 10:52, Tim Moore wrote: LibreOffice Writer wakes up huge displating about a 10ths of an A4 sheet and makes it unuseable. I'm using Mint 11 Linux Any thoughts on how to fix this ? A desperate, Tim Adjust ViewZoom to something reasonable (100%) -- For unsubscribe

[libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Andreas Säger
Am 31.05.2012 04:57, chimak111 wrote: Apropos the announcement and referring to [i]with up to 100% performance gains when opening large files (depending on operating system, hardware configuration and file contents)[/i] in particular, it would be nice if LibreOffice had a set of large files that

Re: [libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Tom Davies
Hi :) Please can we try to keep this mailing-list family friendly?  It is a good point that marketing and PR often needs to say things that are not always objective or quantifiable.  A salesman's claim that something is 100% is not the same as a programmers idea of 100% and neither may bear any

Re: [libreoffice-users] Re: LibreOffice Writer

2012-05-31 Thread Tom Davies
Hi :) Lol, is that a little slider on the bottom right or something that easy?  Regards from Tom :) --- On Thu, 31/5/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: LibreOffice Writer To: users@global.libreoffice.org Date:

Re: [libreoffice-users] Fonts: Not all installed fonts are listen at font selection drop list

2012-05-31 Thread Tom Davies
Hi :) There is an expert on fonts that may be around later but they are a complete mystery to me.  I take it you do have the fonts installed on your system? Regards from Tom :)  --- On Thu, 31/5/12, Alon Bar-Lev alon.bar...@gmail.com wrote: From: Alon Bar-Lev alon.bar...@gmail.com Subject:

Re: [libreoffice-users] embedded spreadsheets

2012-05-31 Thread Eric S. Johansson
On 5/31/2012 5:05 AM, Tom Davies wrote: Hi :) Errr, i'm not clear on what you are doing! Sorry! At a guess you mean OpenDocument Format rather than OpenOffice format. There are a lot of programs that use ODFs as their native format and many are nothing to do with the OO, LO, Go-oo,

Re: [libreoffice-users] Fonts: Not all installed fonts are listen at font selection drop list

2012-05-31 Thread Alon Bar-Lev
Thanks, Yes, I wrote that fonts are installed... and working for example in Firefox. On Thu, May 31, 2012 at 4:09 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) There is an expert on fonts that may be around later but they are a complete mystery to me.  I take it you do have the fonts

Re: [libreoffice-users] embedded spreadsheets

2012-05-31 Thread Tom Davies
Hi :) By default LibreOffice and OpenOffice use ODFs such as Ods and Odt.  The S at the end is for Spreadsheet and the T in the other is yes please but no sugar.  It is easy to change to default to MS formats but if you set LO up yourself you would probably have noticed doing something like

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread berritorre
Hi Paul! I am not sure if I can follow. In my few tests Libreoffice exportet interpreted the fixed length as the width of the cell showing in CALC. Unfortunately for me CALC somehow gives a little space to the left when presenting the data and thus in the export there is a space. When I manuall

Re: [libreoffice-users] LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Bob Nelson
PLEASE remove my email address from your list Thank You On Wed, May 30, 2012 at 7:57 PM, chimak111 chimak...@gmail.com wrote: Apropos the announcement and referring to [i]with up to 100% performance gains when opening large files (depending on operating system, hardware configuration and

unsubscribing Fw: Re: [libreoffice-users] LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Tom Davies
Hi :) Please follow the instructions on http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ We can't force people from this end except in dire emergencies.  Apols and regards from Tom :)  --- On Thu, 31/5/12, Bob Nelson bob124...@gmail.com wrote: From: Bob Nelson

Re: [libreoffice-users] Installation problem Windows 7 and LO 3.5

2012-05-31 Thread Tom Davies
Hi :) Nicely done :) You might find that when you have a document open using 1 program you wont be able to open another program with the other although you can have multiple files open with either one as long as you stick to using the same one for each file.  If all files are closed you can

Re: [libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Tom Davies
Hi :) Isn't there an option for tab delimiter?  Would that help?  I'm not sure it would tbh but it might be what 'they' are looking for.  Regards from Tom :) --- On Wed, 30/5/12, berritorre berrito...@gmail.com wrote: From: berritorre berrito...@gmail.com Subject: [libreoffice-users] Re:

Re: [libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Tom Davies
Hi :) Aaargh!!  Why not Emacs or Vi?  or Gedit or SciTe?  I'm quite enjoying Gedit at the moment but used to prefer SciTe.  Regards from Tom :)  --- On Wed, 30/5/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Problem

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread berritorre
Hi Andreas, As I said, it is not a problem about editing the text file. I need to export the data of a spreadsheet into a certain ASCII format. The file has 1000-2000 columns and 350 rows. I don't see how a text editor can help with this. But maybe I just don't know thos editors well enough.

[libreoffice-users] Writer makes a mess of saved documents

2012-05-31 Thread jjs
Hi, i don't know why but when you make a document, starting with just a blanc layout. You put in text and in between some pictures. Then it looks ok. When you save it in docx or odt format and then re-open it, it is a totall mess. aaaHrrggg! it totally does not remember were you placed the

Re: [libreoffice-users] Writer makes a mess of saved documents

2012-05-31 Thread Tom Davies
Hi :) Try keeping your originals in Odt format (for 'text' (really word-processed) documents) and then save in DocX or better still Doc.  The way you are doing it, ie DocX for originals, is creating problems.  Actually DocX is a nightmare at best.  Try to avoid it!  Even MS Office renders it

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Andreas Säger
Hello, As already stated, spreadsheet programs are horrible text editors. This is my fixed length output of a spreadsheet copied from a text editor: 000123 2012-05-130.57715one_char 000124 2012-05-140.58904two_char 000125 2012-05-170.86385three_char

Re: [libreoffice-users] Writer makes a mess of saved documents

2012-05-31 Thread Dan Lewis
jjs wrote: Hi, i don't know why but when you make a document, starting with just a blanc layout. You put in text and in between some pictures. Then it looks ok. When you save it in docx or odt format and then re-open it, it is a totall mess. aaaHrrggg! it totally does not remember were you

Re: [libreoffice-users] Impress crashes when attempting to play video

2012-05-31 Thread Rev. Nick Sharp
On 31 May 2012 09:52, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) If either of you have time then either of these 2 links can help you do a quick search to see if there is an existing bug-report. http://wiki.documentfoundation.org/BugReport https://www.libreoffice.org/get-help/bug/ If

[libreoffice-users] Re: Writer makes a mess of saved documents

2012-05-31 Thread jjs
Hi Dan and Tom, thank you both for your comments, i appreciate it True MS can also do weird things. But i never had to use an anchor in MS word. So i will try your suggestions and hopefully that will help me out and save me some frustration ;) Of course the free open source software is highly

Re: [libreoffice-users] Impress crashes when attempting to play video

2012-05-31 Thread Rev. Nick Sharp
On 31 May 2012 09:52, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) If either of you have time then either of these 2 links can help you do a quick search to see if there is an existing bug-report. http://wiki.documentfoundation.org/BugReport https://www.libreoffice.org/get-help/bug/ If

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread berritorre
Hi Paul! So I did some more testing with the latest version and I still persist: LibreOffice uses the visible width of the column to determine the fixed width! Here is what I did: - Followed your instructions on how to format the cells (had done this before already!). - Included some text

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread berritorre
Hi Andreas, I thought I had posted loads of trivial example data. What could be a problem is that you read this in your email program and I am writing the posts in Nabble, where I can format the example texts and the show nicely, because I have formatted them with a fixed length font by using the

[libreoffice-users]

2012-05-31 Thread Pablo M Ibáñez
Hi all Thanks for LO, very good! In base, I was wondering how to have the creation date of a new entry automaticaly inserted in the corresponding field? Thanks a lot for your help! Pablo -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Alexander Thurgood
Le 31/05/12 14:59, Tom Davies a écrit : Hi Tom, Why can't they just say things like A LOT faster?? Why drag in numbers that are likely to be proven wrong in certain/all cases? Well, probably because the cynic in me knows that someone in the AOO camp released a statement about AOO 3.4

[libreoffice-users] Re: Fonts: Not all installed fonts are listen at font selection drop list

2012-05-31 Thread Alexander Thurgood
Le 31/05/12 14:19, Alon Bar-Lev a écrit : Hi Alon, Is there any way to use these fonts within a document? It is very important as these font for example are complete Hebrew fonts, most other fonts out there supports only the basics. You're not using a Mac, are you, by any chance ? Alex

Re: [libreoffice-users] Re: Fonts: Not all installed fonts are listen at font selection drop list

2012-05-31 Thread Alon Bar-Lev
Oh... Sorry! I am using Linux. Gentoo to be specific. Version: app-office/libreoffice-3.5.4.2-r1 Thanks! On Thu, May 31, 2012 at 7:45 PM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 31/05/12 14:19, Alon Bar-Lev a écrit : Hi Alon, Is there any way to use these fonts within a

Re: unsubscribing Fw: Re: [libreoffice-users] LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Mike Phelan
I have followed the unsubscribe instructions *_twice_* in the last month, and still am getting 30-40 e-mails a day. *_PLEASE_* make them stop! Mike Phelan Innovative Woodworking www.InnovativeWoodworking.com 508-875-3262 On 5/31/2012 10:21 AM, Tom Davies wrote: Hi :) Please follow the

[libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread chimak111
Alexander Thurgood wrote ... I ... prefer factual analysis, but how often is software tested and statistically significant results given ? errmm On my Linux box, with less than one Gig of ram and an old 5400 rpm harddisk, everything is slow ;-) On my Macbook, it depends. So

Re: [libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Chad Neeper
On 5/31/2012 12:57 PM, chimak111 wrote: Alexander Thurgood wrote ... I ... prefer factual analysis, but how often is software tested and statistically significant results given ? errmm On my Linux box, with less than one Gig of ram and an old 5400 rpm harddisk, everything is slow ;-)

[libreoffice-users] How to play movies using API

2012-05-31 Thread Fernand Vanrie
I can insert a mediashape in a doc using Basic and the API but how to play out the movie (opening the Active Movie Window) The final goal is to play a movie in a Dialog, as i can display a document in a Dialog Window, i suppose the mediashape must been visible, but how to play the movie ?

[libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Andreas Säger
Am 31.05.2012 19:08, Chad Neeper wrote: So in my own real-(in my)-world test files, v3.5.x is thousands of percent slower! But I do see your point. This project has too many consumers and fan boys but no power users. Apart from that, the time of spreadsheets is over. In the 2020ies hardly

[libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Marc Paré
Hi Chad, Le 2012-05-31 13:08, Chad Neeper a écrit : But, really, so what? In my particular case, I regularly use a large and complex spreadsheet with numerous custom macros. In my case, moving from LO 3.4.x to 3.5.x apparently broke something vital. A process that has taken less than 60

Re: [libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Tom Davies
Hi :) I think you under-value your own skill-level.  If you don't value your own extremely advanced skill-set then of course you despair of other people that successfully use it a lot but just almost never need to do so at the advanced levels you consider basic.  Regards from Tom :) --- On

Re: [libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Chad Neeper
On 5/31/2012 1:18 PM, Andreas Säger wrote: Am 31.05.2012 19:08, Chad Neeper wrote: So in my own real-(in my)-world test files, v3.5.x is thousands of percent slower! But I do see your point. This project has too many consumers and fan boys but no power users. Apart from that, the time of

[libreoffice-users] Re: Writer makes a mess of saved documents

2012-05-31 Thread Andreas Säger
Am 31.05.2012 17:48, jjs wrote: Hi Dan and Tom, thank you both for your comments, i appreciate it True MS can also do weird things. But i never had to use an anchor in MS word. So i will try your suggestions and hopefully that will help me out and save me some frustration ;) Of course the

WoooHooo!! :))) Re: [libreoffice-users] Impress crashes when attempting to play video

2012-05-31 Thread Tom Davies
Hi :) Wow!!  Congrats!  Nicely done.  I'm still not entirely sure of exactly what the problem was but i think i have a vague idea and i am really glad i was able to point you in the right direction so that you were able to fix it yourself! Congrats and regards from Tom :)  --- On Thu,

Re: [libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Chad Neeper
On 5/31/2012 1:29 PM, Marc Paré wrote: Hi Chad, Le 2012-05-31 13:08, Chad Neeper a écrit : LO 3.4.x to 3.5.x apparently broke something vital. A process that has taken less than 60 seconds to complete in versions 3.x through 3.4.x now can take 30 minutes or more. Total deal-breaker and major

[libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Marc Paré
Hi Chad, Le 2012-05-31 13:48, Chad Neeper a écrit : On 5/31/2012 1:29 PM, Marc Paré wrote: Hi Chad, Le 2012-05-31 13:08, Chad Neeper a écrit : LO 3.4.x to 3.5.x apparently broke something vital. A process that has taken less than 60 seconds to complete in versions 3.x through 3.4.x now can

Re: [libreoffice-users] Re: Writer makes a mess of saved documents

2012-05-31 Thread Tom Davies
Hi :) You are welcome.  MS Word automatically sets your anchor type and point and has a more limited range of choices if you are not happy with their default choice.  My company newsletter was a nightmare until i started afresh with a fresh new blank Odt and then copied the various logos and

[libreoffice-users] Re: (unknown)

2012-05-31 Thread Alexander Thurgood
Le 31/05/12 19:21, Andreas Säger a écrit : Hi Andreas, menu:ToolsSQL... ALTER TABLE table name ALTER COLUMN column name SET DEFAULT CURRENT_DATE I just tried that, and what do you know, it didn't work : With an existing hsqldb db Table containing : ID int autoincrement=YES numseq int(10)

[libreoffice-users] Re: Fonts: Not all installed fonts are listen at font selection drop list

2012-05-31 Thread Alexander Thurgood
Le 31/05/12 18:51, Alon Bar-Lev a écrit : Hi again, Oh... Sorry! I am using Linux. Gentoo to be specific. Version: app-office/libreoffice-3.5.4.2-r1 Hmm, look in your psfonts subdirectory and see whats in there (if it si still there, I can't check at the moment on a Linux box). Support for

Re: [libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Chad Neeper
On 5/31/2012 1:56 PM, Tom Davies wrote: +1 Growth is good :) A fresh start in a new format can be great but_finding time to do it is not always easy_! ...especially when one has to try to interpret mind-bending comments about skill levels...LOL! I'm driving quickly enough to the nut

Re: [libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Steve Edmonds
On 2012-06-01 02:34, berritorre wrote: Hi Andreas, As I said, it is not a problem about editing the text file. I need to export the data of a spreadsheet into a certain ASCII format. The file has 1000-2000 columns and 350 rows. I don't see how a text editor can help with this. But maybe I

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Andreas Säger
OK, this comes from the Nabble interface and from your example data I come to the conclusion that all data are integers. A generic solution for up to 1024 columns may look like this: Assumed data in Data.A1:AMJ999 A1000: =MAX(LEN(A$1:$A$999)) [this is an array formula to be entered with

Re: [libreoffice-users] Re: LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Tom Davies
Hi :) [bows] I just re-read it and i think i need to lay off the coffee! Regards from Tom :) --- On Thu, 31/5/12, Chad Neeper cnee...@level9networks.com wrote: From: Chad Neeper cnee...@level9networks.com Subject: Re: [libreoffice-users] Re: LibreOffice 3.5.4: 100% faster To:

Re: [libreoffice-users] Libreoffice headless option

2012-05-31 Thread Tom Davies
Hi :) Sorry no-one has been able so answer this so far!  We have had a rather overwhelming sudden increase in activity on this list in the last couple of days.  Hopefully someone here has experience with being headless all the time rather than just using it to open LO up as a gui.  Regards

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Andreas Säger
Am 31.05.2012 20:07, Andreas Säger wrote: Assumed data in Data.A1:AMJ999 A1000: =MAX(LEN(A$1:$A$999)) [this is an array formula to be entered with Ctrl+Shift+Enter rather than Enter] Small but important correction: =MAX(LEN(A$1:A$999)) By the way: http://user.services.openoffice.org is a

Re: [libreoffice-users] Problem with Writer

2012-05-31 Thread Tom Davies
Hi :) Hybrid Pdfs look and behave like Pdfs to most people https://wiki.documentfoundation.org/Documentation/Publications#Video_Tutorials but anyone with LO can then edited them as normal Odfs.  Advanced video tutorials covering advanced topics would be really useful there but we only have the

[libreoffice-users] Re: Can't edit database connected to Access 2010 database?

2012-05-31 Thread projectdarkness
http://nabble.documentfoundation.org/file/n3987184/Test_files.zip Test_files.zip I attached my test files via Nabble. The structure is exactly the same as the real files. -Douglas Pope P.S. All the tables have primary keys (called ID in the test files) and I didn't use any Access special

Re: [libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Steve Edmonds
On 2012-06-01 06:07, Andreas Säger wrote: OK, this comes from the Nabble interface and from your example data I come to the conclusion that all data are integers. A generic solution for up to 1024 columns may look like this: Assumed data in Data.A1:AMJ999 A1000: =MAX(LEN(A$1:$A$999)) [this is

[libreoffice-users] Re: (unknown)

2012-05-31 Thread Andreas Säger
Am 31.05.2012 19:58, Alexander Thurgood wrote: Tried entering a new tuple. Tab between fields, when I get to the last field, i.e. the dtchg field, I leave blank and press Tab. Error !! Non-nullable field. Attempt to insert null into a non-nullable column: column: ID table: seq3 in statement

Re: [libreoffice-users] Re: Fonts: Not all installed fonts are listen at font selection drop list

2012-05-31 Thread Alon Bar-Lev
On Thu, May 31, 2012 at 9:01 PM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 31/05/12 18:51, Alon Bar-Lev a écrit : Hi again, Oh... Sorry! I am using Linux. Gentoo to be specific. Version: app-office/libreoffice-3.5.4.2-r1 Hmm, look in your psfonts subdirectory and see whats in

Re: [libreoffice-users] Re: Fonts: Not all installed fonts are listen at font selection drop list

2012-05-31 Thread Alon Bar-Lev
On Thu, May 31, 2012 at 9:51 PM, Alon Bar-Lev alon.bar...@gmail.com wrote: On Thu, May 31, 2012 at 9:01 PM, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 31/05/12 18:51, Alon Bar-Lev a écrit : Hi again, Oh... Sorry! I am using Linux. Gentoo to be specific. Version:

[libreoffice-users] Choose GUI toolkit for LO session

2012-05-31 Thread v_2e
Hello! Could somebody please remind me the name of environment variable and its possible values to select which GUI toolkit to start LibreOffice with? Thanks. Vladimir - v...@ukr.net -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread berritorre
Hi all! I will give Andreas solution a try and also will check the other link. Because I guess this goes out to everyone on the list everytime. I usually don't like mailing lists. I prefer the forum style a lot more. I had hoped that there is a simpler solution than go for formulas, because with

Re: [libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Tom Davies
Hi :) Don't worry!  Many of us are on the lists because we like to see what problems people run into and how that changes over time, also many of us like to learn a little when we hear answers or enjoy getting inspired by someone else's answer and find we are able to help, perhaps,

[libreoffice-users] Re: Libreoffice headless option

2012-05-31 Thread David Bolen
merter ser...@hebux.com writes: All these commands are looking for an X server. How can I avoid it? I don't believe it's actually looking for a server, rather it just needs a library related to X11. When run in headless mode, no communication with an X server will take place, but since the LO

Re: [libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Paul D. Mirowsky
Hello berritorre I have setmy email for fixed width in hopes that this test will be clearer. The table below is a direct copy from Calc using the commands I spoke of. Letter Gothic typeface. No override of default in formatting. (assuming it is defined on import) The headers are a=column1

Re: [libreoffice-users] Choose GUI toolkit for LO session

2012-05-31 Thread Liz Young
Hi! On 05/31/2012 12:03 PM, v...@ukr.net wrote: Hello! Could somebody please remind me the name of environment variable and its possible values to select which GUI toolkit to start LibreOffice with? Maybe you are thinking of OOO_FORCE_DESKTOP? Possible values: kde (KDE), gnome (Gnome), none

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread Andreas Säger
Paul D. Mirowsky wrote Sorry but must advise using a different program as filter for export. I do not know if importing data to a Base file would export in fixed length or if it did, would be correct. Paul Of course some database engine is by far more suitable, particularly when it

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread NoOp
On 05/31/2012 09:17 AM, berritorre wrote: Hi Andreas, I thought I had posted loads of trivial example data. What could be a Actually if you are referring to: So here would be a csv file with delimiter: As a fixed length ascii file it should look like this: it didn't make it through to

[libreoffice-users] Re: Problem when exporting exporting from CALC to a fixed length csv

2012-05-31 Thread NoOp
On 05/31/2012 06:29 PM, NoOp wrote: On 05/31/2012 09:17 AM, berritorre wrote: ... I think Paul got my problem. LibreOffice shouldn't add any spaces in the first place, as long as it is not told to do. Because the spaces actually do not exist in the data and are only added for exporting the

Re: [libreoffice-users] LibreOffice 3.5.4: 100% faster

2012-05-31 Thread Andrew Douglas Pitonyak
I want the performance gain while saving. I routinely work on large documents. I open them once, then save them repeatedly. That said, i am all for faster :-) On 05/30/2012 10:57 PM, chimak111 wrote: Apropos the announcement and referring to [i]with up to 100% performance gains when