[libreoffice-users] Re: Request for resoure suggestions.

2015-03-27 Thread Andreas Säger
Best resource I'm aware of if your requiements are similar to those of a student: https://wiki.openoffice.org/wiki/Documentation/Writer_for_Students -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-27 Thread Andreas Säger
Am 25.03.2015 um 23:42 schrieb Richard VINCK: This is undoubtedly a serious bug... and nobody has detected this before? How strange. Hi, With older versions of LO and with OpenOffice you can define named ranges which remember their sort orders, filter arguments and options, so called

[libreoffice-users] Re: converting txt to dates

2015-03-24 Thread Andreas Säger
Am 25.03.2015 um 01:28 schrieb Kaj: Am 2015-03-24 18:22, Andreas Säger schrieb: Am 24.03.2015 um 14:22 schrieb Kaj: Hi ! Now you happened to use the wrong conversion function, VALUE instead of DATEVALUE, so of course it did not work. But even with the correct function there seems to be some

[libreoffice-users] Re: converting txt to dates

2015-03-24 Thread Andreas Säger
Am 24.03.2015 um 14:22 schrieb Kaj: Hi ! Now you happened to use the wrong conversion function, VALUE instead of DATEVALUE, so of course it did not work. But even with the correct function there seems to be some issues. According to the help text for the date acceptance pattern: besides

[libreoffice-users] Re: converting txt to dates

2015-03-24 Thread Andreas Säger
Am 20.03.2015 um 02:28 schrieb James: Column A has text strings that are DD/MM/ format. I want to make them real dates. I tried these 2 datevalue formulas but I can't make it work. 14/03/2015Err:502 14/03/2015Err:502 =DATEVALUE(TEXT(A1,##/##/)) =DATEVALUE(A2) Short

[libreoffice-users] Re: converting txt to dates

2015-03-24 Thread Andreas Säger
Am 24.03.2015 um 20:09 schrieb V Stuart Foote: Andreas Säger wrote All this conversion from strings to numbers is unrelated to the date acceptance patterns that determines how Calc turns your keyboard input into day numbers. No, it is not just for keyboard entry! And, it is certainly

[libreoffice-users] Re: database2spreadsheet

2015-03-23 Thread Andreas Säger
Am 23.03.2015 um 17:01 schrieb hw: Am 16.03.2015 um 18:07 schrieb Andreas Säger: Am 16.03.2015 um 15:57 schrieb hw: Creating LO documents directly would be nice and might have the advantage to be able to specify some formatting --- which I might need to do sooner or later. Formatting

[libreoffice-users] Re: New 'tab' system in Calc

2015-03-23 Thread Andreas Säger
Am 23.03.2015 um 17:17 schrieb Pat Brown: Just tried the new system and love it. I find it so much easier than fiddling around with increasing/decreasing sliders. I would like to make a feature request regarding the tabs. I would like to be able to scroll the tabs using the mouse wheel. Where

[libreoffice-users] Re: converting txt to dates

2015-03-23 Thread Andreas Säger
Am 20.03.2015 um 12:21 schrieb Kaj: No, this won't work. You've got to change the global locale option in order to change the evaluation context for existing data. Other method: =DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)) Do you have the used date pattern defined? Look at (menu) - Tools -

[libreoffice-users] Re: converting txt to dates

2015-03-20 Thread Andreas Säger
Am 20.03.2015 um 05:56 schrieb Emil Payne: On 19/03/15 08:28 PM, James wrote: Column A has text strings that are DD/MM/ format. I want to make them real dates. I tried these 2 datevalue formulas but I can't make it work. 14/03/2015Err:502 14/03/2015Err:502

[libreoffice-users] Re: Using SQL functions in LibreOffice base (notation)

2015-03-20 Thread Andreas Säger
Am 20.03.2015 um 13:08 schrieb xavier2: Hi there, yes that is right, but what is completely weird is that LibreOffice Base, using a modified SQL don't have a reference book showing all these modifications and notations? then where can we find reference for that modification of the SQL

[libreoffice-users] Re: converting txt to dates

2015-03-20 Thread Andreas Säger
Am 20.03.2015 um 12:21 schrieb Kaj: Do you have the used date pattern defined? Look at (menu) - Tools - Language Settings - Languages at Date acceptance patterns. No. Do you? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: database2spreadsheet

