[libreoffice-users] Writer: Page numbers in ToC

2011-10-24 Thread mjormakka
Hello, I have a document that contains a cover page, abstract, toc and the actual text content chapters. Technically the first content chapters begin from page 4, but I have defined the page numbering in the document so that it restarts from the toc page making the first text chapter page appear

Re: [libreoffice-users] Writer: Page numbers in ToC

2011-10-24 Thread Regina Henschel
Hi mjormakka, mjormakka schrieb: Hello, I have a document that contains a cover page, abstract, toc and the actual text content chapters. Technically the first content chapters begin from page 4, but I have defined the page numbering in the document so that it restarts from the toc page making

[libreoffice-users] Re: I want to add formulas and functions to calc

2011-10-24 Thread ES Champ
I'm interested in that, too. On Sat, 22 Oct 2011 21:12:59 -0400, you wrote in gmane.comp.documentfoundation.libreoffice.user: Hi all, I'm a finance major so I use excel a lot, but I don't have the money for it so I use calc. I see that there's is a lot of financial formulas that are

[libreoffice-users] Re: I want to add formulas and functions to calc

2011-10-24 Thread ES Champ
I'm interested, too On Sat, 22 Oct 2011 21:12:59 -0400, you wrote in gmane.comp.documentfoundation.libreoffice.user: Hi all, I'm a finance major so I use excel a lot, but I don't have the money for it so I use calc. I see that there's is a lot of financial formulas that are missing but

[libreoffice-users] Re: I want to add formulas and functions to calc

2011-10-24 Thread ES Champ
Thanks. On Sat, 22 Oct 2011 22:20:44 -0400, Steve Edmonds steve.edmo...@ptglobal.com wrote: Hi. http://help.libreoffice.org/Calc/User-Defined_Functions steve On 23/10/11 14:12, Alberto Sanchez wrote: Hi all, I'm a finance major so I use excel a lot, but I don't have the money for it so

[libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread ES Champ
On Sat, 22 Oct 2011 14:20:23 -0400, Yogi bar...@hotmail.com wrote: I'm using LibreOffice 3.4.3 on a Windows 7 Ultimate machine. All my work is saved on the same hard drive as the installed copy of LibreOffice, F:\ All works well there. From time to time I manually copy the files stored

[libreoffice-users] Re: Attach files to records in Base

2011-10-24 Thread Alex Thurgood
Le 23/10/2011 23:34, MsBriscow a écrit : Hi Anne, The idea is to attach all the files associated with a specific record so that I have everything in one place. Is this even possible without me having to write an app? I could probably install an extension if I knew where and how to find one.

[libreoffice-users] Re: hyperlink toolbar

2011-10-24 Thread Alex Thurgood
Le 23/10/2011 22:48, PeterRoots a écrit : Hi Peter, Problem No hyperlink toolbar - have a hyperlink button for adding them to docs but not the one pictured in Help. Does this work/should it work? I seem to recall that the hyperlink toolbar as previously know was being phased out /

[libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Alex Thurgood
Le 22/10/2011 19:20, Yogi a écrit : Hi Yogi, From time to time I manually copy the files stored on my internal drive F:\ to a network attached storage (NAS) hard drive for backup purposes. When I double click the file on the NAS drive it will not open. The right click context menu will

[libreoffice-users] Re: Attach files to records in Base

2011-10-24 Thread Alex Thurgood
Le 23/10/2011 23:34, MsBriscow a écrit : Hi Anne, The link below covers image insertion/display : http://user.services.openoffice.org/en/forum/viewtopic.php?f=83t=44124 for other binary objects, you would have to search through the Base forum. Alex -- For unsubscribe instructions e-mail

[libreoffice-users] Sel-defined formulas insertng in Calc

2011-10-24 Thread plmvantooren
Dear sirs, I would like to insert sel-developped formulas into Calc for frequent use. I have read the help-file of LibreOffice.org Help. I have made the steps suggested in that report Calc/user-defined Functions However, the formula in the help-file does not work in Calc. I get in Calc using the

[libreoffice-users] Re: Attach files to records in Base

2011-10-24 Thread Alex Thurgood
Le 23/10/2011 23:34, MsBriscow a écrit : Hi Anne, Further to my previous message, there is a discussion on BLOB/CLOB support in Base here : http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=40606p=187057hilit=database+binary+object#p187057 Note that Base with the current 1.8

[libreoffice-users] Re: Writer: Page numbers in ToC

2011-10-24 Thread mjormakka
Thanks for the help. I got it right now. I had missed the Change page number check box. -- View this message in context: http://nabble.documentfoundation.org/Writer-Page-numbers-in-ToC-tp3447394p3447710.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

Re: [libreoffice-users] Sel-defined formulas insertng in Calc

2011-10-24 Thread Stephan Zietsman
plmvantoo...@hetnet.nl wrote: I get in Calc using the formula VOL(aA1;B1;C1) only the message #NAAM? This will mean that the name of the function is not recognized by Calc. What is wrong in what I have done, following the instructions in the report   Calc/user-defined Functions? Not sure if

Re: [libreoffice-users] Sel-defined formulas insertng in Calc

2011-10-24 Thread Regina Henschel
Hi Paul, plmvantoo...@hetnet.nl schrieb: Dear sirs, I would like to insert sel-developped formulas into Calc for frequent use. I have read the help-file of LibreOffice.org Help. I have made the steps suggested in that report Calc/user-defined Functions However, the formula in the help-file

[libreoffice-users] Update to MySQL Native Connector for Linux 32bit

2011-10-24 Thread Alex Thurgood
Hi all, Just to let you know that I've updated the Linux 32bit mysql connector extension, which you can download here : http://extensions-test.libreoffice.org/extension-center/mysql-native-connector-for-mac-osx/releases/1.0.1/mysql-native-connector-1.0.1-linux-32bit @Heinrich : Can you

[libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Yogi
Do you get an error message? What is it? No error messages. After clicking on the target file the LibreOffice splash screen appears but then shuts down without ever opening the document. ES Champ wrote: On Sat, 22 Oct 2011 14:20:23 -0400, Yogi lt;baradj@gt; wrote: -- For

[libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Yogi
Alexander Thurgood wrote: Le 22/10/2011 19:20, Yogi a écrit : Hi Yogi, Is your NAS a SMB mounted ? (probably, I think that's what most are by default). There are known issues with reading/writing to SMB shares with current versions of LibO, these are already in the bug reporting

[libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Alexander Thurgood
Le 24/10/11 14:04, Yogi a écrit : I'm talking about Windows here - I believe SMB shares are unique to Linux. The NAS is a Windows share and functioned perfectly under Open Office. I also have an Ubuntu virtual machine and can test it there as well, but my primary use of LibreOffice is in

[libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Yogi
SMB/CIFS more or less the same (Microsoft renamed Server Message Block protocol to Common Internet File System). The point is, does your NAS drive use the CIFS protocol to allow access to files stored on it ? Alex Yes, CIFS is one of the supported network protocols. I'm using Synology's DS109

[libreoffice-users] Font attributes will not save in Calc

2011-10-24 Thread Emil Richard Ellison
I have tried saving font changes (to Arial Black from Times New Roman) many times in Calc. I need this due to problems with poor vision. Each time I reload the document I have to do it again (block, change, and re-save). It is a three-page spreadsheet. Am I doing something wrong? -- View this

[libreoffice-users] Two in One Page

2011-10-24 Thread Onyeibo Oku
I introduced a friend to LibreOffice and ever since I've become some sort of support personnel. Her office is downstairs, mine is above. Now there's a new problem and I lack the experience. I never did any such thing in M$-Word too. She wants two pages to print on one paper (like having two A5

[libreoffice-users] Font disappears in Draw text box

2011-10-24 Thread ProWorks1
I'm running LibreOffice 3.4.3 on a MacBook Pro 2010 with OSX Lion 10.7.2 - when creating a Draw document any text box defaults to the font Arial, which is fine. However, when changing to certain fonts loaded in mt system, they will not appear in the text box - a blank area will show as selected,

Re: [libreoffice-users] Two in One Page

2011-10-24 Thread Tom Davies
Hi :) I think it's a setting of the printer rather than within LibreOffice. When you try to print there is a dialogue-box. At the top is a drop-down menu to select which printer to use and beside that is a Properties button. Then the printer's dialogue-box appears and hopefully makes some

[libreoffice-users] Re: Sel-defined formulas insertng in Calc

2011-10-24 Thread Tom
Hi :) If the document is not confidential then you could always upload it to Nabble. Hopefully there is a link in this message that gets you to the right thread in the Nabble 'forum'. Regards from Tom :) -- View this message in context:

Re: [libreoffice-users] Two in One Page

2011-10-24 Thread webmaster for Kracked Press Productions
I loaded a large multi page A4 document [hard to find since I use Letter] in Writer. I then did the following: File Print Page Layout This should show you the option to print several pages on one sheet face. Plus you have the option to place a border around each page on the sheet. I use

[libreoffice-users] Re: Two in One Page

2011-10-24 Thread Pedro
Onyeibo Oku-2 wrote: She wants two pages to print on one paper (like having two A5 page texts showing on one A4 paper). She wants it visible on screen with page numbers showing for both sheets -- one on left and the other on right side of the ONE mother page. On the Print dialog (File,

Re: [libreoffice-users] Font attributes will not save in Calc

2011-10-24 Thread Dean Chia
And if I can compound to this problem - same thing applies to say page formatting in Writer - I reconstruct margins and header/footer stuff, and it doesn't appear when I open a new document... Dean On Mon, Oct 24, 2011 at 9:38 AM, Emil Richard Ellison emilrich...@msn.comwrote: I have tried

Re: [libreoffice-users] Two in One Page

2011-10-24 Thread Bob Williams
On 24/10/11 14:51, Onyeibo Oku wrote: I introduced a friend to LibreOffice and ever since I've become some sort of support personnel. Her office is downstairs, mine is above. Now there's a new problem and I lack the experience. I never did any such thing in M$-Word too. She wants two pages to

[libreoffice-users] Re: Update to MySQL Native Connector for Linux 32bit

2011-10-24 Thread Alexander Thurgood
Le 24/10/11 15:31, Tom Davies a écrit : Hi :) Great stuff. Good work :) So it's there for Mac OS X and Linux 32bit. I take it thattit doesn't matter whether normal installs are done via .deb or .rpm as the oxt bypasses both methoods? Thanks Alex Hi Tom, It is neither a deb nor a rpm,

Re: [libreoffice-users] Re: Update to MySQL Native Connector for Linux 32bit

2011-10-24 Thread Tom Davies
Hi :) Thanks :) and thanks for the warning note too! :) Regards from Tom :) --- On Mon, 24/10/11, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: Update to MySQL Native Connector for Linux 32bit To:

