[libreoffice-users] Re: Issues with date fields in dialogues

2017-01-08 Thread Andreas Säger
[Tutorial] Date-Time Conversion in StarBasic including a spreadsheet document and a Basic function which converts all types of dates, times, timestamps into any other type. Date-times can be represented by UNO structs, integers,

[libreoffice-users] Re: Issues with date fields in dialogues

2017-01-07 Thread Andreas Säger
Hit the push button which is attached to the sheet. It opens a dialog with a date and time control. The two controls read and write the A1 cell. It works with all versions of Libre/OpenOffice and it works correctly with different NullDate settings. Function convertDateTime is designed to convert

[libreoffice-users] Re: Calculating hours using spin button - simplified - answered

2017-01-07 Thread Andreas Säger
There is a control named "DateField" writing to a cell named "DateField" There is a control named "TimeField" writing to a cell named "TimeField" There is a control named "CurrencyField" writing to a cell named "CurrencyField" etc. Each control has a "Text Modified" event which calls the macro.

[libreoffice-users] Re: Problems exporting and importing a dialogue

2017-01-07 Thread Andreas Säger
Importing/exporting Basic modules and dialogs is easy when you do NOT store everything in libraries named "Standard". Use the organizer to create a library with a distinct project name within a template, document or in global container "My Macros" Move dialogs and code modules into the library.

[libreoffice-users] Re: Conditional formatting and named ranges issues.

2017-01-07 Thread Andreas Säger
As far as I understand the matter, the LibreOffice devs have broken the c.f. feature. The c.f. conditions are formula expressions but they do not behave like other formula expressions when you move, copy, expand or shrink references. This is one of the things that still work (almost) properly with

[libreoffice-users] Re: Calc Options > Libreoffice Calc > General > Expand references when new columns/rows are inserted

2017-01-04 Thread Andreas Säger
*Without "expand references"* =SUM(Sheet1.A1:A99) becomes =SUM(Sheet1.A2:A100) after you inserted one new row at Sheet1, row #1. The reference moves down one row. When you insert one row between row #2 and row #99 the reference expands by one row: =SUM(Sheet1.A1:A100) Nothing happens when you

[libreoffice-users] Another LO anti-feature

2016-12-21 Thread Andreas Säger
How can I disable the silly dialog that pops up after every search on a Calc sheet? After correcting a column of 250,000 numbers it tries to write 250,000 cell addresses into a list box which takes by a magnitude more time than the replacement process. If such feature is really, really desired by

[libreoffice-users] Re: Compatibility of LO Base with Access databases

2016-08-07 Thread Andreas Säger
Walther Koehler-4 wrote > My doctors office uses a dBase based system for administration, keeping > patient records and so on. It has integrated LO for many purposes, i.e. > medical letters. As I was told, reading those dbf files using scripts is > easy > (dbf_dump), modifying dbf files from

[libreoffice-users] Re: Compatibility of LO Base with Access databases

2016-07-31 Thread Andreas Säger
After all the years I'm still shocked by the level of ignorance on this user support mailing list. https://forum.openoffice.org/en/forum/viewtopic.php?f=83=25300 -- View this message in context:

[libreoffice-users] Re: Embedded Base on Windows Share?

2016-06-08 Thread Andreas Säger
For multi-user access you need a database server. It is fairly easy to convert your embedded HSQLDB into a server application. -- View this message in context: http://nabble.documentfoundation.org/Embedded-Base-on-Windows-Share-tp4185518p4185648.html Sent from the Users mailing list archive at

[libreoffice-users] Re: very slow loading of a ods file

2016-04-30 Thread Andreas Säger
Am 30.04.2016 um 00:02 schrieb John R. Sowden: > > I then copied another test sheet and deleted all entries below December, > calcs and cursor moves worked fine. > > Therefore I concluded that the problem is with the dates after > December. I am doing no date math. This seems like a LO

[libreoffice-users] Re: LO for Android - is there more than a Viewer available? Beta maybe?

2016-04-29 Thread Andreas Säger
Dreams are free. -- View this message in context: http://nabble.documentfoundation.org/LO-for-Android-is-there-more-than-a-Viewer-available-Beta-maybe-tp4182275p4182372.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: LO for Android - is there more than a Viewer available? Beta maybe?

2016-04-29 Thread Andreas Säger
Am 29.04.2016 um 11:19 schrieb Andreas Säger: > > Your initial question was if there is more than a viewer for Android and > now you come up with issues of taste and branding. Sorry. It was Tim's initial question. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] Re: LO for Android - is there more than a Viewer available? Beta maybe?

