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

[libreoffice-users] Re: [Base] Can we connect a macro to a report?

2014-11-15 Thread Andreas Säger
Am 14.11.2014 um 23:58 schrieb Jean-Francois Nifenecker: Le 14/11/2014 21:22, Andreas Säger a écrit : It is possible to use Calc as reporting engine. Hit F4 and drag your query onto a spreadsheet cell. When the database content changed, click any cell in that import range and call

[libreoffice-users] Re: [Base] Can we connect a macro to a report?

2014-11-14 Thread Andreas Säger
Am 14.11.2014 um 16:03 schrieb Jean-Francois Nifenecker: Hi, I've got a working report in Base (connected to a Query, the data source being a Calc sheet). This is an accounting report that groups data according to some code in a column. A subtotal amount is accumulated for each group. I'm

[libreoffice-users] Re: Tab defaults change when pasting into Writer from some other applications

2014-11-05 Thread Andreas Säger
Am 05.11.2014 um 01:23 schrieb Virgil Arrington: I fully agree with you. Just learning how styles control so much in Writer is very helpful. But, I have spent literally hours setting up and modifying styles. While it has been a labor of love for me, it has been a labor and a major investment

[libreoffice-users] Re: [Solved] Re: Setting Base to open with a slected form

2014-11-05 Thread Andreas Säger
Am 05.11.2014 um 02:51 schrieb Mark LaPierre: Hey Tom, It would be nice to post the solution here on the string that is labelled [Solved] so that people searching for the solution can find it. Maybe Peter should do that since he seems to have a better grip on the solution. The clean

[libreoffice-users] Re: Calc -- setting tab sequence of cells for spreadsheet user

2014-11-03 Thread Andreas Säger
Am 03.11.2014 um 14:54 schrieb Marc Paré: Is there a way to define the order the tab key (on the keyboard) would cycle through the cells. Is this possible in Calc? I would like to define which cells a user is sent to by using her/his tab key. Marc You can do all this and much more

[libreoffice-users] Re: Calc -- setting tab sequence of cells for spreadsheet user

2014-11-03 Thread Andreas Säger
Am 03.11.2014 um 17:48 schrieb Marc Paré: Should I put it up as a requested feature tiem on the bugzilla? Marc It won't be implemented because this is too far away from the intended purpose of an arithmetic calculator. And this feature is not part of the ODF standard, so it can't be

[libreoffice-users] Re: Calc -- setting tab sequence of cells for spreadsheet user

2014-11-03 Thread Andreas Säger
Am 03.11.2014 um 18:26 schrieb Marc Paré: Yes, I did look at Base, but, would rather like to stay with Calc as there are more people who would be able to trouble-shoot on spreadsheet software that on LibreOffice Base. Database design is development work. With a database no user would ever

[libreoffice-users] Re: Simple address data and 3 sheets

2014-11-03 Thread Andreas Säger
Hi, First of all, no professional IT person would do in a spreadsheet what you perfectly describe as a relational database. VLOOKUP is the key to mis-use a spreadsheet as a relational database. First you have to ensure that ToolsOptionsCalcCalculate: Enable Regular Expressions is OFF and Match

[libreoffice-users] Re: Recommended version of Java?

