Fwd: [libreoffice-users] Value and Date function in Macro

2013-02-10 Thread Johnny Rosenberg
Oh no, I did it again! I sent yet another reply directly to the original poster. Will I never learn? I really hate the new behaviour of this list, especially since it's the only list that I am subscribed to that behaves this way. Maybe it's the only one that is correct, I don't know, but it annoys

[libreoffice-users] Re: RE-NAMING database (Base) tables is broken in LO v.4?

2013-02-10 Thread Alex Thurgood
Le 08/02/2013 10:32, frofa a écrit : Hi, Also the RENAME option under the mail EDIT menu is dimmed. I have restarted the OS and cleared caches with no result. Open a bug report against the Database component, but please provide detailed information on how to set up your particular

[libreoffice-users] Page count does not match visible pages

2013-02-10 Thread C. H. D.
Hello! I think I have found a bug. I have submitted the bug report. https://bugs.freedesktop.org/show_bug.cgi?id=60594 This potential bug may affect printing, e.g. producing blank pages because the page count does not look correct. Is there any other information which is necessary to

Re: [libreoffice-users] Page count does not match visible pages

2013-02-10 Thread Brian Barker
At 21:36 10/02/2013 +0800, Conly Honly Donly wrote: I think I have found a bug. I'm not so sure. This potential bug may affect printing, e.g. producing blank pages because the page count does not look correct. In double-sided printing, odd-numbered pages need to be rectos, or right-hand

[libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Jean-Francois Nifenecker
Hello, does anyone know if it is possible to retrieve the current page number in a pre-defined variable in Writer? The page count is available through the PAGE var, but I can't find anywhere (or do I have missed smthg?) a way to test against the current page num. The aim is to have some

Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread webmaster-Kracked_P_P
Tom I ram the install on Linux Mint 14 and had no troubles with it. On 02/09/2013 03:07 PM, Tom Davies wrote: Hi :) I downloaded the .Deb for Ubuntu (and others) twice yday and tried installing it as per instructions but when i tried running LibreOffice from the command-line by typing in

Re: [libreoffice-users] How do I change the case of a field in writer?