2016-04-29 Thread Andreas Säger
Am 29.04.2016 um 03:30 schrieb James Knott: > On 04/28/2016 06:02 PM, Tim---Kracked_P_P---webmaster wrote: >> I chose LibreOffice over all of the forks out there. > > Ummm... LibreOffice is a fork of OpenOffice. > > Your initial question was if there is more than a viewer for Android and now

[libreoffice-users] Re: LO for Android - is there more than a Viewer available? Beta maybe?

2016-04-28 Thread Andreas Säger
Am 29.04.2016 um 00:02 schrieb Tim---Kracked_P_P---webmaster: > > I would rather have a LibreOffice for Android instead of Open Office for > Android. > I trust that the developers who made this happen know exactly what they are doing. -- To unsubscribe e-mail to:

[libreoffice-users] Re: LO for Android - is there more than a Viewer available? Beta maybe?

2016-04-28 Thread Andreas Säger
Do you really believe in brands? -- View this message in context: http://nabble.documentfoundation.org/LO-for-Android-is-there-more-than-a-Viewer-available-Beta-maybe-tp4182275p4182305.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: LO for Android - is there more than a Viewer available? Beta maybe?

2016-04-28 Thread Andreas Säger
Am 28.04.2016 um 17:55 schrieb Tim---Kracked_P_P---webmaster: > With the posts about iOS version is not available [on the Website list], > I remember reading something about an Android version that was more than > just a Viewer. > > Is there an Android version yet, that can edit documents? Even

[libreoffice-users] Re: LibreOffice Online

2016-04-25 Thread Andreas Säger
Am 25.04.2016 um 05:52 schrieb Bo Siltberg: > The site wants me to install a client, what is this client used for? > My antivirus program claims it contained "Variant.Graftor.5639" and deleted > it... > Hakuna Matata > https://malwaretips.com/blogs/gen-variant-adware-graftor-removal/ -- To

[libreoffice-users] Re: open a Mac numbers file in calc?

2016-04-24 Thread Andreas Säger
This is not a universal file opener. Universal file opener do not exist. -- View this message in context: http://nabble.documentfoundation.org/open-a-Mac-numbers-file-in-calc-tp4181740p4181825.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: Err:504 with DDE links since LO 4→5 upgrade

2016-04-20 Thread Andreas Säger
Am 20.04.2016 um 17:21 schrieb martin f krafft: > also sprach Andreas Säger <ville...@t-online.de> [2016-04-20 17:11 +0200]: >> Works for me. DDE works with system notation ("C:\path name\file >> name.ods") and with URL notation >> "file:///C:/path%20name

[libreoffice-users] Re: Deleting external links

2016-04-20 Thread Andreas Säger
Am 20.04.2016 um 15:45 schrieb martin f krafft: > Hey list, > > we are dealing with a rather complex spreadsheet and looking at > Edit→Links, there are literally thousands of links in there that are > no longer used anywhere in the document. Opening the document (and > saving, and sometimes

[libreoffice-users] Re: Err:504 with DDE links since LO 4→5 upgrade

2016-04-20 Thread Andreas Säger
Am 20.04.2016 um 15:43 schrieb martin f krafft: > Hey list, > > We're dealing with a complex document containing hundreds of DDE > links. Worse yet, those DDE links are dynamically created, e.g. > using the following formula to reference filename ($B$2), sheet name, > ($B$3), column ($B$6), and

[libreoffice-users] Re: Error on creation of sum in write table

2016-04-19 Thread Andreas Säger
Am 19.04.2016 um 18:52 schrieb Heinrich Stoellinger: > Hello, > I am trying to create a sum of arithmetic columns in a writer table, using > the procedure described in the help document. I put the cursor into the > cell that the sum should end up in, press F2, then select the first cell > that is

[libreoffice-users] Re: Calc method to change whole column cell content

2016-04-14 Thread Andreas Säger
If you would read the initial posts of the topics you are replying to ... MRZenwiz: > What I've been doing is loading the .csv file into a text editor, > change those fields and then reload into calc. This is terribly > cumbersome. > However, in the .csv file they send, the dollar transactions

[libreoffice-users] Re: Calc method to change whole column cell content

2016-04-14 Thread Andreas Säger
Am 13.04.2016 um 18:23 schrieb James E. Lang: > And there *are* text editors (even on Windows) that use regular expressions > and thus can perform the transformation relatively painlessly. > > All the best! > Writer is one of them. Calc supports regular expressions as well. I have tested

[libreoffice-users] Re: Calc method to change whole column cell content

2016-04-13 Thread Andreas Säger
Am 13.04.2016 um 12:32 schrieb Tom Davies: > Hi :) > CSV format can be easily edited in normal text-editors before opening in > Calc. Sometimes its easier to use a simpler tool to do a part of the job > rather than use a complicated route in a heavier tool such as Calc. > Regards from > Tom :)