2014-11-02 Thread Andreas Säger
Am 01.11.2014 um 16:30 schrieb Tanstaafl: On 10/31/2014 4:12 PM, Andreas Säger ville...@t-online.de wrote: Am 31.10.2014 um 20:32 schrieb Tanstaafl: If Libreoffice requires Java to do certain things (yes, I understand that iits reliance on Java is less and less as time goes on, but it still

[libreoffice-users] Re: Estimating size of page with Calc

2014-11-02 Thread Andreas Säger
Am 02.11.2014 um 15:51 schrieb Marc Paré: Is there a way to have the sheets show as pages rather than just a series of unlimited rows and columns? Thanks for any help. Marc Did you try menu:FilePage Preview and menu:ViewPage Layout ? -- To unsubscribe e-mail to:

[libreoffice-users] Re: Compress images

2014-11-02 Thread Andreas Säger
Am 02.11.2014 um 17:43 schrieb Bill: I am in the same boat as the OP. I have searched for a quick, simple solution to this for several years, always smiling at the discussion boards dismissal of it as a needed add-on... Just now decided the current solution remains to find someone with a copy

[libreoffice-users] Re: Recommended version of Java?

2014-11-01 Thread Andreas Säger
Am 01.11.2014 um 10:07 schrieb Alex Thurgood: Le 31/10/2014 21:12, Andreas Säger a écrit : Huh? Really? Which issue number was that? I can't believe that any LO version had been released with such a show stopper issue. Well, please reconsider your statement in light of the requirement

[libreoffice-users] Re: Base Relationships: Update cascade not working

2014-11-01 Thread Andreas Säger
Am 01.11.2014 um 12:19 schrieb Marion Noel Lodge: Hi Andreas, Thanks for your detailed reply. After I had sent my message, I realised that I had neglected to mention that I am using the H2 database. I went back into Tools | Relationships and decided to remove the the relationship lines

[libreoffice-users] Re: date acceptance patterns not sticking

2014-11-01 Thread Andreas Säger
Am 14.10.2014 um 22:20 schrieb bunk3m: Libreoffice is driving me nuts. I am in Canada. UI is set to English US; Locale settings to English Canada and Default Currency is CAD. I have my Mac set dates to dd.mm.. (OSX 10.9.x) For some reason Libreoffice (4.3.1.2) will only accept dates

[libreoffice-users] Re: Forgotten where to look for template converting text dates to numeric and sortable form

2014-10-31 Thread Andreas Säger
Am 31.10.2014 um 04:01 schrieb Custfold: What do I put in the find replace boxes? Hi, First of all, it is easier to avoid this problem rather than fixing it. You turn on regular expressions and replace .+ with -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] Re: Base Relationships: Update cascade not working

2014-10-31 Thread Andreas Säger
Am 31.10.2014 um 14:11 schrieb Marion Noel Lodge: Hi, I am trying to change some Primary Keys in my main table, and get the changes to be reflected in several Foreign Keys. I have gone into Tools | ​ ​ Relationships, have set up the 1 to n connections between the tables and ​chosen

[libreoffice-users] Re: Macro to abandon edits

2014-10-31 Thread Andreas Säger
Am 31.10.2014 um 12:20 schrieb rmg: I'm migrating a bunch of spreadsheets from Debian Lenny/Openoffice to Debian Wheezy/Libreoffice 3.5.x. This is a dedicated setup used by many once-a-year users (who aren't chosen for their familiarity with computers) and, for instance, boots straight into a

[libreoffice-users] Re: Tab defaults change when pasting into Writer from some other applications

2014-10-31 Thread Andreas Säger
Hi, Follow Dan's advice. Pasting unformatted text only does the same as typing the text into your preformatted paragraphs. Everything becomes clear and easy to use when your mind starts separating data from presentation. Once you got there, using paragraph styles is just a matter of course and

[libreoffice-users] Re: Recommended version of Java?

2014-10-31 Thread Andreas Säger
Am 31.10.2014 um 19:10 schrieb Tanstaafl: On 10/30/2014 5:02 PM, Virgil Arrington arringto...@gmail.com wrote: In my experience on this list, Tom has been extremely helpful and, just as important, courteous. I agree for the most part, and he is always polite and cordial. I just really

[libreoffice-users] Re: Recommended version of Java?

2014-10-31 Thread Andreas Säger
Am 31.10.2014 um 20:32 schrieb Tanstaafl: On 10/31/2014 3:26 PM, Andreas Säger ville...@t-online.de wrote: Am 31.10.2014 um 19:10 schrieb Tanstaafl: So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... You are the one to check this out. We don't

[libreoffice-users] Re: Recommended version of Java?

2014-10-31 Thread Andreas Säger
Am 31.10.2014 um 20:50 schrieb Sophie Gautier: Hi Andreas GSM Le 31 oct. 2014 20:27, Andreas Säger ville...@t-online.de a écrit : Am 31.10.2014 um 19:10 schrieb Tanstaafl: On 10/30/2014 5:02 PM, Virgil Arrington arringto...@gmail.com wrote: In my experience on this list, Tom has been

[libreoffice-users] Re: Recommended version of Java?

2014-10-30 Thread Andreas Säger
Any of the latest Java 6, 7 or 8 should work equally well with LibreOffice. The bitness of the _office_suite_ is the only limiting factor. All LibreOffice versions for Windows are 32 bit, so you need a 32 bit Java even on a 64 bit system. LibreOffice for the Mac comes with 32 or 64 bitness. So it