2013-02-10 Thread Jean-Francois Nifenecker
Le 07/02/2013 16:39, paulwhitehurst a écrit : I'm using writer to import data from a database. Can I set the format on the field so some entries will be all caps and some will only capitalize the first letter of a word? I want to insert names from the database. Most entries I want to have

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Tom Davies
Hi :) how do other people normally do this?  It's possible to have 1st page different isn't it?  Is there a way of having last page different too?  Does everyone do this by having at least 3 page-styles per book?  Regards from Tom :)  From: Jean-Francois

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Jean-Francois Nifenecker
Hello Tom, Le 10/02/2013 16:35, Tom Davies a écrit : how do other people normally do this? It's possible to have 1st page different isn't it? Is there a way of having last page different too? Does everyone do this by having at least 3 page-styles per book? in fact the problem is different

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Mirosław Zalewski
On 10/02/2013 at 15:50, Jean-Francois Nifenecker jean- francois.nifenec...@laposte.net wrote: The aim is to have some text in the footer of any page, but the last one (eg to be cont'd) without regard to the pages styles. As far as I know, you can't do this without different page styles.

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Brian Barker
At 16:41 10/02/2013 +0100, Jean-Francois Nifenecker wrote: I want to have footers with to be cont'd for any page but the last one, ... Do you need to do this? Don't most people know that, in the absence of any indication to the contrary, any incomplete word, sentence, paragraph, article,

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Jean-Francois Nifenecker
Le 10/02/2013 17:22, Brian Barker a écrit : At 16:41 10/02/2013 +0100, Jean-Francois Nifenecker wrote: I want to have footers with to be cont'd for any page but the last one, ... Do you need to do this? Don't most people know that, in the absence of any indication to the contrary, any

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Regina Henschel
Hi Jean-Francois, Jean-Francois Nifenecker schrieb: Hello Tom, Le 10/02/2013 16:35, Tom Davies a écrit : how do other people normally do this? It's possible to have 1st page different isn't it? Is there a way of having last page different too? Does everyone do this by having at least 3

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Jean-Francois Nifenecker
Hi Regina, Le 10/02/2013 17:40, Regina Henschel a écrit : Why do you want to give the information this way? For not binded sheets a phrase k / n is common, where k is the field Page number and n is the field Page count. Yes, I also use the k / n thingy. Yet, here in France, the .../... at

Re: [libreoffice-users] Custom Bitmap for Chart Wall?

2013-02-10 Thread Regina Henschel
Hi Jonathan, Regina Henschel schrieb: Hi Jonathan, Jonathan Levi schrieb: Brian and Regina, Thank you both for your responses. Both methods worked (Regina's had the advantage of not needing a new document) but both also produced an unexpected (and undesired) blurring of the boundary between

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Tom Davies
Hi :) Has anyone been able to fix this yet?  I tend to prefer to spell it out and say Page x of n. but i think i'm alone in doing that.  I have seen the / mark used quite frequently.  It's interesting to see how other countries or other professions or industries do things slightly differently. 

Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread M Henri Day
2013/2/9 Dan Lewis elderdanle...@gmail.com On 02/09/2013 04:21 PM, Jay Lozier wrote: On 02/09/2013 03:07 PM, Tom Davies wrote: Hi :) I downloaded the .Deb for Ubuntu (and others) twice yday and tried installing it as per instructions but when i tried running LibreOffice from the

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Jean-Francois Nifenecker
Le 10/02/2013 18:57, Tom Davies a écrit : Hi :) Has anyone been able to fix this yet? I tend to prefer to spell it out and say Page x of n. but i think i'm alone in doing that. I have seen the / mark used quite frequently. It's interesting to see how other countries or other professions or

Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread Tom Davies
Hi :) my extremely inelegant way would be to uninstall both and then just reinstall the one you do want.  There has to be a lot of better ways to do this though! Regards from Tom :)  From: M Henri Day mhenri...@gmail.com To: Dan Lewis

Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread Don Myers
Tom, I used the following instructions to upgrade to LibreOffice 4.0.0.3 on three machines with Ubuntu 12.10. It has worked really well so far. No issues installing or using it. The bug that made some functions in Base run unacceptably slow have been fixed!!! *Instructions for the 64

Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread sun shine
On 10/02/13 18:13, Tom Davies wrote: Hi :) my extremely inelegant way would be to uninstall both and then just reinstall the one you do want. There has to be a lot of better ways to do this though! Regards from Tom :) From: M Henri Day mhenri...@gmail.com

Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread Don Myers
Hi Tom, This method should uninstall all LibreOffice versions at one time. I've seen one person recommend using a purge command also to make sure all LibreOffice elements are removed. This method really works very well. Just paste three commands in a terminal and you have a complete new

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Jay Lozier
On 02/10/2013 12:57 PM, Tom Davies wrote: Hi :) Has anyone been able to fix this yet? I tend to prefer to spell it out and say Page x of n. but i think i'm alone in doing that. I have seen the / mark used quite frequently. It's interesting to see how other countries or other professions or

[libreoffice-users] Find out a name of inserted image in Impress

2013-02-10 Thread v_2e
Hello! I have some problem with opening a presentation created in Impress v.3.5 with a new Impress v.4.0.0.3. Particularly, it turned out that some images are absent on the slides in 4.0 while they are present when I open the presentation on my friend's PC with LO 3.6 on it. So, I do not

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Jean-Francois Nifenecker
Le 10/02/2013 20:07, Jay Lozier a écrit : I have mostly seen either Page x of y, x, or more rarely x of y in the US. The x / y page notation is not very common from what I have seen in the US. x / y is extensively used 'round here. Page x sur y is also met but less often. -- Jean-Francois

Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread M Henri Day
2013/2/10 Don Myers donmy...@myersfarm.com Hi Tom, This method should uninstall all LibreOffice versions at one time. I've seen one person recommend using a purge command also to make sure all LibreOffice elements are removed. This method really works very well. Just paste three commands in

Re: [libreoffice-users] Find out a name of inserted image in Impress

2013-02-10 Thread Tom Davies
Hi :) If you create a copy of the file and then change the file-ending from .pptX or .odp to .zip then you can double-click to open the file as though it was a compressed file.  There should be a folder called Images or something similar.  The images might still be in there but somehow just not

Re: [libreoffice-users] Find out a name of inserted image in Impress

2013-02-10 Thread v_2e
Hello! On Sun, 10 Feb 2013 20:08:06 + (GMT) Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) If you create a copy of the file and then change the file-ending from .pptX or .odp to .zip then you can double-click to open the file as though it was a compressed file.  There should be a

Re: off-list Re: [libreoffice-users] Serious problems with Insert Movie and Sound... on MAC OS X 2 bugs.

2013-02-10 Thread Declan Moriarty
I have subscribed to the list again.  I didn't get any responses to the email requesting help with inserting Movie and Sound.  I submitted 2 bugs about the subject.  One about the text wrapping problem and the other not being able to play videos in OS X Snow Leopard.  The latter is a regression

