Re: [libreoffice-users] Word 2003 to Libre Writer - Comparison Chart
Hello, sent also to [design] as I think this is where it pertains. Le 12/11/2012 18:27, charles meyer a écrit : Hi Folks, MS Word has a comparison chart which shows you how to perform certain tasks in Word compared to how you effect them in WordPerfect. It's an easy chart to check (and learn) Word if you've been a WordPerfect user. Ex. Ctrl/F8 will perform a certain task in WordPerfect but that same task is done with different function key combinations in Word I was wondering if anyone has come across a similar comparison chart for Libre Writer and Word, especially Word 2003? The chart would show how a task is done in Word and then next to it would reveal how that task is done in Libre Writer. On the same goal and idea, I had suggested a *lng* time ago on the French OOo lists to create a set of keyboard shortcuts that would help the MS-Word power users switching to Writer. Beginners and standard users can switch quite easily. They haven't a thorough knowledge of the tool and usually just use the menus to get to the functionalities they need (argh!). Power users have long understood that the keyboard is a tool of productivity. Thus, they use keyboard shortcuts widely. As Word and Writer have different sets of shortcuts (at least they had when I left MS-Word alone, a long time ago), it could be an interesting work to port the Word shortcuts into Writer. We could then offer an easy transition that would fill a big gap for these people, helping them to switch tools more quickly. What do you think? Do I miss something? Note that this is just an idea. I have to-day no clue to what the Word shortcuts are vs Writer ones. -- Jean-Francois Nifenecker, Bordeaux -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] missing file in libreoffice 3.6.3
Hi :) Arrgh. So it's still not working :( Don't worry about bothering us. That is what we are here for. So, when you installed Fedora did you install on the same machine as your Ubuntu? Did you install over the top of Ubuntu or was it a new partition? Can you still boot into Ubuntu? Is your internet connection able to deal with updates now? If so then in Fedora can you force PackageKit (or whatever you use as a package-manager) to look for all updates for everything? There should (hopefully) be a button somewhere saying Updates. I think you can install Synaptic Package Manager which might be more familiar and easier for you to use. A couple of years ago they made it able to deal with rpms as well as debs (depending on which distro you install synaptic into, it picks up the right one to use). So, old timers still worry about using synaptic for Rpm distros but it's fine now. I found this link https://fedoraproject.org/wiki/User_Guide_-_Managing_Software There is a drop-down at the top left to change to a better language for you. At the moment it's set on English which seems fine but you can change if you like. Fedora 17 should have LibreOffice 3.5.2 installed by default and that should be a reasonably good version to use. Do you still have the Fedora Cd? Do you have enough space on your hard-drive to do an extra install to experiment? Alternatively you might have more success using the Fedora Cd as a LiveCd. Live Cd means just boot up straight from the Cd and avoid installing. It should get you to a usable desktop with LO (3.5.2) ready to use. LiveCd is a bit slower than a proper hard-drive install but it's a good way to get a working system uprunning quickly. Just avoid configuring it or installing extra programs, just use it as is. Also if you save stuff make sure it's to your network-fileshares or proper hard-drive and NOT Documents (or Desktop, or whatever) inside the Live Cd session. The local files vanish when you take the Cd out or reboot. Ones on your hard-drive are still there of course. Regards from Tom :) From: abdullah Al-Ammari أبو العباس future_m...@hotmail.com To: tomdavie...@yahoo.co.uk Sent: Tuesday, 13 November 2012, 9:50 Subject: RE: [libreoffice-users] missing file in libreoffice 3.6.3 thanks tom, and sorry for all the bothering I install fedora 17 lately (I didn't had internet when I installed it). I used to work over ubuntu and LO works fine. and I install the files from LO official website then I run 'yum install '*.rpm' (apart from desktop files) in terminal and received install completed the LO Icons shown in app. menu but nothing works. sorry again and appreciate you help man I have to submit my final report of Co-Operative program to my instructor within 10 days and prepare my presentation too. best wishes Abdullah Date: Fri, 9 Nov 2012 19:32:30 + From: tomdavie...@yahoo.co.uk Subject: Re: [libreoffice-users] missing file in libreoffice 3.6.3 To: future_m...@hotmail.com; users@global.libreoffice.org Hi :) LibreOffice should work fine without java. Sorry i only just now found your 1st email today. So, your OS is Fedora. Does LibreOffice work well enough without the desktop integration packages? I think that is the first thing to check. Then you can try again with the freedesktop-menus if you haven't already got that working by now. (Sorry i know you probably haven't been able to work at this today as it's Friday) Regards from Tom :) From: abdullah Al-Ammari أبو العباس future_m...@hotmail.com To: tomdavie...@yahoo.co.uk; users@global.libreoffice.org users@global.libreoffice.org Sent: Friday, 9 November 2012, 4:58 Subject: RE: [libreoffice-users] missing file in libreoffice 3.6.3 thanks tom, I install the file three time. it contains the RPMS folder with 54 items (.rpm) and it runs OK the subfolder desktop-integration - I thought it has something to do with the installing but it seems not - contains -freedesktop-menus -mandriva-menus -suse-menus the redhat-menus not there - which is for fedora dist. however, I re-install the files again, it is exactly the same as what I already installed and the program still not working. I wonder if the java components have anything to do with that ( I just install them lately ) I'll try to uninstall it and re-install it again.. Date: Wed, 7 Nov 2012 16:05:31 + From: tomdavie...@yahoo.co.uk Subject: Re: [libreoffice-users] missing file in libreoffice 3.6.3 To: future_m...@hotmail.com; users@global.libreoffice.org Hi :) Please can you try downloading again from https://www.libreoffice.org/download/ Well, navigate from there to the right language for you. This link is to the next page, the one that lets you select which Operating System you are using. https://www.libreoffice.org/download/?nodetect Are
[libreoffice-users] Inserting an OLE as an Icon and Create Package
Hi I am trying to insert an object in OLE. The steps i am following: Insert - Object - OLE Object - further objects - create from file - browse - select the file - select the display as icon - OK. at this stage instead of inserting the object the program is asking for create package - browse etc. i was at a loss to understand this. I experimented but could not come to a conclusion or insert the object as icon in Calc or Writer. (Version 3.6.0.4 (Build ID: 932b512), win 7, 64 bit. I am attaching the screen shot file along with this for ready reference. thanks Gopi Krishna V Sr. Manager Admin SoCtronics Technologies Pvt. Ltd. Plot No. 89 90, Road No.2, Banjara Hills, Hyderabad 500034, India. P: +91 40 3061 F: +91 40 30615560 M: +91 9912379998 -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Downloading the new LO
Hi All A friend of mine has just got herself a new HP computer (Desktop). Rather nice!! And - naturally it came with Windows-7 installed as well as a trial version of MS Office. She asked me to set it all up for her but that she did NOT want to use MSOffice and would I later, (maybe in January), consider changing it over to Linux for her. This I agreed to and suggested I get her the latest LO Suite so she can do her immediate work AND still be able to take it back to School, (she's a Teacher), for them to use there as well, (the School is on MS Office!!). So off I went to download the latest LO for Windows - - - - - Can't find it!!! All I find is some strange BitTorrent thing which I'm NOT interested in, don't know about, can't understand the info on their pages and, with out Bandwidth problems here in SA, don't want anything to do with!! *SO* - Bottom line Where can I find a plain old .exe installer for LO 3.6.3? *PS* - I'm also wanting to upgrade my PCLinuxOS version as well - so where are the plain rpm files for this?? Thanks for any help. IanW Pretoria RSA. -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Downloading the new LO
Hi Ian, You can download at http://www.libreoffice.org/download/ and click on main installer, just above the bit torrent link. I find it quite confusing as well. About the rpm - I should have a look at home, on my linux, but I'm convincedyou'll find some guidings when you google rpm libreoffice or ubuntu libreoffice (that's how I found it) Met vriendelijke groeten, Salutations distinguées, Kind Regards, *DRIES FEYS* *CORPORATE SERVICES* • *Specialist Software Developer* T +32 56 43 42 45 • F +32 56 43 44 46 • dries.f...@tvh.com *TVH GROUP NV* Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com On 13 November 2012 15:10, Ian Whitfield whitfi...@telkomsa.net wrote: Hi All A friend of mine has just got herself a new HP computer (Desktop). Rather nice!! And - naturally it came with Windows-7 installed as well as a trial version of MS Office. She asked me to set it all up for her but that she did NOT want to use MSOffice and would I later, (maybe in January), consider changing it over to Linux for her. This I agreed to and suggested I get her the latest LO Suite so she can do her immediate work AND still be able to take it back to School, (she's a Teacher), for them to use there as well, (the School is on MS Office!!). So off I went to download the latest LO for Windows - - - - - Can't find it!!! All I find is some strange BitTorrent thing which I'm NOT interested in, don't know about, can't understand the info on their pages and, with out Bandwidth problems here in SA, don't want anything to do with!! *SO* - Bottom line Where can I find a plain old .exe installer for LO 3.6.3? *PS* - I'm also wanting to upgrade my PCLinuxOS version as well - so where are the plain rpm files for this?? Thanks for any help. IanW Pretoria RSA. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Downloading the new LO
I should have looked better : http://www.libreoffice.org/download/?nodetect Met vriendelijke groeten, Salutations distinguées, Kind Regards, *DRIES FEYS* *CORPORATE SERVICES* • *Specialist Software Developer* T +32 56 43 42 45 • F +32 56 43 44 46 • dries.f...@tvh.com *TVH GROUP NV* Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com On 13 November 2012 15:22, Dries Feys dries.f...@tvh.com wrote: Hi Ian, You can download at http://www.libreoffice.org/download/ and click on main installer, just above the bit torrent link. I find it quite confusing as well. About the rpm - I should have a look at home, on my linux, but I'm convinced you'll find some guidings when you google rpm libreoffice or ubuntu libreoffice (that's how I found it) Met vriendelijke groeten, Salutations distinguées, Kind Regards, *DRIES FEYS* *CORPORATE SERVICES* • *Specialist Software Developer* T +32 56 43 42 45 • F +32 56 43 44 46 • dries.f...@tvh.com *TVH GROUP NV* Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com On 13 November 2012 15:10, Ian Whitfield whitfi...@telkomsa.net wrote: Hi All A friend of mine has just got herself a new HP computer (Desktop). Rather nice!! And - naturally it came with Windows-7 installed as well as a trial version of MS Office. She asked me to set it all up for her but that she did NOT want to use MSOffice and would I later, (maybe in January), consider changing it over to Linux for her. This I agreed to and suggested I get her the latest LO Suite so she can do her immediate work AND still be able to take it back to School, (she's a Teacher), for them to use there as well, (the School is on MS Office!!). So off I went to download the latest LO for Windows - - - - - Can't find it!!! All I find is some strange BitTorrent thing which I'm NOT interested in, don't know about, can't understand the info on their pages and, with out Bandwidth problems here in SA, don't want anything to do with!! *SO* - Bottom line Where can I find a plain old .exe installer for LO 3.6.3? *PS* - I'm also wanting to upgrade my PCLinuxOS version as well - so where are the plain rpm files for this?? Thanks for any help. IanW Pretoria RSA. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] SQL Error on Insert
Hi All My saga continues with getting Base to work with MySQL!! I am almost there but our friend Murphy has caught me yet again. After a MAJOR battle I managed to get all my data out of the old HSQL Database. If I tried to extract it all in one go Base either froze or crashed. So I added a select function to pull out all the 'As, the 'Bs' etc etc and that worked. I then concatenated all the Data in Calc and spent a few days cleaning it all up. Right final step - to INSERT it into the already prepared SQL Databse, (created using My Admin). I tried the SQL scripts in a terminal for well over a day with no results except error messages. While Googling about this I came across a tutorial on how to do this with MyAdmin so decided to go that route. After several hiccups due to differences in Field Names all seemed to be right but do what want I can not get past the error Invalid column count in CSV input on line 1. I have tried everything I can think of and tried all the answers I found after lots of Googling but the problem remains!! Does anyone know what causes this error or better how to fix it?? ANY help would be appreciated IanW Pretoria RSA -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Downloading the new LO
Well, you can simply click on Main installer link to start downloading msi file (just like exe, I don't know exact differences). There are direct links: 3.6.3: http://download.documentfoundation.org/libreoffice/stable/3.6.3/win/x86/LibO_3.6.3_Win_x86_install_multi.msi 3.5.7: http://download.documentfoundation.org/libreoffice/stable/3.5.7/win/x86/LibO_3.5.7_Win_x86_install_multi.msi (you should be aware of LibreOffice version numbering scheme; read there: http://wiki.documentfoundation.org/ReleasePlan ) As for BitTorrent - this is peer-to-peer network used to share files. Basically each user that downloads file also shares it with other users of network. This way download is decentralized. This takes stress out of The Document Foundation servers, making them use less resources and pay less money for maintenance. Also, this is environment friendly and makes our planet greener ;) . To start using bittorrent, you just need dedicated application (called client). There are plenty of these for each operating system out there. Just search web for name of OS torrent client. If you are interested in knowing more, this page seems like a good starting point: http://www.utorrent.com/help/guides/beginners-guide -- Best regards Mirosław Zalewski -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Auto changes on a new spreadsheet set for next year
Thank you again Brian, yesterday I tried all-sorts to try and get this
working, looking at your solution I was nearly there. -- So much to learn.
What is the best source for this sort of information?
I would like to learn more and make my spreadsheets more efficient.
I must admit that the help pages were a bit daunting and I couldn't relate the
example given to my problem.
kind regards
Paul
On Tuesday 13 Nov 2012 05:00:05 Brian Barker wrote:
At 14:42 12/11/2012 +, Paul Stear wrote:
On Thursday 08 Nov 2012 14:19:22 Brian Barker wrote:
At 11:45 08/11/2012 +, Paul Stear wrote:
I have the same spreadsheet set I use each year. The new
spreadsheet for 2013 will need to reference fields in the 2012
spreadsheet. For the past few years I have manually changed the
Readings-2012 in every instance (well over 100).
I would like to be able to construct the spreadsheets with a
method to change the current year, eg 2013 minus 1 to give 2012
inserted so that the ref in the 2013 spreadsheet reads;-
='file:///home/fred/Generation Readings-2012.ods'#$Jan.A68
Is this possible?
Yes. You need to concatenate the required year value with the
strings required before and after it. Suppose that you have the
current year - 2013 in your example - in A1 of your new
spreadsheet. You need to concatenate
'file:///home/fred/Generation Readings- with A1-1 and
.ods'#$Jan.A68. Note that the two single quotes are part of the
string you are creating and the four double quotes delimit the two
text strings, so the first string has a single quote immediately
following its opening double quote. You can carry out this
concatenation using the operator:
='file:///home/fred/Generation Readings-A1-1.ods'#$Jan.A68
(The numerical expression A1-1 is converted to a string value
automatically.)
You might expect this to work, but it doesn't. The formula above
results in a text string which is interpreted literally and not as
a cell reference to the other spreadsheet file. But the trick you
need is available in the INDIRECT() function, which provides the
necessary conversion. So the formula which works is
=INDIRECT('file:///home/fred/Generation Readings-A1-1.ods'#$Jan.A68)
Hi Brian,
Thank you so much, your solution works a treat.
My spreadsheet consists of 15 pages each year, so my next question
is:- would it be possible to put the new year on page 1 named
cover in cell A2 and then change the A1-1 to reference this on
for each instance on every page?
Yes. You refer to a cell on another sheet as sheet.cell. So you
would just need to use ...cover.A2-1... .
Brian Barker
--
mail sent using kmail and kubuntu
--
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 + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Is it possible to show cell value with text
2012/11/13 Viral Orpe viral.o...@yahoo.com: Thanks Johnny, Season's Greetings!! (Today we are celebrating Diwali Festival and New Year here - India) I would like to know what is this language used to talk to Calc? And would appreciate any pointers to any literature, guides etc. I know C and have worked with formulas - this combination is new to me. I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Thanks, Regards, Viral Orpe :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Viral Orpe viral.o...@yahoo.com Sent: Monday, November 12, 2012 11:42 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/12 Viral Orpe viral.o...@yahoo.com: Hi John, Checked your reply on list-archives :) Somehow must have missed on 6th Nov when it first appeared. Please, what is the stand for? =A1 B1 is the same as =CONCATENATE(A1;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Dave_ had asked the question with a + So, I guess this is some standard way of doing things(name?) with slightly diff syntax. I have never known it can be done that way - text and formula together in a cell. I have always used adjacent cells - one with the text part and another with the formula. Any pointers would be great. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory: 4GB, DDR3 OS: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: John Clegg john.cl...@nailsea.net To: Dan Lewis elderdanle...@gmail.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, November 11, 2012 9:59 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text This was a thread from 5th November which I answered to the group. He thanked me but got fooled by the stupid group reply settings. On 11 November 2012 16:24, Dan Lewis elderdanle...@gmail.com wrote: On 11/11/2012 11:03 AM, dave_ wrote: Thanks for the solution. -- View this message in context: http://nabble.** documentfoundation.org/Is-it-**possible-to-show-cell-value-** with-text-tp4016842p4018036.**htmlhttp://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html Sent from the Users mailing list archive at Nabble.com. How can we give you a solution when you have not yet given us the problem? It appears that you are using Calc. But what to you mean by show cell value? Where is the text located? Are you referring to a cell containing twenty-seven rather than 27 for example? Or perhaps ten november two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012? Please be more specific. --Dan -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-design] Re: [libreoffice-users] Word 2003 to Libre Writer - Comparison Chart
Hi Marc, Le 13/11/2012 11:17, Marc Paré a écrit : We had discussed this quite a while ago on the Marketing Team and Ron Faile JR had developed a series of reference cards that could be adapted for this. In fact we did adapt some of these for different booth purposes. When the end product is folded it is formed into a triangular prism that can sit on a desk in front of the keyboard. Have a look here: http://wiki.documentfoundation.org/Marketing/Reference_Cards The reference cards may need checking as they were designed for LibreOffice 3.3 and they still need to be adapted for A4 paper stock. I still have one on my desk and the people I sent it to (educators who tried it with students) said that it was well received by both groups. It is really cool. Unless I'm mistaken, the ref cards you're talking about are a different beast. My suggestion is to have a configurable set of Writer shortcuts so that a Word power user finds his/her usual way of use without the need to learn yet another shortcut set. (BTW, ISTR that I had a proposal for a A4 3-fold refcard.) -- Jean-Francois Nifenecker, Bordeaux -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] - novice question about scalc and C++ uno objects
Hi Andrew, I know you said you don't work with c++/java, but you are only hope I can see so far :-) Hope I am not bothering too much. After a few more find/grep, I found class XSpreadsheetDocument in a dir that I had specified as OO_SDK_OUTPUT_DIR. You were right about the examples being similar. I was able to port most of the lines from Scalc.java to Scalc.cxx. I am now down to last line xSpreadSheetDoc = (XSpreadSheetDocument) UnoRuntime.queryInterface(XSpreadSheetDocument.class, xComp); This looks so java specific, I am not even sure what google or grep. Any links/googlable key words would be appreciated. Thx Neeraj -Original Message- From: Rai, Neeraj [ICG-MKTS] Sent: Tuesday, November 13, 2012 10:16 AM To: 'and...@pitonyak.org'; 'users@global.libreoffice.org' Subject: RE: [libreoffice-users] - novice question about scalc and C++ uno objects Hi Andrew, Thanks for responding. Maybe I am looking in wrong place. The Java examples : http://api.libreoffice.org/examples/examples.html#Java_examples The C++ examples : http://api.libreoffice.org/examples/examples.html#Cpp_examples I see only 4 C++ examples. I can't find the class used in Scalc.java (XSpreadsheetDocument) in sdk/include. Is there any other dir I should look in ? Thanks Neeraj -Original Message- From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] Sent: Tuesday, November 13, 2012 12:20 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] - novice question about scalc and C++ uno objects On 11/12/2012 06:28 PM, Rai, Neeraj wrote: Hi , I am trying to learn about UNO objects and how to remotely update scalc data. I have looked at Scalc.java and would like to convert it to c++. What is the best way to go about it and are there cpp examples publicly available ? The cpp examples that come with libreoffice (remoteclient/docloader etc) don't seem to get interact with scalc. Any pointers / links/ tutorials and samples would be appreciated. Thanks Neeraj Although I don't spend time writing in C++ or Java (to access OOo), my expectation is that the Java and the C++ examples will look very similar. I thought that the examples in the developer's guide were in C++ -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Book Preview button in Print Preview Screen
I've used both the zoom the print previews; how can I stay in these views and edit??? when I begin to edit, it switches to the regular mode. It sure would save a few steps if I could edit in the preview mode ;-) On Mon, Nov 12, 2012 at 4:08 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Errr, i don't think this counts but when you are editing a document you can zoom in and out quite a lot. I sometimes zoom out so far that i can easily see the layout of 12 pages and i think i could zoom out a lot further. It helps me arrange the whole of our company newsletter to be more attractive by making sure the layout of pcitures in amoungst the text is not identical on each page. I can move pictures around and place them roughly and then zoom in to be a bit more precise later. It's not quite the same as a print-preview. Regards from Tom :) From: Dr. R. O Stapf reinh...@stapf-online.com To: users@global.libreoffice.org Sent: Monday, 12 November 2012, 12:29 Subject: Re: [libreoffice-users] Book Preview button in Print Preview Screen Although I am not writing books the feature described by CVAlkan is a very interesting one. Especially if the settings could be made on a document base, rather than general. On 2012-11-12 02:14, CVAlkan wrote: Just for the record: I'm using Writer 3.6.1.2 on Ubuntu 12.04, but I don't think either makes a difference. When using 2-up, the Print Preview screen defaults to showing the first page on the left. There is a button called Book Preview (just left of the (+) magnifier button) that permits the display to show the odd-numbered pages on the left, as in a printed book or other material. This is, of course, quite useful for reviewing layouts more realistically. Since that is what I'm creating, I would like to set the Book Preview as the default for the Print Preview display (yes, I acknowledge my laziness, but isn't the fact that I use a word processor instead of a typewriter sufficient proof of that?); it would be even cooler if that display choice could be set on a per-document basis as well, but I don't want to be too greedy. I've searched around, but haven't run across anything that would allow me to do that. Does anyone know if such a setting exists and, if so, how to set it? Otherwise, I guess I'll just toss it in at the bottom of the massive list of requested enhancements. Thanks. -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Collate print option not working
I've had that problem with any software I've used; the only sure way is to set the printer's options - then it works as it should every time. I've asked the reason for this only to be given varying responses; none logical to the point ;-) On Mon, Nov 12, 2012 at 4:19 PM, Girvin R. Herr girvin.h...@sbcglobal.netwrote: Greetings, Has anyone else noticed that the Collate option in the print dialog is not working?! I wanted to print 2 copies of a 3-page document and I selected Collate. However, the pages came out 1,1,2,2,3,3 not the 1,2,3,1,2,3 that I expected. So, I unselected Collate and it still came out 1,1,2,2,3,3! Is there some other setting controlling this or is it a bug I should look into? Running LO 3.5.7.2 under KDE 3 and Linux. Thanks in advance. Girvin Herr -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Diwali
Hi :) Happy Diwali all! In my country it is not an official holiday so some of us celebrated it last weekend and others will celebrate this coming weekend and some are hoping to do both! Enjoy dancing and have fun :) (Perhaps some relevant photos?) Regards from Tom :) -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Auto changes on a new spreadsheet set for next year
Hi :)
You might have more fun with the official guides
wiki.documentfoundation.org/Documentation/Publications
particularly the Calc Guide. There are some 3rd party guides near the end of
the page and other things that might be interesting. Google might help you
find some HowTo videos.
Happy hunting!
Regards from
Tom :)
From: Paul Stear p...@appjaws.plus.com
To: users@global.libreoffice.org
Sent: Tuesday, 13 November 2012, 16:06
Subject: Re: [libreoffice-users] Auto changes on a new spreadsheet set for
next year
Thank you again Brian, yesterday I tried all-sorts to try and get this
working, looking at your solution I was nearly there. -- So much to learn.
What is the best source for this sort of information?
I would like to learn more and make my spreadsheets more efficient.
I must admit that the help pages were a bit daunting and I couldn't relate the
example given to my problem.
kind regards
Paul
On Tuesday 13 Nov 2012 05:00:05 Brian Barker wrote:
At 14:42 12/11/2012 +, Paul Stear wrote:
On Thursday 08 Nov 2012 14:19:22 Brian Barker wrote:
At 11:45 08/11/2012 +, Paul Stear wrote:
I have the same spreadsheet set I use each year. The new
spreadsheet for 2013 will need to reference fields in the 2012
spreadsheet. For the past few years I have manually changed the
Readings-2012 in every instance (well over 100).
I would like to be able to construct the spreadsheets with a
method to change the current year, eg 2013 minus 1 to give 2012
inserted so that the ref in the 2013 spreadsheet reads;-
='file:///home/fred/Generation Readings-2012.ods'#$Jan.A68
Is this possible?
Yes. You need to concatenate the required year value with the
strings required before and after it. Suppose that you have the
current year - 2013 in your example - in A1 of your new
spreadsheet. You need to concatenate
'file:///home/fred/Generation Readings- with A1-1 and
.ods'#$Jan.A68. Note that the two single quotes are part of the
string you are creating and the four double quotes delimit the two
text strings, so the first string has a single quote immediately
following its opening double quote. You can carry out this
concatenation using the operator:
='file:///home/fred/Generation Readings-A1-1.ods'#$Jan.A68
(The numerical expression A1-1 is converted to a string value
automatically.)
You might expect this to work, but it doesn't. The formula above
results in a text string which is interpreted literally and not as
a cell reference to the other spreadsheet file. But the trick you
need is available in the INDIRECT() function, which provides the
necessary conversion. So the formula which works is
=INDIRECT('file:///home/fred/Generation Readings-A1-1.ods'#$Jan.A68)
Hi Brian,
Thank you so much, your solution works a treat.
My spreadsheet consists of 15 pages each year, so my next question
is:- would it be possible to put the new year on page 1 named
cover in cell A2 and then change the A1-1 to reference this on
for each instance on every page?
Yes. You refer to a cell on another sheet as sheet.cell. So you
would just need to use ...cover.A2-1... .
Brian Barker
--
mail sent using kmail and kubuntu
--
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 + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
--
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 + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Is it possible to show cell value with text
Hi Johnny, May be I should go through Calc documents/ How to use Calc or something similar! I have used Excel/Calc in a hands on approach - using the drop down menu one gets after clicking the = sign for entering a formula, a generous use of F1, exploring the menus/ icons on tool-bar and of course, Google. So, (now it seems, obviously) I do not know the full capabilities of either software. I may not have needed/ used/ or thought possible many aspects/ functionalities of these applications that are standard practice for most users! And, hence the confusion. Got to get back to the basics :) Thanks anyways, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) Processor : Intel (R) Pentium(R) III Memory : 256MB SDRAM (!?), 20GB IDE OS : Vector Linux - Kernel (???) LibreOffice : Yet to try.. ! --- From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Tuesday, November 13, 2012 10:14 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/13 Viral Orpe viral.o...@yahoo.com: Thanks Johnny, Season's Greetings!! (Today we are celebrating Diwali Festival and New Year here - India) I would like to know what is this language used to talk to Calc? And would appreciate any pointers to any literature, guides etc. I know C and have worked with formulas - this combination is new to me. I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Thanks, Regards, Viral Orpe :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Viral Orpe viral.o...@yahoo.com Sent: Monday, November 12, 2012 11:42 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/12 Viral Orpe viral.o...@yahoo.com: Hi John, Checked your reply on list-archives :) Somehow must have missed on 6th Nov when it first appeared. Please, what is the stand for? =A1 B1 is the same as =CONCATENATE(A1;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Dave_ had asked the question with a + So, I guess this is some standard way of doing things(name?) with slightly diff syntax. I have never known it can be done that way - text and formula together in a cell. I have always used adjacent cells - one with the text part and another with the formula. Any pointers would be great. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: John Clegg john.cl...@nailsea.net To: Dan Lewis elderdanle...@gmail.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, November 11, 2012 9:59 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text This was a thread from 5th November which I answered to the group. He thanked me but got fooled by the stupid group reply settings. On 11 November 2012 16:24, Dan Lewis elderdanle...@gmail.com wrote: On 11/11/2012 11:03 AM, dave_ wrote: Thanks for the solution. -- View this message in context: http://nabble.** documentfoundation.org/Is-it-**possible-to-show-cell-value-** with-text-tp4016842p4018036.**htmlhttp://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html Sent from the Users mailing list archive at Nabble.com. How can we give you a solution when you have not yet given us the problem? It appears that you are using Calc. But what to you mean by show cell value? Where is the text located? Are you referring to a cell containing twenty-seven rather than 27 for example? Or perhaps ten november two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012? Please be more specific. --Dan -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
Re: [libreoffice-users] Collate print option not working
Webmaster, See below for answers to your questions. webmaster-Kracked_P_P wrote: snip What version of Linux are you using? Ubuntu, Linux Mint, Fedora, Opensuse, etc., etc.? Slackware 12.2 (K2.6.27) Since you run Linux, can you try creating a PDF file for your document and then use the default viewer package for PDF to open it. Then go to your printer's options and try to print 2 or 3 copies of the document with the collate option. Now that got interesting! I tried this using Adobe Acrobat Reader to print the PDF file and although I selected 2 copies, collated, I got one copy! I then tried 3 copies and still only got one copy. snip What printer are your using? Which driver set? Original-manufacture-style, CUPS-style or GhostScript-style? Manually installed or did the Linux version find the printer driver and installed it automatically? I am using an HP Laserjet 8150DN, CUPS 1.3.11, on AppSocket/HP JetDirect and the HP Laserjet 8150 Series Postscript (en) driver. When I installed it, CUPS found the printer on my network automagically with the Find New Printers option, but I continued to install it manually using the CUPS wizard. I did not opt for the Foomatic or Gutenprint drivers, thinking they would not be needed, since the printer has Postscript emulation, and a simple Postscript driver should suffice. Now I may go back and rethink that decision. I noticed there are two other drivers I may try: Foomatic and CUPS Gutenprint v5.2.2. snip Try the Export to PDF for one copy of the document and then try and print the duplex and collated document that way. If it works, then it is a LO printer option issue. If it does not work properly, then it is a printer/driver issue. My Epson has a problem with LO and my HP has a driver issue, the last time I tried it - which was a few months back when I was still running Ubuntu 10.04. snip Thanks for the help. You may be onto something with the driver. I will try the other drivers and report back. Girvin Herr -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Diwali
On 11/13/2012 04:10 PM, Tom Davies wrote: Hi :) Happy Diwali all! In my country it is not an official holiday so some of us celebrated it last weekend and others will celebrate this coming weekend and some are hoping to do both! Enjoy dancing and have fun :) (Perhaps some relevant photos?) Regards from Tom :) Happy happy Deepavali :) Regards, Joel -- 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Is it possible to show cell value with text
http://wiki.documentfoundation.org/Documentation/Publications Download the Calc Guide from this link. It may help. --Dan On 11/13/2012 08:06 PM, Viral Orpe wrote: Hi Johnny, May be I should go through Calc documents/ How to use Calc or something similar! I have used Excel/Calc in a hands on approach - using the drop down menu one gets after clicking the = sign for entering a formula, a generous use of F1, exploring the menus/ icons on tool-bar and of course, Google. So, (now it seems, obviously) I do not know the full capabilities of either software. I may not have needed/ used/ or thought possible many aspects/ functionalities of these applications that are standard practice for most users! And, hence the confusion. Got to get back to the basics :) Thanks anyways, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) Processor : Intel (R) Pentium(R) III Memory : 256MB SDRAM (!?), 20GB IDE OS : Vector Linux - Kernel (???) LibreOffice : Yet to try.. ! --- From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Tuesday, November 13, 2012 10:14 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/13 Viral Orpe viral.o...@yahoo.com: Thanks Johnny, Season's Greetings!! (Today we are celebrating Diwali Festival and New Year here - India) I would like to know what is this language used to talk to Calc? And would appreciate any pointers to any literature, guides etc. I know C and have worked with formulas - this combination is new to me. I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Thanks, Regards, Viral Orpe :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Viral Orpe viral.o...@yahoo.com Sent: Monday, November 12, 2012 11:42 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/12 Viral Orpe viral.o...@yahoo.com: Hi John, Checked your reply on list-archives :) Somehow must have missed on 6th Nov when it first appeared. Please, what is the stand for? =A1 B1 is the same as =CONCATENATE(A1;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Dave_ had asked the question with a + So, I guess this is some standard way of doing things(name?) with slightly diff syntax. I have never known it can be done that way - text and formula together in a cell. I have always used adjacent cells - one with the text part and another with the formula. Any pointers would be great. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory: 4GB, DDR3 OS: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: John Clegg john.cl...@nailsea.net To: Dan Lewis elderdanle...@gmail.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, November 11, 2012 9:59 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text This was a thread from 5th November which I answered to the group. He thanked me but got fooled by the stupid group reply settings. On 11 November 2012 16:24, Dan Lewis elderdanle...@gmail.com wrote: On 11/11/2012 11:03 AM, dave_ wrote: Thanks for the solution. -- View this message in context: http://nabble.** documentfoundation.org/Is-it-**possible-to-show-cell-value-** with-text-tp4016842p4018036.**htmlhttp://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html Sent from the Users mailing list archive at Nabble.com. How can we give you a solution when you have not yet given us the problem? It appears that you are using Calc. But what to you mean by show cell value? Where is the text located? Are you referring to a cell containing twenty-seven rather than 27 for example? Or perhaps ten november two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012? Please be more specific. --Dan -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems?