[libreoffice-users] Re: Date manipulation

2014-10-30 Thread Andreas Säger
For an embedded HSQL database the query goes like this: SELECT * FROM Your Table WHERE DATEDIFF('day', CURRENT_DATE, Date Field) BETWEEN -10 AND 10 Replace the double quoted names with the actual names of your table and field. -- View this message in context:

[libreoffice-users] Re: Styles mess

2014-10-27 Thread Andreas Säger
Create your custom currency format +# ##0,00 [$kr-41D];# ##0,00 [$kr-41D] with a red and green variant -- View this message in context: http://nabble.documentfoundation.org/Styles-mess-tp4126946p4127068.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail

[libreoffice-users] Re: Serial Letters

2012-10-16 Thread Andreas Säger
Am 16.10.2012 09:31, Heinrich Stoellinger wrote: Hello, A couple of versions ago of LO I mentioned that I have a problem with serial letters using Writer and MySQL-Views through Base. When printing a letter populated with database-view variables from just ONE tuple (=record) everything is

[libreoffice-users] Re: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Andreas Säger
Am 14.10.2012 21:08, chaonis wrote: I am trying to write scripts accessing the system files, such as /dev/ttyS0. If I use Open I got the error Device I/O error message. Are there any special function call needed to be done for the system files? User permission is good as I can access to the

[libreoffice-users] Re: Fwd: Re: Re: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Andreas Säger
Am 15.10.2012 13:31, Tom Davies wrote: Hi :) No-one is suggesting dropping Star Basic! That would be a huge nightmare for many people i'm sure. I was just curious what might be better. A quick look at what languages can be used for macros in LO reveals 4 choices; LO Basic, Python,

[libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Andreas Säger
Am 15.10.2012 09:49, Pertti Rönnberg wrote: if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else (-- if c3 is '1' or bigger then -- ) use the integer of value in c3) =MIN(0;INT(C3)) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Andreas Säger
Am 15.10.2012 10:45, Brian Barker wrote: At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote: On 14.10.2012 12:20, Gilles SICHE wrote: could anyone tell me which formula I should use for the integer part of a cell to be shown in another cell, ... The answer could be: =IF(C31;0;INT(C3)) You

[libreoffice-users] Re: how to crack a PW in LO?

2012-10-15 Thread Andreas Säger
Am 15.10.2012 15:49, rost52 wrote: LO files can be protected with PWs when doing save as. Fighting currently with an xls file and its lost PW, I wonder how LO files can be cracked? Can the MS related PW remover be used for LO as well? Thanks in advance for comments. xls does not

[libreoffice-users] Re: how to crack a PW in LO?

2012-10-15 Thread Andreas Säger
Am 15.10.2012 16:30, Dr. R. O Stapf wrote: However, my question was how to open an LO file if the PW get forgotten (not and MS file)? Hints are welcome for the future. There is no way to open encrypted ODF other than a brute force script working through a list of possible passwords. --

[libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Andreas Säger
Am 15.10.2012 16:20, Brian Barker wrote: At 14:42 15/10/2012 +0200, Andreas Säger wrote: Am 15.10.2012 09:49, Pertti Rönnberg wrote: if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else (-- if c3 is '1' or bigger then -- ) use the integer of value in c3) =MIN(0;INT(C3

[libreoffice-users] Re: LibreOffice in MacWorld Australia

2012-10-14 Thread Andreas Säger
Am 14.10.2012 03:33, anne-ology wrote: but MSFT products are NOT cheap - their limited editions are included on new PCs due to some agreement BGates made with the manufacturers; once the trial version runs its course and/or the user desires more than the trial version offers they must

[libreoffice-users] Re: Auto and Manual Spell do not work x

2012-10-14 Thread Andreas Säger
Am 14.10.2012 10:10, Lostsoul wrote: Ok now what the crap; why are abiword documents being saved as adobi docs how do i fix that can t get anything right crap . - later I strongly recommend some computer crash curse. File name associations are free. There is nothing hard wired to

[libreoffice-users] Re: Auto and Manual Spell do not work . .

2012-10-13 Thread Andreas Säger
Am 13.10.2012 03:53, Lostsoul wrote: Not thinking of using ubanta was just asking about it ; and does anyone out their use libre with win 7 so far i would guess its a huge no and your throwing out ramdom guess s as fixs. And libre comes in three sizes on various freeware sites; not

[libreoffice-users] Re: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-13 Thread Andreas Säger
Am 13.10.2012 16:37, Dr. R. O Stapf wrote: On 12.10.2012 01:36, Gordon Burgess-Parker wrote: On 11/10/12 13:27, Andreas Säger wrote: This is not a free clone of some other program. All it can do is loading .doc files fairly well. Please switch to this software or stay with WinWord

[libreoffice-users] Re: Color cursor (active cell) on calc

2012-10-11 Thread Andreas Säger
Am 11.10.2012 15:38, Àngel mompó wrote: I am using Libreofice Calc version 3.6.2.2 I have a group of cells witha a black 1pt border so i find dificult to see at witch cell the cursor is. Is there any way to change the color and or other characteristics of the cursor? A macro

[libreoffice-users] Re: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-11 Thread Andreas Säger
Am 11.10.2012 18:08, Tom Davies wrote: Hi :) Hmmm, i would try opening the template and then do File - Save As .. and save the document as an OpenDocument Format template. I'm not sure if it would work but it's got to be worth trying. Regards from Tom :) No, it should be ...

