[libreoffice-users] Cell references - apply formats too?
Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? Thanks -- To unsubscribe e-mail to: users+unsubscr...@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] Calc - allow users to format cells on protected sheets
Hello, Microsoft Excel has the ability to allow users to apply formatting changes to protected cells when a sheet is protected. Is there any possible way to do this in Calc? Thanks -- To unsubscribe e-mail to: users+unsubscr...@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] Re: [MariaDB Announce] MariaDB 5.5.32 now available
Hi :) For those interested in trying to move away from Oracle's MySql this drop in replacement might be worth looking at as long as you are not using a Mac! Regard from Tom :) From: MariaDB Announce List annou...@mariadb.org To: annou...@mariadb.org Sent: Thursday, 18 July 2013, 17:29 Subject: [MariaDB Announce] MariaDB 5.5.32 now available The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.32. This is a bug-fix release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.32 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5532-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5532-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.32 Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add feedback=ON to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our contributing and donations pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org ___ announce mailing list annou...@mariadb.org https://lists.askmonty.org/cgi-bin/mailman/listinfo/announce To unsubscribe, send an email with unsubscribe as the Subject: to announce-requ...@mariadb.org -- To unsubscribe e-mail to: users+unsubscr...@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] Creating a good looking document with videos in it
Hi, I wanted to create a document that containes videos as a help manual but libreoffice can't place them in html or pdf format as a resualt if I redistribute the doc the end user will open it up in libreoffice and all the tecnical terms will turn red (if spell check is enabled,) the vidios will be movable the text editable (by acciden or on purpose,) and the links you will have to ctrl click in order to follow, etc. I wanted a finished kind of look like an html page or a pdf page. How do I do this? -- To unsubscribe e-mail to: users+unsubscr...@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] Printing with HP 960C Deskjet
Hi :) Upgrading LO to 4.0.x sounds like a good plan, as does File - Export to Pdf and then print the Pdf through whatever you view Pdfs with. Errr i only had a go on 1 Macbook once and i wasn't able to fully explore it. it was quite a big deal for me as it's been about a decade since i last used a Mac. I have seen quite a few people on these mailing lists deal with Mac issues and documentation is pretty good at providing a conversion table to deal with a couple of issues. So i listen to other people and copypaste parts of their previous answers if it seems appropriate. These lists are great for learning tons of useful stuff or just increasing understanding general understanding. As Tim said Mac is kinda a brother or sister of GnuLinux so advice based on one might help with the other but there are some odd differences between the platforms. The main problem seemed to be that because the drivers were built-in to OS X 10.5 it's very difficult to get hold of a package that is just the driver or installer. However, i think the op has found 3 drivers that are almost right but just not quite there. Perhaps upgrading LO might help them. Regards from Tom :) From: Kracked_P_P---webmaster webmas...@krackedpress.com To: users@global.libreoffice.org Sent: Wednesday, 17 July 2013, 5:03 Subject: Re: [libreoffice-users] Printing with HP 960C Deskjet For now, as a big work around. . . Do you have luck printing a PDF file to the HP 960? If so, then just export to PDF and print that file. That will work till we get the direct printing from LO issue fixed. For the longest time, that was what I did to print a duplex document on the Epson printer. Do you have the ability to use the OSX 10.5 driver? Or the more generic 10.1.5 to 10.4.x driver? HP has those drivers on their web site for download. I am not a Mac person, but since it is sort of a Linux-like OS [do not tell me how it is not a Linux OS, since I am using a generic comparison] then there must be a way to install this older driver and use it. I know that for Linux and Windows, drivers for earlier version of the OS can work, most times, when there is no newer version for the newer OS. I have used 10.04 and 11.x drivers for my Ubuntu system when there has not been one made for my 12.04 version of the OS. Actually I have done that with several packages. So I am hoping that the 10.5.x driver would work on a 10.7 OSX, since there is none listed for 10.6 or 10.7. Also, LO 3.4.1 may not be the best version for your needs. I had a lot of trouble with dialogs and duplex printing till the 3.6.x line. I use 4.0.4.2 on a Linux system at this time. So it is possible for you to download and install the 3.6.6 version or the 4.0.4 version for OSX and see if some of your dialog issues are fixed. To get duplex working on all my duplexing printers [HP laser, Canon inkjet, and Epson inkjet] I had to check the use LO dialog option for the print dialogs. That was listed as an option for Linux but did not show up for the Windows version. So I would expect that the OSX version might have some different dialog options. Before I found that Linux only option, no one could figure out how to get my Epson printer to duplex when my HP laser would. Now I have a Canon inkjet and the check box option works with that duplexing printer as well. I know that Tom is a Linux person, but he has access to Mac systems, so he may know some OSX specific option, but I have used 3 duplexing printer and I know what works for me. On 07/16/2013 07:26 PM, Tom Davies wrote: Hi :) 2 approaches to fix this, i've not thought about which should be number 1 1. To use the LO dialogues ... When the printer dialogue-box pops-up note there are 4 tabs at the top. On the 1st tab you should see a list of all the printers installed. Select the Hp 960 but instead of printing click on the Properties button. It's just under the list. The Properties pop-up also has a couple of tabs. The 1st should be Paper. Duplex is about the 4h drop-down. Long-edge for Portrait but Short-edge for landscape. My boss can never figure out that short-edge refers to the shortest edge of the paper, or perhaps he is just being kind. 2. To change to normal dialogues ... LibreOffice - Preferences - General - Print dialogues - UNtick the tick-box that says Use LO dialogues. Errr, are you sure that duplex is installed? When you install the driver it should ask you if you want duplex to be included. It might do it automatically. Regards from Tom :) From: Cliff Scott c...@intergate.com To: users@global.libreoffice.org Sent: Tuesday, 16 July 2013, 22:29 Subject: [libreoffice-users] Printing with HP 960C Deskjet Fellow LibreOffice users - I am running LO on a Mac, OSx 10.7.5 and the printer is a HP 960C Deskjet. There are no native OSx drivers for
Re: [libreoffice-users] Re: Errores de certificado en la web
Hi :) I think all of us here are on roughly the same side. It's just a case of trying to work out what works when and what doesn't. I haven't had a huge amount of success in converting MS users to LO. People seem to prefer sticking with broken mangled systems that don't do what they want rather than risk change. The more broken the system the more they resist change. Hence IE6 users being scared to death of trying anything else Regards from Tom :) From: Paul paulste...@afrihost.co.za To: users@global.libreoffice.org Sent: Wednesday, 17 July 2013, 12:30 Subject: Re: [libreoffice-users] Re: Errores de certificado en la web Hi, Or you could just install FireFox and be done with the problems .. Well, as Tom says, I don't think it's usefull to just say Get a new browser. Also, if the certificate is actually wrong, then it should be corrected, there really is no good reason it should be wrong, and switching browsers to not have to see the error is not a real solution. That said... ...Or LO webmasters could just stop being idiots and not offer a certificate for *.documentfoundation.org for libreoffice.org? That's maybe ever so slightly harsh. I just checked in Firefox, and the certificate for https://www.libreoffice.org has a certificate with a CN for www.libreoffice.org, so I'm not sure what the problem is... unless of course they've already fixed it. Just sayin' Paul On Wed, 17 Jul 2013 12:05:07 +0100 (BST) Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I kinda agree but even though IE has recently become a minority share of the web-browser market it is still used by quite a lot of people. Usually those people are clueless about the alternatives and/or seem to think they are using a superior product because they haven't really tried anything else. There's a LOT of them and we don't want to cut them out of our potential market. Telling them they have to change web-browser just to use LO just gives them an extra reason not to bother trying LO. It just makes yet another artificial barrier and increases the FUD. Something that does seem to surprise people and encourage them to install LO is that they can have both LO and MSO on their system. A dismaying number of people wont dare try LO because they think they have to get rid of their MSO. Similarly with web-browsers of course but that is not our fight. I'm credited with having written the 2nd paragraph below but it really wasn't me 1. Most of the web developers i know are ladies 2. If i had thought of it i would have written directly to the Websites List to ask them if they could do it. probably the only reason it might not have been done already is that they are a small team and are still working on it. However, i doubt that IE 9 needs a different certificate from IE 8 or that certificates made for IE 8 are incompatible with IE 9. It's always possible, of course, especially if it could make things difficult for LO without affecting too many other people. Most of the people on tis list probably are already using Firefox, Chrome, the Mac one, Opera or some other non-MS web-browser. We need to catch more people that haven't tried the others yet and maybe be their gateway into OpenSource. Regards from Tom :) From: P NIKOLIC p.nikol...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 17 July 2013, 7:29 Subject: Re: [libreoffice-users] Re: Errores de certificado en la web On Wed, 17 Jul 2013 10:05:57 +0700 Urmas davian...@gmail.com wrote: Tom Davies: Note that IE is made by a 3rd party competitor that has good reason to want to see LibreOffice (and all other OpenSource products) fail. The more they can do to discredit LibreOffice the more likely they are to sell more of their own product and make more money. So, if IE doesn't behave we might not be able to do anything about it. ...Or LO webmasters could just stop being idiots and not offer a certificate for *.documentfoundation.org for libreoffice.org? Or you could just install FireFox and be done with the problems .. Pete . -- Linux 7-of-9 3.9.9-1-ARCH #1 SMP PREEMPT Wed Jul 3 22:45:16 CEST 2013 x86_64 GNU/Linux -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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:
[libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output
Hi :) Sorry you haven't received many replies to this yet! You could upload the files to Nabble so that people can see them and see the problem. It's not as tough as it sounds! Just use the links in this email or navigate to the right thread through the official site Get help - Nabble - then look for the same subject-line that you wrote Start posting a reply and notice that above where you are typing-in there are some buttons such as More. The More one has Upload a file as it's top option. Then it's just the same as adding an attachment to an email. It has the same sort of browse thing. Once done all you see is a line of html code added into your reply. You can move that link around to position it better if you want. Btw have you tried upgrading to 4.0.something? Have you had time to try the 3.6.7 that has just been released? Regards from Tom :) Dan-2 wrote I have some ODP-format slides which appear correctly when I view them with the [F5] slide show view in Impress, but in which some content is missing when I view them in the normal view, and when I export to PDF. Any ideas why this might be, and how I can get a PDF in which all the content appears correctly, please? I've attached a minimal(ish) example. My apologies if attachments violate the netiquette of this list. (BTW, this is all happening in LibreOffice 3.6.6.2 under Windows 7.) -- Kind regards, Dan -- View this message in context: http://nabble.documentfoundation.org/Some-content-in-ODP-slide-appears-only-in-slide-show-view-of-Impress-not-in-normal-view-or-PDF-output-tp4065812p4066061.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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] Kerning issue with LIbreOffice 4 and Helvetica font
In LibreOffice 4.1.0.1, if I open a document containing Helvetica font and export to PDF, the Helvetica font has horrible kerning--almost all spaces between words are removed, making the PDF very difficult to read. If I open the same document in LibreOffice 3.4.5, it exports to PDF just fine--spaces between words are easy to identify making the quote easy to read.Is this a known issue with LibreOffice 4? Is there a simple fix?I'm attaching a sample doc which contains Helvetica font and the resulting PDF.Best regards,Patrick Frost test.doc http://nabble.documentfoundation.org/file/n4066062/test.doc test.pdf http://nabble.documentfoundation.org/file/n4066062/test.pdf -- View this message in context: http://nabble.documentfoundation.org/Kerning-issue-with-LIbreOffice-4-and-Helvetica-font-tp4066062.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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] Kerning issue with LIbreOffice 4 and Helvetica font
In LibreOffice 4.1.0.1, if I open a document containing Helvetica font and export to PDF, the Helvetica font has horrible kerning--almost all spaces between words are removed, making the PDF very difficult to read. If I open the same document in LibreOffice 3.4.5, it exports to PDF just fine--spaces between words are easy to identify making the quote easy to read. Is this a known issue with LibreOffice 4? Is there a simple fix? I'm attaching a sample doc which contains Helvetica font and the resulting PDF. Best regards, Patrick Frost -- To unsubscribe e-mail to: users+unsubscr...@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] Kerning issue with LIbreOffice 4 and Helvetica font
Hi :) 4.1.0 is very early on in that branches life-cycle. I typically wait for the x.x.4 rather than the x.x.0. Can you post a bug-report about it and get back to 4.0.3 or something? I still have a lot of machines on around 3.5.4 but 3.6.x is better. I meant to upgrade all machines to 4.0.4 (or something) today but never quite got around to doing anything i'd planned for today! Regard from Tom :) From: pfrost pfr...@redhat.com To: users@global.libreoffice.org Sent: Thursday, 18 July 2013, 19:17 Subject: [libreoffice-users] Kerning issue with LIbreOffice 4 and Helvetica font In LibreOffice 4.1.0.1, if I open a document containing Helvetica font and export to PDF, the Helvetica font has horrible kerning--almost all spaces between words are removed, making the PDF very difficult to read. If I open the same document in LibreOffice 3.4.5, it exports to PDF just fine--spaces between words are easy to identify making the quote easy to read.Is this a known issue with LibreOffice 4? Is there a simple fix?I'm attaching a sample doc which contains Helvetica font and the resulting PDF.Best regards,Patrick Frost test.doc http://nabble.documentfoundation.org/file/n4066062/test.doc test.pdf http://nabble.documentfoundation.org/file/n4066062/test.pdf -- View this message in context: http://nabble.documentfoundation.org/Kerning-issue-with-LIbreOffice-4-and-Helvetica-font-tp4066062.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Creating a good looking document with videos in it
Hi :) Are you using Impress to make the document? Impress might be the best tool for the job. Alternatively could you create the document, save as html and then edit the html coding? That sounds a bit messy. I tend to write html in a text-editor to avoid all the added extras other programs throw in but i haven't tried putting videos in. Can't imagine it's much different from adding a photo or logo though? Errr, i started with Notepad which was a bit of a pain but the normal text-editors in GnuLinux colour-code the coding which makes it easier. I think SciTE and Notepad++ (available in Windows) do colour-coding too. Of course the colours are calculated rather than being hidden codes in the document. Regards from Tom :) From: frank ernest do...@mail.com To: users@global.libreoffice.org Sent: Thursday, 18 July 2013, 18:32 Subject: [libreoffice-users] Creating a good looking document with videos in it Hi, I wanted to create a document that containes videos as a help manual but libreoffice can't place them in html or pdf format as a resualt if I redistribute the doc the end user will open it up in libreoffice and all the tecnical terms will turn red (if spell check is enabled,) the vidios will be movable the text editable (by acciden or on purpose,) and the links you will have to ctrl click in order to follow, etc. I wanted a finished kind of look like an html page or a pdf page. How do I do this? -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Cell references - apply formats too?
Hi :) I think we had a thread about this maybe 6months-1year ago? I think the up-shot was that it's not possible and maybe better to have a 2nd column to indicate colour. Regards from Tom :) From: Tanstaafl tansta...@libertytrek.org To: users@global.libreoffice.org Sent: Thursday, 18 July 2013, 15:53 Subject: [libreoffice-users] Cell references - apply formats too? Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? Thanks -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Português e mailing list
Hi :) Good answer, i think :) Has this helped? Orlando? Have you found the right place? Regards from Tom :) From: Daniel A. Rodriguez daniel.armando.rodrig...@gmail.com To: users@global.libreoffice.org Sent: Wednesday, 17 July 2013, 22:26 Subject: Re: [libreoffice-users] Português e mailing list 2013/7/17 Orlando Figueiredo orlandofigueir...@pensatempos.net Hi, Does anyone know ir there is a discution group for libreoffice Portugal. O. Take a look at the wiki page for Local Mailing Lists https://wiki.documentfoundation.org/Local_Mailing_Lists#Portugu.C3.AAs ___ Escuelas Libres :: Porque la educación es mucho mejor cuando es libre www.escuelaslibres.org.ar --- Para entrenar, cualquier programa sirve. Para educar, sólo Software Libre. (Federico Heinz) --- -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Re: Kerning issue with LIbreOffice 4 and Helvetica font
Hi :) Sorry, attachments get taken off before emails are sent out to everyone. Otherwise people using limited dial-ups and strict caps might get annoyed. You can upload files to Nabble and then people can choose to see it if they want to. The upload option is on the More button Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Kerning-issue-with-LIbreOffice-4-and-Helvetica-font-tp4066062p4066077.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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] Base PostgreSQL Transactions
Hi all, I have a 4-table DB in PostgreSQL to which I connect using LibreOffice Base. I have a form with 2 subforms in place that allows me to: Select an existing entity (from the ENTITY table) Add a new financial transaction (to the TRANSREC table) Add new line items for each transaction (to the TRANSDETAILS table). I would like to take advantage of PostGRESQL's underlying transaction (start, rollback, commit, etc.) to ensure that a given transaction and its line items are entered as one single transaction. I just don't know how to implement that using Base as a front-end. Maybe I really need something like macros and BASIC or Python to make such a thing work? If anyone knows a good tutorial on this subject, I can certainly read - just haven't really found anything yet. Thanks! Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ https://www.xing.com/profile/Don_Parrishttp://www.linkedin.com/in/dcparris GPG Key ID: F5E179BE -- To unsubscribe e-mail to: users+unsubscr...@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] Base PostgreSQL Transactions
Hi :) If you are looking for a good guide about Macros then Andrew Pitonyak's guide is supposedly the best https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers Apparently it is well worth the money but you might want to have a quick look at the official guides for free first. Andrew wrote most of the chapters about Macros in those too as a first step into understanding Macros So, start with Chapter 9 of the Getting Started Guide https://wiki.documentfoundation.org/Documentation/Publications#Getting_Started_with_LibreOffice Maybe have a look at Chapter 12 in the Calc Guide https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide because spreadsheets and databases share some common ground i suspect. Also this whole handbook might be helpful!! https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook Note that the entire Base Handbook has been updated for the 4.0.x branch of LibreOffice already even though individual chapters were not done separately. If you want the separate chapters you can always get the almost identical ones for the 3.5-3.6 branches. I'm not entirely sure any of this helps you but hopefully others will appear later to let you know if you really do need macros. Obviously Python is a more useful language once you have gotten to grips with it but Basic might be easier to learn Regards from Tom :) From: Don Parris parri...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 18 July 2013, 21:05 Subject: [libreoffice-users] Base PostgreSQL Transactions Hi all, I have a 4-table DB in PostgreSQL to which I connect using LibreOffice Base. I have a form with 2 subforms in place that allows me to: Select an existing entity (from the ENTITY table) Add a new financial transaction (to the TRANSREC table) Add new line items for each transaction (to the TRANSDETAILS table). I would like to take advantage of PostGRESQL's underlying transaction (start, rollback, commit, etc.) to ensure that a given transaction and its line items are entered as one single transaction. I just don't know how to implement that using Base as a front-end. Maybe I really need something like macros and BASIC or Python to make such a thing work? If anyone knows a good tutorial on this subject, I can certainly read - just haven't really found anything yet. Thanks! Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ https://www.xing.com/profile/Don_Parrishttp://www.linkedin.com/in/dcparris GPG Key ID: F5E179BE -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Calc - allow users to format cells on protected sheets
Depends on where you open it. If I double-click an email attachment to open it, I can't make any changes at all (not even column width). Once I save it to my hard drive, it becomes unprotected. I think what the OP is referring to is that in Excel you can do whatever you want to a protected spreadsheet -- you just can't save the changes. Thus, you can do a lot of what if analysis but can't mess up someone else's work. Dave On 7/18/2013 11:44, Tom Davies wrote: Hi :) I think if you open an Excel spreadsheet that is supposedly protected in Calc then you bypass all the password protections and stuff. My company's (well the place where i work, it's not really mine as such) finance lady was somewhat horrified when i was easily able to fix a problem for her despite having no idea what the password was. I hadn't even realised the spreadsheet was supposedly protected! Regards from Tom:) From: Tanstaafl tansta...@libertytrek.org To: users@global.libreoffice.org Sent: Thursday, 18 July 2013, 15:47 Subject: [libreoffice-users] Calc - allow users to format cells on protected sheets Hello, Microsoft Excel has the ability to allow users to apply formatting changes to protected cells when a sheet is protected. Is there any possible way to do this in Calc? Thanks -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Benford's Law
On 07/15/2013 12:42 PM, Brian Barker wrote: don't stop being what they are after some arbitrary number of significant figures - whether it be one, three, or any other. At the fourth significant digit, 0 and 9 occur slightly (¿1:10,000?) more frequently than 1, 2, 3, 4, 5, 6, 7, and 8. For most practical purposes, the fourth digit can be treated as a uniformly random number. At the fifth, and subsequent digits, the numbers are randomly, and uniformly distributed. If you want values that follow Benford's Law up to three digits, you can easily take the true values from my suggested formula, truncate (or round?) them after three digits, and add further random digits selected from a uniform distribution. And my original post was asking what happened to the macro that automatically did that. jonathon -- LibreOffice in a Multi-Lingual Environment. -- To unsubscribe e-mail to: users+unsubscr...@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] Printing with HP 960C Deskjet
Hi. I have LO 4.1 dev build on a macbook pro 10.6.8 (I think) and can print duplex to a Brother 2040D and an HP C410. Steve On 2013-07-19 05:37, Tom Davies wrote: Hi :) Upgrading LO to 4.0.x sounds like a good plan, as does File - Export to Pdf and then print the Pdf through whatever you view Pdfs with. Errr i only had a go on 1 Macbook once and i wasn't able to fully explore it. it was quite a big deal for me as it's been about a decade since i last used a Mac. I have seen quite a few people on these mailing lists deal with Mac issues and documentation is pretty good at providing a conversion table to deal with a couple of issues. So i listen to other people and copypaste parts of their previous answers if it seems appropriate. These lists are great for learning tons of useful stuff or just increasing understanding general understanding. As Tim said Mac is kinda a brother or sister of GnuLinux so advice based on one might help with the other but there are some odd differences between the platforms. The main problem seemed to be that because the drivers were built-in to OS X 10.5 it's very difficult to get hold of a package that is just the driver or installer. However, i think the op has found 3 drivers that are almost right but just not quite there. Perhaps upgrading LO might help them. Regards from Tom :) From: Kracked_P_P---webmaster webmas...@krackedpress.com To: users@global.libreoffice.org Sent: Wednesday, 17 July 2013, 5:03 Subject: Re: [libreoffice-users] Printing with HP 960C Deskjet For now, as a big work around. . . Do you have luck printing a PDF file to the HP 960? If so, then just export to PDF and print that file. That will work till we get the direct printing from LO issue fixed. For the longest time, that was what I did to print a duplex document on the Epson printer. Do you have the ability to use the OSX 10.5 driver? Or the more generic 10.1.5 to 10.4.x driver? HP has those drivers on their web site for download. I am not a Mac person, but since it is sort of a Linux-like OS [do not tell me how it is not a Linux OS, since I am using a generic comparison] then there must be a way to install this older driver and use it. I know that for Linux and Windows, drivers for earlier version of the OS can work, most times, when there is no newer version for the newer OS. I have used 10.04 and 11.x drivers for my Ubuntu system when there has not been one made for my 12.04 version of the OS. Actually I have done that with several packages. So I am hoping that the 10.5.x driver would work on a 10.7 OSX, since there is none listed for 10.6 or 10.7. Also, LO 3.4.1 may not be the best version for your needs. I had a lot of trouble with dialogs and duplex printing till the 3.6.x line. I use 4.0.4.2 on a Linux system at this time. So it is possible for you to download and install the 3.6.6 version or the 4.0.4 version for OSX and see if some of your dialog issues are fixed. To get duplex working on all my duplexing printers [HP laser, Canon inkjet, and Epson inkjet] I had to check the use LO dialog option for the print dialogs. That was listed as an option for Linux but did not show up for the Windows version. So I would expect that the OSX version might have some different dialog options. Before I found that Linux only option, no one could figure out how to get my Epson printer to duplex when my HP laser would. Now I have a Canon inkjet and the check box option works with that duplexing printer as well. I know that Tom is a Linux person, but he has access to Mac systems, so he may know some OSX specific option, but I have used 3 duplexing printer and I know what works for me. On 07/16/2013 07:26 PM, Tom Davies wrote: Hi :) 2 approaches to fix this, i've not thought about which should be number 1 1. To use the LO dialogues ... When the printer dialogue-box pops-up note there are 4 tabs at the top. On the 1st tab you should see a list of all the printers installed. Select the Hp 960 but instead of printing click on the Properties button. It's just under the list. The Properties pop-up also has a couple of tabs. The 1st should be Paper. Duplex is about the 4h drop-down. Long-edge for Portrait but Short-edge for landscape. My boss can never figure out that short-edge refers to the shortest edge of the paper, or perhaps he is just being kind. 2. To change to normal dialogues ... LibreOffice - Preferences - General - Print dialogues - UNtick the tick-box that says Use LO dialogues. Errr, are you sure that duplex is installed? When you install the driver it should ask you if you want duplex to be included. It might do it automatically. Regards from Tom :) From: Cliff Scott c...@intergate.com To: users@global.libreoffice.org Sent: Tuesday, 16 July 2013, 22:29 Subject: [libreoffice-users] Printing with HP 960C Deskjet Fellow LibreOffice users - I am running
Re: [libreoffice-users] Base PostgreSQL Transactions
On Thu, Jul 18, 2013 at 4:27 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) If you are looking for a good guide about Macros then Andrew Pitonyak's guide is supposedly the best https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers Apparently it is well worth the money but you might want to have a quick look at the official guides for free first. Andrew wrote most of the chapters about Macros in those too as a first step into understanding Macros So, start with Chapter 9 of the Getting Started Guide SNIP I'm not entirely sure any of this helps you but hopefully others will appear later to let you know if you really do need macros. Obviously Python is a more useful language once you have gotten to grips with it but Basic might be easier to learn Regards from Tom :) Thanks Tom, yes I have been reading over the official guides, but haven't really found anything pertaining to my question so far, hence my asking here. -- To unsubscribe e-mail to: users+unsubscr...@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] Cell references - apply formats too?
Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? Yes, using conditional formats. First create format styles with F11, then tell the cell to apply the format appropriate to the value of a referenced cell. In the example at https://docs.google.com/file/d/0B6LXy9sguZVkVDdMMXh3Y1dhQWs/edit?usp=sharing c2 - n2 are months Jan to Dec, b3 - b12 are 10 salespersons and c3 - n12 are their monthly sales. We want to use colours to quickly see who sold the most and least each month. c15 - n15 show the min sales in each column (and are formatted white on red. This is per style named Min) c17 - n17 show the max sales in each column (and are formatted white on blue. This is per style named Max) In the conditional formatting for each cell c3 - n12, 1. apply style Min if the cell contents = cell in row 15 and 2. apply style Max if the cell = row 17. What you achieve is 2 cells in each column automatically turning red or blue if they match other cells based on their value, allowing high or low achievers to be immediately recognised. Hope this helps. Errol -- To unsubscribe e-mail to: users+unsubscr...@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] Calc SYLK support error?
I was reading the SYLK entry in Wikipedia: https://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29 and came across the following short SYLK file content: ID;P C;Y1;X1;KRow 1 C;Y2;X1;KRow 2 C;Y3;X1;KTotal C;Y1;X2;K11 C;Y2;X2;K22 C;Y3;X2;K0;ER1C2+R2C2 E which I copied and pasted into a UTF-8 text file with newline line endings named test.slk. I loaded test.slk into two builds of LibreOffice Calc: - Version 3.5.7.2 Build ID: 350m1(Build:2) on GNU/Linux 64-bit - Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2) on Microsoft Windows 7 64-bit Both systems had all OS updates installed as of the time/date on this email. I expected to get what the Wikipedia page described -- a table with two columns, three rows, and one sum: Row 1|11 Row 2|22 Total|33 but instead I get the following on both aforementioned Calc versions in both OSes: Row 1|11 Row 2|22 Total|0 (I'm using | to show where the cell ends/starts, not that theres a literal vertical bar anywhere in the SYLK file or Calc output) I'm seeing the K value for Y3;X2; (from the penultimate line of my SYLK file) instead of the computed value 33. Also, when I focus the cell in column 2 row 3 in both versions of Calc listed above I do not see the formula R1C2+R2C2. This formula is clearly specified in the SYLK file. I don't see any formula in this cell at all. Is this because Calc's SYLK support is broken or is something else going on? When I load my SYLK file into Gnumeric 1.10.17 on GNU/Linux I see 0 in the same position (column 2 row 3) but I also see the formula (=$B$1+$B$2) and when I recalculate the spreadsheet I get the 33 I expect. Thus, Gnumeric isn't recalculating on load but that's okay because no data is lost. Per https://wiki.documentfoundation.org/QA/BugReport I've searched https://bugs.freedesktop.org/buglist.cgi?quicksearch=calc+sylk but found only 2 bugs neither of which seem applicable so I'm asking on this mailing list before filing a bug of my own against Calc. Thanks. -- To unsubscribe e-mail to: users+unsubscr...@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] Calc - allow users to format cells on protected sheets
On 2013/07/18 04:47 PM, Tanstaafl wrote: Hello, Microsoft Excel has the ability to allow users to apply formatting changes to protected cells when a sheet is protected. Is there any possible way to do this in Calc? Thanks Yes, using conditional formats. Protecting the cell _and_ the sheet together normally locks out all changes, but a conditional format can override both and unlock the cell (but not for formats alone). In the example at https://docs.google.com/file/d/0B6LXy9sguZVkeE8wTFgyZ2JQcW8/edit?usp=sharing 1. d2 and d3 are both Format Cells|Cell Protection|Protected (this is to show that locked cells can be opened) 2. c2 and c3 are both Format Cells|Cell Protection|unprotected (this is to change their value so as to trigger the condition) 3. sheet Protect is Tools|Protect Document|Sheet|Select unprotected cells 4. 2 styles exist; Protect, which is red background and cell protected, and Unprotect which is blue background and not. 5. d2 and d3 also have conditional formats. so that when the adjacent cell is a particular value (here 1), the Protect style applies, when the cell is not 1, the Unprotect style applies. The effect of this is that when c3 = 1 (or some password of your choice), d3 can be selected|format changed even though the sheet and d3 are protected. This way achieves the intended result, with the possibly unintended result of opening d3's value to change as well, which undoes the intention of protection. A half-way is to use conditional formatting to switch automatically between styles based on pre-set criteria, giving visual diversity without creating edit risk. PS In this example, the trigger value is transparent when the cell is unlocked (the user can see the conditional formatting formula), but you can make the trigger refer offsheet to a value the user can't see. Hope this helps Errol -- To unsubscribe e-mail to: users+unsubscr...@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] Calc SYLK support error?
At 17:52 18/07/2013 -0500, J.B. Nicholson-Owens wrote: I was reading the SYLK entry in Wikipedia: https://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29 ... I know nothing about this - but did you notice in the Wikipedia article *Variants of* the format are supported by [...] OpenOffice.org, ... (my emphasis)? and came across the following short SYLK file content: ID;P C;Y1;X1;KRow 1 C;Y2;X1;KRow 2 C;Y3;X1;KTotal C;Y1;X2;K11 C;Y2;X2;K22 C;Y3;X2;K0;ER1C2+R2C2 E which I copied and pasted into a UTF-8 text file with newline line endings named test.slk. I loaded test.slk into two builds of LibreOffice Calc: ... . I expected to get what the Wikipedia page described -- a table with two columns, three rows, and one sum: Row 1|11 Row 2|22 Total|33 but instead I get ... [...] Total|0 Also, when I focus the cell in column 2 row 3 in both versions of Calc listed above I do not see the formula R1C2+R2C2. This formula is clearly specified in the SYLK file. I don't see any formula in this cell at all. Is this because Calc's SYLK support is broken or is something else going on? Your sample file uses the R1C1 numbered-row-and-column method of referencing cells, which you probably know Calc does not support. Since Calc will save a spreadsheet sheet in its version of SYLK format, it is a fairly simple job to see what works. You need to change the cell references in the formula to the column-letter-and-row-number form. It appears that Calc also needs its name on the first line. Try this: ID;PSCALC3 C;X1;Y1;KRow 1 C;X1;Y2;KRow 2 C;X1;Y3;KTotal C;X2;Y1;K11 C;X2;Y2;K22 C;X2;Y3;K0;EB1+B2 E Will you need CALC4 instead for one of your versions? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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] Benford's Law
At 21:03 18/07/2013 +, Toki Jonathan Kantoor wrote: On 07/15/2013 12:42 PM, Brian Barker wrote: ... don't stop being what they are after some arbitrary number of significant figures - whether it be one, three, or any other. At the fourth significant digit, 0 and 9 occur slightly (¿1:10,000?) more frequently than 1, 2, 3, 4, 5, 6, 7, and 8. For most practical purposes, the fourth digit can be treated as a uniformly random number. At the fifth, and subsequent digits, the numbers are randomly, and uniformly distributed. It's surely intuitively obvious that this cannot be so. The first digits are very non-uniformly distributed, the second ones less so, and so on. What your source is telling you is that the fourth digit is very, very nearly uniformly distributed and that subsequent digits are so nearly so that they may be considered so for all practical purposes - not that they really are. (That would be wrong.) In any case, if the formula I suggested works (and we've seen plenty of evidence that it does and none that it doesn't - but I'm still open to correction), then according to your theory it *will* provide such uniformly distributed digits after the fourth. You've already got what you want: the problem appears to be that you cannot believe the distribution will turn out the way that you say it will! It's irrational of you to suggest removing one set of digits that you claim are already uniformly distributed and replacing them with another also uniformly distributed set! And if there were any difference, how many variates would you have to call upon before any difference would be noticeable? Billions of billions of billions?! More than you are going to use, at any rate. If you want values that follow Benford's Law up to three digits, you can easily take the true values from my suggested formula, truncate (or round?) them after three digits, and add further random digits selected from a uniform distribution. And my original post was asking what happened to the macro that automatically did that. And you now have an even simpler solution: a formula that does it. But you are very welcome not to use it if you don't like it. Even if you wanted to make the irrational change, you could easily construct a formula to do this. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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] Cell references - apply formats too?
At 10:53 18/07/2013 -0400, Charles Marcus wrote: Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? If you mean so that you can arbitrarily change the background of the target cell and the background of the referencing cell will follow suit, I think not: there appears to be no way to test the formatting of a cell or to retrieve the formatting details. At least, you can retrieve numeric formatting using the CELL() function, but not other aspects of formatting, including background colour. Unless someone knows better. What you can do, of course, is to set up another column or row in which you put suitable values which can then control conditional formatting of both the target cell and the referencing one. To change the background of both, you merely need to change the controlling values. These could even be colour names: red, green, and so on. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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] Cell references - apply formats too?
At 00:52 19/07/2013 +0200, Errol Goetsch wrote: [Someone asked:] Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? Yes, using conditional formats. First create format styles with F11, then tell the cell to apply the format appropriate to the value of a referenced cell. In the example at https://docs.google.com/file/d/0B6LXy9sguZVkVDdMMXh3Y1dhQWs/edit?usp=sharing c2 - n2 are months Jan to Dec, b3 - b12 are 10 salespersons and c3 - n12 are their monthly sales. We want to use colours to quickly see who sold the most and least each month. c15 - n15 show the min sales in each column (and are formatted white on red. This is per style named Min) c17 - n17 show the max sales in each column (and are formatted white on blue. This is per style named Max) In the conditional formatting for each cell c3 - n12, 1. apply style Min if the cell contents = cell in row 15 and 2. apply style Max if the cell = row 17. What you achieve is 2 cells in each column automatically turning red or blue if they match other cells based on their value, allowing high or low achievers to be immediately recognised. Sorry to be a wet blanket, but this appears to show how the format of the destination cell can be made to depend on the value, not the format, of another cell. If I change the format of your Min and Max value rows - say to give them green backgrounds - the cells highlighted by conditional formatting still appear in red and blue - according to your Min and Max cell styles. It's very pretty and well designed and no doubt useful, but it doesn't quite do what I think the questioner is asking for. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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