[libreoffice-users] Re: repeated search

2012-07-25 Thread Andreas Säger
Hi, The little box is supposed to be kept visible. If you keep it visible, you can refocus your document and keep the current search term. As far as I know, this requires a mouse click. It can be docked and undocked like any other dockable window or toolbar. Now Ctrl+H is the shortcut for the fully

[libreoffice-users] Re: Batch conversion from csv

2012-07-24 Thread Andreas Säger
Am 24.07.2012 20:11, Michael Crider wrote: which only exports as csv. The reason I attempted other spreadsheet types is because dBase files can be opened directly in Calc, as well as accessed through Base. I am open any suggestions for improving this process. Connect a Base document to your I

[libreoffice-users] Re: SQL statement in Base query

2012-07-24 Thread Andreas Säger
Am 23.07.2012 23:54, Dan wrote: Ferry Toth wrote: Did you try with another database as a backend? I like postgres as a backend a lot. Ferry I am writing a chapter of the Base Guide that includes using SQL in the Query Design dialog. Chapter 8 of the Base Guides covers using HSQLDB 2.2.8

[libreoffice-users] Re: Batch conversion from csv

2012-07-24 Thread Andreas Säger
Am 24.07.2012 13:34, Michael Crider wrote: I have csv files generated from an SQL command-line utility that I am trying to convert to dBase using the batch converter. If I open the csv in LibreOffice, a default option is "Quoted fields as text", and if it is saved as another filetype, those field

[libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Andreas Säger
Am 23.07.2012 14:44, Guy Voets wrote: Hi folks, A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown as 20 Jul 12. - In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell. If I enter 20-7-

Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-23 Thread Andreas Säger
Am 20.07.2012 21:37, Johnny Rosenberg wrote: 2012/7/20 Andreas Säger: Am 20.07.2012 14:19, Andreas Säger wrote: Try my "SpecialCells" extension which selects combinations of cell types: http://user.services.openoffice.org/en/forum/download/file.php?id=11048 Done. Snippet recor

[libreoffice-users] Re: Filter rows of certain dates, LibreOffice Calc

2012-07-22 Thread Andreas Säger
Am 22.07.2012 19:31, Johnny Rosenberg wrote: Thanks for the suggestion. However, I failed making it work. I tried a few different variations on that and either nothing happened at all, or I got an error message saying that there are no valid filter parameters in that range of cells. Kind regar

[libreoffice-users] Re: Labeling in Calc

2012-07-22 Thread Andreas Säger
yet ready for masses and does take some fairly considerable expertise "to get it right". Set-up is not trivial even if some people find it easy. Regards from Tom :) --- On Sun, 22/7/12, Andreas Säger wrote: Please ignore Tom. He is very kind but totally ignorant towards LibreOffice

[libreoffice-users] Re: Chart Office compatibility issue

2012-07-22 Thread Andreas Säger
Am 22.07.2012 18:10, Regina Henschel wrote: A first step might be to add a request to LO bugzilla. But I personally liked more, when named ranges would be possible. Kind regards Regina Named ranges are named formula expressions. Formula expressions would include constant arrays. -- For

[libreoffice-users] Re: Labeling in Calc

2012-07-22 Thread Andreas Säger
Am 22.07.2012 01:48, Andrew Brager wrote: On 7/21/2012 10:47 AM, Andreas Säger wrote: Am 20.07.2012 23:50, Andrew Brager wrote: Nevermind, I figured it out. In case anyone else has a similar desire and wants to know... I simply select all the rows I want to belong to a group, add a border

[libreoffice-users] Re: Filter rows of certain dates, LibreOffice Calc

2012-07-22 Thread Andreas Säger
Am 22.07.2012 13:27, Johnny Rosenberg wrote: I searched for Standard Filter examples and the only thing I found had a string or a number in the Value fields. I want to use an expression instead, but that doesn't seem possible, or maybe I'm just doing it wrong. For example: Column A>= Today

[libreoffice-users] Re: LibreOffice pause during startup

2012-07-21 Thread Andreas Säger
Am 22.07.2012 00:05, Anthony Easthope wrote: If there is no registry or temporary paging system within the OS then how does that work? It is a curiosity within itself :D Windows is the only system with a registry database. Under Linux everything is a file. All configuration is written into

[libreoffice-users] Re: LibreOffice pause during startup

2012-07-21 Thread Andreas Säger
Am 20.07.2012 08:44, Robert Mesibov wrote: I'm running LibreOffice 3.4.6 OOO340m1 (Build:602) on Debian Squeeze. The progress bar on the splash screen stops part-way during startup for about 10 seconds. During this time LO sends a request of some sort over the network connection (lights flash