[libreoffice-users] Re: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-11 Thread Andreas Säger
Am 11.10.2012 18:36, Gordon Burgess-Parker wrote: On 11/10/12 13:27, Andreas Säger wrote: This is not a free clone of some other program. All it can do is loading .doc files fairly well. Please switch to this software or stay with WinWord. And with that attitude on a help list, LO is never

[libreoffice-users] Re: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-11 Thread Andreas Säger
Am 11.10.2012 19:59, Tom Davies wrote: Hi :) And all the offices will close and money will cease to be important and there will be peace and happiness everywhere like Star Trek. Regards from Tom :) However, Kyla R. asked how to fuel up her new e-car and the answer is that you must

[libreoffice-users] Re: LibreOffice in MacWorld Australia

2012-10-11 Thread Andreas Säger
Am 11.10.2012 20:46, webmaster-Kracked_P_P wrote: It is nice to see that MacWorld Australia states that LibreOffice is a must have app/package. I wonder if the MacWorld for the USA and Europe would have the same statement. Be nice to have LO listed in the must have category in the various

[libreoffice-users] Re: Help in LibreOffice 3.5.6

2012-10-10 Thread Andreas Säger
Am 04.10.2012 19:40, Eliane Domingos de Sousa wrote: Hi all, I have a situation under LibreOffice 3.5.6 with a dialog that has several steps. In the LibreOffice IDE, I see only the last page of the dialog. The module that invokes the dialog uses the property Step as oDialog.Model.Step = 1 '

[libreoffice-users] Re: removing AbiWord from Ubuntu 12.04 kills LO desktop-menus

2012-10-10 Thread Andreas Säger
Am 10.10.2012 17:21, webmaster-Kracked_P_P wrote: I noticed that AbiWord was the default ODF file reader when I right-click on a document created with LO. I just upgraded to Ubuntu 12.04.1 64-bit from 10.04. When I use the package manager to remove AbiWord, it removed things like the

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-09 Thread Andreas Säger
Am 09.10.2012 09:14, Marcello Romani wrote: Il 08/10/2012 14:13, John Clegg ha scritto: OK, if I accept everything that has been said, then why wouldn't opening an in-memory r/w copy be the sensible default action? So that when the user would try to save it a Save As dialog would appear ?

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-09 Thread Andreas Säger
Am 09.10.2012 11:24, John Clegg wrote: Forgive me, but I thought one of the aims of LO was improvements to usability. I open emails mailed to me dozens of times a day. Doing Save-As, or clicking the edit button takes little time I agree, but why is it so wrong to desire that as the default to

[libreoffice-users] Re: regexp function

2012-10-09 Thread Andreas Säger
Am 09.10.2012 12:24, Tom Davies wrote: Hi :) Is there not some way to identify how far along the letter is through one of the count functions? If so then a +1 should give the required value? In the interests of release early and release often it might be faster for you to 'just' do a

[libreoffice-users] Re: Libre office using MSVCR90.dll cause Explorer to crash?

2012-10-09 Thread Andreas Säger
[Solved] Dynamic link library MSVCR90.dll missing http://forum.openoffice.org/en/forum/viewtopic.php?f=15t=46996 -- 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 +

