Re: [libreoffice-users] Re: [Writer] Regular expressions

2013-01-08 Thread Brian Barker
At 23:39 08/01/2013 +0100, Miroslaw Zalewski wrote: On 08/01/2013 at 21:17, Nino Novak wrote: but only if it's really true ;-) Unless you are 100% sure that my statement is not true, please don't question it. And you are NOT 100% sure until you post LO Writer regexp that will use negation

Re: [libreoffice-users] [Writer] Regular expressions

2013-01-08 Thread Brian Barker
At 19:58 08/01/2013 +0100, Gordom Noname wrote: I would appreciate your help with the regular expressions. I have a document consisting of hundreds of lines. A small sample is here: Set: 01SA34509 0109SA 011017B 01020207B 010902B 01090002 011007B 01090001 090110 Set: 0134501 011101 01110102

Re: [libreoffice-users] Changing time format in Calc header

2013-01-08 Thread Brian Barker
At 12:15 08/01/2013 -0800, Karen Dinse wrote: We are using Windows XP, SP3, LibreOffice 3.5.5.3 We have created a Calc spreadsheet and want to show the time in the header. When we print the sheet, the time shows military time. Is there a way to change that to show 12 hour time? I know that w

Re: [libreoffice-users] Re: Base scenario

2013-01-08 Thread Dan Lewis
Comment inline below. --Dan On 01/08/2013 07:07 PM, Girvin R. Herr wrote: Ian, Have you actually drawn any relationships? Base will not do that for you. Just adding the tables in the 'Relationships Window' will not create the relationships automagically. You must click and hold on the on

Re: [libreoffice-users] Re: Base scenario

2013-01-08 Thread Winston Chuen-Shih Yang
Ian, Below, Girvin had a warning about joins. Specifically, he was talking about inner joins. SQL has different types of joins. Below, I explain them. Note: It has been some time since I used SQL. I might have errors. Sorry if you already know this information. But possibly it will be help

Re: [libreoffice-users] Re: [Writer] Regular expressions

2013-01-08 Thread Winston Chuen-Shih Yang
Gordom, Below, Miroslaw mentioned grep. In Linux, you can achieve your goal by typing something like the following: grep --extended-regexp "^Set" input.txt > output.txt This gets the lines in input.txt that start with "Set" and writes these lines to output.txt. You might not even have

[libreoffice-users] Re: Unable to use dotx files

2013-01-08 Thread NoOp
On 01/07/2013 06:29 PM, kahu wrote: > I really would like to see a "fix" for this which would allow for other users > to open "dotx" files within our organization by simple steps--not just me, > but something I can recommend to anyone else. If it is a technical process > of extraction I think usin

[libreoffice-users] Re: Unable to use dotx files

2013-01-08 Thread NoOp
On 01/08/2013 03:57 PM, kahu wrote: > I would be happy to start a bug request for this--thanks for your work on > this with me. > > Can you help me define exactly what the problem is, so I can explain what > needs to be addressed in the report?

[libreoffice-users] Re: Unable to use dotx files

2013-01-08 Thread kahu
Opened bug: https://bugs.freedesktop.org/show_bug.cgi?id=59148 -- View this message in context: http://nabble.documentfoundation.org/Unable-to-use-dotx-files-tp4027691p4027881.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@g

Re: [libreoffice-users] Re: Unable to use dotx files

2013-01-08 Thread Jay Lozier
On 01/08/2013 06:57 PM, kahu wrote: I would be happy to start a bug request for this--thanks for your work on this with me. Can you help me define exactly what the problem is, so I can explain what needs to be addressed in the report? Writer does not open a dotx file correctly. Describe like you

Re: [libreoffice-users] Re: [Writer] Regular expressions

2013-01-08 Thread Tom Davies
Hi :)  I like the quote "Never believe anything until it's been denied by a government minister" but now i can't find where the quote comes from so i'm beginning to doubt it was ever really said by anyone.  Regards from Tom :)  > > From: Mirosław Zalewski

Re: [libreoffice-users] Re: Base scenario

2013-01-08 Thread Girvin R. Herr
Ian, Have you actually drawn any relationships? Base will not do that for you. Just adding the tables in the 'Relationships Window' will not create the relationships automagically. You must click and hold on the one table element (remote key) and drag over to the related table's element (pr

[libreoffice-users] Re: Unable to use dotx files

2013-01-08 Thread kahu
I would be happy to start a bug request for this--thanks for your work on this with me. Can you help me define exactly what the problem is, so I can explain what needs to be addressed in the report? -- View this message in context: http://nabble.documentfoundation.org/Unable-to-use-dotx-files-

Re: [libreoffice-users] Re: [Writer] Regular expressions

2013-01-08 Thread Mirosław Zalewski
On 08/01/2013 at 21:17, Nino Novak wrote: > but only if it's really true ;-) Unless you are 100% sure that my statement is not true, please don't question it. And you are NOT 100% sure until you post LO Writer regexp that will use negation pattern that OP is looking for. -- Best regards Miro