Re: [libreoffice-users] I want to add formulas and functions to calc

2011-10-24 Thread Tom Davies
Hi :) So, a good oppotunity to get ahead of the game then. I guess there are add-on packages or something for MS Office that might not be so easy to find as our extensions website? Regards from Tom :) --- On Sun, 23/10/11, Brian Barker b.m.bar...@btinternet.com wrote: From: Brian Barker

Re: [libreoffice-users] Two in One Page

2011-10-24 Thread Regina Henschel
Hi, Onyeibo Oku schrieb: I introduced a friend to LibreOffice and ever since I've become some sort of support personnel. Her office is downstairs, mine is above. Now there's a new problem and I lack the experience. I never did any such thing in M$-Word too. She wants two pages to print on one

[libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Alexander Thurgood
Le 24/10/11 15:10, Yogi a écrit : Yes, CIFS is one of the supported network protocols. I'm using Synology's DS109 http://www.synology.at/us/products/DS109/spec.php http://www.synology.at/us/products/DS109/spec.php Thanks, but that doesn't tell me what yours is actually running, merely

Re: [libreoffice-users] Two in One Page

2011-10-24 Thread Onyeibo Oku
You peoples are awesome! Regina gives the most descriptive answer. Tom, how did U know I sent the question from a phone? I guess my signature gave me away. I was at her office then and she doesn't have internet (which rules out the option of posting her questions to this list by herself). In

Re: [libreoffice-users] problem with the pictures

2011-10-24 Thread Tom Davies
Hi :) Is this something to do with the Anchor Point? I tend to find that right-clicking on an image and changing the Anchor Point to Anchor to page or ... to paragraph seems to fix the picture on the page better. I don't think i have found the perfect way of doing this tho. Also when the