[libreoffice-users] Re: Update SQL does nothing using Run SQL directly button

2012-10-08 Thread Andreas Säger
Am 04.10.2012 01:27, David S. Crampton wrote: Register1a is a table with field Trans-Date of type TIMESTAMP. Field Trans-Date-Year is either TIMESTAMP or INTERGER. I have tried with both. Update Register1a Set Register1a.Trans-Date-Year = YEAR(Register1a.Trans-Date); Looks like is should

[libreoffice-users] Re: using \t in regular expression replace

2012-10-08 Thread Andreas Säger
Am 08.10.2012 09:03, Cor Nouws wrote: Of course I used this workaround. But I wondered if I did something wrong, or missed some special trick to replace $ with a tab in one run. The $ does not match any character. It matches a position. You may think of the position where the bar cursor

[libreoffice-users] Re: Base list, was: Fw: Re: Update SQL does nothing using Run SQL directly button

2012-10-08 Thread Andreas Säger
Am 08.10.2012 12:01, Tom Davies wrote: Hi :) All the threads about Base are buried in the archives: scattered and hidden, incoherent amongst hundreds of threads about things that are nothing to do with Base. If there was a Base List then some of those threads might have been

[libreoffice-users] Re: Base list, was: Fw: Re: Update SQL does nothing using Run SQL directly button

2012-10-08 Thread Andreas Säger
Am 08.10.2012 14:15, Tom Davies wrote: Hi :) Thanks Andreas! :) I have been looking for that link for a while. It feels a bit cheeky to send people from here to AOO but it's probably a good idea if we are going to keep helping Base users. Regards from Tom :) When the whole

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-08 Thread Andreas Säger
Am 08.10.2012 14:13, John Clegg wrote: OK, if I accept everything that has been said, then why wouldn't opening an in-memory r/w copy be the sensible default action? Tell your mail client, browser, whatever to call soffice with the -n switch. The -n switch treats every document as if it were

[libreoffice-users] Re: Label mail merge producing one page per record, not six records per page

2012-10-07 Thread Andreas Säger
Am 07.10.2012 05:53, robertjm wrote: Hi all, Sorry for the subject being confusing, but that's the best way I could describe it. I'm working with Avery 5384 Name Badge labels. These has six spots per page. I set up a layout in the upper left-hand label, and then clicked synchronize to

[libreoffice-users] Re: Count number of rows satisfying two conditions

2012-10-07 Thread Andreas Säger
Am 07.10.2012 12:28, Alaak wrote: Hi, I have the following problem. I need to count all rows from a table satisfying two conditions in separate columns. I know of the function COUNTIF (ZÄHLENWENN in german), but that one is only able to consider one condition. Let's look at a brief example.

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-06 Thread Andreas Säger
Am 05.10.2012 14:09, John Clegg wrote: I thought LO was emulating MSO 97?? Read-only is the only sensible way to open other people's files (web downloads, mail attachments). -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-06 Thread Andreas Säger
Am 06.10.2012 19:16, John Clegg wrote: Whilst a condom is always wise I still prefer to put it on for myself If you prefer to not choose anything, the other side will take her own precautions. -- Your mail/cloud client creates a *temporary file for viewing* unless you explicitly

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-06 Thread Andreas Säger
Am 06.10.2012 19:59, Felmon Davis wrote: On Sat, 6 Oct 2012, Mirosław Zalewski wrote: On 06/10/2012 at 19:27, Felmon Davis dav...@union.edu wrote: I am still not sure how one gets an infection from saving a file as writable. on a Linux system it's not executable, not sure how it works on

[libreoffice-users] Re: documentation for LO base

2012-10-06 Thread Andreas Säger
Am 06.10.2012 21:34, Wolfgang Keller wrote: Huh? Access is a pathological data shredder. Not as bad as Base's default type of database. This part of Base is not even a valid proof-of-concept. The whole concept is dysfunctional by design and nobody dares to stop this madness. Just like

[libreoffice-users] Re: documentation for LO base