[libreoffice-users] Re: Labeling in Calc

2012-07-21 Thread Andreas Säger
Am 20.07.2012 23:50, Andrew Brager wrote: Nevermind, I figured it out. In case anyone else has a similar desire and wants to know... I simply select all the rows I want to belong to a group, add a border around it all, and insert a row above the box I just made. The inserted box contains the la

[libreoffice-users] Re: Marching ants, Calc, Xorg, CPU usage, Ubuntu

2012-07-21 Thread Andreas Säger
Chuck Davis wrote > > Marching ants around a selection are a curse directly from Microsoft! > A very good reason to continue using OpenOffice !! > > P. S. I hate marching ants! > +1 Somebody who knows Excel's marching ants without hating them will learn to hate them in

[libreoffice-users] Re: Date format macro.

2012-07-21 Thread Andreas Säger
rhubarbpieguy wrote > >> > Thank you for responding; I admire your style. I manually changed the > date format of my spreadsheet, saved , then coded it as the default > template. The default template took, but unfortunately, again the > user-defined date format wasn't saved. > > That would

[libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread Andreas Säger
Am 20.07.2012 14:19, Andreas Säger wrote: Try my "SpecialCells" extension which selects combinations of cell types: http://user.services.openoffice.org/en/forum/download/file.php?id=11048 Done. Snippet recorded by the MRI inspector: Sub Snippet(Optional oInitialTarget As Obj

Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread Andreas Säger
Am 20.07.2012 18:56, Johnny Rosenberg wrote: 2012/7/20 Andreas Säger: As far as I know, the find/replace tool can not find empty strings nor blanks. The standard filter can. It has an "-- empty --" option for the blanks and one empty entry at the end of the combo box for the empty s

[libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread Andreas Säger
As far as I know, the find/replace tool can not find empty strings nor blanks. The standard filter can. It has an "-- empty --" option for the blanks and one empty entry at the end of the combo box for the empty strings (if any). -- View this message in context: http://nabble.documentfoundation

[libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread Andreas Säger
Try my "SpecialCells" extension which selects combinations of cell types: http://user.services.openoffice.org/en/forum/download/file.php?id=11048 -- View this message in context: http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996615.html Sent fr

[libreoffice-users] Re: [List Threading] was: Re: Correct Syntax to address a table or form field in Base's Basic

2012-07-20 Thread Andreas Säger
Am 19.07.2012 07:02, NoOp wrote: On 07/18/2012 11:12 AM, Andreas Säger wrote: I did not reply to your bloody mailing list. I used a server named "nabble.documentfoundation.org" which shows the whole topic on a web-page. Ah, a web-pager... wrong tool for the job eh? Using nabble,

[libreoffice-users] Re: Chart Office compatibility issue

2012-07-20 Thread Andreas Säger
Am 20.07.2012 09:28, davews wrote: The file displays properly in MS Excel viewer. Use the Excel viewer or http://gnumeric.org which lets you view and edit the file. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/

[libreoffice-users] Re: Date format macro.

2012-07-20 Thread Andreas Säger
Am 19.07.2012 23:48, rhubarbpie...@gmail.com wrote: but I understand the LibreOffice format can't save user-defined formats. The entire suite is about customization rather than programming. Templates and styles provide most of the productivity features. Macros (particularly recorded ones) ar

[libreoffice-users] Re: Can words in LibreOffice be auto-italicized?

2012-07-19 Thread Andreas Säger
Lluís de Yzaguirre wrote > > Thanks, but could you teach a macro to do so? > Of course. Go ahead and write your macro if you are a programmer. But what is it good for? Save 3 keystrokes per day or 30? Forget it. -- View this message in context: http://nabble.documentfoundation.org/Can-words-in

[libreoffice-users] Re: Can words in LibreOffice be auto-italicized?

2012-07-19 Thread Andreas Säger
Hi, menu:Find&Replace... Search: button: [Select All] Now you have a multiple selection which can be formatted by a character style (character styles can be assigned to shortcuts) or by hard formatting. -- View this message in context: http://nabble.documentfoundation.org/Can-words-in-LibreOffic

[libreoffice-users] Re: Base fread-only

2012-07-18 Thread Andreas Säger
[Tutorial] Read-Only in Base: http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=26448 -- View this message in context: http://nabble.documentfoundation.org/Base-fread-only-tp3996291p3996297.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructi

[libreoffice-users] Re: SQL statement in Base query

2012-07-18 Thread Andreas Säger
On this simple level I would consider HSQLDB as free of bugs whereas the primitive Base parser fails in many different ways. Did you try the direct SQL mode (SQL view, menu:Edit>Run SQL directly)? If you get reasonable result in direct mode, it is one of many bugs in the Base's SQL parser. -- View

[libreoffice-users] Re: Correct Syntax to address a table or form field in Base's Basic

2012-07-18 Thread Andreas Säger
I did not reply to your bloody mailing list. I used a server named "nabble.documentfoundation.org" which shows the whole topic on a web-page. NoOp wrote > > On 07/17/2012 03:08 PM, Andreas Säger wrote: >> RTFM > ... > > WTFAYRT? > > Learn how to quote p

[libreoffice-users] Re: Problem with exporting BASE query result to CALC sheet

2012-07-17 Thread Andreas Säger
Yes, it's a bug. Use copy&paste instead of drag&drop. If your database is a registered one, you can drag&drop the query from the left pane of the data source window (F4) which creates a refreshable link. -- View this message in context: http://nabble.documentfoundation.org/Problem-with-exporting-

[libreoffice-users] Re: Correct Syntax to address a table or form field in Base's Basic

2012-07-17 Thread Andreas Säger
RTFM -- View this message in context: http://nabble.documentfoundation.org/Correct-Syntax-to-address-a-table-or-form-field-in-Base-s-Basic-tp3996103p3996132.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

[libreoffice-users] Re: Unexpected behavior while writing Calc Functions

2012-07-16 Thread Andreas Säger
Am 16.07.2012 06:11, Andrew Douglas Pitonyak wrote: On 07/15/2012 06:52 PM, Andreas Säger wrote: Calc does not know any dates nor times. It's all about doubles and text. -- View this message in context: http://nabble.documentfoundation.org/Unexpected-behavior-while-writing-Calc-Func

[libreoffice-users] Re: CALC-Need an easier way to do the following -

2012-07-15 Thread Andreas Säger
Vertically: =A1+MOD(ROW(A1);2) Horizontally: =A1+MOD(COLUMN(A1);2) -- View this message in context: http://nabble.documentfoundation.org/CALC-Need-an-easier-way-to-do-the-following-tp3995670p3995675.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-m

[libreoffice-users] Re: Unexpected behavior while writing Calc Functions

2012-07-15 Thread Andreas Säger
Calc does not know any dates nor times. It's all about doubles and text. -- View this message in context: http://nabble.documentfoundation.org/Unexpected-behavior-while-writing-Calc-Functions-tp3995669p3995674.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instr

[libreoffice-users] Re: lo 3.5.5

2012-07-15 Thread Andreas Säger
Am 15.07.2012 13:10, Sharon Kimble wrote: i've just installed almost successfully libreoffice 3.5.5 except i installed the helppack before the language pack. consequently my desktop integration is mixed up with missing shortcuts in the menu. how do i get them back please? At the moment i have to

[libreoffice-users] Re: Quickstarter is missing from LO3.5.5. on Debian

2012-07-12 Thread Andreas Säger
Am 12.07.2012 20:35, AG wrote: I did download and install the desktop integration packages for Debian from the ODF site, and there's nothing in synaptic. Perhaps the quickstart has been deprecated in the 3.4.* and 3.5.5 releases? AG There is no quick-start application. When this anti-featu

[libreoffice-users] Re: CALC - How to count blank cells?

2012-07-10 Thread Andreas Säger
Am 10.07.2012 05:34, Simon Cropper wrote: IMHO, the tone and content of your response is not very helpful and belittles other peoples attempts to assist. Do you know how much a client feels belittled by misleading (overly complicated) answers? Outlining the keystrokes mentioned and how da

[libreoffice-users] Re: LibreOffice won't save settings

2012-07-09 Thread Andreas Säger
You have a macro and a toolbar button. Where is the macro stored? Globally or in a document? Where is the modified toolbar stored? Globally or in a document? -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-won-t-save-settings-tp3994487p3994541.html Sent from the

[libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?

2012-07-09 Thread Andreas Säger
Am 09.07.2012 14:54, Dan wrote: Have you formatted your C1 and C2 columns correctly? The OP gets the #NAME error. What is a correctly formatted cell? Can you demonstrate us a single case where any formatting attribute has any influence on the cell value? -- For unsubscribe instructions e-ma

[libreoffice-users] Re: CALC - How to count blank cells?

2012-07-09 Thread Andreas Säger
Am 09.07.2012 10:22, MiguelAngel wrote: El 09/07/12 3:31, Simon Cropper escribió: On 09/07/12 11:01, Michael Reich wrote: On 7/4/12 11:00 AM, users+h...@global.libreoffice.org wrote: Subject: Re: [libreoffice-users] CALC - How to count blank cells? From: MiguelAngel Date: 7/4/12 3:44 AM To:

[libreoffice-users] Re: a little math problem with Calc

2012-07-07 Thread Andreas Säger
Am 07.07.2012 00:37, alex sato wrote: Regina. I'm writing this email just to say "thank you" again. About the idea of rewriting math function using string. I may do it but just for fun, not for a serious use. ;-) Programming Basic is no fun. Never. Function Test (n) dim r(3) r(0)=CINT(n) r(

[libreoffice-users] Re: You made me smile today .... Re: Re: stubborn macro security

2012-07-05 Thread Andreas Säger
Am 05.07.2012 03:34, Andrew Douglas Pitonyak wrote: You made me smile today when I read your post: Just wanted to mention it... Thanks for your smile. Very much appreciated. :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.

[libreoffice-users] Re: a little math problem with Calc

2012-07-05 Thread Andreas Säger
Am 05.07.2012 11:43, Andreas Säger wrote: E1: input value A1: =INT($E1) B1: =$E1-$A1 C1: =$B1*100 D1: =INT($C1) This is how it works in all spreadsheet applications. It applies to any other row where you copy the formulas to. You may even save this simple calculation in xls(x) format and it

[libreoffice-users] Re: a little math problem with Calc

2012-07-05 Thread Andreas Säger
Am 05.07.2012 03:50, alex sato wrote: Hi, I have a problem with functions I made. Let's say I create the function: Function Test (n) dim r(3) r(0)=int(n) r(1)=n-r(0) r(2)=r(1)*100 r(3)=int(r(2)) Test = r End Function Then, in a empty spreadsheet take the following steps: -select A1:D1 -press

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-07-05 Thread Andreas Säger
Am 04.07.2012 17:42, Ken Springer wrote: For the ordinary user, not only does LO need to explain the basics by using "=FUNCTION(number ; text ; range ; vector )" and "=FUNCTION( function_number(x) ; function_text(x) ; function_range(x) ; function_vector(x) )" with explanations, you need examples

[libreoffice-users] Re: Macro code to highlight a field on a Form

2012-07-01 Thread Andreas Säger
Hello, All you need is the MRI extension. http://extensions.libreoffice.org/extension-center/mri-uno-object-inspection-tool Within seconds it can point you to method http://www.openoffice.org/api/docs/common/ref/com/sun/star/awt/XTextComponent.html#setSelection The .setSelection(aSelection)

[libreoffice-users] Re: The vlookup don't work properly.

2012-07-01 Thread Andreas Säger
The only "bug" is that you are misusing a spreadsheet as database. Your formula is =VLOOKUP($A6,'all Staging'.$A$2:$E$1197,3,0) and A6 would be matched in row #2335 -- View this message in context: http://nabble.documentfoundation.org/The-vlookup-don-t-work-properly-tp3993117p3993160.html Sent fr

[libreoffice-users] Re: "Lost" Python macros

2012-07-01 Thread Andreas Säger
Am 01.07.2012 11:33, Ulf Göransson wrote: Yes and no. I see three example macros under "LibreOffice Macros" but none of my own. And the hello world macro runs just fine. /ug You upgraded from 3.4 to 3.5 and some devel moron changed the location of the user profile from ~/.libreoffice/ to ~

[libreoffice-users] Re: How can I edit a database with Calc ?

2012-07-01 Thread Andreas Säger
Am 01.07.2012 16:23, Sylvain Vasseur wrote: Attach a form to a sheet and connect it to your database. View>Toolbars>FormDesign + FormControls Turn on design mode. Hit the 5th button for the form navigator and start with a new form. Bind the form to a table. Attach form controls and bind them

[libreoffice-users] Re: "Lost" Python macros

2012-07-01 Thread Andreas Säger
Am 01.07.2012 11:08, Ulf Göransson wrote: Hi, I have a problem running an old Python macro that I've written for Calc. It is a plain .py file, stored under ~/.libreoffice/3/user/Scripts/python. I used to be able to run it via the Tools - Macros - Run Macro... menu command but now when I try, non

[libreoffice-users] Re: stubborn macro security

2012-07-01 Thread Andreas Säger
Am 30.06.2012 23:44, Girvin R. Herr wrote: [...] How can we know all this? *You* are the owner of that document. It is *your* hierarchy of templates and someone in *your* domain spills dirty Basic into this world. Do those macros serve any purpose in the distributed document? May be you ca

[libreoffice-users] Re: stubborn macro security

2012-06-30 Thread Andreas Säger
Where is the macro stored? Obviously you store it in the template and all resulting documents from that template inherit the macro. When you store a new document from that template in some untrusted location, the macro can not be trusted anymore. -- For unsubscribe instructions e-mail to: user

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-30 Thread Andreas Säger
Am 30.06.2012 14:52, Ken Springer wrote: What frustrates me is there seems to be very few "simple and easy" to grasp and use database programs anymore. Some database such as MySQL is a development tool for well paid professional computer geeks. To some extent you need to get the same way of

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-30 Thread Andreas Säger
Am 30.06.2012 14:09, Ken Springer wrote: After reading your other new replies, I'm wondering if the way I wrote my posts led you to some wrong conclusions. Possibly, it came out sounding more complicated than the problem really was, as I did get it solved. It wasn't the logic or the functions t

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-30 Thread Andreas Säger
Am 30.06.2012 02:37, Ken Springer wrote: And I've not been able to come up with a competent explanation of what I'm trying to accomplish. :) That's what *you* have got to explain to the application. Any competent resource on spreadsheets tells you how to tell anything to the application.

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-30 Thread Andreas Säger
Am 30.06.2012 02:17, Ken Springer wrote: chapters are there before they get put together to form the entire book. Unfortunately, there's nothing there for 3.5.x.x.:-( And the Formula Wizard is different in 3.5.x.x. I compared the wizard in 3.5 with the one in OOo 1.1 of 2004. Apart fr

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-30 Thread Andreas Säger
Ken, There is no way to help further without a single formula nor data. I have no idea what your problem is. Like in any programming language un-nesting is a good way to debug steps. Threre are a billion of cells on each sheet. Use as many as possible and things will clear up. Have a nice we

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Andreas Säger
Am 28.06.2012 02:43, Jay Lozier wrote: Generally you can nest functions several levels deep in any spreadsheet. Typically the maximum is 7 levels but I would not go beyond about 3 because it becomes to difficult to follow the logic. You could have something like =if( (x or y), if( (a and b), sum

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Andreas Säger
Am 29.06.2012 10:49, webmaster-Kracked_P_P wrote: Is there a place where users can "drop off" a description on how to do something that is not explained in the current documentation? The current docs are "guides" and not "how-to" books. For me, "how-to" books are more example driven where there

[libreoffice-users] Re: Question about Calc

2012-06-29 Thread Andreas Säger
Am 29.06.2012 11:10, Ian Whitfield wrote: Morning All Can you help me out - I've done this before but now can not get it to work!! I'm working in Calc (latest) on PCLinuxOS (latest) and have a multi-page spreadsheet. I have my dates in SHEET 1.Col 'C' with the matching data in the same ROW. Lo

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Andreas Säger
Am 29.06.2012 09:04, Tom Davies wrote: Hi :) It makes a lot of sense. Hopefully the proper LO documentation is far better than most! The Pdfs allow you to click on items in the Table-of-Contents and has other clickable links to help you navigate to where you want quickly. The built-in help i

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-28 Thread Andreas Säger
Hi, Like any other programming language Calc can nest functions as far as the data types of the incoming parameters match the data types of the nested function results. The details are mostly the same as with any other spreadsheet program of the past 30 years with the only exception that ther

[libreoffice-users] Re: Dual Screen and Libre Office crash

2012-06-28 Thread Andreas Säger
Am 28.06.2012 10:04, Frank Wolff wrote: Andreas, Thanks a lot, the install did the trick. One short follow-up: The name of the executable seems to have changed: " desktop:~/Documents$ lowriter The program 'lowriter' is currently not installed. You can install it by typing: sudo apt-get install

[libreoffice-users] Re: Dual Screen and Libre Office crash

2012-06-28 Thread Andreas Säger
Am 28.06.2012 09:12, Frank Wolff wrote: Dear all, thanks for the great program! However, this looks like a serious bug to me. After my upgrade from ubuntu 11.10 to 12.04 libreoffice crashes when started on my second screen. It works fine on xscreen0. This is the error message I get when I sta

[libreoffice-users] Re: [SOLVED] Re: Re: [3.5.4.2/Writer] CTRL-P shortcut freezes LiBo V 3_5_4_2

2012-06-26 Thread Andreas Säger
Am 26.06.2012 10:21, henri wrote: .Now I shall just write a 100 times :" I will always check my second monitor" Copy that sentence with a line break. Paste into some text editor which can show line numbers and hold Ctrl+V until line 100 is reached. -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: Need Help AGAIN with Mail Merge

2012-06-25 Thread Andreas Säger
Am 25.06.2012 21:49, Gilles SICHE wrote: Thank you to all of you who answered Charles' question, I asked more or less the same some weeks ago, got many useful answers (thank you Andreas) but it was only today that I discovered the F4 button, which works great. Another query about the same functi

[libreoffice-users] Re: [3.5.4.2/Writer] CTRL-P shortcut freezes LiBo V 3_5_4_2

2012-06-25 Thread Andreas Säger
Because [Esc] takes you back to the edit window, I think that the print dialog is active but its position is out of visible bounds. Alt+Space_Key might open the window-menu for the active but hidden dialog. There you might find some way to move it by means of arrow keys. I don't use Windows righ

[libreoffice-users] Re: latest java update has broken my install of Libre Office.

2012-06-25 Thread Andreas Säger
LibreOffice works well on any system without any Java being installed. If it does not start because of anything related to Java, this is a clear bug. You may have replaced Java while the office was running (thanks to that completely useless "quick-starter"). Does a reboot of the whole system hel

[libreoffice-users] Re: Need Help AGAIN with Mail Merge

2012-06-25 Thread Andreas Säger
Am 24.06.2012 23:21, Charles218 wrote: Tom, I checked the View - Fields command and it is not enabled. The view status of the place holders should not matter at all. It toggles between "" and "Database.Table.Field Name". The latter lets you prove that each field is connected to the right so

[libreoffice-users] Re: Need Help Setting Up Mail Merge

2012-06-24 Thread Andreas Säger
Dan Lewis wrote > > > Have you opened the file you exported from Filemaker using a text > editor? This should tell you what the structure is and what separators > you need to use. Exactly. In the end it is just text with a certain structure and nothing magic. When the wizard asks

[libreoffice-users] Re: Need Help Setting Up Mail Merge

2012-06-24 Thread Andreas Säger
If you have Filemaker Pro, you should have an ODBC driver and connect directly to Filemaker Pro without any text file. Mail merge from plain text extremely simple: A The text file Create a dedicated directory for the text file and for similar files to come. Open the text file in a text editor (no

[libreoffice-users] Re: Screen goes dark gray, Libreoffice stops

2012-06-23 Thread Andreas Säger
Am 23.06.2012 20:54, Tom Davies wrote: Hi :) Open Lo and go to Tools - Options - Java Once again: Not a single built-in Calc feature depends on Java. Like any other type of document, spreadsheets can be exported to XHTML which depends on Java, but all this has nothing to do with the creatio

[libreoffice-users] Re: Writer - concatenate text & fields

2012-06-23 Thread Andreas Säger
1) Depending on the type of database backend you may do that in a query. SELECT CASE WHEN ... THEN ... ELSE ... END AS "Name", ... FROM "Table" 2) Everything you may ask about mail merge: http://openoffice.blogs.com/openoffice/mail_merge/ May 02, 2007 Suppressing Blank Address2 Fields in OpenOff

[libreoffice-users] Re: We want to create a questionnaire...

2012-06-21 Thread Andreas Säger
Am 21.06.2012 11:19, JenS8 wrote: Is there a newbie guide for creating an online form with LibreOffice Writer's XML Form Document? This link is very important, too: http://yourmediashelf.com/2010/07/writing-on-the-wall-xforms-has-been-dead-for-years/ -- For unsubscribe instructions e-m

[libreoffice-users] Re: We want to create a questionnaire...

2012-06-21 Thread Andreas Säger
Am 21.06.2012 11:19, JenS8 wrote: Thanks, Tom and e-letter, for suggesting LibreOffice Writer XML Form Document (File/New/XML Form Document). You folks are probably right that on online form is more universal than a file that someone has to download, whether it be a PDF, LibreOffice file, or Micr

[libreoffice-users] Re: Signing Documents with a personal Certificate

2012-06-21 Thread Andreas Säger
Am 21.06.2012 11:15, Steve Edmonds wrote: I think firefox throws a tiz because it is a self signed cert (they certify their own certificate). I get the same thing for the self signed cert I use on our web server (company access only) and on my router. steve That's what I'd like believe as well

[libreoffice-users] Re: Signing Documents with a personal Certificate

2012-06-21 Thread Andreas Säger
Am 21.06.2012 07:47, Marc Grober wrote: https://www.cacert.org/index.php?id=1 On 6/20/12 6:14 PM, James Knott wrote: Marc Grober wrote: get a cert from CACert.org Hmmm... I just tried going to that site and got this: "This Connection is Untrusted You have asked Firefox to connectsecurely

[libreoffice-users] Re: We want to create a questionnaire...

2012-06-20 Thread Andreas Säger
Am 20.06.2012 10:58, Walther Koehler wrote: High Tom do you really recommend a proprietary format like pdf in an open source environment? What is your suggestion for the given task? You know, PDF is licensed by Adobe and even a simple end user has to subscribe a contract with this company.

[libreoffice-users] Re: Integer Not Null

2012-06-18 Thread Andreas Säger
Dan Lewis wrote > >Seems like I guessed wrong twice. The problem that you have has > to do with adding a field that is NOT NULL. When you add a field to a > table, it has no values until entries are made. So, selecting "Yes" for > Entry Required causes the error. > Create the fie

[libreoffice-users] Re: Hyperlink Field Types in Base

2012-06-17 Thread Andreas Säger
This question asked on a users list is completely pointless. You may find the answer in the issue tracker. If not, you may file an issue or vote for an existing one. I have a simple Python macro to do the trick. It may be too simple since it does not include any error handling. def url_on_record_

[libreoffice-users] Re: Can not add new field to Form

2012-06-17 Thread Andreas Säger
Which type of database? Is the form directly bound to the table or is it a query based on that table? With a form directly bound to a table of an embedded HSQLDB I can see any new field after I saved and modified the table in the table designer while the form design was open. I only have to close a

[libreoffice-users] Re: Integer Not Null

2012-06-17 Thread Andreas Säger
SewHelpMe wrote > > Error while saving the table design > Column constraints are not acceptable in statement [ALTER TABLE "Companion > Subspecies" ADD "Help Type" INTEGER NOT NULL] > First of all we should know which type of database you refer to. No, Base is not a database. It includes a certai

[libreoffice-users] Re: Integer Not Null

2012-06-17 Thread Andreas Säger
Tom, Shut up if you do not have anything to answer. The embedded HSQL database is documented here: http://www.hsqldb.org/doc/1.8/guide/ch09.html -- View this message in context: http://nabble.documentfoundation.org/Integer-Not-Null-tp3990551p3990580.html Sent from the Users mailing list archive a

[libreoffice-users] Re: Base, Use wizard to create tables

2012-06-15 Thread Andreas Säger
Experience is the keyword. From my experience it is a matter of pure chance if the table wizard produces a set of tables that can be related to each other. It is perfectly normal that a primary key does not fit the type of a foreign key. This is inacceptable because newbies can not understand th

[libreoffice-users] Re: PowerPoint templates and choice of .pot vs .potx?

2012-06-15 Thread Andreas Säger
AGAIN for the hundredths time: Because e-letter is perfectly right. Only MS software can edit MS file formats simply because they tailor their file format very tightly around their software. LibO can export to the old binary formats in acceptable quality so this is the one and only acceptable file

[libreoffice-users] Re: Base, Use wizard to create tables

2012-06-15 Thread Andreas Säger
You must never use a wizard to create a table. The table wizard makes too many wrong assumption about what you need. It is easy to create a table in design view. It is even easier to create a table in SQL. Certain features are only accessible through SQL. -- View this message in context: http://n

[libreoffice-users] Re: PowerPoint templates and choice of .pot vs .potx?

2012-06-14 Thread Andreas Säger
Am 14.06.2012 22:44, Tom Davies wrote: Hi :) Blimey. I guess the aim is to deter people from trying LO through sheer rudeness and unreasonable demands. A good Toyota car-dealer would easily have sold a Toyota car to the person asking about mercs or at least would have left a good enough impre

[libreoffice-users] Re: List and Combo boxes

2012-06-13 Thread Andreas Säger
The order of row and columns in a database has no meaning. You can get any order of rows and columns as needed. If the visible field is the same as the bound one use the same field for both columns: SELECT "Field", "Field" FROM "Table" -- For unsubscribe instructions e-mail to: users+h...@glob

[libreoffice-users] Re: List and Combo boxes

2012-06-13 Thread Andreas Säger
Am 13.06.2012 09:56, Alexander Thurgood wrote: I seem to recall having seen somewhere on the OOo dev lists that it should now be possible to directly select Bound field=0, and still have your sorted distinct data on the other data field, or have I muddled things up ? This was part of the develop

[libreoffice-users] Re: cannot save an .html type document, opened in calc as .ods file (libreoffice 3.5.3)

2012-06-12 Thread Andreas Säger
Am 12.06.2012 19:12, toodr wrote: but if we are inside calc and we try to open the same file from within the calc program - the same file gets opened into a writer/web program. Why is this inconsistency ? There is no Calc nor Writer program. This is one program to open all types of files. When

[libreoffice-users] Re: List and Combo boxes

2012-06-12 Thread Andreas Säger
Am 12.06.2012 21:08, Dan wrote: To populate a list or combo box, I have been using single field tables. Seems like it should be possible to use a single table for more than one list or combo box. (The SQL statement for selecting a field for a list or combo box is: SELECT "field name" FROM "table

[libreoffice-users] Re: spreadsheet question

2012-06-09 Thread Andreas Säger
Am 07.06.2012 19:48, Eric S. Johansson wrote: I'm using a spreadsheet to track a project (yes I know not a good idea but that's what the customer wants). Worst idea of millions of spreadsheet fools, indeed. Each task is listed with certain number of days plus a slip factor. I calculate the pr

[libreoffice-users] Re: cannot save an .html type document, opened in calc as .ods file (libreoffice 3.5.3)

2012-06-09 Thread Andreas Säger
Am 08.06.2012 21:48, Andreas Säger wrote: OK, I've got to correct myself. Calc can load html directly and I can load html with some tabular content with LibreOffice 3.3 as well as with 3.5. Anyway, if the name ends with .xls it is never clear what the true content is until you load it into

[libreoffice-users] Re: cannot save an .html type document, opened in calc as .ods file (libreoffice 3.5.3)

2012-06-08 Thread Andreas Säger
OK, I've got to correct myself. Calc can load html directly and I can load html with some tabular content with LibreOffice 3.3 as well as with 3.5. Anyway, if the name ends with .xls it is never clear what the true content is until you load it into a hex editor or until you get some human readable

[libreoffice-users] Re: cannot save an .html type document, opened in calc as .ods file (libreoffice 3.5.3)

2012-06-08 Thread Andreas Säger
First of all, it would be interesting to know the actual content of the file. Calc can not open html directly but there are all kinds of files out there which share the .xls suffix in order to trigger the Excel application. Calc does not care about the file name suffix. If the file has a well known

[libreoffice-users] Re: Oracle Java 1.7.0_04 is not compatible with the Writer of LibreOffice 3.5.4.2 on the Windows platform

2012-06-07 Thread Andreas Säger
I suggest this database: https://bugs.freedesktop.org/ -- View this message in context: http://nabble.documentfoundation.org/Oracle-Java-1-7-0-04-is-not-compatible-with-the-Writer-of-LibreOffice-3-5-4-2-on-the-Windows-platform-tp3988634p3988801.html Sent from the Users mailing list archive at Nab

[libreoffice-users] Re: Slovenian in user-defined list when not installed?

2012-06-07 Thread Andreas Säger
Because you and your co-workers may write Slovenian text anyway. The office will apply Slovenian auto-correct conventions (e.g. typographic quotes) and it will be spell checked on any other machine with a Slovenian spell checker. -- View this message in context: http://nabble.documentfoundation.o

[libreoffice-users] Re: Oracle Java 1.7.0_04 is not compatible with the Writer of LibreOffice 3.5.4.2 on the Windows platform

2012-06-07 Thread Andreas Säger
Tom wrote > > Hi :) > That is interesting.  Does the official information about the 3.5.x branch > still claim that it works with java 7?  If it doesn't then perhaps that > should be changed.  > I don't care of official information. I know every feature that depends on Java and I can prove that

[libreoffice-users] Re: Oracle Java 1.7.0_04 is not compatible with the Writer of LibreOffice 3.5.4.2 on the Windows platform

2012-06-07 Thread Andreas Säger
Am 07.06.2012 13:36, Tom Davies wrote: Hi :) It is quite likely to be true for everyone. Like always, your are plain wrong. A bug-report would be nice. The devs are well aware of this. They do not need more duplicates in their issue database. -- For unsubscribe instructions e-mail to: us

[libreoffice-users] Re: Oracle Java 1.7.0_04 is not compatible with the Writer of LibreOffice 3.5.4.2 on the Windows platform

2012-06-07 Thread Andreas Säger
Am 07.06.2012 08:11, Michael Wu wrote: Dear all, It is seemed that Oracle Java 1.7.0_04 is not compatible with the Writer of LibreOffice 3.5.4.2 on the Windows platform XP + SP3. ... if and only on a 64 bit Windows platform. On a 32 bit platform I could not find any issues with Java

[libreoffice-users] Re: Sending an email within Writer

2012-06-06 Thread Andreas Säger
[Solved] Emailing attachments with Windows Live Mail http://user.services.openoffice.org/en/forum/viewtopic.php?f=15&t=39031 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guide

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