[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: 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: 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: 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 properly and remain in the thread that you

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

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

[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

[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

[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

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

[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

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

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

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

[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

[libreoffice-users] Re: libreoffice 3.5 inaccessible

2012-06-05 Thread Andreas Säger
for the whole options dialog. I hope this helps. Greetings, Andreas Säger -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

[libreoffice-users] Re: Printing page in landscape in 2 column mode

2012-06-05 Thread Andreas Säger
Am 05.06.2012 06:25, Marc Paré wrote: The printer setting is set to landscape already and the preview shows landscape correctly. May be the layout is turned twice when you set landscape mode in both, application and printer? I saved the document as a .pdf and it prints correctly as a

[libreoffice-users] Re: libreoffice 3.5 inaccessible

2012-06-05 Thread Andreas Säger
We do not know the system yet. In case of Windows x64 Jude has to install a 32 bit version of Java 6 (current version number 1.6.0_32). Such a version can be downloaded from http://www.oracle.com/technetwork/java/javase/downloads/jre-6u32-downloads-1594646.html Accept license and download

[libreoffice-users] Re: Document 'corrupt' for LibreOffice, opens fine with other OOo-based software

2012-06-04 Thread Andreas Säger
Am 04.06.2012 09:59, Eric Brunel wrote: Looks like the attached document didn't get through, so here is a link to it: http://ubuntuone.com/0LoWLJjhmIkje4wrRLOpuo Hi, All my recent offices consider your document as broken and suggest to repair. The repair process ends successfully with a

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-04 Thread Andreas Säger
Am 04.06.2012 17:22, Heinrich Stoellinger wrote: Hello Pertti, As a long-time (now retired) IBM-Systems Engineer serving large customers I can only agree with you completely. I myself keep using the latest LO-versions - having used OO/LO for at least 6 to 7 years. However, there are a couple of

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-03 Thread Andreas Säger
Am 02.06.2012 21:18, Jude DaShiell wrote: No. Not ready for Government academic or business users. What's worse, the accessibility problems inferior jre with windows registry patch merged didn't start in libreoffice at all. https://bugs.freedesktop.org/show_bug.cgi?id=46114#c7 [Resolved, not

[libreoffice-users] Re: install of 3.5.4 over 3.4.6 removed all my extensions

2012-06-03 Thread Andreas Säger
Am 03.06.2012 11:28, Alexander Thurgood wrote: Le 03/06/12 11:03, Tom Davies a écrit : Hi Tom, Hi :) I thought it was possible to copy user-profiles between different machines? Even between ones running different OSes? Is it not possible to copypaste the Extensions folder from the old

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-03 Thread Andreas Säger
Am 03.06.2012 20:14, Felmon Davis wrote: I am curious: what happens if one just changes the file extension from .doc to .docx? F. Brilliant idea! This way you get much better results while the WinWord user will not notice any difference at all. -- For unsubscribe instructions e-mail

[libreoffice-users] Re: Bug on change foreground color on Calc (LibO 3.5.4.2 on Mac)

2012-06-03 Thread Andreas Säger
Am 03.06.2012 11:32, Januar V. Simarmata (G!) wrote: Hi, I'm using LibO 3.5.4.2 on Mac, specifically trying it on Calc. I'm trying to change foreground color and it doesn't show as expected. With same version, It works fine on Windows. I'm not sure if it's already known, and also haven't have

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-03 Thread Andreas Säger
Am 03.06.2012 22:18, Jay Lozier wrote: My idea is to show that whatever MS does with file formats that you are not required to use MSO at all. And this is falsified each and every day as you can read on this list, in the press, anywhere on the internet. -- For unsubscribe instructions

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-03 Thread Andreas Säger
Am 04.06.2012 00:59, Tom Davies wrote: Andreas' and e-letter's answer is to tell people that to use LO they must stop communicating with anyone that uses MS Office, so that is all their customers and clients, their colleagues, their boss and people that work for them, their family and

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-03 Thread Andreas Säger
Am 04.06.2012 00:50, Brian Barker wrote: You are implying that a file with a .docx extension but actually in .doc format will be happily opened by Microsoft Word - that Word will simply interpret the contents and ignore the inappropriate extension, that is. Sadly for your theory, that appears

[libreoffice-users] Re: Calc: Cell Reference Duplicate?

2012-06-02 Thread Andreas Säger
Hello John, Go to ToolsOptionsCalcGeneral and turn on the option expand references Now you can insert new rows anywhere in the list and directly below the list and all references in formulas, charts, conditional formatting, validation formulas and form controls will follow the new

[libreoffice-users] Re: Calc: Cell Reference Duplicate?

2012-06-02 Thread Andreas Säger
Am 02.06.2012 05:47, John Sowden wrote: Cell Reference Method (cell referenced is in parenthesis): =sumif($checks.$M$(b110):$checks.$M$(c110), etc. That would be =SUMIF(OFFSET($Checks.$M$1 ; $B$110-1 ; 0 ; $C$110-$B$110 ; 1)) That is from M1 b110-1 cells down, 0 to the right, resized to the

[libreoffice-users] Re: Calc: Cell Reference Duplicate?

2012-06-02 Thread Andreas Säger
Am 02.06.2012 16:48, John Sowden wrote: At each month, I break that to allow for totals, and I leave a blank line to show where that month ended. You must not do that. This is how one would work with paper records. A spreadsheet can store thousands of rows in arbitrary order and the software

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-02 Thread Andreas Säger
Am 02.06.2012 16:46, webmaster-Kracked_P_P wrote: There seems to be differenting opinions on how business ready 3.5.3 was So now that LO 3.5.4 is out, I ask the users, is it ready to be deployed to my/our business users? We really need to know. The last official word on the 3.5.x line was

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-02 Thread Andreas Säger
Am 02.06.2012 21:18, Jude DaShiell wrote: No. Not ready for Government academic or business users. What's worse, the accessibility problems inferior jre with windows registry patch merged didn't start in libreoffice at all. Those same problems exist in openoffice 3.45 which I think is its

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-02 Thread Andreas Säger
Am 02.06.2012 23:26, Jay Lozier wrote: I use 3.5.4.2 from the repository for both business and personal use and do not have any issues for what I need and do with it. But I have limited business needs with the most important issue being the ability to open and to create docx and xlsx files from

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-02 Thread Andreas Säger
Am 02.06.2012 23:29, webmaster-Kracked_P_P wrote: I do not know of any professional IT person who would offer a major package to their boss with the an attitude of lets find out if it will work, instead of these sources indicates it should work, so lets look into it more. Yes, sure. Recently

[libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-02 Thread Andreas Säger
Am 03.06.2012 01:21, Jay Lozier wrote: Can you please explain why you create docx and xlsx and not doc and xls? To keep others happy, How can you be sure that you keep others happy with a poorly supported file format? Why should a user of MSO be unhappy with doc/xls being a second native

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

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

[libreoffice-users] Re: LibreOffice Writer

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

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

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

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

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

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

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

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

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

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

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

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