[libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Andreas Säger
Am 26.05.2012 22:13, Girvin R. Herr wrote: Andreas, Yes! Plus the com.mysql.jdbc.Driver class and the MySQL (JDBC) connection type option. And I am using the MySQL-connector-java-5.0.7-bin.jar in the class path and the MySQL 5.0.67 server. Sun (Oracle) Java version 1.6.0_30 All test okay, of

[libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Andreas Säger
Say X99 displays 0.005. Turn on menu:ViewHighlight Values [Ctrl+F8]. What is the font color of X99? A blue color proves that X99 is a number. Text appears black. Get some unused cell and enter =X99=0.005 What is the result? Should be either TRUE or FALSE. If FALSE, what is the result of

[libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Andreas Säger
Am 25.05.2012 09:35, Tom Davies wrote: Hi :) I think there is another way to build reports? I think Andreas uses a different way inside Base. Other people seem to start with the report builder and then hack it around. It might be worth search the archives to find how Andreas does reports!

[libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Andreas Säger
Am 25.05.2012 10:04, Tom Davies wrote: Sadly most of the people that know a lot about the ins-and-outs of Base are unwilling to help write the Base guide so it's down to 1 person who is desperately busy with a lot of other projects. How would you write a guide for hammer, chisel, plow, saw

[libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Andreas Säger
Am 25.05.2012 16:31, Rich Shepard wrote: On Fri, 25 May 2012, Mirosław Zalewski wrote: Can you post your document somewhere on the web? I think that there are users who are just curious what's so special about your data that neither of tips have worked for you. Mirosław, It's client data so

[libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Andreas Säger
Am 25.05.2012 15:14, Rich Shepard wrote: On Fri, 25 May 2012, Andreas Säger wrote: Turn on menu:ViewHighlight Values [Ctrl+F8]. What is the font color of X99? A blue color proves that X99 is a number. Text appears black. Other than column A (site names), every other cell is blue. I'm going

[libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread Andreas Säger
Am 24.05.2012 19:39, SuneOskar wrote: Is Tkinter supported ? -- View this message in context: http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866.html Sent from the Users mailing list archive at Nabble.com. help modules Tkinter Here is a list of matching modules. Enter any

[libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread Andreas Säger
Am 25.05.2012 21:00, Andreas Säger wrote: Am 24.05.2012 19:39, SuneOskar wrote: Is Tkinter supported ? -- View this message in context: http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866.html Sent from the Users mailing list archive at Nabble.com. help modules Tkinter Here

[libreoffice-users] Re: Writer crashing saving in docx format

2012-05-24 Thread Andreas Säger
Am 24.05.2012 16:27, Jay Lozier wrote: If you are using Linux MSO is NOT an option because there is no Linux version of MSO. Stop assuming that someone has access to Windows or can afford to buy a retail copy of MSO. Many LO users have limited finances and can not afford to buy new software

[libreoffice-users] Re: Writer crashing saving in docx format

2012-05-24 Thread Andreas Säger
Am 24.05.2012 16:27, Jay Lozier wrote: Stop assuming that someone has access to Windows or can afford to buy a retail copy of MSO. Many LO users have limited finances and can not afford to buy new software and possibly the hardware to run it. A Pentium PC with Office '97 reads and writes

[libreoffice-users] Re: Is ^ different in Mac??

2012-05-24 Thread Andreas Säger
Am 24.05.2012 18:26, Alexander Thurgood wrote: Le 24/05/12 01:58, alex sato a écrit : Hi Alex A friend downloaded and installed Mac version of LibreOffice (he has a Mac). He told me that he can't use ^ simbol to calculate exponentiation in ooBasic b ecause always get syntax error or

[libreoffice-users] Re: Hiding negative numbers in Clac?

2012-05-24 Thread Andreas Säger
Am 24.05.2012 18:11, Regina Henschel wrote: If you really want only change the display, then use the format code Standard;;Standard as cell format. which is General;;General in English locale context. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-24 Thread Andreas Säger
Am 24.05.2012 21:01, Girvin R. Herr wrote: I will certainly take your experience to heart and your recommendation to update my Java. Thanks again. Girvin If you are running Java 1.7 downgrading to some recent 1.6 version may be even more helpful. Until now I could not test RB with Java 1.7

[libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-24 Thread Andreas Säger
Am 24.05.2012 21:33, Andreas Säger wrote: Am 24.05.2012 21:01, Girvin R. Herr wrote: I will certainly take your experience to heart and your recommendation to update my Java. Thanks again. Girvin If you are running Java 1.7 downgrading to some recent 1.6 version may be even more helpful

[libreoffice-users] Re: Maintaining Calc spreadsheet w/ multiple headers/subheaders

2012-05-24 Thread Andreas Säger
Am 24.05.2012 21:22, avamk wrote: Hello, Here is a scenario that I am trying to deal with in a Calc spreadsheet: (1) Every year Bill and Nancy measure the weights and heights of four people. (2) The four people being measured are Fred, Joe, Alice, and Beatrice. Right now the measurements for

[libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-23 Thread Andreas Säger
With LibO 3.5 under Linux I can use any recent Java version without any issues. I tested 1.6.22, 1.6.31 and 1.7. Any of these simply work with my Java databases. I avoid the report builder like illness. If you feel the need to dance with this software diva then you should do all calculations,

[libreoffice-users] Re: No QuickStarter? (Linux)

2012-05-21 Thread Andreas Säger
Am 21.05.2012 14:26, Stefan Weigel wrote: Hi, Am 21.05.2012 14:00, schrieb James Knott: From the users point of view, QuickStarter also is an alternative (and by some users preferred) way of accessing LibrOffice in the GUI, with nice shortcuts for opening documents or creating new

[libreoffice-users] Re: No QuickStarter? (Linux)

2012-05-21 Thread Andreas Säger
Am 21.05.2012 14:55, Stefan Weigel wrote: Am 21.05.2012 14:37, schrieb Andreas Säger: How would I add a menu like this http://ipir.at/menu to the panel, without activating QuickStarter? swriter scalc simpress sdraw sbase smath soffice .uno:NewDoc soffice .uno:Open Ok yes. However

[libreoffice-users] Re: No QuickStarter? (Linux)

2012-05-21 Thread Andreas Säger
Am 21.05.2012 14:45, Tom Davies wrote: Hi :) I hadn't realised about the menu. I guess it is a good reason for having the QuickStarter in GnuLinux. However there are a lot more serious changes in the entire interfaces of most OSes in the last year or so. It would be good to be able to have

[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file

2012-05-21 Thread Andreas Säger
Am 21.05.2012 23:40, Jonathan Ryshpan wrote: blah Ask your question on a SQLite forum with some _technical_ information about your operating system, SQLite version of the creating application, driver version, configuration file, connection URL of the client (Base

[libreoffice-users] Re: Can you exclude spell checking from a style?

2012-05-20 Thread Andreas Säger
Am 20.05.2012 09:40, Simon Cropper wrote: Hi, Simple situation. I have a range of scientific names dumped from a database. The names are set and should not be changed. None are recognized by the spell checker. I know you can select text and tell LO to not check the spelling but can you tell LO

[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file

2012-05-20 Thread Andreas Säger
Base opens only one particular type of file: the Base document (*.odb). This file format is basically an archive with info about how to access a certain tabular data source, where to find it, which protocol to use, which file filter, which vendor specific driver (analog to a file system driver).

[libreoffice-users] Re: ThreadDeath using BasicOfficeBean.java in LibreOffice

2012-05-19 Thread Andreas Säger
Q1: As far as I know, the scripting interface did not change a byte since OOo 1.1 (don't know which StarOffice version that was). Q2: I don't know how many persons world wide ever used BeanShell as macro language. May be hundred? Thank you for sharing whatever you find out. If you think there is a

[libreoffice-users] Re: What versions of LibO and Java-JRE to install today?

2012-05-18 Thread Andreas Säger
And the answer remains the same all days. No problems with LibreOffice 3.5.3 and any version of Java whereas LibO3.4 can handle the (still maintained) 1.6 branch. -- View this message in context:

[libreoffice-users] Re: Problem with using Zotero

2012-05-18 Thread Andreas Säger
David-4 wrote I have LO 3.5.3.2 installed and Java 7.0 u4 x86_64 installed on Windows 7 x86_64 and I have no problems with LO databases. -- David Whatever LO databases means. The built-in bibliography is dBase and does not require any Java at all. Java_64 can not interface with a 32

[libreoffice-users] Re: Problem with using Zotero

2012-05-18 Thread Andreas Säger
Am 18.05.2012 20:34, David wrote: On 5/18/2012 2:25 PM, Andreas Säger wrote: David-4 wrote I have LO 3.5.3.2 installed and Java 7.0 u4 x86_64 installed on Windows 7 x86_64 and I have no problems with LO databases. -- David Whatever LO databases means. The built-in bibliography is dBase

[libreoffice-users] Re: Problem with using Zotero

2012-05-18 Thread Andreas Säger
Am 18.05.2012 23:24, David wrote: Really? Then why did some version of Java always come with OpenOffice. And was required for 'something' (I thought it was the database module) to work? No, not even Base requires any Java to be useful. You can do almost anything with non-Java databases. Just

[libreoffice-users] Re: Can't create python script?

2012-05-17 Thread Andreas Säger
Am 17.05.2012 03:15, Kelly Holman wrote: When I go to tools - macros - organize macros - python I can't create or edit scripts. The buttons are grayed out. It does have a few sample scripts, which I can run. I went to the extension manager and found script provider for python so

[libreoffice-users] Re: Base and Java 1.7 - does not work

2012-05-17 Thread Andreas Säger
Am 17.05.2012 02:32, NoOp wrote: Perhaps if you would include some quotation from the post others could understand what you are replying to. I see nothing in the OP that indicates 'steelej' was using a 64 bit version. You are right. Java 1.7 works well with LibO 3.5. I tested with

[libreoffice-users] Re: Can't create python script?

2012-05-17 Thread Andreas Säger
Am 17.05.2012 13:04, Tom Davies wrote: Hi :) Ahhh, thanks Andreas! Do text-editors such as Gedit, Kate, SciTe count as IDEs or are IDEs a tad more technical? Regards from Tom :) The minimum Swiss knife for Python macros consists of Writer and a shell. When I need to fix Python on a Windows

[libreoffice-users] Re: Base and Java 1.7 - does not work

2012-05-17 Thread Andreas Säger
Am 17.05.2012 15:48, Pertti Rönnberg wrote: Dear LibreO folks out there, In two of his mails Andreas Säger says In any case it -- (Java 1.7) -- has to be 32 bit because under Windows the office (LibreOffice) is a 32 bit application. The 32/64 Java bits have to match with the LibreOffice

[libreoffice-users] Re: Can't create python script?

2012-05-17 Thread Andreas Säger
Redirect the output to a file and link the file content? How can I tell without the faintest idea about the purpose nor the exact flavour of data? Once upon a time there used to be some Perl module for UNO. Being a Perl programmer you may even manipulate the XML source code of an ODF document. --

[libreoffice-users] Re: Can't create python script?

2012-05-17 Thread Andreas Säger
Am 17.05.2012 22:31, Andreas Säger wrote: Anyhow, on my Linux system the following Basic macro ... Sub Main x = shell(~/bin/number2words.pl,0,123) End Sub ... executes number2words.pl in no visible window and with argument 123. The output one hundred twenty three is dumped to the shell from

[libreoffice-users] Re: Can't create python script?

2012-05-17 Thread Andreas Säger
Am 17.05.2012 23:05, Kelly Holman wrote: Thanks Andreas. You may be right about running a perl script under windows. I have the installation but haven't used it yet. It's a long time since I've done any real programming. In the meantime, I think I've found another way that would work more

[libreoffice-users] Re: Base and Java 1.7 - does not work

2012-05-16 Thread Andreas Säger
Sorry, I forgot to mention that even Base is usable without Java. Most of the Java additions do not add any functionality of importance and the *embedded* HSQLDB is not worth trying anyway. Important: HyperSQL as a stand-alone database is mature, best breed Java software and extremely useful.

[libreoffice-users] Re: LibreOffice croatian hyphnation

2012-05-16 Thread Andreas Säger
Am 16.05.2012 18:32, Krunoslav Šebetić wrote: @ Andreas Säger I did that with my tamplate, I thicked Croatian and For the current document only in ToolsOptionsLanguagesDefault languages for Documents but nothing. When I save my tamplate after modification, and if I again go

[libreoffice-users] Re: LibreOffice croatian hyphnation

2012-05-15 Thread Andreas Säger
How to make Croatian documents: Open a new document in component Writer/Calc/Draw/Impress menu:FilesProperties, Note the template name on the first tab at the bottom. If there is no template name: ToolsOptionsLanguagesSettingsLanguagesDefault Language=Croatian, This Document only=OFF This is for

[libreoffice-users] Re: Base and Java 1.7 - does not work

2012-05-15 Thread Andreas Säger
There is no reason to run Java 1.7 unless required by some bleeding edge application. Even then you can install a second Java 1.6 and point the office to that installation. In any case it has to be 32 bit because under Windows the office is a 32 bit application. -- For unsubscribe

[libreoffice-users] Re: calc: linking to closed docs

2012-05-14 Thread Andreas Säger
Calculators always need to load all involved data sets into memory. Get professional and use a database instead. -- View this message in context: http://nabble.documentfoundation.org/calc-linking-to-closed-docs-tp3983737p3983775.html Sent from the Users mailing list archive at Nabble.com. --

[libreoffice-users] Re: DocX

2012-05-14 Thread Andreas Säger
Tanstaafl wrote The problem with the Compatability Pack is, it takes over *all* file associations for *all* Office documents, including the ordinary .doc, .xls and .ppt files... this confuses users who are not computer saavy... -- Why bother about users who are not computer savvy?

[libreoffice-users] Re: mailing

2012-05-14 Thread Andreas Säger
It never worked this way. Data always come from a database document (.odb) which itself may be connected to a spreadsheet (worst choice) or various other tabular data sources (plain text, dBase, address books, true databases). Unforturnately, this matter of fact is striktly hidden from the user

[libreoffice-users] Re: DocX

2012-05-11 Thread Andreas Säger
Am 11.05.2012 09:51, Tom Davies wrote: Hi :) They might be good on Windows machines but i suspect they are not perfect at reading DocX either. MSO 2010 implements DocX differently from 2007 and according to Microsoft's 2010 installer it can be different on different on different versions of

[libreoffice-users] Re: Freezing a cell in Calc permanently

2012-05-11 Thread Andreas Säger
Am 10.05.2012 23:38, The Wolfkin wrote: I'm confused because as far as I can tell in this thread you're the first person to even mention xlsx or xls. I don't think I mentioned that file format in the other thread. In your other topic you mentioned that you save in foreign file formats by

[libreoffice-users] Re: Freezing a cell in Calc permanently

2012-05-11 Thread Andreas Säger
Am 10.05.2012 23:38, The Wolfkin wrote: I'm confused because as far as I can tell in this thread you're the first person to even mention xlsx or xls. I don't think I mentioned that file format in the other thread. By the way: The Gnumeric spreadsheet saves xlsx with frozen panes flawlessly.

[libreoffice-users] Re: HOWTO change all-user default file formats (Windows), for LOo3.5?

2012-05-11 Thread Andreas Säger
Am 11.05.2012 10:47, ultraxlnt-domai20044...@yahoo.com wrote: Hi Tom, Thanks for the quick reply. I probably wasn't clear enough about the goal being that any users added to the machines (post facto) would get MS default formats without doing (knowing how to do) anything. (I was recently

[libreoffice-users] Re: Freezing a cell in Calc permanently

2012-05-11 Thread Andreas Säger
Am 11.05.2012 16:09, Tom Davies wrote: Hi :) Ahhh, i take it back then. I didn't realise Gnumeric is better at doing MS Formats. The only thing i noticed was that it couldn't be set to default to saving as MS Formats or anything else. I had to use Save As, not a big problem for me but

[libreoffice-users] Re: HOWTO change all-user default file formats (Windows), for LOo3.5?

2012-05-11 Thread Andreas Säger
Am 11.05.2012 16:44, Jay Lozier wrote: I think the problem is the users do not understand Save As will allow them to save in different format. Thus the problem of file default file settings for LO with some users. I have worked with people who have never understood what Save As does in any

[libreoffice-users] Re: HOWTO change all-user default file formats (Windows), for LOo3.5?

2012-05-11 Thread Andreas Säger
Am 11.05.2012 19:59, Doug wrote: I know this is not a popular opinion with certain folks, but I believe you should save ALL documents in either .doc or .rtf format. Why keep files in a format most people can't read? Just because Microsoft invented it is no reason not to use it. You use their

[libreoffice-users] Re: HOWTO change all-user default file formats (Windows), for LOo3.5?

2012-05-11 Thread Andreas Säger
Am 11.05.2012 20:45, Jay Lozier wrote: I understand the legitimate technical issues that you are raising but unfortunately the problem is with the ultimate end user. The real solution is social not technical of training and education. My observation is there are significant number of users who

[libreoffice-users] Re: Cal default print settings (and general default settings)

2012-05-10 Thread Andreas Säger
Am 10.05.2012 02:51, The Wolfkin wrote: another quick one. by default Calc doesn't print the grid or column/row headers. For everyone for whom I suggest LibreOffice this is a huge problem. Is there a way to change settings by default? Speaking of default settings.. on a slightly more off topic.

[libreoffice-users] Re: Templates Disappeared

2012-05-10 Thread Andreas Säger
Am 10.05.2012 11:37, Keith Bates wrote: I get all that. It's not helping. I've edited the paths. I've even deleted them and re-added them. The templates are in the correct folder but LO isn't finding them. There isn't even a folder in the organiser for any templates-- My Templates isn't there.

[libreoffice-users] Re: Templates Disappeared

2012-05-10 Thread Andreas Säger
Am 10.05.2012 12:19, Keith Bates wrote: I deleted all the existing templates in .config/.libreoffice/3/user/template. Then I opened a template and tried to save as a template and got this error: Error writing document Untitled2 as template: templates already exists Click OK and it opens the box

[libreoffice-users] Re: Cal default print settings (and general default settings)

2012-05-10 Thread Andreas Säger
Am 10.05.2012 14:15, The Wolfkin wrote: Sorry I can't possibly switch anyone to a program that requires this much work to save in an excel format http://www.vladd44.com/ubuntu-linux/gnumeric_save_excel.php Our usage scenarios are relatively simple. Gnumeric's accuracy advantages will likely

[libreoffice-users] Re: Freezing a cell in Calc permanently

2012-05-10 Thread Andreas Säger
Am 10.05.2012 14:29, The Wolfkin wrote: Thanks Tom I did actually figure that part out. It was just when i saved and closed the file. I tried to open it again and the row wasn't frozen. I assumed that was intentionally and didn't know how to change it. Now i see that it was a bug and i need to

[libreoffice-users] Re: Freezing a cell in Calc permanently

2012-05-10 Thread Andreas Säger
Am 10.05.2012 21:33, Andreas Säger wrote: You forgot to mention that you save in some foreign format. Obviously you do even save in xlsx which is the worst choice. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

[libreoffice-users] Re: Combining data rows on one sheet

2012-05-08 Thread Andreas Säger
Am 08.05.2012 07:01, Kelly Holman wrote: Is there some way to do this, without programming? Hello, CopyPaste is the way to go. Merge all your data in a single table and let the softare do the rest.

[libreoffice-users] Re: Email more than once .doc file

2012-05-08 Thread Andreas Säger
Am 07.05.2012 06:04, Marc Paré wrote: A couple of users who are using LibreOffice professionally are wondering if it was possible to email their .odt files through the File-Send-Email as Microsoft Word not only one at a time? There are many occasions where they need to email to contacts but need

[libreoffice-users] Re: Read error on .ods file

2012-05-08 Thread Andreas Säger
Am 08.05.2012 12:49, Tom Davies wrote: Hi :) Archive Manager is the generic name that covers a large number of different programs such as the ones you have found. I heard that something like 7up (i thought that was a drink) was a good one along with WinRar, WinZip and others. It should be

[libreoffice-users] Re: Email more than once .doc file

2012-05-08 Thread Andreas Säger
Am 08.05.2012 14:15, James Knott wrote: Andreas Säger wrote: Do the send as MS Word with as many ODF documents as you like. When you are done drag all the attachments into one email and close them without saving. How do you drag the attachments? Where do you drag them from? Thunderbird

[libreoffice-users] Re: blog with great comparison table between LO and AOO

2012-05-08 Thread Andreas Säger
krackedpress wrote In his blog, Michael Weeks has as a great table comparison between LO and Apache's OO. I would love to see something like this between LO and MSO. http://people.gnome.org/~michael/blog/2012-04-26-ooo-comparison.html

[libreoffice-users] Re: IPad?

2012-05-06 Thread Andreas Säger
Why should MSOffice support ODF? Why should Apple allow virtual machines on their iPads? You can wait until another hacker team opens that platform for unauthorized software which of course will not change the matter of fact that 99% of all users are happy with what they are allowed to do. --

[libreoffice-users] Re: IPad?

2012-05-06 Thread Andreas Säger
Am 06.05.2012 14:38, Renaud (Ron) Olgiati wrote: On Sunday 06 May 2012 08:21 my mailbox was graced by a message from Andreas Säger who wrote: Why should MSOffice support ODF? Because in more and more places (think European Union) it is becoming a legal obligation to publish official texts

[libreoffice-users] Re: Using Copy only visible cells version 1.0.5 on subtotal summary causes Calc to exit

2012-05-05 Thread Andreas Säger
Am 05.05.2012 14:24, chimak111 wrote: LibreOffice 3.5.3.2 Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80 O/S Ubuntu 12.04 Computer: Dell Inspiron 1545 Processor: Intel® Core™2 Duo CPU T6400 @ 2.00GHz × 2 Memory: 3.9 GiB *Using Copy only visible cells version 1.0.5 to copy subtotal summary

[libreoffice-users] Re: transfer of customised styles

2012-05-04 Thread Andreas Säger
Am 04.05.2012 10:30, e-letter wrote: Sorry, but should have clarified that the version LO334 is used. In this version, there is no option to select source and target documents. This is the same dialog since version 1. You drag styles from one document or template to some other document or

[libreoffice-users] Re: [3.5.1.2/Calc/XP] Regex to find/replace numbers?

2012-05-03 Thread Andreas Säger
Am 03.05.2012 12:38, Steve Edmonds wrote: It looks like AOO3.4 will support ICU regexp, so \s(\d\d)(\d\d)(\d\d) would become valid and replacement with $n values possible. Means I can search and replace dates changing format. Especially useful in writer. Cheers, Steve Dates can be set in

[libreoffice-users] Re: Inserting comment causes Impress to close without warning

2012-05-03 Thread Andreas Säger
Am 03.05.2012 13:20, chimak111 wrote: Reported here: http://ubuntuforums.org/showpost.php?p=11899154postcount=261 and some subsequent posts PS: application bugs: whole different issue. Try this on 12.04; Load LibreOffice Impress, start a new presentation and make a new slide. Select Insert

[libreoffice-users] Re: Inserting comment causes Impress to close without warning

2012-05-03 Thread Andreas Säger
Am 03.05.2012 14:34, Tom Davies wrote: Hi :) Crashes often seem to be due to a wrong version of java but i can't imagine java being called for that sort of thing. Mac users especially should make sure they have the ultra-latest version. It is possible for most people to get the pre-release

[libreoffice-users] Re: [3.5.1.2/Calc/XP] Regex to find/replace numbers?

2012-05-03 Thread Andreas Säger
Am 03.05.2012 12:38, Steve Edmonds wrote: It looks like AOO3.4 will support ICU regexp, so \s(\d\d)(\d\d)(\d\d) would become valid and replacement with $n values possible. Means I can search and replace dates changing format. Especially useful in writer. Cheers, Steve Once again: Nope. They

[libreoffice-users] Re: printing docs with comments?

2012-05-03 Thread Andreas Säger
Am 03.05.2012 19:49, Rogier F. van Vlissingen wrote: Is there a way to print docs complete with comments ToolsOptionsWriterPrintComments -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Fonts Re: Albany ? Thorndale ?

2012-05-02 Thread Andreas Säger
Am 02.05.2012 15:06, Renaud (Ron) Olgiati wrote: On Wednesday 02 May 2012 08:55 my mailbox was graced by a message from Andreas Säger who wrote: The fonts have nothing to do with this particular program. You are the one to buy the fonts you need for one computer and all of its software

[libreoffice-users] Re: [3.5.1.2/Calc/XP] Regex to find/replace numbers?

2012-05-02 Thread Andreas Säger
Am 02.05.2012 20:03, Steve Edmonds wrote: Hi. Is the object to then paste the new number from $1 $2 $3 to get the new formatting? Is there always white space at the front \s(\d\d)(\d\d)(\d\d) steve Nope. You should really start the software and try before posting. Perl regexes are not

[libreoffice-users] Re: IPad?

2012-05-02 Thread Andreas Säger
Am 02.05.2012 23:38, Mark Stanton wrote: Is there a LO for the iPad? Mark Apple does not allow free software on that platform. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

[libreoffice-users] Re: How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

2012-05-01 Thread Andreas Säger
Am 01.05.2012 01:45, Tom Davies wrote: Hi :) If you feel you could produce good guides then i'm sure the docs team would be glad to welcome you in. Regards from Tom :) No, they woudn't! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-05-01 Thread Andreas Säger
Am 01.05.2012 16:04, Ant wrote: Is there a way to tell LO not to look for/use Java? I still use v6 u31 because v7 is still not ready for the normal usage according to http://www.java.com/en/download/faq/java7.xml ... I only use Java for my work's time card system. :( It runs perfectly well

[libreoffice-users] Re: Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-05-01 Thread Andreas Säger
Am 01.05.2012 19:05, Ant wrote: You can turn off all Java in menu:ToolsOptionsJava. The only problem is that I can't get to LibreOffice to change the options. Is there a way to do it with its configuration files/Windows' registry? My config file

[libreoffice-users] Re: Wanted: Macro for removing Page Breaks in MailMerge docs

2012-05-01 Thread Andreas Säger
Am 01.05.2012 22:25, Nino Novak wrote: Hi, when producing MailMerge text documents, semi-automatic Page Breaks are inserted which can only be removed manually one by one, but not all together by e.g. selecting the whole document (Ctrl+A) and removing Page Breaks in the Format Paragraph dialog.

[libreoffice-users] Re: How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

2012-04-30 Thread Andreas Säger
Am 30.04.2012 21:20, Tom Davies wrote: Hi :) Hopefully other people will have better answers later but it might be worth having a quick flick through likely chapters in the official documentation on http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide Good luck

[libreoffice-users] Re: How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

2012-04-30 Thread Andreas Säger
Am 01.05.2012 00:35, Richard Quadling wrote: Perfect. At least now I can get data into a spreadsheet. Next I need to work out calling stored procedures and passing user parameters to the SP as well as automated updating (on open and on parameter changing). These are probably macro based

[libreoffice-users] Re: rtf import broken in 3.5.1?

2012-04-27 Thread Andreas Säger
Am 27.04.2012 09:13, Milos Sramek wrote: Dear Tom, do you have any references to those court cases? Sounds very interesting. RTF is in Slovakia one of the officialy approved standards to be used by public administration (besides pdf, odf and HTML). Of course, since MS is everywhere and

[libreoffice-users] Re: Updating a previously opened ods via Python script without closing LibreOffice

2012-04-26 Thread Andreas Säger
Create a dedicated directory. Put your data.ods into that directory. I would use .txt or .csv as file name suffix here. FileNewDatabase... Connect to existing database. Type: Text Specify .ods as name suffix, the column separator, encoding, text separator. [x] Register the database Save the

[libreoffice-users] Re: rtf import broken in 3.5.1?

2012-04-26 Thread Andreas Säger
RTF never really worked in OOo nor LibO and there are reasons why: http://diaryproducts.net/for/geek/microsoft_rtf_specification_nightmare -- View this message in context: http://nabble.documentfoundation.org/rtf-import-broken-in-3-5-1-tp3877445p3942245.html Sent from the Users mailing list

[libreoffice-users] Re: Windows - Lost my new file entries

2012-04-26 Thread Andreas Säger
Nils Jeppe wrote Hi Guys, Got a small semi-cosmetic issue, and I have absolutely no idea how it happened. I did have OOo installed, and deinstalled while I kept LO, and I noticed this afterwards - no clue if that's got something to do with it. Anyway, I am a big user of the

[libreoffice-users] Re: Convert multi-sheet ods to csv files

2012-04-24 Thread Andreas Säger
Am 03.04.2012 11:54, Pedro wrote: I found out that it does work. But it opens and displays the file first, which is exactly what I didn't want to happen. The problem is that I'm working with 100.000+ lines xls documents and because they are heavily formatted (don't ask! :) ) it takes ages to

[libreoffice-users] Re: Convert multi-sheet ods to csv files

2012-04-24 Thread Andreas Säger
Am 24.04.2012 01:21, jjjk wrote: FYI As an alternative Gnumeric makes it very easy to extract individual sheets to csv (even on Windows). Reading this gives me yet another reason to learn Python. Cheers, John -- View this message in context:

[libreoffice-users] Re: Significant Memory Leaks As An UNO Service Provider

2012-04-24 Thread Andreas Säger
Am 24.04.2012 20:10, Adam Tauno Williams wrote: We run OOo/LOo headless in order to utilize services via UNO from a web application. Works great. But it leaks memory rather badly, and eventually gets killed off for out-of-memory conditions. Out of memory: Kill process 9145 (soffice.bin)

[libreoffice-users] Re: database

2012-04-23 Thread Andreas Säger
Walther Koehler wrote to Andreas Säger lt;villeroy@gt; Hallo Andreas, thank you for your short practical guide how to use a .dbf for serial letters. I spent a lot of time fiddling around reading books etc. and couldnt come up with a result. With your advice LO did what I want

[libreoffice-users] Re: launching app from within base

2012-04-23 Thread Andreas Säger
brainflakes wrote Thanks! I don't see a URL setting in the Table Design. Other doesn't seem to be the correct type. All forms are ordinary Writer documents and starting some other program has nothing to do with Base. InsertHyperlink... There you can point to some macro, file, web-page,

[libreoffice-users] Re: launching app from within base

2012-04-23 Thread Andreas Säger
Nino wrote As I said, I don't see a type for URL other than text. But, it looks like I could implement a macro or I also see there is some sort of python link in OL. I don't know much about how to write OL macros, but on briefly looking, it looks like it is too hard. Anyone know if

[libreoffice-users] Re: database

2012-04-21 Thread Andreas Säger
Am 20.04.2012 16:39, Elizabeth Lawrence wrote: HI, I have downloaded libreoffice in order to use the database. I can bring up the database but the one I want use wont open the wizard for tables. I have tried to uninstall libreoffice twice but it wont go. My blood pressure is soaring - please

[libreoffice-users] Re: database

2012-04-21 Thread Andreas Säger
Am 20.04.2012 22:07, Elizabeth Lawrence wrote: Hi Nick, I'm using Mac OS X 10.5.8. I am trying to start a new database and trying to click on use Wizard to create table. It doesn't click properly and the suggestion of creating a table using the Wizard vanishes. I have to confess I haven't used

[libreoffice-users] Re: calc compliance with openformula

2012-04-21 Thread Andreas Säger
Am 20.04.2012 15:57, e-letter wrote: Readers, According to the specification for openformula (see: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html), the syntax for the function 'sum' is: SUM( { NumberSequenceList N }+ ) Analog to a regular expression, this means:

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-21 Thread Andreas Säger
Am 21.04.2012 15:46, Ian Whitfield wrote: This leaves me wondering if the .jre file is at fault. It's new, (I downloaded it yesterday), and is 1.4Mb in size?? This is the md5sum of my working hsqldb-2.2.8.zip: $ md5sum ~/download/hsqldb-2.2.8.zip 8b7668689cd208867c77f2f4d77922de

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-21 Thread Andreas Säger
Am 21.04.2012 18:58, Mark Stanton wrote: Copying the structure and data in one go, as offered by the import wizard, never creates any auto-ID fields. Would this be a sensible improvement to make? Mark Stanton One small step for mankind... Hello Mark, Yes, it would be useful to have more

[libreoffice-users] Re: Calc Data Filter, Standard Filter, Value lost during restart?

2012-04-20 Thread Andreas Säger
Am 19.04.2012 23:37, lagagnon wrote: Can anyone suggest what is going on. BTW this is LibreOffice v3.5.1.2 under ArchLinux. thanks in advanceLarry Your sheet name is Database1 so I assume that you have more such databases. 1) Select the range to filter. 2) DataDefine... enter some

[libreoffice-users] Re: Open Office and Libre Office Questions...

2012-04-20 Thread Andreas Säger
Am 19.04.2012 14:34, R.S. wrote: Hi, although it colud be possible, the installation program registers on the registry the same associations. So what? There can be many programs to open a certain type of files. But only one program that loads a given file on a double-click. On my Linux laptop

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Andreas Säger
Am 20.04.2012 10:48, Ian Whitfield wrote: On 20/04/2012 01:18, Andreas Säger wrote: There are not many users who suffer from the limited capabilities of HSQL 1.8. A high risk of total data loss is the main reason why one must not use the embedded database. Getting an embedded database out

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Andreas Säger
Am 20.04.2012 14:08, Mark Stanton wrote: Hi Ian, The easy version is :- 1) Open your database with the HSQLDB embedded data. 2) In a separate window, create a new database with any other kind of data engine. 3) Drag the tables from the embedded database to the new database, one by one.

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Andreas Säger
Am 20.04.2012 16:48, Ian Whitfield wrote: /home/ian/software/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar menu:ToolsOptionsJava Button Class Path Button Add Archive and point to the above one. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-19 Thread Andreas Säger
Am 19.04.2012 13:00, ptoye wrote: Mark Stanton wrote I think I'm being misunderstood here. I've never mentioned trying to link Base and Word - that's not something I want to do. You do it all the time. All of your input forms are attached to Writer documents. All I originally asked

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-19 Thread Andreas Säger
Am 19.04.2012 20:45, Pertti Rönnberg wrote: LibO-folks, From this long and very interesting thread and some other discussions on this mailing list too, together with my own recent experiences, there is only one main conclusion to draw: There is no real future forLibO's Base module, perhaps

<    3   4   5   6   7   8   9   10   11   12   >