Re: [libreoffice-users] Re: [Writer] Regular expressions

2013-01-08 Thread Mirosław Zalewski
Although you have solved your problem already by other means, but let's check other possibilities. On 08/01/2013 at 21:45, gordom wrote: > In "real" life :-) there are lines starting with letters also. Only > these with "Set:" at the beginning should be left, rest is going to be > deleted. By

Re: [libreoffice-users] Changing time format in Calc header

2013-01-08 Thread upscope
On Tuesday, January 08, 2013 12:15:40 PM Karen DInse wrote: > We are using Windows XP, SP3, LibreOffice 3.5.5.3 > > We have created a Calc spreadsheet and want to show the time in the header. > When we print the sheet, the time shows military time. Is there a way to > change that to show 12 hour

Re: [libreoffice-users] Re: Base scenario

2013-01-08 Thread Dan Lewis
On 01/08/2013 09:32 AM, Ian Whitfield wrote: Hi All Re - My previous post Have been doing some Googling etc and found the 'Relationships Window' for setting Relationships. I can get the Window up, select my Tables but it _DOES NOT_ draw any connecting lines or set any Relationships!!??

Re: [libreoffice-users] Changing time format in Calc header

2013-01-08 Thread Dan Lewis
On 01/08/2013 03:15 PM, Karen DInse wrote: We are using Windows XP, SP3, LibreOffice 3.5.5.3 We have created a Calc spreadsheet and want to show the time in the header. When we print the sheet, the time shows military time. Is there a way to change that to show 12 hour time? I know that we wou

Re: [libreoffice-users] Re: [Writer] Regular expressions

2013-01-08 Thread gordom
W dniu 2013-01-08 21:17, Nino Novak pisze: Am 08.01.2013 21:11, schrieb gordom: W dniu 2013-01-08 20:20, Mirosław Zalewski pisze: Since LibreOffice regex engine is crippled and don't support lookaheads, the short answer is: no, you can't do that. That's a pity. but only if it's really true

[libreoffice-users] Re: [Writer] Regular expressions

2013-01-08 Thread Nino Novak
Am 08.01.2013 21:11, schrieb gordom: W dniu 2013-01-08 20:20, Mirosław Zalewski pisze: Since LibreOffice regex engine is crippled and don't support lookaheads, the short answer is: no, you can't do that. That's a pity. but only if it's really true ;-) BUT do lines you want to delete happe

[libreoffice-users] Changing time format in Calc header

2013-01-08 Thread Karen DInse
We are using Windows XP, SP3, LibreOffice 3.5.5.3 We have created a Calc spreadsheet and want to show the time in the header. When we print the sheet, the time shows military time. Is there a way to change that to show 12 hour time? I know that we would have to enter am or pm if needed. -

[libreoffice-users] Re: [Writer] Regular expressions

2013-01-08 Thread Nino Novak
Am 08.01.2013 19:58, schrieb gordom: Set: 01SA34509 0109SA 011017B 01020207B 010902B 01090002 011007B 01090001 090110 Set: 0134501 011101 01110102 01110103 080908 Set: 0111679SE 0111SE Search for: ^[^Ss] Replace with: (leave empty) [x] Regular expression works fine for me (LibreOffice 3.

Re: [libreoffice-users] [Writer] Regular expressions

2013-01-08 Thread gordom
W dniu 2013-01-08 20:37, Mirosław Zalewski pisze: On 08/01/2013 at 19:58, gordom wrote: I use "set:.+" regular expression, all these lines, that should be kept, are selected. Another idea: since you can select these lines you want to preserve, why don't copy them and paste into new document?

Re: [libreoffice-users] [Writer] Regular expressions

2013-01-08 Thread gordom
W dniu 2013-01-08 20:20, Mirosław Zalewski pisze: Since LibreOffice regex engine is crippled and don't support lookaheads, the short answer is: no, you can't do that. That's a pity. BUT do lines you want to delete happen to fall into some common pattern? In your sample (which may or may not

Re: [libreoffice-users] [Writer] Regular expressions

2013-01-08 Thread Mirosław Zalewski
On 08/01/2013 at 19:58, gordom wrote: > I use "set:.+" regular expression, all these lines, that should be kept, > are selected. Another idea: since you can select these lines you want to preserve, why don't copy them and paste into new document? This should be easiest and most error-proof sol

Re: [libreoffice-users] [Writer] Regular expressions

2013-01-08 Thread Mirosław Zalewski
Since LibreOffice regex engine is crippled and don't support lookaheads, the short answer is: no, you can't do that. BUT do lines you want to delete happen to fall into some common pattern? In your sample (which may or may not be representative for entire text) they does. In fact you want to de

Re: [libreoffice-users] Re: Unable to use dotx files

2013-01-08 Thread Tom Davies
Hi :) +1 Yes, i think a bug-report would be great.  https://wiki.documentfoundation.org/BugReport Regards from Tom :)  > > From: kahu >To: users@global.libreoffice.org >Sent: Monday, 7 January 2013, 23:50 >Subject: [libreoffice-users] Re: Unable to use dotx

