[libreoffice-users] Re: Base and new Report Builder in 3.5

2012-03-13 Thread Andreas Säger
Am 13.03.2012 12:11, Fernand Vanrie wrote: It would be handy to see some examples of how you make reports with calc. We have questions on how to Make headers , footers and grouping somes results ? Greetz Fernand Page headers and footers can not have database content unless you write a

[libreoffice-users] Re: Base and new Report Builder in 3.5

2012-03-13 Thread Andreas Säger
Am 13.03.2012 18:05, Fernand Vanrie wrote: Andreas , Thanks for your interest With grouping i meaned having the content of the grouped column on top or at the bottom off the items off the same group. We where thinking on a macro who use a resulstet to fill the spreadsheet cell by cell with some

[libreoffice-users] Re: Base and new Report Builder in 3.5

2012-03-12 Thread Andreas Säger
Am 11.03.2012 19:48, tops wrote: Hi all, I have been using OO and LibreOffice prior to 3.5 with Base and Reports. Now the Reports in 3.5 can not be used any further, instead I had to try (despair) and create new Reports using the Oracle Reports Tool. IMHO this is a major leap backwards… It

[libreoffice-users] Re: OOoBean

2012-03-12 Thread Andreas Säger
Am 12.03.2012 19:16, Robson Peixoto wrote: Hi, I'd like to embed the Write in a java application, but on Mac OS X doesn't has the libofficebean and OOoBean. Is possible embed the Writer without it ? How? Hi, http://www.oooforum.org/forum/viewtopic.phtml?t=9883 This is a macro which

[libreoffice-users] Re: Enable JRE Alert when starting Writer document

2012-03-11 Thread Andreas Säger
Am 11.03.2012 22:44, bernie12 wrote: Any ideas here? Thanks! This office suite runs perfectly well without any Java. Disable the use of Java in ToolsOptionsJava. The following features will not work: FileWizardsLetter,Fax,Agenda,Web page FileExportXHTML Connections to Java databases. A new

[libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file

2012-03-10 Thread Andreas Säger
The CELL function is there for some historic reasons. Very old documents from other applications may use it. Except for the filename option there is no use for it in Calc. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file

2012-03-10 Thread Andreas Säger
Am 10.03.2012 19:59, csanyipal wrote: Andreas Säger wrote The CELL function is there for some historic reasons. Very old documents from other applications may use it. Except for the filename option there is no use for it in Calc. So which function can be used instead of CELL function

[libreoffice-users] Re: This is how I got LibreO installed and working

2012-03-09 Thread Andreas Säger
Am 09.03.2012 13:40, Pertti Rönnberg wrote: 4 the Java/JRE is said to be a must for both OO and LO; This is a rumor. Both suites run fine without any Java. You can check it out when you disable the use of Java components in the Office options. It is rather unlikely that the avarage user

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-08 Thread Andreas Säger
Am 08.03.2012 06:54, Andrew Douglas Pitonyak wrote: I believe that a sample solution can be found in AndrewBase.odt, search for the macro listing Prompt for a CSV file, and then display the data. Right, your AndrewBase.odt demonstrates how to load plain text database data into the database

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
Am 07.03.2012 00:35, fork wrote: I can provide any more info if anyone would like. A couple of lines of actual data copied from a text editor tell more than thousand words. P.S. -- I don't really want to get good at macro writing, so I am hoping for the very quickest quick hack, rather

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
All that Inelligent Technology is about data processing. Input Processing - Output. Without knowing anything about the input there is no way to write any program to process data. Programmers are lazy because they know how to write routines to solve the same problem once for all times. You are

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
May be you did not notice that LibreOffice remembers the import settings for text files. If you need to open the same type of file repeatedly, you can specify the import options once and next time you simply confirm the dialog. -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
Am 07.03.2012 19:24, fork wrote: Andreas Sägervilleroyat t-online.de writes: May be you did not notice that LibreOffice remembers the import settings for text files. If you need to open the same type of file repeatedly, you can specify the import options once and next time you simply

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
Again, it is technically and logically impossible to write a program without knowing anything about the input. If you can not copy a few lines of text from a text editor, then I will have to explain too many details anyway. End of discussion. Bye. -- For unsubscribe instructions e-mail

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
Am 07.03.2012 22:03, Johnny Rosenberg wrote: A Tab delimited text file – what more could we want to know? 4 different lines of tab delimited text each with 4 identical values: 2012/03/08 1,213.59text7-8 2012-03-08 1,213.59text7-8 8.März1201213,59

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
Am 08.03.2012 01:48, fork wrote: Andreas Sägervilleroyat t-online.de writes: Am 07.03.2012 22:03, Johnny Rosenberg wrote: A Tab delimited text file – what more could we want to know? 4 different lines of tab delimited text each with 4 identical values: 2012/03/08 1,213.59

[libreoffice-users] Re: Table Format

2012-03-06 Thread Andreas Säger
Screenshot http://www.mediafire.com/i/?r49k545au99e2wb -- 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/Netiquette List

[libreoffice-users] Re: Table Format

2012-03-06 Thread Andreas Säger
Am 06.03.2012 16:00, Sylvain Bromberber wrote: That picture was very helpful! However I still can't do it. I cannot get that Form Navigation tool bar to show up, as in your picture, or that icon to be added to any toolbar. I click on Form Navigation for toolbars when in a form and the option is

[libreoffice-users] Re: Table Format

2012-03-06 Thread Andreas Säger
Am 06.03.2012 19:25, Sylvain Bromberber wrote: Hi Pertti, All that worked as you described. I found 'Navigation bar'. It was already marked yes! But no visible navigation bar with the icon on your example! Picking Parent form instead of yes made no difference. What is going on? Let me say again

[libreoffice-users] Re: Subforms in LibreO-Base

2012-03-06 Thread Andreas Säger
Am 06.03.2012 19:28, Pertti Rönnberg wrote: Andreas Säger, In your answer to Sylvain Bromberber (about Table format) you mentioned that you set /that property to Parent Form for all subforms of the main form/. Do you mean that you in LibreO-Base can have two or more subforms in one main form

[libreoffice-users] Re: Spell check problems

2012-03-06 Thread Andreas Säger
Am 06.03.2012 15:16, Edwin Matheson wrote: I want to thank everyone for trying to help me with my spell check problem. However, I still have the problem. Spell check tells me that every word in my doc. is spelled wrong. I still have OpenOffice on my computer and I was able to get into the system

[libreoffice-users] Re: Table Format

2012-03-05 Thread Andreas Säger
Am 05.03.2012 02:43, Dennis E. Hamilton wrote: Are you on a laptop? Your function keys may have as default actions the control of laptop display functions and other provisions. (These are usually signified by a variety of symbols.) Usually, there is a way to obtain the F4 key function. If

[libreoffice-users] Re: Table Format

2012-03-05 Thread Andreas Säger
Am 05.03.2012 18:30, Sylvain Bromberber wrote: I don't think that I have that last button on. I either have the wrong toolbar on or I have to add a button to it, but I don't know what button. Thanks for your help. Sylvain The toolbar with all the buttons to let the form user interact with

[libreoffice-users] Re: Help with date formatting

2012-03-04 Thread Andreas Säger
Am 03.03.2012 20:00, Duncan Murdoch wrote: - I want to be able to cut and paste lines from a web page into the file, to make small updates. This is why I'm using Calc for editing. OO lets me paste data and it gets treated as I want. Hopefully with your suggestions for configuring LO, it'll do

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-03-04 Thread Andreas Säger
Am 04.03.2012 21:59, Dag Wieers wrote: Yet, the link you carefully removed from my mail was *your* answer to my mail to e-letter's mail: http://www.mail-archive.com/users@global.libreoffice.org/msg17560.html So we are not discussing whatever mail you initially send to Roger, we are discussing

[libreoffice-users] Re: Table Format

2012-03-04 Thread Andreas Säger
Am 04.03.2012 19:12, drew jensen wrote: On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the

[libreoffice-users] Re: Calc DATEVALUE() accepts only locale format

2012-03-04 Thread Andreas Säger
Am 04.03.2012 22:35, Ferry Toth wrote: Couldn't datavalue take the locale of the formatted cell? Or is there a better trick to ge this done? The same probably holds for other localized conversions as well. Ferry Convert the text to number using the appropriate formulas and locale.

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-03-03 Thread Andreas Säger
Am 02.03.2012 23:17, Dag Wieers wrote: On Fri, 2 Mar 2012, Andreas Säger wrote: So what do you reply to Roger Sawkins? That he can file a bug report hoping that some day in future LibreOffice will fully support the extinct ppt format? Yup, with the help of the community we can improve

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-03-03 Thread Andreas Säger
Am 02.03.2012 23:41, Roger Sawkins wrote: Well, having had your little spat I see we have got back to suggestions as to what I might do about my problem. Bear in mind I am new to this game. There is a suggestion of reporting a bug. I realise there is a link for that, but what is the best way?

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-03-03 Thread Andreas Säger
Am 02.03.2012 19:25, Dag Wieers wrote: I didn't reply to your post in this thread. I was replying to e-letter's post. Maybe you got lost and assumed I was replying to your post, I don't know. I wonder who got lost in this thread actually. This is the only answer to e-letter: There is

[libreoffice-users] Re: Python uno object comparison change in 3.5

2012-03-03 Thread Andreas Säger
Hi, Your 3rd line is supposed to be: TABALIGN_LEFT = uno.Enum(com.sun.star.style.TabAlign, LEFT) With this modification I can run your code with various Python runtimes of OpenOffice.org as well as LibreOffice 3.3: $ $OFFICE unocmp.py A: type 'instance' uno.com.sun.star.style.TabStop A:

[libreoffice-users] Re: Help with date formatting

2012-03-03 Thread Andreas Säger
Am 03.03.2012 14:19, Duncan Murdoch wrote: I have recently switched from OpenOffice to LibreOffice (version 3.5.0), and am having problems configuring it to handle dates in the same way. These are the problems: 1. I want to maintain a CSV file containing dates in the format DD/MM/YY. When I

[libreoffice-users] Re: Queries wizard in Base

2012-03-03 Thread Andreas Säger
Am 03.03.2012 14:43, Sylvain Bromberber wrote: The Queries wizard in my Libre Office 3.05 simply does not work. Nothing happens when I click on it. Queries through Design works fine. I tried by starting a new Base file to determine whether the problem was with the base file on which I was

[libreoffice-users] Re: Queries wizard in Base

2012-03-03 Thread Andreas Säger
Am 03.03.2012 16:09, Sylvain Bromberber wrote: I do have Java installed. By the way, it worked fine while I was still using Open Office. It works with all versions of OpenOffice.org, LibreOffice 3.3.x and it broke unnoticed somewhere in the development process of LibreOffice 3.4. The other 2

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-03-02 Thread Andreas Säger
Am 02.03.2012 01:49, Dag Wieers wrote: Why are you so defensive ? Open Source thrives on people that are interested in a certain subject, and one of those subjects could be improving the PPT import and export filters. Even if you personally are not affected by such improvements, why would you

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-03-02 Thread Andreas Säger
Am 02.03.2012 09:41, Andreas Säger wrote: OK, can open source make my car fly and swim if I only wish hard enough? There are limitations in software development just like there are limitations in the physical technology. MS has the big truck and refuses to carry the comparatively small ODF

[libreoffice-users] Re: Tell me it's not true

2012-03-02 Thread Andreas Säger
Am 29.02.2012 14:36, e-letter wrote: Interesting; suggests that base exists just to answer the question by m$ fans: where is the equivalent to acce$$? Right, at a first glance it is nothing but Access mimicry. Maybe base should be removed from LO entirely and a separate database product be

[libreoffice-users] Re: How to create a custom control on a form?

2012-03-02 Thread Andreas Säger
Am 01.03.2012 23:38, Ferry Toth wrote: Is there an easy way? We would like to put an 'agenda' (like daily/weekly/monthly tasks) control on a Base form. Any suggestions? Ferry You can use an ordinary one-to-many relation where each task has one period type (list box with period name and

[libreoffice-users] Re: Tell me it's not true

2012-03-02 Thread Andreas Säger
Am 02.03.2012 04:25, Andrew Douglas Pitonyak wrote: What is wrong with telling someone not to use base??? The purpose of free software is freedom to use other tools; noone said it had to be a traditional office software product. I remember being advised by OO users to use R for statistics; it

[libreoffice-users] Re: Protection in Calc

2012-03-02 Thread Andreas Säger
Just like in Excel, OpenOffice.org and Gnumeric, the document protection protects the order, visibility and naming scheme of the sheets collection. You can not rename, insert, copy, move nor delete sheets. Sheet protection protects all locked cells against modification. By default all cells are

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-03-02 Thread Andreas Säger
Am 02.03.2012 12:33, Dag Wieers wrote: What does flying/swimming cars have to do with improving the existing PPT import and export filter ? It's the economy! Only dreams are free. Of course everybody wants the magic soft to open each and every proprietary file format of computing history.

[libreoffice-users] Re: Simple Base questions accessing a CVS file

2012-03-02 Thread Andreas Säger
Am 02.03.2012 18:12, Dan Lewis wrote: Specifically, a CVS formated file can be accessed by Base. Among the format choices is thousands separator. Will Base access a CVS file that uses a thousands separator and show the numbers with it? (1,000,000 or 1.000.000?) Or, will the field containing

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-03-02 Thread Andreas Säger
So what do you reply to Roger Sawkins? That he can file a bug report hoping that some day in future LibreOffice will fully support the extinct ppt format? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-03-01 Thread Andreas Säger
Am 01.03.2012 15:20, Dag Wieers wrote: On Tue, 28 Feb 2012, e-letter wrote: On 28/02/2012, Roger Sawkins ro...@sawkins.name wrote: I have Powerpoint on one machine and LibreOffice on another. I want to be able to edit and save PowerPoints on either machine. However, when loading Ppt in

[libreoffice-users] Re: Tell me it's not true

2012-03-01 Thread Andreas Säger
Am 01.03.2012 22:19, Andrew Douglas Pitonyak wrote: I created a few databases but I found them unstable By that, I mean that things would simply stop working after an upgrade or after too much data had been added (by large I mean too many images so the dataset took many MB rather than too

[libreoffice-users] Re: Tell me it's not true

2012-03-01 Thread Andreas Säger
Am 01.03.2012 23:02, Mark Stanton wrote: Hi Andrew, Was that instability with an internal HSQL database? Mark Stanton One small step for mankind... The .odb file claims to be a document but in fact it is an extension. When you open the file and then open one of its objects, the embedded

[libreoffice-users] Re: Headless mode examples for socket and pipe methods.

2012-02-29 Thread Andreas Säger
http://code.google.com/p/jodconverter/ -- 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/Netiquette List archive:

[libreoffice-users] Re: Tell me it's not true

2012-02-29 Thread Andreas Säger
Am 29.02.2012 16:06, Mark Stanton wrote: perhaps able to include some aspects of the spreadsheet paradigm to data manipulation. That's an interesting thought. What sorts of aspects do you have in mind? Mark Stanton A database component without databases would be as interesting as a

[libreoffice-users] Re: Tell me it's not true

2012-02-29 Thread Andreas Säger
Am 29.02.2012 18:15, Dan Lewis wrote: This thread for the most part is exactly what should not be part of this mailing list. @Mark Stanton, Would you please visit us at http://user.services.openoffice.org/en/forum/index.php next time? What would most people who are new to Base think

[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout

2012-02-28 Thread Andreas Säger
Am 28.02.2012 01:10, Roger Sawkins wrote: I have Powerpoint on one machine and LibreOffice on another. I want to be able to edit and save PowerPoints on either machine. Hello Roger, It is not supposed to work like this. LibreOffice is not a drop in replacement for any other software. You can

[libreoffice-users] Re: Tell me it's not true

2012-02-28 Thread Andreas Säger
Am 28.02.2012 11:27, Mark Stanton wrote: Thanks Andreas, Unfortunately this isn't for a form, it's for a report. Mebbe I'll start having a look at that code, being on Linux you're other suggestion doesn't help me :-( Regards Mark Stanton One small step for mankind... Create a brand new

[libreoffice-users] Re: Unprotecting table cells

2012-02-28 Thread Andreas Säger
This is the same in OpenOffice.org, LibreOffice, Excel, Gnumeric and other spreadsheet programs. menu:ToolsProtectionSheet=OFF opens the locks of all the cells on that sheet having a lock attached. Now you can edit any cell. FormatCellsTab:Protection allows you to add or remove a lock to

[libreoffice-users] Re: Calc broke my document

2012-02-28 Thread Andreas Säger
With all the given information about the flaws in your content.xml it should be possible to fix the file mainly by removing some format attributes. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Tell me it's not true

2012-02-28 Thread Andreas Säger
Am 28.02.2012 12:09, John Talbut wrote: This is a very old bug with lots of people urgently wanting something done about it: https://issues.apache.org/ooo/show_bug.cgi?id=42464 That issue refers to the fact that you can only connect one database per database document. This topic is about

[libreoffice-users] Re: Can several instances of soffice be run in parallel?

2012-02-28 Thread Andreas Säger
Am 28.02.2012 16:37, Apollo wrote: Is there a way to enable Libreoffice to run multi-threaded, or simply to have Calc, Writer use a dedicated instance of soffice.bin? I can run LibO 3.3.x and 3.5 and OpenOffice.org in parallel. If the same office occurs twice in your task manager you should

[libreoffice-users] Re: Tell me it's not true

2012-02-28 Thread Andreas Säger
Am 28.02.2012 18:08, Mark Stanton wrote: That'll be a good stopgap, thanks. I'll have a look at the code, but it looks like you're saying it's a slightly wider scope than just dBase. Don't hold your breath :-) We get editable relations from relational database servers if the connecting

[libreoffice-users] Re: Headless mode examples for socket and pipe methods.

2012-02-28 Thread Andreas Säger
322 results for headless on the user forum: http://user.services.openoffice.org/en/forum/search.php?keywords=headless Dozends of tools have been written for OOo: http://www.oooforum.org/forum/viewtopic.phtml?t=11890 http://artofsolving.com/opensource/jodconverter Google shows dozends of

[libreoffice-users] Re: Delayed Execution of a Formula in Calc

2012-02-28 Thread Andreas Säger
Try MY_NUMERIC_FUNC(constant_params)+RAND() or MY_TEXT_FUNC(constant_params)T(RAND()) The volatile randomizer enforces a recalculation on each and every change. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Headless mode examples for socket and pipe methods.

2012-02-28 Thread Andreas Säger
Am 29.02.2012 07:52, Andreas Säger wrote: 322 results for headless on the user forum: http://user.services.openoffice.org/en/forum/search.php?keywords=headless Dozends of tools have been written for OOo: http://www.oooforum.org/forum/viewtopic.phtml?t=11890 http://artofsolving.com/opensource

[libreoffice-users] Re: Question re: Calc default font

2012-02-27 Thread Andreas Säger
Am 27.02.2012 05:05, Brian Barker wrote: At 13:09 25/02/2012 +0100, Andreas Säger wrote: Am 23.02.2012 18:28, Willy Williams wrote: That was just the trick, Regina. Thanks for the wisdom. Now, if that capability could be made part of the Options, much as it's part of the Options in Writer

[libreoffice-users] Re: calc : very slow

2012-02-27 Thread Andreas Säger
Am 27.02.2012 10:43, pcpconsulting wrote: I have removed libreoffice 3.5 from my computer linux ubuntu and I have reinstalled version 3.3.4 because operating with calc appear very slow. I use one file in calc linked to another one as dabase with 4000 rows. When I open the first one it is so slow

[libreoffice-users] Re: calc : very slow

2012-02-27 Thread Andreas Säger
Am 27.02.2012 11:22, Tom Davies wrote: Hi :) It might be the version of java you are using. Earlier versions of LibreOffice seem to prefer earlier versions of java (the 6u21 release seemed best) but the 3.5.0 needs java 7 which still doesn't seem to have been officially released yet.

[libreoffice-users] Re: calc problem

2012-02-27 Thread Andreas Säger
I right-click the hyperlink in my browser, mail program, office document, whatever and choose a command like Copy Link Address. Then I paste the naked URL string into a Calc cell. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: HLOOKUP Broken in 3.5

2012-02-27 Thread Andreas Säger
Am 27.02.2012 00:41, spuch...@austin.rr.com wrote: I've been using the ss to chose movies to watch. The formula in cell c$ used to work great. Now after upgrading to 3.5 it always returns #N/A. -- Regards, Sig HLOOKUP works for me in LibO exactly like it used to work in all versions of

[libreoffice-users] Re: Relationships in Base

2012-02-27 Thread Andreas Säger
Am 27.02.2012 11:36, gerbreown wrote: I have just started using LO Base 3.4.4. I created 2 tables with a relationship between them. I then deleted one of the tables and created another one with a relationship to the first. When I try to add records to the table is gives me the following error

[libreoffice-users] Re: calc : very slow

2012-02-27 Thread Andreas Säger
Am 27.02.2012 14:10, Tanstaafl wrote: On 2012-02-27 4:47 AM, Andreas Säger ville...@t-online.de wrote: Am 27.02.2012 10:43, pcpconsulting wrote: I have removed libreoffice 3.5 from my computer linux ubuntu and I have reinstalled version 3.3.4 because operating with calc appear very slow. I use

[libreoffice-users] Re: calc problem

2012-02-27 Thread Andreas Säger
Am 27.02.2012 16:53, Johnny Rosenberg wrote: 2012/2/27 Václav Medekvaclav.me...@nic.cz: Andreas, I tried it now on Windows 7 with Libre Office 3.5 and it is working right as expected. When ctrl+c/ctrl+v some email address to Calc, no dialogue appear and address is just filled into Calc cell (as

[libreoffice-users] Re: Tell me it's not true

2012-02-27 Thread Andreas Säger
Am 27.02.2012 23:38, Mark Stanton wrote: When I select the dBase connector it seems to say that queries cannot contain more than one table. Tekll me it's not true... Mark Stanton One small step for mankind... Sadly, this is true. You may use a hierarchy of forms and subforms to mimic

[libreoffice-users] Re: Datetime diff formatting

2012-02-26 Thread Andreas Säger
Am 26.02.2012 07:35, gldvorak wrote: Using LibreOffice Calc I want to display the difference between two datetimes as days and hours with correct rounding. I am having problems with the rounding where for instance I get 2 days and 24 hours where the result should be 3 days 0 hours. Can someone

[libreoffice-users] Re: Editing Auto-completion List in Calc

2012-02-25 Thread Andreas Säger
Am 24.02.2012 18:18, Rich Shepard wrote: In LO-3.5.0 Calc I am offered a completed word or phrase as I start typing in a cell. The list of potential completions varies with the column. However, there are some mis-spelled words in that list and I would like to edit them out. How do I access

[libreoffice-users] Re: Question re: Calc default font

2012-02-25 Thread Andreas Säger
Am 23.02.2012 18:28, Willy Williams wrote: That was just the trick, Regina. Thanks for the wisdom. Now, if that capability could be made part of the Options, much as it's part of the Options in Writer, it would be even better. Pardon? Which options in Writer? I only know the same methods in

[libreoffice-users] Re: calc: file database

2012-02-24 Thread Andreas Säger
Am 23.02.2012 09:24, pcpconsulting wrote: I have a problem with link to database in calc. I use libreoffice 3.5 on linux ubuntu 10.4 Before was installed libreoffice 3.3 Now when I press F4 in calc appear some database where old, used before installing libreoffice 3.5 If I go on tools option

[libreoffice-users] Re: Macros - Basic Documentation

2012-02-24 Thread Andreas Säger
Am 24.02.2012 00:11, Nicolás Adamo wrote: On 02/23/2012 04:37 PM, Tom Davies wrote: Hi :) Did you get any good answers to this one or solve it on your own? If not then now might be a good time to ask the list or find the new askBOT thing on the official LibreOffice website and ask afresh

[libreoffice-users] Re: numbers to time

2012-02-20 Thread Andreas Säger
All dates and times in all spreadsheets are numbers in unit days. TIME(8;15;0) equals 8/24+15/24/60 (1/3+1/96) A concatenation gives a text value, in this case a sequence of digits separated by a colon. -- View this message in context:

[libreoffice-users] Re: Fw: LibreO-Base is lying about my age!

2012-02-19 Thread Andreas Säger
SELECT Table.*, DATEDIFF( 'mm', BirthDate, CURRENT_DATE ) / 12 - CASE WHEN MONTH(BirthDate)=MONTH(CURRENT_DATE) AND DAY(BirthDate)DAY(CURRENT_DATE) THEN 1 ELSE 0 END AS Age FROM Table I tested that query literally with a table named Table having a date column named BirthDate in both parsed mode

[libreoffice-users] Re: Fw: LibreO-Base is lying about my age!

2012-02-19 Thread Andreas Säger
I created a new database from scratch and copied the above query string without modification. This is the resulting file: http://www.mediafire.com/file/lsx9jxlesvhw7vd/AgeCalculator.odb -- View this message in context:

[libreoffice-users] Re: Fw: LibreO-Base is lying about my age!

2012-02-16 Thread Andreas Säger
SELECT Table.*, DATEDIFF( 'mm', BirthDate, CURRENT_DATE ) / 12 - CASE WHEN MONTH(BirthDate)=MONTH(CURRENT_DATE) AND DAY(BirthDate)DAY(CURRENT_DATE) THEN 1 ELSE 0 END AS Age FROM Table -- View this message in context:

[libreoffice-users] Re: Fw: LibreO-Base is lying about my age!

2012-02-16 Thread Andreas Säger
The problem has nothing to do with LibreOffice. It is a built-in function of the HSQL database engine. I am sure that it is designed to work like this. '' is not a valid argument for the datediff function. This is the home page of that software: http://hsqldb.org/ Version 2.2 is documented

[libreoffice-users] Re: Fw: LibreO-Base is lying about my age!

2012-02-16 Thread Andreas Säger
Functions TO_CHAR, TO_DATE and TO_TIMESTAMP convert between strings and date values and accept '' as part of the string format specification so the function gets a hint that the text assumes dd/mm/ format, -mm-dd or whatever. These functions are unavaillable in the built-in HSQLDB 1.8

[libreoffice-users] Re: Can't find folder for templates

2012-02-16 Thread Andreas Säger
FileTemplatesSave... will store the template in the right directory and register it so it appears in FileNewTemplates and in FileTemplatesOrganize... ToolsOptionsPaths shows all the paths used by the office suite. -- View this message in context:

[libreoffice-users] Re: Base - Phone book ?

2012-02-15 Thread Andreas Säger
James Knott wrote I thought the OP simply wanted to print his address book, after selecting the columns he wanted to print. That is easy enough to do in Calc. The question was about printing specific columns only which is even more easy without any calculator software or using Calc as

[libreoffice-users] Re: Base - Phone book ?

2012-02-15 Thread Andreas Säger
Joep L. Blom wrote All, I would like to do the same however, as I wrote on 29-12-2012 in LO 3.4.5 on Ubuntu 10.04 it is impossible to link with the TB address-book although the choice is given (see the referenced mail). Or is this feature finally implemented in 3.5. Joep Just do not

[libreoffice-users] Re: Base - Phone book ?

2012-02-15 Thread Andreas Säger
Linux users who can not connect to TB can export csv files from TB and connect LibreOffice to this data source. Notice that you can export any virtual address list you have created in TB and that the exported csv is a snapshot of the current address data. You need to repeat the export procedure

[libreoffice-users] Re: Populate database form with table data

2012-02-15 Thread Andreas Säger
Lots of links, tutorials and examples: http://user.services.openoffice.org/en/forum/viewforum.php?f=74 All you need is toolbar Form Design, the forms navigator (button #5 on that toolbar) and the properties window for the selected item(s). -- View this message in context:

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Andreas Säger
That is easy. Open the Base document which connects the TB address database with this office suite. Go to the query section. Let the designer or wizard create a new query from the table in question. Add only the columns you need. -- View this message in context:

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Andreas Säger
Andreas Säger wrote That is easy. Open the Base document which connects the TB address database with this office suite. Go to the query section. Let the designer or wizard create a new query from the table in question. Add only the columns you need. Continued: Save the query Save

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Andreas Säger
You can export the address book in tab or comma delimited format. You can then import that file into Calc and do whatever you want with it. No, you can't do anything with database data in Calc. You can not query virtual tables nor can you generate reports nor serial letters. The TB export to

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Andreas Säger
Compare this: Thunderbird CSV export Calc import Base document Report with this: Thunderbird Base document Report The Base document provides a direct link to the current TB data. You don't need to update any intermediate files. The availlable features and limitations are the same for all

[libreoffice-users] Re: Fwd: Can't get Spanish distionary to stay selected

2012-02-13 Thread Andreas Säger
Am 13.02.2012 15:04, webmaster for Kracked Press Productions wrote: Yes, having styles and templates set up for making a new document have a specific default language may be a good idea, but the basic user would not know how to do this. I have been using LO since 3.3.0 and have not got into

[libreoffice-users] Re: Calc and gradient conditional formatting

2012-02-12 Thread Andreas Säger
Am 12.02.2012 02:03, 451farenheit wrote: Hi there! I have been looking for a while and I do not find any related topic finally. What I want is to do a conditional format between a group of data, where the background of the cells in calc depends on the values inside the group. For example a list

[libreoffice-users] Re: Calc: how do I change what cell a form control is anchored to?

2012-02-12 Thread Andreas Säger
Am 12.02.2012 05:00, Jim Trigg wrote: I can change whether a form control is anchored to the page or to a cell, but not what cell it's anchored to. I want to anchor it to the cell that it populates, but it seems to always (no matter where on the page it is) anchor it to cell A1. This is

[libreoffice-users] Re: Left-floated headings using styles

2012-02-12 Thread Andreas Säger
Am 11.02.2012 08:44, Jason Heeris wrote: I'm looking to achieve a certain layout effect in LibreOffice writer, but it's a bit hard to describe. I can demonstrate it in HTML: http://heeris.id.au/test/test.html [Tutorial] In-line or run-in headings:

[libreoffice-users] Re: Fwd: Can't get Spanish distionary to stay selected

2012-02-12 Thread Andreas Säger
ToolsOptionsLanguageSettingsDefault Language sets the language for all brand new documents. Brand new documents those documents which are not derived from some template. If you use some default template for a component, you've got to open the template for editing (FileTemplatesEdit...) and

[libreoffice-users] Re: Write2epub

2012-02-11 Thread Andreas Säger
Am 11.02.2012 15:42, Ron Johnson wrote: Because epub is essentially zipped up xhtml+css. Thank you very much. I was going to ask why not using device oriented html if pdf is too much page oriented. Can we export ODF to XHTML and get something close to epub? -- For unsubscribe

[libreoffice-users] Re: Avoid destop window

2012-02-10 Thread Andreas Säger
Am 08.02.2012 08:03, Pedro wrote: I understand your idea (yes annoying is the perfect word ;) ). I think that it would make a lot of sense to have an alternate working mode where closing a document would keep the programs interface instead of showing the Start Center. And in that mode, the New

[libreoffice-users] Re: Mailmerge, working, fairly well, but...

2012-02-10 Thread Andreas Säger
Am 10.02.2012 08:43, Mark Stanton wrote: No, that's not quite my question. There will *always* be a picture, and it is either a picture of a first class stamp or a second class one. But I want whichever stamp it is to appear in (almost) the same place according to destination (international

[libreoffice-users] Re: question about print multiple addresses

2012-02-10 Thread Andreas Säger
Am 10.02.2012 18:51, Jeremy Sears wrote: Hello, Im new to LibreOffice. I have searched a bit but can seem to find a specfic answer to my question. In LibreOffice can I print address to multiple labels or on multiple letters? I have a spreadsheet with a number of mailing addresses. I would like

[libreoffice-users] Re: Write2epub

2012-02-10 Thread Andreas Säger
Am 10.02.2012 15:41, Tinkerer wrote: I have found Write2epub. All the extensions are on a disc downloaded from Kracked Press. I thought I would try it for converting Libre User Guides to epub format for the iPad. Why not PDF? What is the advantage of epub? -- For unsubscribe instructions

[libreoffice-users] Re: Mailmerge, working, fairly well, but...

2012-02-09 Thread Andreas Säger
Am 09.02.2012 20:14, Alex Thurgood wrote: Le 09/02/2012 19:03, Fernand Vanrie a écrit : Hi Fernand, I did a bit more testing, now i can store en review a image in a database, using a Form and a image control, but there is still the problem that there is nothing like a imagefield to recall and

[libreoffice-users] Re: Mailmerge, working, fairly well, but...

2012-02-09 Thread Andreas Säger
Am 09.02.2012 21:58, Alex Thurgood wrote: Agreed, but can you set it up to make the paragraph as invisible depending on whether or not you have a varchar string ? I imagine so, but that is the question that the original poster was asking. Your macro would need to take care of that piece of

<    5   6   7   8   9   10   11   12   13   14   >