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

[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

[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

[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

[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

[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

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

[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 Field Name and Database.Table.Field Name. The latter lets you prove that each field is connected to the

[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

[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

[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

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

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

[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

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

[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),

[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

[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

[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

[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

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

[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

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

[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. ViewToolbarsFormDesign + 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: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: 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

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

2012-07-02 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

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

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

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

[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 mari...@miguelangel.mobi

[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

[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

[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

[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

[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

[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

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

[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: Problem with exporting BASE query result to CALC sheet

2012-07-17 Thread Andreas Säger
Yes, it's a bug. Use copypaste instead of dragdrop. If your database is a registered one, you can dragdrop the query from the left pane of the data source window (F4) which creates a refreshable link. -- View this message in context:

[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:EditRun 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: 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=83t=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

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

2012-07-19 Thread Andreas Säger
Hi, menu:FindReplace... Search: whatever 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:

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

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

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

[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, gmane.org, etc

[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

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

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ägerville...@t-online.de: 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

[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 Object) Dim

[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 be a

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

[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: 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: 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=

[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: 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. --

[libreoffice-users] Re: Labeling in Calc

2012-07-22 Thread Andreas Säger
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 ville...@t-online.de wrote: snip / Please ignore Tom. He is very kind but totally ignorant towards

[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

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ägerville...@t-online.de: 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

[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

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

[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

[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

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

2012-07-25 Thread Andreas Säger
These cultural differences can not be resolved by software. This office suite used to handle these things gracefully. After all those years since Excel '95 I got used to the input method 23/ which enters this month's 23th day from any num-pad on any keyboard, in any office component, under US

[libreoffice-users] Re: turn off specific autocorrect items

2012-07-25 Thread Andreas Säger
Works for me. I enter (c) and get © I remove the respective list entry in the replace list of the auto-correct options, enter (c) and get (c). -- View this message in context: http://nabble.documentfoundation.org/turn-off-specific-autocorrect-items-tp3997604p3997635.html Sent from the Users

[libreoffice-users] Re: Do You Share ODF Documents With MS Office Users?

2012-07-25 Thread Andreas Säger
Am 24.07.2012 03:03, Don Parris wrote: I would like to take something of a straw poll, if that's ok. I simply want to know whether any of you have shared documents using the ODF format with MS Office users (preferably in a business environment), and what was the reaction? What problems -- I

[libreoffice-users] Re: Do You Share ODF Documents With MS Office Users?

2012-07-25 Thread Andreas Säger
Am 25.07.2012 21:29, Gordon Burgess-Parker wrote: On 25/07/12 20:25, Andreas Säger wrote: Every MS Office user can save the much more compatible doc and xls easily. One of the major problems with Windows 7 (and possibly Vista - I can't remember) is that the Show file extensions for known file

[libreoffice-users] Does this file crash with the latest 3.6 beta?

2012-07-25 Thread Andreas Säger
Hi, The simple spreadsheet document http://www.mediafire.com/view/?1s1wui59p3p2oxz crashes with LO-Dev Beta 1 (Build ID: 1f1cdd8). I know there is a more recent build of 3.6 but 3.5 will be my last version of LibreOffice. If someone confirms the crash with a more recent build, that would be a

[libreoffice-users] Re: Does this file crash with the latest 3.6 beta?

2012-07-26 Thread Andreas Säger
Am 26.07.2012 14:06, Regina Henschel wrote: Hi Andreas, Andreas Säger schrieb: Hi, The simple spreadsheet document http://www.mediafire.com/view/?1s1wui59p3p2oxz crashes with LO-Dev Beta 1 (Build ID: 1f1cdd8). I know there is a more recent build of 3.6 but 3.5 will be my last version

[libreoffice-users] Re: Does this file crash with the latest 3.6 beta?

2012-07-26 Thread Andreas Säger
Am 26.07.2012 08:02, V Stuart Foote wrote: Andreas, No crash observed. Guess you'll stay the course a while longer... Results as opened in LO 3.6.0.2, on Windows 7, 64-bit. Days column were not rendered on the MediaFire file preview in IE9 or FF 14.0.1 DOB Years Months Days

[libreoffice-users] Re: Date format macro.

2012-07-27 Thread Andreas Säger
Am 19.07.2012 23:48, rhubarbpie...@gmail.com wrote: I'd like to create a macro for a user-defined date format (H:MMa/p). As examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p. I can create the format manually, but I understand the LibreOffice format can't save user-defined formats.

[libreoffice-users] Re: I have a question

2012-07-28 Thread Andreas Säger
Am 28.07.2012 14:17, Lynne Stevens wrote: omega The Omega sector America's Last Line of Defense *How do I check for duplicates in a data base using another data base ? * SELECT A.* FROM A JOIN B ON A.ID = B.ID returns all rows from table A with an equivalent ID in table B. --

[libreoffice-users] Re: I have a question

2012-07-28 Thread Andreas Säger
Am 28.07.2012 22:03, Lynne Stevens wrote: omega The Omega sector America's Last Line of Defense *Ok Thomas downloads 2 Data bases ( CVS format ) he wants to remove Duplicates from Data Base B using Data base A and THEN Data Base A gets deleted when done * OK, that is $ cat fileA.csv

[libreoffice-users] Re: BASE SQL problem

2012-07-29 Thread Andreas Säger
Am 29.07.2012 14:02, Mark Stanton wrote: BASE's pre-processing, of MySQL at least, prevents the perfectly legal SQL field specifier field1 = field2 AS ConditionName Does it really need to pre-process, or is this more a shortcoming of its pre-processing? Regards Mark Hi, It works

[libreoffice-users] Re: BASE SQL problem

2012-07-29 Thread Andreas Säger
Am 29.07.2012 15:57, Mark Stanton wrote: Hi! It works when you turn off the parser (direct SQL mode) but then you don't have an editable record set anymore. Ah yes, silly me. Because it complained that it had to use SQL view I assumed it was in SQL mode, it wasn't. Yes, selecting SQL mode

[libreoffice-users] Re: insufficient user rights if I change the filename

2012-08-01 Thread Andreas Säger
Am 31.07.2012 09:33, Grant wrote: I'm using Libreoffice Writer on Gentoo Linux and I'm getting an error telling me I have insufficient user rights when I try to save a document to any filename other than the default Untitled 1 which saves fine. Does anyone know what could be causing this? -

[libreoffice-users] Re: insufficient user rights if I change the filename

2012-08-01 Thread Andreas Säger
Am 01.08.2012 08:51, Marc Paré wrote: Could you be trying to save in a file folder where you do not have the rights to save to? Try saving in your Home or Document folder to see if this is the problem. Cheers, Marc This thread is symptomatic for the whole mailing list. Nobody has the

[libreoffice-users] Re: pdf creation issue on a single file?

2012-08-02 Thread Andreas Säger
Am 28.07.2012 15:42, Hylton Conacher (ZR1HPC) wrote: I will gladly send this file to anyone who can assist as I need to create and post to a public user mailing list a PDF at the end of the month. Yes, please. Help is much appreciated Hylton Let's see what I can do for you. -- For

[libreoffice-users] Re: Calc Pivot Table format preservation

2012-08-03 Thread Andreas Säger
The number formats are taken from the source cells. Anything else can be set in the styles that are generated for the pivot tables. -- View this message in context: http://nabble.documentfoundation.org/Calc-Pivot-Table-format-preservation-tp3999186p3999193.html Sent from the Users mailing list

[libreoffice-users] Re: Finding active standard filters

2012-08-04 Thread Andreas Säger
Am 04.08.2012 04:15, Carlos Pita wrote: Hi, does anyone know if it's possible to list or quickly find all active standard filters in a calc spreadsheet? AFAIK there is no visible hint about what columns may be filtered so, in case I don't remember where the filters are, I have to look for them

[libreoffice-users] Re: paragraph marks

2012-08-06 Thread Andreas Säger
Am 06.08.2012 08:43, carlamar...@xmsnet.nl wrote: I want to replace two paragrah endings punctuation marks by one, because I want to replace white lines. How do I do that? Carla -- I am using the free version of SPAMfighter. SPAMfighter has removed 12759 of my spam emails to date. Get the free

[libreoffice-users] Re: paragraph marks

2012-08-06 Thread Andreas Säger
Am 06.08.2012 11:43, Tom Davies wrote: Hi :) Of course make a back-up (just a normal copy) of your file before taking our advice. I think Andreas might have meant replace ^$^$ Contrary to you, I know very well what I mean and I use test what I suggest. I bet, you don't even have LibreOffice

[libreoffice-users] Re: Calc Pivot Table format preservation

2012-08-06 Thread Andreas Säger
Am 06.08.2012 13:06, Zappaz wrote: Andreas Säger wrote The number formats are taken from the source cells. Anything else can be set in the styles that are generated for the pivot tables. Hi Andreas, thanks for your reply. Unfortunately the formatting of the cells in question does

[libreoffice-users] RE: paragraph marks

2012-08-06 Thread Andreas Säger
http://nabble.documentfoundation.org/file/n3999573/replace_para.png http://www.mediafire.com/?rr03nrkrgj47t9j -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-Stay-on-Top-property-tp3999136p3999573.html Sent from the Users mailing list archive at Nabble.com.

[libreoffice-users] Re: Can't Sum() time measurements

2012-08-09 Thread Andreas Säger
Am 08.08.2012 18:12, teknow wrote: I have a list of measured times in [H]:MM:SS format and I would like to sum them. If I put in a formula: = B2+B3+B4+B5 it works, but if I try: =Sum(B2:B5) I get 00:00:00 as a result. What am I missing? I have tried both LibO 3.5.5.3 and 3.6.0.4 Thanks.

[libreoffice-users] Re: Pivottable/Chart Compatibility in Calc 3.6 with Excel 2002

2012-08-09 Thread Andreas Säger
Am 08.08.2012 01:01, Steve Morris wrote: Hi, I am trying to reproduce spreadsheets created at work in Excel 2002 in Libreoffice 3.6 under Linux and can't do it because pivottables and charts are not functionally compatible. When I create the pivottable and drag the fields to the layout

[libreoffice-users] Re: Do You Share ODF Documents With MS Office Users?

2012-08-09 Thread Andreas Säger
Am 09.08.2012 18:51, webmaster-Kracked_P_P wrote: I have one users that only uses Windows due to his need to access a database he created using MSO 98[?] and now using MSO 2000 or 2003. With no real Base documentation for me to deal with, I cannot figure out how to make it work with Base. So

[libreoffice-users] Re: Open in maximized window

2012-08-10 Thread Andreas Säger
Am 10.08.2012 08:53, Walther Koehler wrote: What is wrong? Where is the switch? Install an additional Base package from your repositories or install the real thing from http://www.libreoffice.org/download/ Since OOo 2 I pin the PPD versions as uninstallable and install the latest

[libreoffice-users] Re: Open in maximized window

2012-08-10 Thread Andreas Säger
Am 10.08.2012 09:53, Walther Koehler wrote: Are you refering to the postscript printer descriptions, my problem is not related to print its just with opening a file and having an unwanted window. Walther No, I was using the wrong acronym. Just go to your package manager and search for

[libreoffice-users] Re: Problems sending e-mail with Libre Office

2012-08-10 Thread Andreas Säger
http://nabble.documentfoundation.org/file/n4000497/AOO_mail_config.png -- View this message in context: http://nabble.documentfoundation.org/Problems-sending-e-mail-with-Libre-Office-tp4000385p4000497.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

  1   2   3   4   5   6   7   8   9   10   >