2012-10-04 Thread Andreas Säger
The ultimate guide by Mariano Casanova: http://www.scribd.com/doc/48635562/Base-Tutorial-OOo -- View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Andreas Säger
Mark Stanton wrote I hope not, XML is supposed to be a self defining file format surely? It's a meta-file format. You (who defines all the XML tags) are the one and only person able to develop import and export software for your particular flavour of XML. xml BLAH foo=bar blub x=121.43/blub

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Andreas Säger
FoxPro export exports database fields like this: ?xml version=1.0?Document OrderUpdate OrderId12345/OrderId OrderDate01/01/2004/OrderDate Confirmation123/Confirmation Storage StorageId01/StorageId Quantity1450/Quantity /Storage Storage

[libreoffice-users] Re: [Writer] Data to Fields is not working

2012-10-04 Thread Andreas Säger
You can not do anything useful with a blank new document. 1. Open your letter template with fields. 2. Hit F4 and get your row set (query or table) 3. Click a grey row selector left of the first column to select the record that represents the receipient of your letter. 4. Click data-to-fields

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Andreas Säger
MySQL can import your customer-visibility-groups: http://dev.mysql.com/doc/refman/5.5/en/load-xml.html If there is any reason why you want customer-visibility-groups in a calculator software, connect a registerd Base document to your MySQL server and dump the imported data from the data source

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Andreas Säger
Am 03.10.2012 20:54, Mark Stanton wrote: I've got an XML file (I've generated myself, programmatically). I thought it ought to be easy to import it in LO (3.4.6), somehow. I thougth Calc would be a good bet, but it just gives me General I/O error. Base does the same. The website

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-03 Thread Andreas Säger
Am 03.10.2012 09:23, HBarr wrote: Hi, I am a database user and emphasis on the word *user*. I like learning new stuff too and Base is a challenge. I want LObase to work so I will contribute feedback whenever I can but no more than that because I haven't learnt to code or programme...yet. I

[libreoffice-users] Re: Opening a CSV file with Calc

2012-09-30 Thread Andreas Säger
Am 29.09.2012 03:41, Jeff Hahn wrote: I download financial information from Yahoo Finance. The download is a CSV file format.Athought I am able to open it with MS Excel I am not able to open it using LO except as a text file. Any suggestions on how I can open the file with Calc?

[libreoffice-users] Re: No Java could be found: LO 3.6.1.2: Win7 pro sp1; java 1.7.0_07

2012-09-30 Thread Andreas Säger
Am 30.09.2012 20:57, David S. Crampton wrote: Geez, I'm feeling a right dunce on this. You were correct in that my architecture is 64-bit. I uninstalled Java and then installed from jre-7u7-windows-i586.exe as downloaded from filehippo. Restarted machine. Still same behavior in Base. Yes in

[libreoffice-users] Re: ZOOM: strange or bug??

2012-09-29 Thread Andreas Säger
Am 28.09.2012 14:00, manuel_songo...@yahoo.it wrote: hello i dont say GESTURES ON LO ok? i say why when my mouse on area zoom slider and why it's activated drag only when area zoom-slider do you undy? how i can record my screen video? so will send you to see what is problem ok? Save your

[libreoffice-users] Re: formatting lost in referenced calc fields

2012-09-27 Thread Andreas Säger
Am 27.09.2012 09:31, jef.peeraer wrote: So the thousands separator is lost. Shouldn't the formatting of the calculator fields be copied into the writer doc? Or do I have to format the fields again in the writer doc ? LO is version 3.6.0.4 on 32 bit linux. No, it shouldn't. You pull some raw

[libreoffice-users] Re: formatting lost in referenced calc fields

2012-09-27 Thread Andreas Säger
Am 27.09.2012 13:56, jef.peeraer wrote: ok, but it would be nice if you could indicate to copy the formatting as wellI thought I saw this somewhere in a dialog jef This is not about copypaste. When you reference another cell ( =A1 ) you would not expect the format to carry over. A

[libreoffice-users] Re: Calc - bar chart - does not list order properly for cell values

2012-09-26 Thread Andreas Säger
Hi, The Y-axis is a numeric scale with start, end and some interval. The scale can be adjusted to be logarithmic or in reverse order. Just double-click the chart and then the y-axis. The order of the corresponding cell vector does not matter as long as the cell values are numeric. -- For

[libreoffice-users] Re: Calc - bar chart - does not list order properly for cell values