[libreoffice-users] Re: Importing CSV file into Calc with records determined by the number of field separators instead of Line Feeds

2016-04-11 Thread Andreas Säger
Am 11.04.2016 um 06:26 schrieb Philip Rhoades: > People, > > I need to import a CSV dump from an Android SMS Sqlite DB - the problem > is, many of the SMSs have line breaks in the text body of the DB record > and this messes up the import into Calc. There does not seem to be any > way of saying

[libreoffice-users] Re: Calc method to change whole column cell content

2016-04-08 Thread Andreas Säger
Am 08.04.2016 um 13:49 schrieb Bruce Hohl: > Method 1 - Using Value() > Use value() function to convert a text string into a number or date. > Copy the result; paste special as number or date. > --- > Method 2 - Search & Replace > Select (highlight) a cell range then: > Using Search & Replace

[libreoffice-users] Re: Libreoffice 5.1.1.3 on Windows 7

2016-04-08 Thread Andreas Säger
Am 08.04.2016 um 04:04 schrieb Henry Sikkema: > Thank you Andreas, for the suggestion. Running Windows 7 in SafeMode > allows the file to load! So how do I find the offending files or > configuration? > > Henry > I don't know. My knowledge about Windows is very limited. -- To unsubscribe

[libreoffice-users] Re: Libreoffice 5.1.1.3 on Windows 7

2016-04-07 Thread Andreas Säger
Am 08.04.2016 um 03:02 schrieb Henry Sikkema: > I tried a complete re-uninstall and deleted the profile folder and > reinstalled and a new profile folder was created when I started LO Calc > again. The file still crashes LO Calc on my machine but not on the other > machine. > > Aside from a

[libreoffice-users] Re: Calc method to change whole column cell content

2016-04-07 Thread Andreas Säger
Am 08.04.2016 um 01:35 schrieb MR ZenWiz: > I recently began to use the spreadsheet downloads from one of my > credit unions as it is so far superior to the home-grown method I have > been using it's not even funny. > > (I know, way late... Cries of "luddite" in the background, etc.) > >

[libreoffice-users] Re: Libreoffice 5.1.1.3 on Windows 7

2016-04-07 Thread Andreas Säger
Am 07.04.2016 um 21:19 schrieb Henry Sikkema: > Would an uninstall remove this configuration file? ... if so, I have > uninstalled twice and reinstalled and the problem persists. > > *Henry* No. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: file format problem?

2016-04-07 Thread Andreas Säger
Am 07.04.2016 um 04:20 schrieb Thomas Blasejewicz: >> >> [these are MsFt not LO documents.] > After the trouble occured, I copied TEXT ONLY into Writer, finished work > there AND THEN saved first as .odt and then as .docx (same file) > > Necessity for Word format: translation agencies send me

[libreoffice-users] Re: Adding decimal minutes to regular minutes and hours (calc)

2016-04-07 Thread Andreas Säger
Am 06.04.2016 um 19:27 schrieb James Knott: > > While I haven't done this in a spreadsheet, I used to on a calculator. > I did it by converting between decimal degrees and degrees, minutes & > seconds. > > BTW, as an indication of how long ago I did this, I used this method to > add up the time

[libreoffice-users] Re: Adding decimal minutes to regular minutes and hours (calc)

2016-04-06 Thread Andreas Säger
Am 06.04.2016 um 15:36 schrieb John Meyer: > Hi, > > I have a project where I am trying to calculate the total amount of work > hours for a project based upon the timestamp of calls throughout the > day. The time at which the calls is placed is in hh:mm:ss while the > duration of the call is in

[libreoffice-users] Re: Calc as a Flat File Database

2016-03-22 Thread Andreas Säger
Calc menu:Data>Form... https://forum.openoffice.org/en/forum/viewtopic.php?f=21=77543 includes a macro to extract and reconnect all forms from a database document. Background: https://forum.openoffice.org/en/forum/viewtopic.php?f=83=40493 -- View this message in context:

[libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

2016-01-28 Thread Andreas Säger
Am 27.01.2016 um 21:23 schrieb Sergio Gutierrez: > Hi, to all who had been participating, for some time now, in this > nonsensical religious comments. When I accepted to receive e-mails from > this user group, I thought that it could be useful whilst using Libre > Office. I never expected to

[libreoffice-users] Re: LO-Base - Autoreconnect

2016-01-27 Thread Andreas Säger
Am 27.01.2016 um 13:16 schrieb Walther Koehler: > Hello list, > > me too would like to have a reconnect: > > When LO-Base the first connection to a dBase > database (directory) has made, all the existing *.dbf files in that directory > are recognized and shown as tables in *.odb. > > However,

[libreoffice-users] Re: difference between Excel and Calc

2016-01-26 Thread Andreas Säger
Am 26.01.2016 um 13:53 schrieb Ian McCarthy: > Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've > fallen over an incompatibility > as spread sheet will be used by both tools is there a switch I can use. > The problem > =CELL("filename",A1) in LO returns >

[libreoffice-users] Re: [calc] is there a GOAL_SEEK function somewhere?

2016-01-26 Thread Andreas Säger
Am 26.01.2016 um 11:47 schrieb Larry Evans: > I've checked that the value returned by the YIELD function: > > https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD > > can be gotten by using [Tools>Goal Seek...] and the PV function: > >

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-26 Thread Andreas Säger
Am 24.01.2016 um 09:04 schrieb Hank Alper: > Hi Ian, > I frequently import Calc Spreadsheets into my MySQL database using > phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to > import.Specifically, it offers a Browse option. Locate the Calc file you > wish to import.by

[libreoffice-users] Re: Auto Increment Doesn't Work

2016-01-25 Thread Andreas Säger
Am 25.01.2016 um 10:44 schrieb Marion & Noel Lodge: > Hi Tim, > > It may depend on which Database you are using with LibreOffice. > > I use the H2 Database and in my tables if I make CustomerID's type > BigInt[Identity], > then AutoValue = 'Yes works. That might be worth trying in your

[libreoffice-users] Re: Base: problem with where clause in a select query.

2016-01-25 Thread Andreas Säger
Am 25.01.2016 um 10:28 schrieb Egbert Eissing: > > > I must be doingsomething wrong: Here is the where clause of my select query > within amacro: > WHERE ""EmployeeID""='" + sEmployeeID + "' AND ""ItemValue""<> '0' AND > ""MidOrEndMonth"" = '0'") > Instead of returningthe table rows where

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-21 Thread Andreas Säger
Am 21.01.2016 um 13:20 schrieb Heinrich Stoellinger: > Of course these are valid values as for as CSV is concerned, but not ALL > are > valid as far as MySQL goes. I have no problem restoring MySQL-DATE COLUMN > values, but represent them as "2014-12-22", the same as character strings. > Forget

[libreoffice-users] Re: use calc rows as fooier

2016-01-21 Thread Andreas Säger
Am 20.01.2016 um 22:06 schrieb Keith Bainbridge: > Good morning All > > > > It's been a while. > > > > I am trying to use 4 rows on a calc sheet as a footer, in addition to a > header row. Can only see how to use rows as a header. > > > Any hints please? > > > Thanks > > > If I

[libreoffice-users] Re: question about the best version of libreoffice:

2016-01-21 Thread Andreas Säger
Am 21.01.2016 um 01:42 schrieb Tom Davies: > Hi :) > Many people on this mailing list have had signatures that include > Bible quotes or such-like without anyone grumbling or anything. I > thought it was nice to see something similar from a different religion > for a change. > > Regards from >

[libreoffice-users] Re: question about the best version of libreoffice:

2016-01-21 Thread Andreas Säger
Am 21.01.2016 um 06:54 schrieb James E. Lang: > Hi Andreas and Tom, > > It was good to see that someone actually responded to the question that was > asked about LO. I don't make much use of Writer so I have little but civility > to contribute. I have *reflowed* your messages as quoted below my

[libreoffice-users] Re:

2016-01-21 Thread Andreas Säger
Am 22.01.2016 um 01:17 schrieb Dave Stevens: > Quoting James Knott : > >> And it's all nonsense. The bible is provably fiction. > > is it possible to park this thread or take it off-list? > > Dave > The religious bullshit is disturbing indeed. But we have to cope with

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-20 Thread Andreas Säger
When using HSQL (which is less powerful than MySQL) command CREATE TEXT TABLE "Foo"(...) prepares a table "Foo" with fields and indices just like a regular data table. A second command SET TABLE "Foo"... links the text table "Foo" to a particular text file. If the linked text table and the

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-20 Thread Andreas Säger
How can anybody solve any csv related problem without knowing anything about the actual content? 4 different lines of perfectly valid and commonly used csv data: 1234.98;2014-12-22 1.234,98;22 Dez 2014 1234.98;12/22/14 1234.98;22/12/14 Each line carries the exact same information. I could add a