[libreoffice-users] [Writer] Regular expressions

2013-01-08 Thread gordom
Hallo everyone. I would appreciate your help with the regular expressions. I have a document consisting of hundreds of lines. A small sample is here: Set: 01SA34509 0109SA 011017B 01020207B 010902B 01090002 011007B 01090001 090110 Set: 0134501 011101 01110102 01110103 080908 Set: 0111679S

[libreoffice-users] [LibreOffice-QA] Conference Call - January 11th, 2013 - 1400 UTC

2013-01-08 Thread Joel Madero
Hi All, First Happy New Year! This will be our first QA call of the new year and we're excited to get back into our bi-weekly open meetings. Our next call will be: Date: Friday, January 11th, 2013 Time: 1400 UTC Duration: Approximately 1 hour This is a public meeting so anyone is welcome to joi

[libreoffice-users] Re: Unable to use dotx files

2013-01-08 Thread Tom
Hi :) I just used MSO 2010 to save as a normal Word document Meidal_Jared.doc and also as a proper OpenDocument Format file Meidal_Jared.odt In MSO 20

Re: [libreoffice-users] Re: Base scenario

2013-01-08 Thread Wolfgang Keller
> I have the following - > A Members Table called 'Members' with > > * The Key being 'RecordID'. INT, Auto, > * Plus the rest of my 70-odd fields.. (This table comes up > in my "Main Form") 70 fields in one table? Sounds like this database may be de-normalised: http://en.wikipe

Re: [libreoffice-users] Re: Base scenario

2013-01-08 Thread Ian Whitfield
Hi All Re - My previous post Have been doing some Googling etc and found the 'Relationships Window' for setting Relationships. I can get the Window up, select my Tables but it _DOES NOT_ draw any connecting lines or set any Relationships!!?? Is this another "Gotcha" of using MySQL and B

Re: R: [libreoffice-users] Problem opening previously saved files

2013-01-08 Thread Tom Davies
Hi :) Hmm, yes it's true that quite a lot of settings are in registry but usually the problems are in the User Profile.  It's really easy to rename the user profile so it's a good thing to try first before getting bogged down in tricky or time-consuming stuff such as reinstalling.  The commonest

R: [libreoffice-users] Problem opening previously saved files

2013-01-08 Thread federico quadri
Between uninstalling and reinstalling, you should clean windows registry (I suppose you are a windows user). Most of the settings that can affect LO behaviour are stored there. Type "regedit" on a command line. The only (big) problem is that modify registry settings is veeery dangerous. Unfortunat

RE: [libreoffice-users] Footer: How to align chapter title tothe left and page number to the right

2013-01-08 Thread Giuseppe Greco
Yes, it works :-) Thank you very much! J3d -Original Message- From: Brian Barker Sent: 08/01/2013 10:10 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Footer: How to align chapter title tothe left and page number to the right At 09:51 08/01/2013 +0100, Giuseppe Greco

Re: [libreoffice-users] Footer: How to align chapter title to the left and page number to the right

2013-01-08 Thread Brian Barker
At 09:51 08/01/2013 +0100, Giuseppe Greco wrote: My footer contains both the chapter title and the page number... and I'd like to align the first to the left and the latter to the right: Is that possible without creating a table? Yes. Put a tab character between the two fields and set a Righ

[libreoffice-users] Footer: How to align chapter title to the left and page number to the right

2013-01-08 Thread Giuseppe Greco
Dear all, My footer contains both the chapter title and the page number... and I'd like to align the first to the left and the latter do the right: My Current Chapter

Re: [libreoffice-users] Table of contents: How to insert a tab between chapter number and chapter text

2013-01-08 Thread J.A. de Vries
On 2013-01-08 09:45, Giuseppe Greco wrote: > Thanks J.A, > > This was my first try... but I got a strange result: > > 1 Chapter..1 >1.1..Section > 1 >1.2.

Re: [libreoffice-users] Table of contents: How to insert a tab between chapter number and chapter text

2013-01-08 Thread Giuseppe Greco
Thanks J.A, This was my first try... but I got a strange result: 1 Chapter..1 1.1..Section 1 1.2..Section 1 The first level worked fine, while the s

Re: [libreoffice-users] Table of contents: How to insert a tab between chapter number and chapter text

2013-01-08 Thread J.A. de Vries
On 2013-01-08 07:12, Giuseppe Greco wrote: > Dear all, > > I'm creating a document template and I've added a table of contents. By > default, the table of contents does not have numbering... so I've just > enabled it. So far so good. The problem is that there is no space or tab > between chapter n