2012-09-26 Thread Andreas Säger
Am 26.09.2012 16:12, Andreas Säger wrote: Hi, The Y-axis is a numeric scale with start, end and some interval. The scale can be adjusted to be logarithmic or in reverse order. Just double-click the chart and then the y-axis. The order of the corresponding cell vector does not matter as long

[libreoffice-users] Re: [OT] Re: What's New in Evolution 3.6

2012-09-24 Thread Andreas Säger
Oh yes! Show us more software you have nothing to tell about. -- View this message in context: http://nabble.documentfoundation.org/What-s-New-in-Evolution-3-6-tp4008228p4008935.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: python reading calc

2012-09-24 Thread Andreas Säger
Instead of running tests, how about debugging your program and reading some documentation? -- View this message in context: http://nabble.documentfoundation.org/python-reading-calc-tp4008804p4008939.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions

[libreoffice-users] Re: python reading calc

2012-09-24 Thread Andreas Säger
Am 23.09.2012 15:30, dutchguy69 wrote: Did some research but have not found many leads yet. Hoping someone might be able to shed some light on this. C:\Program Files\LibreOffice 3.5\share\Scripts\python\pythonSamples\TableSample.py -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-09-20 Thread Andreas Säger
You are free to use any database that works for you and connect a Base document to it. If Base is too simplistic and underdeveloped you are free to connect some other frontend to your database (I use to recommend MS Access as perfect desktop frontend for free databases). Databases do exist. They

[libreoffice-users] Re: Libreoffice Read/Write to Calc

2012-09-20 Thread Andreas Säger
I think he meant ”from the command line”. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ $ mySetValueScript.py myfile.ods Sheet1.D5 1000 -- View this message in context: http://nabble.documentfoundation.org/Libreoffice-Read-Write-to-Calc-tp4008273p4008445.html Sent from the Users mailing list

[libreoffice-users] Re: Base Report Question

2012-09-19 Thread Andreas Säger
SELECT this|| '|' ||that FROM XTable The double-pipe is the SQL concatenation operator analog to in a spreadsheet. '|' is a literal pipe analog to | in a spreadsheet. -- View this message in context: http://nabble.documentfoundation.org/Base-Report-Question-tp4008153p4008175.html Sent from

[libreoffice-users] Re: Libreoffice Read/Write to Calc

2012-09-19 Thread Andreas Säger
Generate office valid documents without any office suite: http://opendocumentfellowship.com/projects/odftools Accessing the UNO API of LibreOffice/OpenOffice in Python: http://wiki.services.openoffice.org/wiki/PyUNO_bridge (similar things work with Java and some other languages) -- View this

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-09-18 Thread Andreas Säger
You can always have your free dose if you want: http://www.zdnet.com/blog/bott/microsoft-quietly-shuts-down-office-genuine-advantage-program/2798 -- View this message in context:

[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-09-18 Thread Andreas Säger
In Germany there is a legal market for used software including OEM versions of Windows and Office. -- View this message in context: http://nabble.documentfoundation.org/MS-raised-prices-so-people-will-now-start-renting-their-office-products-instead-tp4008030p4008079.html Sent from the Users

[libreoffice-users] Re: Socket Creation Error in LibO 3.6.2.1 RC 1

2012-09-18 Thread Andreas Säger
I get a socket creation error on a Windows machine where the HSQLDB with the wrong IP address in the config file. -- View this message in context: http://nabble.documentfoundation.org/Socket-Creation-Error-in-LibO-3-6-2-1-RC-1-tp4008075p4008109.html Sent from the Users mailing list archive at

[libreoffice-users] Re: Array Formulas Do Not Work

2012-09-17 Thread Andreas Säger
Find out if it is a known issue or not: https://www.libreoffice.org/bugzilla/query.cgi May be the problem is not related to arrays? Debug your formulas to find out which part causes the problem. -- View this message in context:

[libreoffice-users] Re: Automatically fill user informations from Sun LDAP

2012-09-16 Thread Andreas Säger
Am 13.09.2012 09:47, Nicolas ABEL wrote: Hi everybody. First of all, I'm sorry for the lack of informations; i'm going to explain a bit more. Yes, Alexander and Andreas, you got it. On 300 computers, I'd like to fill automatically the informations contained in LibreOffice ToolsOptionsUser Data

[libreoffice-users] Re: Where to store a simple database?

2012-09-15 Thread Andreas Säger
Someone found his way to share a database on Dropbox: http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=41238 http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=54988 http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=44131 -- View this message in

[libreoffice-users] Re: How do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.

2012-09-14 Thread Andreas Säger
Am 14.09.2012 12:25, Richard Quadling wrote: Hello. I'm new to using a Mac and some of the things I can do in Windows I'm unable to even work out the question for on a Mac, so please bear with me. The files are generated from an automated system, several hundred a day and have a .tsv extension

[libreoffice-users] Re: Where to store a simple database?

2012-09-14 Thread Andreas Säger
Am 14.09.2012 16:41, John Clegg wrote: where I wouldn't be able to get at it without Internet access? (Dropbox of course keeps local copies which it synchronises). Or is this one use use where embedded HSQL really is the right answer?? All views appreciated! Of course you can not access

[libreoffice-users] Re: How do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.

2012-09-14 Thread Andreas Säger
Am 14.09.2012 17:44, Richard Quadling wrote: The file arrive on the network automatically, I just want to open one when I need to, edit it and save it. Other apps deal with the files changing. And what prevents you from doing so? What's wrong with Writer or any other text editor? Even if

[libreoffice-users] Re: How do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.

2012-09-14 Thread Andreas Säger
A searchable forum with a subforum for Mac related questions, attachments, pictures and many competent contributors: http://user.services.openoffice.org/ Searching the Mac forum: http://user.services.openoffice.org/en/forum/viewtopic.php?f=17t=46590p=215738hilit=writer+calc#p215738 -- For

[libreoffice-users] Re: Where to store a simple database?

2012-09-14 Thread Andreas Säger
Am 14.09.2012 19:03, John Clegg wrote: Whilst your answer is no doubt rigorous it lacks a little in the helpfulness class! You have explained many times before that base is not a database and embedded hsql is evil. You haven't really explained why in either case, but then I am much the same in

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-13 Thread Andreas Säger
Am 13.09.2012 00:49, JAMES MAJESKI wrote: Name one feature that makes a database better than a spreadsheet when flexibility of input is required. -- View this message in context:

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-13 Thread Andreas Säger
Am 13.09.2012 05:18, JAMES MAJESKI wrote: So far nobody has come up with a reason for me to switch to a database where I risk loosing data if I attempt to make a change to the layout. -- View this message in context:

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-13 Thread Andreas Säger
Am 13.09.2012 05:03, JAMES MAJESKI wrote: My only queries of the data are handled adequately by the calculations done in adjacent columns. Nothing special, complex, or complicated will easily replace it nor be more useful. Calc can do all this without very easily with the help of the Base

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-13 Thread Andreas Säger
Am 13.09.2012 11:54, Andreas Säger wrote: Am 13.09.2012 05:03, JAMES MAJESKI wrote: My only queries of the data are handled adequately by the calculations done in adjacent columns. Nothing special, complex, or complicated will easily replace it nor be more useful. Calc can do all

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-13 Thread Andreas Säger
Am 10.09.2012 22:30, Andreas Säger wrote: Am 10.09.2012 19:40, Andreas Säger wrote: Base is our database component. It is very, very underdeveloped, nevertheless underestimated. Even the worst database tool does a better database job than the best spreadsheet can do. Since nobody ever

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-12 Thread Andreas Säger
Am 12.09.2012 07:23, JAMES MAJESKI wrote: Two digit years have always been a problem. I always presume that the use two digit years was obsolete after the Y2K publicity, but bad habits continue. We are no longer in the era of eighty column punch cards, so there is no excuse for two digit years.

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-12 Thread Andreas Säger
Am 12.09.2012 08:00, JAMES MAJESKI wrote: My research has convinced me that I do not have neither the time nor the resources to set up and maintain a database. I might consider it if all of the data were received in the same layout, but the layout is as varied as are the sources. Since I am the

[libreoffice-users] Re: calc

2012-09-12 Thread Andreas Säger
Am 12.09.2012 15:35, a a wrote: Hey, When i am creating a diagram i can change the numeric values of the y-axel, but when i try the same procedure for the x-axel, the template with options stay grey and imposible to change. How can i do to make this grey area black again so i can change the

[libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-12 Thread Andreas Säger
Am 12.09.2012 15:23, Enda wrote: OS: Ubuntu Calligra does not create a dot file when viewing files, is there an option to turn this off in LibreOffice? I give up. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

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