[libreoffice-users] Re: R1C1 reference style with LibreOffice

2016-01-20 Thread Andreas Säger
Am 20.01.2016 um 10:17 schrieb pacopyc pacopyc: > Ok, but the problem is that I must do it from LibreOffice basic code. > If you would spend more than an hour or two with this matter, you would not have to wait days for the answer. >

[libreoffice-users] Re: question about the best version of libreoffice:

2016-01-20 Thread Andreas Säger
Am 20.01.2016 um 13:36 schrieb Andreas Säger: > > I used 3.5 for many years with no problems. > > Oh, shit. Did I feed a troll? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscr

[libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-20 Thread Andreas Säger
Am 20.01.2016 um 11:05 schrieb Ian Whitfield: > Hi All > > I have been trying to import a CSV file from Calc into MySQL to run with > Base for over a week now and can not believe this is so difficult to do > so I'm hoping some other Base users might have cracked this one!! > > My OpSys is

[libreoffice-users] Re: Need help and don't know where to even start.

2016-01-19 Thread Andreas Säger
Am 19.01.2016 um 09:45 schrieb JL: > Good evening all, > > I've found myself in a position where I need to drop serious weight for > health reasons. I have a diet that works (more a complete change of > eating) but I need help in the planning of it. I'd suggest pencil & paper or one of these

[libreoffice-users] Re: Transferrig a parameter to a sub form

2016-01-15 Thread Andreas Säger
Am 15.01.2016 um 04:23 schrieb Egbert Eissing: > I have a form with atable control which lists all the employees, and a > sub-form with atable control that lists the payroll data of each employee. > If an employee isselected in the first table, the employeeID should be passed > to thesub form

[libreoffice-users] Re: maybe is missing formatting character encoding?

2016-01-13 Thread Andreas Säger
Am 13.01.2016 um 15:29 schrieb manuel_songo...@yahoo.it: > hello > my file TXT and CSV, there are bad character encoding (�,é,..)is there > formatting for encoding?maybe is missing this feature for libreoffice...? > Sceenshot >

[libreoffice-users] Re: Displaying data on an unbound field

2016-01-12 Thread Andreas Säger
Always the same answer: > https://forum.openoffice.org/en/forum/viewtopic.php?f=20=81276=375294#p375294 Using the GUI, I can set the default value for an unbound text box belonging to any form or subforme, and nothing changes this text. Then I can inspect this text box using MRI and find out the

[libreoffice-users] Re: BaseForms: transferring contents of data fields to the database table

2016-01-05 Thread Andreas Säger
Am 05.01.2016 um 04:24 schrieb Egbert Eissing: > I have a main form and a sub form. > The main form holds one single record, the sub form contains multiple records > related to the record in the main form. > Both forms are holding alphanumeric and also pure numeric data. > I wrote a macro to

[libreoffice-users] Re: How to close *.dbf files in a Base (makro)

2016-01-03 Thread Andreas Säger
Am 03.01.2016 um 12:17 schrieb Walther Koehler: > Hello list, high Andrew Pitonyak, > > After an SQL UPDATE in a makro, the updated *.dbf is still marked as open > (in LINUX see fuser *.dbf), until the last instance of LO is closed. This is > nasty, because I have usually many files open and

[libreoffice-users] Re: Base: create form wizard sub-form error

2015-12-23 Thread Andreas Säger
Am 23.12.2015 um 17:21 schrieb Blake McBride: > Greetings, > > I am using LibreOffice Base 4.4.3.2 on 64 bit Linux with a PostgreSQL DB. > > I have a hierarchy of tables such that: > > Table A > Table B (many B to one A relationship with Table A) > Table C (many C to one B relationship with

[libreoffice-users] Re: Base: connecting to a DB without requiring a password

2015-12-22 Thread Andreas Säger
Am 22.12.2015 um 20:26 schrieb Blake McBride: > I am trying to build a simple interface app for a user. With 35 years > experience in software development, I can tell you: > > 1. It is customary to password protect a database to prevent unauthorized > access. > > 2. It is customary for

[libreoffice-users] Re: Base: connecting to a DB without requiring a password

2015-12-21 Thread Andreas Säger
Am 21.12.2015 um 22:47 schrieb Blake McBride: > What I want is to keep the password on the database but not require user > entry of it. I have tried a bunch of stuff. I added UserName and Password > to the odbc,ini file. I also tried adding "Password=xyz" to Base's > database properties under

[libreoffice-users] Re: Calc formula syntax assistance

2015-12-19 Thread Andreas Säger
Am 19.12.2015 um 18:42 schrieb Hylton Conacher (ZR1HPC): > > Any ideas to get the correct answer of the number of times a field appears? > https://wiki.documentfoundation.org/images/4/47/CG41-CalcGuideLO.pdf (chapter 8 on pivot tables) -- To unsubscribe e-mail to:

[libreoffice-users] Re: Cannot assign template to existing writer odt file

2015-12-16 Thread Andreas Säger
Am 16.12.2015 um 19:05 schrieb V Stuart Foote: > > @Andreas, I don't agree with your assessment. The > XDocumentPropertiesSupplier is fully functional and suited to task. > XDocumentPropertiesSupplier replaced XDocumentInfo Sub Main obj = ThisComponent.getDocumentInfo() End Sub still

[libreoffice-users] Re: Cannot assign template to existing writer odt file

2015-12-16 Thread Andreas Säger
Am 16.12.2015 um 10:09 schrieb Ken Heard: > "Property or method not > found: Document Info" com.sun.star.document.XDocumentInfo was a deprecated interface in older versions. For OpenOffice it is still documented here: >

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

2015-12-16 Thread Andreas Säger
Am 16.12.2015 um 09:19 schrieb Ken Heard: > On 2015-12-12 20:57, Don Parris wrote: > > > The "address books:registering" entry in the LibreOffice Writer help > (F1) explains how to import various address books into Writer. I have > so far set it up to use my icedove address book in Writer, but

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

2015-12-15 Thread Andreas Säger
Am 15.12.2015 um 17:23 schrieb Don Parris: > On Mon, Dec 14, 2015 at 5:17 AM, Andreas Säger <ville...@t-online.de> wrote: > I though my question - posed some time ago now - was quite clear. But possibly untechnical. Did you ask how you can connect to the contacts and issue

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

2015-12-15 Thread Andreas Säger
Am 15.12.2015 um 17:23 schrieb Don Parris: > > It really is completely mind-boggling that two prominent projects would > somehow "miss" each other like this. > Only a tiny fraction of LO users is aware of database connectivity. Most users use Base through the mail merge wizard to connect a

[libreoffice-users] Re: Where to request a new App (Mind mapping)for Libreoffice?

2015-12-14 Thread Andreas Säger
Am 14.12.2015 um 09:37 schrieb minhsien0330: > Hi all: > I think it will be very good if we have a mind mapping application in > Libreoffice. > > This would be a very good new feature! > > We already have Writer, Calc, Impress, Draw, Math and Base, and how about > add a new application for mind

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

2015-12-14 Thread Andreas Säger
Am 12.12.2015 um 14:57 schrieb Don Parris: > I want to use KAddressBook as the resource for my LibreOffice mailmerge. > Unfortunately, the only way this seems possible is by exporting the > contacts from KAddressBook to a CSV file. > > I have searched high and low, and cannot find any good way to

[libreoffice-users] Re: LibreOffice Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function

2015-11-23 Thread Andreas Säger
Am 23.11.2015 um 18:10 schrieb Michele contabilmenteAG: > Thanks, I solved the problem by entering the 4th argument to 0. > > The solution, as I look for now is effective. > > cordial greetings > > Michele Ras > > 2015-11-23 18:00 GMT+01:00 Andreas Säger <

[libreoffice-users] Re: LibreOffice Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function

2015-11-23 Thread Andreas Säger
Am 23.11.2015 um 16:33 schrieb Michele contabilmenteAG: > Anomaly discovered in *versions 4.2.8 and 4.4.6* - > VLOOKUP function > menu:Tools>Options>Calc>Calculation Regular expression = OFF Match whole cell = ON You leave out the 4th argument which means it defaults to 1. You want 0.

[libreoffice-users] Re: CONGRATULATIONS!!1!

2015-11-19 Thread Andreas Säger
For "compatibility" with something that does not want to be "compatible" at all, you may consider SoftMaker office for Linux. The current version is inexpensive. Its predecessor is free as in "free beer". Of course, it can not be API compatible to any other product. I agree that LO is on a

[libreoffice-users] Re: connecting bibliography to document problem

2015-11-04 Thread Andreas Säger
Am 04.11.2015 um 22:22 schrieb andrey.ry...@bilkent.edu.tr: > >> I'm clueless. >> Can you upload the Writer document somewhere? >> > What i should check in my document? ^) > > Remove any confidential content and attach it to a mail to ville...@t-online.de I'll try to connect it to my biblio

[libreoffice-users] Re: connecting bibliography to document problem

2015-11-04 Thread Andreas Säger
Am 04.11.2015 um 12:06 schrieb andrey.ry...@bilkent.edu.tr: >> Hit F4, Right-click your database in the data source window and choose >> "Edit >> database". >> Look at the status bar of the database window. What does it tell about the >> type of database and the location of the database? > > it

[libreoffice-users] Re: DRAGON in OOWrite problem

2015-11-03 Thread Andreas Säger
Am 03.11.2015 um 06:13 schrieb plexorite: > Greetings all, from Oz! > I have been very happily working with the very latest Windows 10 version of > Dragon Professional Individual Version 14 . . . 180 for a couple of weeks > in OpenOffice version 5. 022. You installed LibreOffice 5 (the green

[libreoffice-users] Re: connecting bibliography to document problem

2015-11-03 Thread Andreas Säger
Hit F4, Right-click your database in the data source window and choose "Edit database". Look at the status bar of the database window. What does it tell about the type of database and the location of the database? -- View this message in context:

[libreoffice-users] Re: Inconveniences of time format

2015-10-31 Thread Andreas Säger
Am 31.10.2015 um 08:40 schrieb Gary Collins: > Hi > > > I've got a column in calc 4.3.2.2 to contain the length of video clips; it's > formatted to Time>876613:37:46. > > > The first inconvenience is that, when using autoincrement the times are > incremented not by 1 second but by 24

[libreoffice-users] Re: Compatibility

2015-10-31 Thread Andreas Säger
V Stuart Foote wrote > > +1 -- I don't understand why this is such a hard concept for folks to > grasp ;-) I found that a whole lot of people suffer from the misconception that their document files contain computer instructions. When I select a portion of text, click the bold button and save the

[libreoffice-users] Announcing OpenOffice 4.1.2

2015-10-29 Thread Andreas Säger
> https://blogs.apache.org/OOo/entry/announcing_apache_openoffice_4_11 > http://www.openoffice.org/download/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

[libreoffice-users] Re: Announcing OpenOffice 4.1.2

2015-10-29 Thread Andreas Säger
Am 29.10.2015 um 17:00 schrieb Bastián Díaz: > > El 29-10-2015 11:10, Andreas Säger escribió: > >>> https://blogs.apache.org/OOo/entry/announcing_apache_openoffice_4_11 >>> [1] http://www.openoffice.org/download/ [2] > > What? This is a mailing li

[libreoffice-users] Re: Announcing OpenOffice 4.1.2

2015-10-29 Thread Andreas Säger
Am 29.10.2015 um 17:50 schrieb Florian Reisinger: > Hi, > > On the contrary it is interesting to see if and when yes how often Open > Office will release. I thought of it as being dead as there has not been a > release in a relative long period of time. > > So thanks for informing ;) > > PS:

[libreoffice-users] Re: Announcing OpenOffice 4.1.2

2015-10-29 Thread Andreas Säger
Am 29.10.2015 um 18:05 schrieb Joel Madero: > I tend to agree that this is a LibreOffice mailing list - it's one thing to > say a new release is out for OOo but to link to their download page...I > don't see this as being the proper venue for that. > > Best, > Joel > Virtually none of your

[libreoffice-users] Re: Can't get LibreOffice 5.2.0 to Startup

2015-10-29 Thread Andreas Säger
Am 29.10.2015 um 10:06 schrieb James R McKenzie: > When I try to launch LibreOffice a dialog button pops up and say "LibreOffice > 5.0 - Fatal Error The application cannot be started. User installation could > not be completed." I'm presented with an OK button on the Dialog Box. How can > I fix

[libreoffice-users] Re: Sorting Calc Sheet in Alphabet orde on names in one Column

2015-10-25 Thread Andreas Säger
Am 25.10.2015 um 21:48 schrieb ajebay: > I have a calc spreadsheet with many lines of data which include one > column with names for the line. > I want to sort the names from A to Z, top to bottom, and have all the > corresponding data in each line move with the corresponding name. Hope > this is

[libreoffice-users] Re: Outline Numbering Ignorance.

2015-10-20 Thread Andreas Säger
Am 20.10.2015 um 20:42 schrieb Steve Edmonds: > How does Tools > Outline Numbering do more than assign a paragraph style > to an outline level, do the settings in Tools > Outline Numbering over > ride the styles or vis versa. > > Any help to clear the fog much appreciated. > Steve > [Tutorial]

[libreoffice-users] Re: Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-19 Thread Andreas Säger
Am 16.10.2015 um 18:25 schrieb anne-ology: >very interesting indeed ;-( > > > > From: Andreas Säger <ville...@t-online.de> > Date: Thu, Oct 15, 2015 at 5:47 PM > Subject: [libreoffice-users] Re: Tooo many messages on this mailing list?? > How to avoid

[libreoffice-users] Re: Too many messages on this mailing list?? How to avoid being swamped ...

2015-10-19 Thread Andreas Säger
Am 19.10.2015 um 13:13 schrieb James Knott: > On 10/18/2015 11:15 PM, jorge wrote: >> As I remember there is an option for example in Evolution mail program >> to let or not the original mail in the server. Is an option of the user. >> This option we check when start a new account. > > Other

[libreoffice-users] Re: Outlining

2015-10-19 Thread Andreas Säger
Am 19.10.2015 um 19:06 schrieb James Wilde: > Using v.5.0.0.5 on OSX 10.9 > > I think this functionality, which everyone says is to be found, is not > too well documented. > > James > Hands-on tutorial by example document about templates, styles, outlines, indices etc. >

[libreoffice-users] Re: Spam? Re: Microsoft outlook support number 1-844-815-2122

2015-10-19 Thread Andreas Säger
Am 19.10.2015 um 18:17 schrieb James E. Lang: > > Of course it is spam. The bots notice that we discuss predominantly about mail. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

[libreoffice-users] Re: Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-18 Thread Andreas Säger
The messenger is the culprit. -- View this message in context: http://nabble.documentfoundation.org/Tooo-many-messages-on-this-mailing-list-How-to-avoid-being-swamped-tp4163215p4163658.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: How to.. sort a table in 3 columns

2015-10-18 Thread Andreas Säger
Am 18.10.2015 um 12:36 schrieb william drescher: >> Operating system? > > Windows 7 >> Office version? >> Office component? Writer? Calc? Base? > I'll use whatever I need >> File format? doc, docx, odt, ods, xls, odb? > odt or ods >> I don't understand how you want to dump 2 fields into 3

[libreoffice-users] Re: Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-18 Thread Andreas Säger
On 10/17/2015 10:39 AM, Andreas Säger wrote: >> > Mailing lists and aggregators are tools of the 90ies. Almost forgotten > in the twitter age. Not everyone like to use Twitter or Facebook. Nor do I. But this mailing list is a very good example why mailing lists can not be used

[libreoffice-users] Re: Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-17 Thread Andreas Säger
Am 16.10.2015 um 18:45 schrieb anne-ology: >curiously wondering what gmane is ... > curiously wondering what else I'll be a-learnin' today ... > curiously wondering what the newest computer gadget'll be ... > curiously wondering ... curiously

[libreoffice-users] Re: How to.. sort a table in 3 columns

2015-10-17 Thread Andreas Säger
Am 16.10.2015 um 22:02 schrieb william drescher: > I have a list that has two fields: aisle and item. I need to maintain > the list sorted by item, but print a pick list by aisle. This would be > simple except, when I print the list for marking I need to print it in > item order, in 3 columns.

[libreoffice-users] Re: Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-16 Thread Andreas Säger
Am 16.10.2015 um 00:47 schrieb Andreas Säger: > Am 15.10.2015 um 23:38 schrieb libreoffice-ml.mbou...@spamgourmet.com: >> >> Most emails appear correctly threaded to me, using SeaMonkey (based on >> Thunderbird). Some messages break threading, because those sending them >&

[libreoffice-users] Re: Digital signatures

2015-10-15 Thread Andreas Säger
Am 15.10.2015 um 12:07 schrieb Евгений: > Hello. > > "Writer 4.2 Guide" from second link. > > = I prefer the AOO documentation > https://wiki.openoffice.org/wiki/How_to_use_digital_Signatures -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-15 Thread Andreas Säger
Am 15.10.2015 um 23:38 schrieb libreoffice-ml.mbou...@spamgourmet.com: > > Most emails appear correctly threaded to me, using SeaMonkey (based on > Thunderbird). Some messages break threading, because those sending them > use a mail client which doesn't include the relevant headers. > > Mark. >

[libreoffice-users] Re: Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-14 Thread Andreas Säger
Hiding away your mails helps a lot. -- To unsubscribe e-mail to: users+unsubscr...@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: Installing Libreoffice in Ubuntu

2015-10-14 Thread Andreas Säger
Am 09.10.2015 um 04:47 schrieb John R. Sowden: > I have been dealing with this issue for years, going back to the Open > Office days. > > How do you install Libreoffice under Ubuntu? > After all those years, you never googled, you never asked anybody, you never tried anything with or without

  1   2   3   4   5   6   7   8   9   10   >