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

[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 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? http://ww

[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

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

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

[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:Tools>SQL 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 "Pi

[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

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

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

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

[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 Tools>Options>Calc>Calculate: "Enable Regular Expressions" is OFF and "Mat

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

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

[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

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

[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:File>Page Preview and menu:View>Page Layout ? -- To unsubscribe e-mail to: users+uns

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

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

[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

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

[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" a écrit : >> >> Am 31.10.2014 um 19:10 schrieb Tanstaafl: >>> On 10/30/2014 5:02 PM, Virgil Arrington wrote: >>>> In my experience

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

[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 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 hate it when so

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

[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

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

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

[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: http://nabble.documentfoundat

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

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

[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

[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

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

[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(C3<1;0;I

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

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

2012-10-14 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

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

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

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

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

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

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

[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

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

[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 11:43, Kyla Robertson wrote: > Hello, > > I'm migrating from MS Word (Office 2002 !) to LibO Writer. In Word, my > Normal.dot template contains many, many things: about 150 styles, 250 > macros, some auto-insert texts, some custom shortcuts, many toolbars > and custom buttons. > > H

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

[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: 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=15&t=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: 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'

[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

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

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

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

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

[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 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: Update SQL does nothing using "Run SQL directly" button

2012-10-07 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

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

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

[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: MS raised prices so people will now start renting their office products instead

2012-10-06 Thread Andreas Säger
Am 06.10.2012 20:18, Jay Lozier wrote: > VBS macros in MSO documents have been used to infect Windows computers. > The issue is what is good practice regardless of the OS. If you follow > good practices, the possibility of problems is significantly reduced. Bullshit. -- For unsubscribe instruc

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

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

[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 17:37, Spencer Graves wrote: > On 10/6/2012 6:13 AM, Andreas Säger wrote: >> 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 >> dow

[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? http://www.libreoffice.org/g

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

[libreoffice-users] Re: Import XML files?

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

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

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Andreas Säger
FoxPro export exports database fields like this: 12345 01/01/2004 123 01 1450 02 2480 It might be comparatively easy to write a Base driver for structures like this one. A spreadsheet does not imply any such structure. As far as I

[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. 1.43 ertzuiopdfghjklöxcvbnm How wou

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

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

[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

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

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

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

2012-09-29 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 C

[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 copy&paste. When you reference another cell ( =A1 ) you would not expect the format to carry ove

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

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

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

[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: users+h...@glo

[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: [OT] Re: What's New in Evolution 3.6

2012-09-23 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: users+h...@

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

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

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

[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

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

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

[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: http://nabble.documentfoundation.org/MS-raised-prices-so-people-will-now-start-renting-their-office-products-instead

[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: http://nabble.documentfoundation.org/Array-Formulas-Do-Not-Work-tp4

[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 "Tools>Options>User Da

[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=13&t=41238 http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=54988 http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=44131 -- View this message in

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

[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=17&t=46590&p=215738&hilit=writer+calc#p215738 -- For

[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

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