Re: off-list Re: [libreoffice-users] Serious problems with Insert Movie and Sound... on MAC OS X 2 bugs.

2013-02-10 Thread V Stuart Foote
Declan, Saw your bugs when you filed them the first time and also the email to the forum. One thing that is very helpful is if in your ML exchanges regards bugzilla reporting your include your bug ID. Yours are: fdo#60218 https://bugs.freedesktop.org/show_bug.cgi?id=60218 for Writer text

Re: Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread Edwin Powell
I installed it with no problems using the procedure outlined at: http://mylinuxexplore.blogspot.com/2013/02/ubuntu-precise-install-libreoffice-400.html. I'm really liking 4.0 so far... On 02/09/2013 04:21 PM, Jay Lozier wrote: On 02/09/2013 03:07 PM, Tom Davies wrote: Hi :) I downloaded the

[libreoffice-users] How-To bump a thread

2013-02-10 Thread Tom Davies
Hi :) Generally it's bad ettiquette to bump a thread, particularly your own, without good reason.  No response for a couple of days after the initial posting is a very good reason though.   To bump it simply reply to it and make sure your reply gets to the list.  Often an initial post might

Re: [libreoffice-users] Page count does not match visible pages

2013-02-10 Thread C. H. D.
Hello! Thanks for responding and giving advice. I am glad that I have supplied enough information for the Quality Assurance team to reproduce this issue. Thanks a lot. I have tried: (both checking and unchecking) Tools | Options... | LibreOffice Writer | Print | Other | Print automatically

Re: [libreoffice-users] Value and Date function in Macro

2013-02-10 Thread Joel Madero
On 02/09/2013 06:58 PM, Andrew Douglas Pitonyak wrote: On 02/08/2013 05:15 PM, Joel Madero wrote: Hi All, I have a macro setup that can easily do the following: pasteValue = mid(currentCellValue,1,4) What is the format of currentCellValue? You grab the first four characters in your example

Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread Don Myers
Hi Henri, I'm glad you have everything working well, and in the manner which you like! Don On 02/10/2013 02:40 PM, M Henri Day wrote: 2013/2/10 Don Myers donmy...@myersfarm.com Hi Tom, This method should uninstall all LibreOffice versions at one time. I've seen one person recommend

Re: [libreoffice-users] Re: Installing the Deb

2013-02-10 Thread webmaster-Kracked_P_P
I do not like all that typing. What I do is use the default file manager and double click the archived file and unarchive it. Then I take the folder that is created and rename it to Lib or LibO. That way you do not need to type all of the characters of the folder's name. I also do not

[libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-10 Thread C. H. D.
Hello! I cannot open a particular file in LibreOffice, but I can open it in Microsoft Office. I would appreciate it if you take a look. https://bugs.freedesktop.org/show_bug.cgi?id=60390 Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- For unsubscribe instructions e-mail to:

[libreoffice-users] Version 4.0 - Enjoying it?

2013-02-10 Thread Joel Madero
Hi All, I hope you're all enjoying the new release of LibreOffice 4! For those of you who are finding LibreOffice to be a great productivity suite I encourage you to head over to http://donate.libreoffice.org/ and donate a few dollars to allow our great team of developers to continue

Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-10 Thread Jay Lozier
On 02/10/2013 10:35 PM, C. H. D. wrote: Hello! I cannot open a particular file in LibreOffice, but I can open it in Microsoft Office. I would appreciate it if you take a look. https://bugs.freedesktop.org/show_bug.cgi?id=60390 Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I

Re: Fwd: [libreoffice-users] Value and Date function in Macro

2013-02-10 Thread Andrew Douglas Pitonyak
On 02/10/2013 04:49 AM, Johnny Rosenberg wrote: Oh no, I did it again! I sent yet another reply directly to the original poster. I feel your pain! :-) -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe

RE: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-10 Thread V Stuart Foote
https://bugs.freedesktop.org/show_bug.cgi?id=60390 Comment # 2 on bug 60390 from V Stuart Foote Also, confirm that ref file will not open in Windows build of LibreOffice 4.0.0 rc3. But on same system it will open in Office 2007 with no issue. And interestingly will also open in an Apache

Re: [libreoffice-users] Page count does not match visible pages

2013-02-10 Thread Brian Barker
At 08:39 11/02/2013 +0800, Conly Honly Donly wrote: 2013/02/10 10:42 PM, Brian Barker: At 21:36 10/02/2013 +0800, Conly Honly Donly wrote: I think I have found a bug. I'm not so sure. This potential bug may affect printing, e.g. producing blank pages because the page count does not look