2015-03-19 Thread Andreas Säger
Am 19.03.2015 um 11:37 schrieb hw: For a LibreOffice user there is only one built-in tool to do reporting with pictures. It is the report tool. Hm, I'm not too happy with that because the defaults aren't too useful, and when I wanted to make a report to display data from a table, the

[libreoffice-users] Re: database2spreadsheet

2015-03-19 Thread Andreas Säger
Am 19.03.2015 um 11:49 schrieb hw: Copying icons? Indeed. In order to copy table or view contents from one DB to another DB you copy the table _icon_ from one database window, select the table icon in the other database window (the DB where you have write access) and paste. A dialog pops up

[libreoffice-users] Re: I need help with functions in Base

2015-03-18 Thread Andreas Säger
Am 18.03.2015 um 16:00 schrieb xavier2: Hello I'm starting with queries and functions. Right now I know how to tackle queries, but I don't know very well how may I use functions on queries. I would like to master all functions, so I need examples with functions. The problem is I don't know

[libreoffice-users] Re: I need help with functions in Base

2015-03-18 Thread Andreas Säger
Am 18.03.2015 um 23:10 schrieb xavier2: Hi Andreas, thanks for the amazing info you gave me. Well, I was not meaning to SQL, because what I want to do right now are queries using the gird, the queries window. The grid (do you mean the design view?) creates an SQL statement as you can see when

[libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread Andreas Säger
Am 17.03.2015 um 13:14 schrieb hw: Am 16.03.2015 um 18:04 schrieb Andreas Säger: Am 16.03.2015 um 16:18 schrieb hw: Exactly: What the perl script does is way beyond the capabilities of a query and of formulas in a spread sheet. In which way? You are rather unspecific about your

[libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread Andreas Säger
Am 17.03.2015 um 16:37 schrieb hw: Am 16.03.2015 um 15:57 schrieb hw: Some experimentation is required at this point ... Thank you for all the replies so far! Ok so I made a new spreadsheet and dragged a query from the datasources view into it. Apparently that fills rows in the

[libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread Andreas Säger
Am 17.03.2015 um 13:36 schrieb hw: Sorry, this is the wrong answer to the right post --- still a question, though. The answer to this post should have been that I would need the images to appear in the spread sheet. Pictures in Calc are no spreadsheet data. Pictures are decorative,

[libreoffice-users] Re: database2spreadsheet

2015-03-17 Thread Andreas Säger
Am 17.03.2015 um 13:22 schrieb hw: Am 16.03.2015 um 18:00 schrieb Andreas Säger: Am 16.03.2015 um 16:21 schrieb hw: Without any coding it is be possible to create a field of hyperlinks. Just add a HYPERLINK formula next to the import range. The adjacent field expands to the size

[libreoffice-users] Re: database2spreadsheet

2015-03-16 Thread Andreas Säger
Am 16.03.2015 um 16:21 schrieb hw: Without any coding it is be possible to create a field of hyperlinks. Just add a HYPERLINK formula next to the import range. The adjacent field expands to the size of the import range. You mean to the size of the image? It doesn't scale the images to

[libreoffice-users] Re: database2spreadsheet

2015-03-16 Thread Andreas Säger
Am 16.03.2015 um 16:18 schrieb hw: Exactly: What the perl script does is way beyond the capabilities of a query and of formulas in a spread sheet. In which way? You are rather unspecific about your requirements. Even letting aside that using the BASIC dialect of LO is very awkward (just

[libreoffice-users] Re: database2spreadsheet

2015-03-16 Thread Andreas Säger
Am 16.03.2015 um 15:57 schrieb hw: Creating LO documents directly would be nice and might have the advantage to be able to specify some formatting --- which I might need to do sooner or later. Formatting is a matter of style, cell styles in this case. Linked import ranges filled with

[libreoffice-users] Re: Business Cards - Printing - Libre Writer version 4.3.5.2

2015-03-15 Thread Andreas Säger
Am 15.03.2015 um 01:18 schrieb charles meyer: Hi Folks, I’ve never printed business cards using Libre Writer and it didn’t go well using the Avery online template. I have blank sheets of cardstock (bought at Office Depot) to print my own business cards with logo - one sided only.

[libreoffice-users] Re: Libre Office 4.4.1.2 install error Files in Use

2015-03-14 Thread Andreas Säger
Am 12.03.2015 um 02:36 schrieb Sabine Gonelli: Hi, I have tried to install Libre Office 4.4.1.2 Win x 86 (English Version) several times now. When installing it tells me: Files in Use. Some files that need to be updated are currently in use. The following applications are using files that

[libreoffice-users] Re: Support options

2015-03-10 Thread Andreas Säger
Am 06.03.2015 um 13:59 schrieb Cor Nouws: Cor Nouws wrote on 22-01-15 21:39: Dave Barton wrote on 18-01-15 14:06: The solution is simple. Just log in to the forum and post the announcement. Ah yes. Will do that. IIRC there will be some major release shortly ;) I guess some of the moderators

[libreoffice-users] Re: Where is Base?

2015-03-06 Thread Andreas Säger
Am 05.03.2015 um 18:36 schrieb SOS: 1. I cannot use 2. LO Base is missing options LibreOffice Base is not a database development platform. It is hardly more than a bridge between databases and office documents. Yes, there is a limited set of form controls and yes, it comes with macro

[libreoffice-users] Re: database2spreadsheet

2015-03-06 Thread Andreas Säger
Am 06.03.2015 um 09:08 schrieb Alex Thurgood: Le 04/03/2015 10:59, hw a écrit : Hi, In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in

[libreoffice-users] Re: Where is Base?

2015-03-06 Thread Andreas Säger
Am 06.03.2015 um 16:06 schrieb Jaroslaw Staniek: On 5 March 2015 at 17:32, SOS s...@pmg.be wrote: Stefan , Macro's can live in any document so also in a Standalone form , better is to place your macro's in the LO application, who makes is fast more easy to Update and distribute for several

[libreoffice-users] Re: database2spreadsheet

2015-03-06 Thread Andreas Säger
Am 04.03.2015 um 10:59 schrieb hw: In a future step, I would like to integrate graphics into the spreadsheet which could be created by a perl script with gnuplot from data in the database; the images could reside in a directory and rows in the database would have a field referring to the file

[libreoffice-users] Re: Where is Base?

2015-03-05 Thread Andreas Säger
Tom, It is too obvious that you never use LibreOffice Base. -- 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

[libreoffice-users] Re: Where is Base?

2015-03-05 Thread Andreas Säger
Am 05.03.2015 um 19:38 schrieb Andreas Säger: Am 05.03.2015 um 16:46 schrieb Stefan Geith: Am 05.03.2015 um 16:21 schrieb Peter Goggin: Macros are available from within LibreBase forms. I use them for switching between forms etc, Are Macros also available, if the form is saved

[libreoffice-users] Re: Where is Base?

2015-03-05 Thread Andreas Säger
Regarding the interface to the big irons: Base can not handle arrays field types. Base can not handle binary field types. It crashes (possibly losing the embedded database) when you load a form with many records having pictures (normal size as in typical photos). Form grids become unusable when

[libreoffice-users] Re: Where is Base?

2015-03-05 Thread Andreas Säger
Am 05.03.2015 um 16:46 schrieb Stefan Geith: Am 05.03.2015 um 16:21 schrieb Peter Goggin: Macros are available from within LibreBase forms. I use them for switching between forms etc, Are Macros also available, if the form is saved as a *standalone form* ? I've heard, that not...

[libreoffice-users] Re: database2spreadsheet

2015-03-04 Thread Andreas Säger
Am 04.03.2015 um 10:59 schrieb hw: Hi, how would I create a spreadsheet from a table in a database? [Tutorial] Using registered datasources in Calc https://forum.openoffice.org/en/forum/viewtopic.php?f=75t=18511 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] Re: Where is Base?

2015-03-04 Thread Andreas Säger
Am 04.03.2015 um 11:03 schrieb Tom Davies: Hi :) I think Noel ( Marion)'s good experience of H2 being sooo much better than Base is purely down to them moving away from the internal back-end in Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas identified as being the

[libreoffice-users] Re: Where is Base?

2015-03-03 Thread Andreas Säger
Am 03.03.2015 um 16:06 schrieb Peter Goggin: Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS

[libreoffice-users] Re: Where is Base?

2015-03-02 Thread Andreas Säger
Am 02.03.2015 um 21:23 schrieb Tom Davies: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. This is

[libreoffice-users] Re: Where is Base?

2015-03-02 Thread Andreas Säger
Am 02.03.2015 um 19:33 schrieb Florian Reisinger: Just a short note: Base can connect to a MySql database using a connector. I even think, knowing not much about Base, that an external database for storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin

[libreoffice-users] Re: Where is Base?

2015-03-01 Thread Andreas Säger
Am 01.03.2015 um 22:31 schrieb Jay Lozier: I have not kept up with Base, I tend to use MariaDB/PostgreSQL directly; not through the Base front end. I vaguely remember some chatter about replacing HSQL with something else. Replacing an excellent database engine with another excellent

[libreoffice-users] Re: Where is Base?

2015-03-01 Thread Andreas Säger
Am 01.03.2015 um 22:01 schrieb Jay Lozier: What is the current backend for Base? I remember at one time is HSQL 1.8 but one could install a later version. Jay When you create a new database document without Java support, then you get a directory of flat dBase files handled by

[libreoffice-users] Re: Where is Base?

2015-03-01 Thread Andreas Säger
Sigh! Each and every aspect of OpenOffice, LibreOffice, Java and Base in particular: https://forum.openoffice.org/en/forum/viewtopic.php?f=74t=69896 Linux distros do not install Base because most people do not understand this drunken cousin of a component anyway. Linux users can install the

[libreoffice-users] Re: making self-defined functions available for all spreadsheets

2015-02-25 Thread Andreas Säger
Am 25.02.2015 um 12:38 schrieb hw: How do you build an installation package? The code needs to live in your own name space (not library Standard). ToolsMacrosOrganizeBasic... [Organizer...] Tab [Libraries] [Export] Non-Standard libraries can be imported from documents and templates. For

[libreoffice-users] Re: making self-defined functions available for all spreadsheets

2015-02-23 Thread Andreas Säger
Am 23.02.2015 um 13:20 schrieb Andreas Säger: Am 23.02.2015 um 13:02 schrieb hw: Would it be possible to have one file this Standard library is saved in for multiple users, or would that give problems with several users accessing the same file? Perhaps I could put it on a network share

[libreoffice-users] Re: making self-defined functions available for all spreadsheets

2015-02-23 Thread Andreas Säger
Am 23.02.2015 um 13:02 schrieb hw: Would it be possible to have one file this Standard library is saved in for multiple users, or would that give problems with several users accessing the same file? Perhaps I could put it on a network share and allow only read-only access to it. Yes.

[libreoffice-users] Re: making self-defined functions available for all spreadsheets

2015-02-21 Thread Andreas Säger
Am 21.02.2015 um 19:17 schrieb hw: Hi, how can I make a self-written function (i. e. a macro) available for all spreadsheets so that I can use this function for any spreadsheet I create or load and modify? Ideally, this should work with multiple users in that I'd like to deploy the

[libreoffice-users] Re: Formatting a date

2015-02-20 Thread Andreas Säger
P.S. to the special case where you imported normal dates in US context ending up with a column of wrong dates and text. Assuming that you don't have the original data at hand so you can not repeat the data import with appropriate import options, this is how to correct wrong values: 1) Switch the

[libreoffice-users] Re: Formatting a date

2015-02-20 Thread Andreas Säger
1. Do not type dates into cells that are formatted as text and do not type dates with a leading apostrophe 2. Do not import dates as text values from csv or html files. 3. When you paste content from another program, then do not hit Ctrl+V. Use the paste-special command, import raw text data and

[libreoffice-users] Re: Conditional Whitespace for Mail Merge

2015-02-12 Thread Andreas Säger
So it's a Calc sheet actually. I would simply use Calc to concatenate the proper field contents and then use that calculated field for the mail merge. Something like =TRIM($A2 $B2 $C2) with a column title in the firs row copied down along the list. A database query would be easier to handle

[libreoffice-users] Re: Conditional Whitespace for Mail Merge

2015-02-12 Thread Andreas Säger
That wizard is counter productive and irritating for several reasons. You can create serial letters easier without it. Once you have a registered database connection to your list (F4 shows your database and tables), all you need to do is this: Select your table or query in the left pane and then

[libreoffice-users] Re: Conditional Whitespace for Mail Merge

2015-02-11 Thread Andreas Säger
Composing the lines of an addressing area is easy to do with a query. Details depend on the type of your database. In Writer you can use a conditional field with a nested data source field like this: If condition: DataSource.QueryName.Title != Then: -- View this message in context:

[libreoffice-users] Re: LinuxQuestions.org's Office Suite of the Year: LibreOffice!

2015-02-09 Thread Andreas Säger
Virgil Arrington-2 wrote That said, it might be interesting to see how the poll might fare if there were an option of MS Office running under Wine. Does anybody actually do that? Four free Microsoft downloads to view file formats rtf, doc(x), xls(x), ppt(x) flawlessly under Wine:

[libreoffice-users] Re: And while I'm here, data extraction

2015-02-05 Thread Andreas Säger
Download this artbitrary database document with an embedded HSQLDB: https://forum.openoffice.org/en/forum/download/file.php?id=22304 Run this: SELECT * INTO TEXT exportTable1 FROM Table1 which creates exportTable1.csv in the same directory where the document lives. -- View this message in

[libreoffice-users] Re: And while I'm here, data extraction

2015-02-04 Thread Andreas Säger
Mark Stanton wrote Hmm Wild! I don't see a text export though, other than saving the Writer file as a text file. Well, yes. Saving in any other file format than ODF is an export indeed. So we can use Calc, Writer and the underlying database engine to export database data as plain text.

[libreoffice-users] Re: And while I'm here, data extraction

2015-02-03 Thread Andreas Säger
You must not copy any opened table or query. You copy and paste the _icon_ of a query or table. You can also link record sets to spreadsheet ranges and pivot tables which gives quite a powerful report engine. [Tutorial] Using registered datasources in Calc

[libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

2015-01-19 Thread Andreas Säger
Am 18.01.2015 um 18:43 schrieb Rich Shepard: Than, when I clicked the 'Finish' button I get a LO save dialog with the default name of 'New Database' (with a space that needs to be removed, no less!). If I give it a name, does the new *.odb contain the schema and data of the existing

[libreoffice-users] Re: Support options

2015-01-18 Thread Andreas Säger
Am 18.01.2015 um 00:07 schrieb Charles-H. Schulz: I am curious why you are pushing the OpenOffice forum rather than the LibreOffice Forum (access via Nabble or the other forum, http:// www.libreofficeforum.org ; or Ask.libreoffice.org ). Obviously you are a volunteer there but please

[libreoffice-users] Re: Support options

2015-01-18 Thread Andreas Säger
So much for topic support options. -- 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: Support options

2015-01-17 Thread Andreas Säger
Am 16.01.2015 um 14:48 schrieb Andreas Säger: As far as content matters, https://forum.openoffice.org/en/forum/index.php is the major resource of user knowledge for both OpenOffice and LibreOffice users. This mailing list is somewhat disappointing. More specificly: A considerable

[libreoffice-users] Re: Support options

2015-01-16 Thread Andreas Säger
Am 15.01.2015 um 19:07 schrieb dave boland: The problem with gmane.org is that I can't seem to append to a thread. I can follow the thread, so it is somewhat helpful. In this aera of spam and fraud you need to subscribe to a mailing list in order to send messages. There is a switch (nomail

[libreoffice-users] Re: function value not being counted

2015-01-14 Thread Andreas Säger
Am 14.01.2015 um 19:23 schrieb Wade Smart: Ive stumbled into one of those totally frustrating things that you cant see the reason for: C65=countif(C3:C61, Lt Blue) E65=countif(E3:E61, Lt Blue) G65=sum(c65+e65) = 2 And what is wrong? (apart from the obsolete sum of an addition which makes

[libreoffice-users] Re: Support options

2015-01-14 Thread Andreas Säger
Am 14.01.2015 um 22:49 schrieb dave boland: Can't we find a way to offer support that is easy and convenient? I get that new groups are considered old fashioned, but they work very well, news://news.gmane.org:119/gmane.comp.documentfoundation.libreoffice.user -- To unsubscribe

[libreoffice-users] Re: Problem with opening document dialogue

2015-01-13 Thread Andreas Säger
Am 13.01.2015 um 22:09 schrieb Andreas Säger: Am 13.01.2015 um 11:45 schrieb Tom Davies: Hi :) That link didn't work on the lock-down system i am currently working on. They block tons of sites here so i suspect it's that. On the other hand the Open Office forums had a few problems back when

[libreoffice-users] Re: Problem with opening document dialogue

2015-01-13 Thread Andreas Säger
Am 13.01.2015 um 08:47 schrieb Angus Wood: On opening Libre Office via the dock icon, a dialogue box comes up telling me that the program previously unexpectedly quit while opening a document. The action button “reopen” is pre-selected (by blue shading) Both buttons do nothing and the

[libreoffice-users] Re: Scaling x-axis on chart

2015-01-13 Thread Andreas Säger
Am 13.01.2015 um 13:00 schrieb Budgie: Hi Tom, Thanks for the reply. No joy so far. The problem is expanding the x axis which is using dates. It is set up for date format but I cannot find how to expand the scale. I have a screen shot which illustrates my problem. I shall try and attach

[libreoffice-users] Re: Problem with opening document dialogue

2015-01-13 Thread Andreas Säger
Am 13.01.2015 um 11:45 schrieb Tom Davies: Hi :) That link didn't work on the lock-down system i am currently working on. They block tons of sites here so i suspect it's that. On the other hand the Open Office forums had a few problems back when Oracle owned their sites. The link works.

[libreoffice-users] Re: Conditional DB-Fields

2015-01-10 Thread Andreas Säger
Am 10.01.2015 um 16:32 schrieb Heinrich Stöllinger: Hello, I want the following to work in writer (LO 4.3.5.2, Linux-Mint 17): if db.table.field != - print db.table.field else print nothing. In other words - if a field in a DB-tuple isn't empty I want LO to print that field, otherwise don't

[libreoffice-users] Re: Batch Convert from .wps to .doc or docx

2015-01-06 Thread Andreas Säger
Am 06.01.2015 um 08:46 schrieb bishoplowe: I have been seeking a way to batch convert WordPerfect files to the .doc format. I was reading that this could previously be done on some versions of Libreoffice. There was something about a command line where this could be done. I have been unable to

[libreoffice-users] Re: BASIC StrComp and tricky Unicode (Turkish, for example)

2015-01-01 Thread Andreas Säger
Am 01.01.2015 um 23:03 schrieb Andrew Douglas Pitonyak: The code contains the Turkish dotless i, but it fails (as it should) on my computer. I am hesitant (perhaps lazy) to mess with my computer's locale since I don't have a good handle on the implications of changing it or whether or not I

[libreoffice-users] Re: Dot separated date in YYYY.MM.DD format

2015-01-01 Thread Andreas Säger
You are free to enter any text value you want. As far as the arithmetic calculators named Calc, Excel, Gnumeric etc. are concermed, the number format is completely unimportant as long as the actual _value_ of a cell is correct. All the following formatted numbers represent the exact same value:

[libreoffice-users] Re: Google Sheets QUERY and Calc equivalent

2015-01-01 Thread Andreas Säger
Am 31.12.2014 um 14:36 schrieb Marc Paré: Is there an equivalent Calc function for the Google Sheets function QUERY? When I downloaded my spreadsheet from Google Sheets as a Calc file, the QUERY function was not translated into an equivalent Calc function. My original Google Sheets function

[libreoffice-users] Re: PDFs

2014-12-30 Thread Andreas Säger
Am 30.12.2014 um 03:16 schrieb anne-ology: Thank you for this information - I did not realize that PDFs were not merely a strange sort of word document ;-) (I have not liked PDFs; have not understand the continual use of them - although some seem to

[libreoffice-users] Re: Macro to open form + pass on value from current form

2014-12-19 Thread Andreas Säger
Am 19.12.2014 um 04:21 schrieb Andrew Douglas Pitonyak: And, when you can solve a problem without a macro, that is generally the better path :-) And for most of the rest we have: http://extensions.libreoffice.org/extension-center/access2base -- To unsubscribe e-mail to:

[libreoffice-users] Re: image anchoring

2014-12-19 Thread Andreas Säger
Am 17.12.2014 um 00:16 schrieb Hedley Finger: All: ​ Why not stay with the advantages of LibreOffice instead of trying to make it as hideous as MS Office!!? ​Can MS Office be more hideous than this? I decided to make a small database of bicycle spare parts in Calc, in which I would

[libreoffice-users] Re: Dot separated date in YYYY.MM.DD format

2014-12-19 Thread Andreas Säger
Am 19.12.2014 um 16:57 schrieb T. R. Valentine: I suspect you would have more success using the ISO format of -MM-DD instead of a non-standard format. Why? Load a Calc document and apply English .MM.DD or German .MM.TT, Spanish .MM.DD or anything like that. Checking this out

[libreoffice-users] Re: Select Concat in Form Dropdown?

2014-12-17 Thread Andreas Säger
Am 16.12.2014 um 21:43 schrieb Joel Madero: Hi All, I have a form based on a table with FirstName and LastName, I want the form to have a dropdown with SELECT CONCAT(FirstName,,,LastName) Is there a way to do this? Thanks! Best, Joel If you want to pick one distinct

[libreoffice-users] Re: [calc] how to insert a relative path in a cell to open file ?

2014-12-17 Thread Andreas Säger
Am 17.12.2014 um 18:37 schrieb Rafnews: Hi, I'm working on a central document in CALC that should be later convert to PDF. in a column i would like to have relative path in such manner that if a user click on the link it open the file at this path. However i discover that everything is not

[libreoffice-users] Re: Macro to open form + pass on value from current form

2014-12-17 Thread Andreas Säger
Am 17.12.2014 um 03:05 schrieb Joel Madero: Hi All, I have a form that has bookID as a unique key. I want to have a button that is to open a second form and do the following: (1) search for the bookID in another table (Series); (2) If bookID does not exist in Series, create a new record

[libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Andreas Säger
Am 10.12.2014 um 03:04 schrieb Joel Madero: pasteSheet.getCellByPosition(1,pasteRow).String = pasteValue Well, you set the string of a cell. Set the formula instead. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Andreas Säger
Am 10.12.2014 um 18:23 schrieb Joel Madero: I literally have no clue where those are coming from. They should be: This is because you hack upon something you do not understand. 1) First of all you need to understand (almost) each and every aspect of the spreadsheet component. Otherwise there is

[libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Andreas Säger
Am 10.12.2014 um 21:43 schrieb Joel Madero: give up the macro and stick with the limited abilities of kmymoney to do graphs and what not. Amen! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Andreas Säger
Am 10.12.2014 um 21:43 schrieb Joel Madero: I'll try to figure out what you mean by what you said - worst case I'll just give up the macro and stick with the limited abilities of kmymoney to do graphs and what not. At least we know know waht you are talking about.

[libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Andreas Säger
Am 10.12.2014 um 23:08 schrieb Joel Madero: I extracted the kmymoney file and the info in it seems to be incredibly conveluted, I'd be surprised if I could just bring it into base without additional problems. Perhaps I'm terribly wrong though. Terribly wrong, indeed. You do not bring

[libreoffice-users] Re: Base knows SQL functions?

2014-11-28 Thread Andreas Säger
Am 28.11.2014 um 10:03 schrieb Mark Stanton: It seems that Base has a list of keywords and functions for SQL, is that right? On the one hand it might be a good thing, on the other, unless the list is kept up to date then it's a real pain. For example, ADD_DATE (or DATEADD) in MariaDb,

[libreoffice-users] Re: Comments on pdf file size in 4.4 alpha; and a new bug?

2014-11-23 Thread Andreas Säger
Am 23.11.2014 um 18:14 schrieb Rob Jasper: Tom, I think this is really well explained. I've been professionally involved in defect reporting for years, and the problems seem to be the same in all organisations. Problems in defect reporting: 1- Qualification of type (A bug is

[libreoffice-users] Re: writer: master doc from template not accepting changes to template

2014-11-21 Thread Andreas Säger
Am 21.11.2014 um 08:34 schrieb Ricky Charlet: Howdy, I hope I have a work flow problem. I'll describe what I want, then describe what I did. And hopefully someone can show me 'the right way'. I'm writing a book. I have chosen the path of creating a chapter template + a master document + a

[libreoffice-users] Re: Problems with writer

2014-11-21 Thread Andreas Säger
Am 21.11.2014 um 15:12 schrieb Jay Ridgley: Folks, I looked on the net and the suggested fix for this message was reinstall libre-office, and libre-writer, so I did that. I still get the message what else did I miss? Install the whole meta package libreoffice with Writer, Calc, Math,

[libreoffice-users] Re: rtf files

2014-11-21 Thread Andreas Säger
As long as the most prominent member of this list has zero technical knowledge, this lengthy discussion about standards, file types and wishful thinking will not stop. Kindly worded excuses can not replace technical support. -- View this message in context:

[libreoffice-users] Re: macro to add annotation to selected text range

2014-11-20 Thread Andreas Säger
Am 19.11.2014 um 21:19 schrieb Matt Price: Thank you Andreas. Unfortunately I don't seem to be able to install either version of the MRI tool -- the unreleased 1.1.4 appears not to be a valid zipfile, whiel 1.1.2 throws this error: (com.sun.star.uno.RuntimeException) { { Message = class

[libreoffice-users] Re: macro to add annotation to selected text range

2014-11-20 Thread Andreas Säger
Am 20.11.2014 um 01:29 schrieb Jim Byrnes: On 11/19/2014 12:30 PM, Matt Price wrote: Yes, lack of more comprehensive documentation is a real pain. Hopefully someone with more knowledge than myself will comment on what I am about to write if I am wrong. With the exception of ThisComponent,

[libreoffice-users] Re: Libre office

2014-11-20 Thread Andreas Säger
Am 20.11.2014 um 21:20 schrieb fred.spurr...@talktalk.net: Can you please tell me which type of documents WRITER will read. e.g. Word, Works,? Open office,PDF etc. Thank you for your help Fred menu:FileOpen... see the list of file types The list of types in menu:FileSave As... shows the

[libreoffice-users] Re: rtf files

2014-11-19 Thread Andreas Säger
Am 19.11.2014 um 05:20 schrieb Urmas: Tom Davies: I still think that Rtf is well worth avoiding if at all possible but sadly a whole load of people fell for MS's marketing. Even to this day there are people who believe in using it, despite the findings of the court case. Which court

[libreoffice-users] Re: rtf files

2014-11-19 Thread Andreas Säger
Am 19.11.2014 um 13:33 schrieb Virgil Arrington: On Windows, I have found Atlantis to be very well behaved. It's default file format is RTF. It doesn't do tables, but everything else it does, it does well. .atlantiswordprocessor.com Virgil Thank you. It doesn't do tables. So

[libreoffice-users] Re: rtf files

2014-11-19 Thread Andreas Säger
Am 19.11.2014 um 14:05 schrieb Urmas: Andreas Säger: Which non-MS application can handle every flavour of RTF you throw at it? The degree of support RTF in application is not related to the 'complexity' of RTF spec. It has to do with the feature set of particular app. Once again, if your

[libreoffice-users] Re: rtf files

2014-11-19 Thread Andreas Säger
Am 19.11.2014 um 15:49 schrieb Tom Davies: Also Rtf is not plain text as it contains tons of spurious coding and formatting. Open rtf in a text editor. Just like HTML, it is plain text indeed. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: rtf files

2014-11-19 Thread Andreas Säger
Am 19.11.2014 um 17:33 schrieb Tom Davies: I'm really not getting plain text. When i right-click and open in a text-editor i get this sort of thing; Which is plain text in plain 7 bit ASCII. I can paste your rtf into any plain text editor, save as tom.rtf and open tom.rtf with any rtf capable

[libreoffice-users] Re: rtf files

2014-11-19 Thread Andreas Säger
Am 19.11.2014 um 19:23 schrieb Tom Davies: Hi :) Ahh, ok. If that counts as plain text of a 5 (ish) letter document then that explains a few misunderstandings i've had. Regards from Tom :) It is a plain text description of an electronic document. -- To unsubscribe e-mail to:

[libreoffice-users] Re: macro to add annotation to selected text range

2014-11-19 Thread Andreas Säger
Am 19.11.2014 um 18:59 schrieb Matt Price: Jim, That was it! Or, almost. I changed the line to: oText.insertTextContent(oVC, oAnno, True) And the annotation now gets attached to the whole range. I wish I knew how to find the documentation for these functions! I don't know what

[libreoffice-users] Re: Base Help Anyone

2014-11-18 Thread Andreas Säger
Hi, Store all picture files in the same directory as your Base file. Call menu:ToolsSQL and execute: ALTER TABLE PicTable DROP COLUMN Pics; ALTER TABLE PicTable ADD COLUMN Pics VARCHAR(100); SHUTDOWN COMPACT; where PicTable should be replaced with the actual name of your table and Pics with the

[libreoffice-users] Re: rtf files

2014-11-17 Thread Andreas Säger
Am 29.09.2014 um 02:04 schrieb Carole Edwards Caruso: I am using LibreOffice 4.3.0.4 with Windows 7. Hi, RTF is an awkward file format. http://diaryproducts.net/for/geek/microsoft_rtf_specification_nightmare Windows comes with a perfect RTF editor called WordPad. Greetings, Andreas --

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