Re: [libreoffice-users] problem with the pictures

2011-10-24 Thread Frieder
Hi I don't know which Version of LO you have, butt if you use LO3.4.3 than it is probably the following Bug: https://bugs.freedesktop.org/show_bug.cgi?id=37083 In LO3.3.4 this Bug doesn't exist. @Tom: Sometime it is not possible to anchor to page. For example if you need to hide and reshow

Re: [libreoffice-users] Two in One Page

2011-10-24 Thread Tom Davies
Hi :) Thanks for the flowers (as they say). People from Windows-land are mostly only familiar with phone-support which makes it difficult to copypaste the answers that are spoken and impossible to give screen-shots or attachments. I guss it's better with smart-phones but then you get into the

Re: [libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Tom Davies
Hi :) Ahh, this explains some problems i was having. I thought it was just because i had been relegated to the duff machine at work while i was doing all the installing and defragging on the others. So many problems that magically didn't happen on the newer machines. Regards from Tom :)

Re: [libreoffice-users] Two in One Page

2011-10-24 Thread webmaster for Kracked Press Productions
On 10/24/2011 10:28 AM, Bob Williams wrote: On 24/10/11 14:51, Onyeibo Oku wrote: I introduced a friend to LibreOffice and ever since I've become some sort of support personnel. Her office is downstairs, mine is above. Now there's a new problem and I lack the experience. I never did any such

[libreoffice-users] problem with formulas

2011-10-24 Thread macq22
Hello, i've got a problem. I have polish version of libreoffice but all formulas in calc are in english. I mean if i want to calculate average i have to use AVERAGE() instead of polish ŚREDNIA(). It wouldn't be problem but there are polish function names in help. What can i do to make polish

Re: [libreoffice-users] problem with formulas

2011-10-24 Thread Stefan Weigel
Hi, Am 24.10.2011 18:34, schrieb macq22: Hello, i've got a problem. I have polish version of libreoffice but all formulas in calc are in english. I mean if i want to calculate average i have to use AVERAGE() instead of polish ŚREDNIA(). It wouldn't be problem but there are polish function

Re: [libreoffice-users] problem with formulas

2011-10-24 Thread Tom Davies
Hi :) I think the problem is that translations are not complete and so the untranslated bits revert to English. I think the best way to deal with it is to encourage a few Polish speakers to join in with the translations teams http://www.libreoffice.org/get-involved/localizers/ However it

[libreoffice-users] Re: hyperlink toolbar

2011-10-24 Thread PeterRoots
Alex Thanks So is a web search possible from inside Writer by any means at all? If not, what is the internet search setting for in Options? Peter On Monday 24 Oct 2011 01:55:43 you wrote: Le 23/10/2011 22:48, PeterRoots a écrit : Hi Peter, Problem No hyperlink toolbar - have a hyperlink

Re: [libreoffice-users] problem with formulas

2011-10-24 Thread Tom Davies
Hi :) Ok, ignore my last email about this. The bug-report that Stefan pointed to gives more and better info. Hopefully it will get fixed now that the Paris Conference is over unless Ubuntu has a freeze on translations at the moment. I'm fairly sure it doesn't so hopefully the problem

Re: [libreoffice-users] problem with formulas

2011-10-24 Thread Johnny Rosenberg
There is a setting for this, maybe it's not set properly? Tools → Options… → LibreOffice Calc → Formula → ☒ Use English function names Should be: Tools → Options… → LibreOffice Calc → Formula → ☐ Use English function names Or maybe it's the bug that's already mentioned. Kind regards Johnny

Re: [libreoffice-users] Re: hyperlink toolbar

2011-10-24 Thread Manfred J. Krause
Hi, On Mon, Oct 24, 2011 at 4:50 PM, PeterRoots wrote: [...] So is a web search possible from inside Writer by any means at all? I'm using the extension 'OKDict' http://www.kilargo.com/en/products/okdict . If not, what is the internet search setting for in Options? [...] 'Tools Options

Re: [libreoffice-users] problem with formulas

2011-10-24 Thread Tom Davies
Hi :) Johnny, that might be a good work-around. I think the problem at the moment is that it's difficult to know whether the formula needs to be in English or as per the documentation for any of those languages. At least by forcing it into English people know what will work. My guess is that

[libreoffice-users] Altered use of CTRLF in Writer

2011-10-24 Thread William W. Austin
In 3.4, the behavior of the ^F is altered so that a brower-style window pops up at the bottom of the screen. While some folks may like that I find it to be an annoyance (this being the only app for which I have to have a different sequence for find-and-replace - and yes, I don't use windows

[libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Yogi
Alexander Thurgood wrote: Le 24/10/11 15:10, Yogi a écrit : Thanks, but that doesn't tell me what yours is actually running, merely what it supports (quite a lot, which is pretty good). What we don't know is which network protocol the NAS is offering your Windows client - my guess would

[libreoffice-users] LibreOffice Document Recovery error message

2011-10-24 Thread Jonathon Waterman
Recently, ever type I exit out of LibreOffice 3.4.3 I get a box with the following error message. LibreOffice Document Recovery Due to an unexpected error, LibreOffice crashed. All the files you were working on will now be saved. The next time LibreOffice is lunched , you files with be recovered

Re: [libreoffice-users] LibreOffice Document Recovery error message

2011-10-24 Thread Tom Davies
Hi :) Have you tried re-naming your user-profile? If it works you could then copy back some of the sub-folders to regain some of your settings and configurations, extensions and so on. This guide might help http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12426 Good luck and

Re: [libreoffice-users] Altered use of CTRLF in Writer

2011-10-24 Thread Calvin Kim
I also found this behavior little odd at first. But I settled with Ctrl+Alt+F which is Find and Replace. On 10/24/2011 2:37 PM, William W. Austin wrote: In 3.4, the behavior of the ^F is altered so that a brower-style window pops up at the bottom of the screen. While some folks may like that

Re: [libreoffice-users] LibreOffice Document Recovery error message

2011-10-24 Thread Jonathon Waterman
That's seems to have resolved the problem. Thanks! On Mon, Oct 24, 2011 at 3:51 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Have you tried re-naming your user-profile? If it works you could then copy back some of the sub-folders to regain some of your settings and configurations,

Re: [libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Tom Davies
Hi :) Ahah, i was wondering what happens if you copy the files that don't work from the NAS back onto the machine you are using? Do they work when they are back on your machine? - using the NAS as back-up and storage but not for working on files actively? I don't know if there is a Windows

Re: [libreoffice-users] LibreOffice Document Recovery error message

2011-10-24 Thread Tom Davies
Hi :) Congrats, Nicely fixed :) You can probably get some of your extensions and things back by following the advice under fixed in this post by Hagar Delest http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12426#p58403 Regards from Tom :) --- On Mon, 24/10/11, Jonathon

Re: [libreoffice-users] Altered use of CTRLF in Writer

2011-10-24 Thread Mirosław Zalewski
Go to Tools - Customize - Keyboard. Under Category list select Edit. Under Function list select Find Replace. In shortcut keys find Ctrl+F and click Modify button on the right. Now click OK and that's it -- you have restored the old behavior. You can do it for Writer only or for whole

Re: [libreoffice-users] LibreOffice Document Recovery error message

2011-10-24 Thread Jonathon Waterman
Thanks for the info. I'm familiar with Hagar's assistance from back in the days I used to experiment with OpenOffice. Fortunately, whenever I get a new extension I keep a copy of it on my harddrive - so reinstalling them wasn't a problem. Thanks for again for your assistance. On Mon, Oct 24,

[libreoffice-users] Videos (mpeg etc) in Impress

2011-10-24 Thread mikko
Hello, I wonder if I am missing something if anyone else has this same problem: I can embed videos in Impress but I have no control on how they start (simple start on click would be fine), appear, leave or repeat. All the effects work fine for images but inserted videos just start and run once.

Re: [libreoffice-users] bug removal and software update policy

2011-10-24 Thread Tom Davies
Hi :) I think it only affects the translation files. Note that there is no problem if people stick with English. If you need better understanding then the best places to ask are localisation lists or in the bug-report. This list does not routinely deal with translation files and so is

[libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread Yogi
Tom wrote: Hi :) Ahah, i was wondering what happens if you copy the files that don't work from the NAS back onto the machine you are using? Do they work when they are back on your machine? - using the NAS as back-up and storage but not for working on files actively? I don't know if

Re: [libreoffice-users] Altered use of CTRLF in Writer

2011-10-24 Thread Libre User
At first I was also annoyed but now find that I like the new arrangement much better than the old function. Since the small search box at the bottom of the screen is a toolbar, it can be moved. I moved it to an unused piece of real estate at the right side of the top tool bar and then

RE: [libreoffice-users] Re: Documents Not Opening On External Drive

2011-10-24 Thread V Stuart Foote
Fellows, I think you're mixing apples and oranges. Yogi's problem has nothing to do with his DHCP service and is unlikely to be a router issue. SMB (Server Message Block) and CIFS (Common Internet Files System) are the same Microsoft controlled specifications. As a practical matter affecting

[libreoffice-users] Slide with moderately complicated picture stops Impress dead in its tracks

2011-10-24 Thread Peter Langfelder
Hello, this is a re-hash of a problem I saw a year or two ago. Any detailed figure saved in windows metafile format and included in Impress (haven't tried other programs) makes Impress grind to a halt. I observed this with OpenOffice 3.3.x and now also with LibreOffice 3.4.3. Running top in

[libreoffice-users] Re: Attach files to records in Base

2011-10-24 Thread MsBriscow
Thanks for the links. I looked at them and suspect that what I'm trying to do will be too much for the database. It would be nice to create clickable links to the files I'd like to attach, but I think that's beyond my skills at present and I really don't have the time to learn. Sigh. You gave

[libreoffice-users] Re: hyperlink toolbar

2011-10-24 Thread PeterRoots
mjk thanks for the clarification and the link ot okdict. shame it is windows only. I will see if I can find anything else along the same lines though as it sounds useful. Peter On Monday 24 Oct 2011 10:59:27 you wrote: Hi, On Mon, Oct 24, 2011 at 4:50 PM, PeterRoots wrote: [...] So is

[libreoffice-users] False Positive Virus detection my MSE for 3.4.3 installer.

2011-10-24 Thread windyweather
http://www.windyweather.net/wp/2011/10/24/false-positive-in-libreoffice-3-4-3-from-mse/ Details of false positive [I assume] virus detection by up to date Microsoft Security Essentials. Win 86 install of 3.4.3 on Windows 7. Not sure if you will notify Microsoft so they can fix definitions or