Re: [libreoffice-users] Calc scale formula conundrum/ logic confusion
Hi :) Someone else asked a very similar question about a month ago and i think someone created a neat calculation or spreadsheet to help figure it out. Now the trick is trying to find it in the archives! Good luck and regards from Tom :) From: zr1hpc hyl...@conacher.co.za To: users@global.libreoffice.org Sent: Thursday, 14 February 2013, 6:07 Subject: [libreoffice-users] Calc scale formula conundrum/ logic confusion Using Calc 3.4.5 on openSuse 11.2 I am trying to work out the currency value of the amount of electricity units I have left at the end of the month (G2). This same formula will be used for the other 11 months of the year with only the G2 reference changing to G3, G4...etc. For those who wish to stretch their grey matter as mine just ain't stretching any more. The pricing scale the energy supplier has given me is: Unit Range Value per unit 0-150 1.1320 150.01 - 600 1.1811 600.01 - 1.4018 Therefore the first 150 units are priced at 1.132 ea. any units still available need to be calculated at the next rate of 1.1811, but only up to 449.90 units at the second rate. Anything more than that must be at the highest rate of 1.4018. Assuming my unit balance of G2 = 433 I can work out the currency value of G2 by following the following logic, and using the scale above: 433 150 therefore the initial 150 units need to be priced at 1.1320 i.e. 150* 1.132= ZAR169.80. To this the balance of the units over 150 need to be multiplied by the next rate of 1.1811 i.e. 433-150= 283. Since 283 is below the max of 449.9 units allowed for this scale, therefore 283*1.1811= ZAR334.25. The third scale is not needed as all the units have been accounted for, however it must be available should G2 exceed 600 units e.g. taking 601 units; the first 150 would be costed at 1.132, the next 449.9 costed at 1.1811 and the balance of 1.1 units costed at 1.4018 per unit. Therefore total value of 433 units is: 150*1.1320 = 169.80 + 283*1.1811 = 334.25 _ Value ZAR504.05 Values used in formulae below are: G2 = 433 available units $F$18 = 1.132 cost per unit $G$18 = 0 - 150 units $H$18 = 169.80 = value of F*G $I$18 = 1.1811 cost per unit $J$18 = 150.1 - 600 units $K$18 = 531.38 = value of I*449.90 = 600-150.1 $L$18 = 1.4018 cost per unit $M$18 = 600.01 $N$18 = 841.09 = M*L however this value is dependent on how many units over 600 column G2:g13 is. SUM(IF(G2=$G$18,$H$18,(G2-$G$18)*$F$18),IF($G$18(G2-$G$18)=$J$18,$K$18,(G2-$G$18)*$I$18),IF((G2-$G$18-$J$18)=$M$18,$N$18,(G2-$G$18-$J$18)*$L$18)) Even taking out the SUM(), and replacing 'commaIF' with '+IF's gives the incorrect answer i.e. 467.22. There must be a problem with my logic in the above formula as the answer is so close, but for the life of me I cannot see it. Asking for some 'logic'al help to work out the correct value in H2:H13 File attached via Nabble: Electricity.ods http://nabble.documentfoundation.org/file/n4037350/Electricity.ods Appreciated Hylton -- Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://e-clubhouse.org/sites/fishhoek/index.php being part of the worlds largest non profit NGO -- View this message in context: http://nabble.documentfoundation.org/Calc-scale-formula-conundrum-logic-confusion-tp4037350.html Sent from the Users mailing list archive at Nabble.com. -- 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] Calc scale formula conundrum/ logic confusion
At 07:45 14/02/2013 +, Tom Davies wrote: Someone else asked a very similar question about a month ago ... That someone else was (not surprisingly) the same person! ... and i think someone created a neat calculation or spreadsheet to help figure it out. Now the trick is trying to find it in the archives! He probably doesn't need to ... Brian Barker -- 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] Table borders
-Mensagem original- De: Jean-Francois Nifenecker [mailto:jean-francois.nifenec...@laposte.net] Enviada: quarta-feira, 13 de Fevereiro de 2013 19:09 Para: users@global.libreoffice.org Assunto: Re: [libreoffice-users] Table borders Le 13/02/2013 17:27, PGR a écrit : My table does show it's border when I open the documento or when doing a previsualization. It gets lost when I print the document, even to pdf creator. That option in LO configuration is also active. I thought this issue was solved on version 3.4... What is the border thickness value? It might be way too thin to be correctly rendered on a printer. -- Jean-Francois Nifenecker, Bordeaux The border does render fine when printing from MS Word. Has I told before, I have a logo inside the header of my document. If I remove the logo, the table gets printed. But I can't do this because these are oficial documents that are connected to a DB. If I create a document from scratch inside LO with a logo and a table this doesn't happen, but I have to keep using existing documents. I think there's no solution yet and I have to still use MS office for a while... :( Many thanks for your help. -- 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] Save as doc crashes LO
On 13/02/2013, steveedmonds steve.edmo...@ptglobal.com wrote: Hi. Saving a writer document as .doc crashes my LO on OpenSuse. Could someone please try on 4.0 and if it persists I will file a bug. perf_calc_translations.odt http://nabble.documentfoundation.org/file/n4037263/perf_calc_translations.odt It is much more important to know: does LO crash when creating an odt file? Considering odf files are opened successfully in many programs, including m$, there is little justification to use LO as an m$-clone. We should want to see more questions posted to m$ support: how do I open an odt file just received? -- 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] Save as doc crashes LO
Hi :) The odt is obviously fine. It's only a problem when the op wants to share the file with other people. Not all of those people have control over what gets installed on their machine and the rest might not yet have heard of LibeOffice or any of the others. Once they get used to receiving higher quality documents they might start being interested. If all the documents they receive from LO users are un-openable or corrupted or look bad then why would they be interested in moving to LO themselves? Regard from Tom :) From: e-letter inp...@gmail.com To: steveedmonds steve.edmo...@ptglobal.com Cc: users@global.libreoffice.org Sent: Thursday, 14 February 2013, 9:23 Subject: Re: [libreoffice-users] Save as doc crashes LO On 13/02/2013, steveedmonds steve.edmo...@ptglobal.com wrote: Hi. Saving a writer document as .doc crashes my LO on OpenSuse. Could someone please try on 4.0 and if it persists I will file a bug. perf_calc_translations.odt http://nabble.documentfoundation.org/file/n4037263/perf_calc_translations.odt It is much more important to know: does LO crash when creating an odt file? Considering odf files are opened successfully in many programs, including m$, there is little justification to use LO as an m$-clone. We should want to see more questions posted to m$ support: how do I open an odt file just received? -- 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
[libreoffice-users] Strange fonts on my Windows system
All, I have a bunch of fonts on my Windows system that have weird names like cmbx6 Regular, cmdunh10 Regular, cmsltt10 Regular... Did these come with LibreOffice and if so what are they for? Also, why such cryptic names? Thanks, Bill -- 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] Strange fonts on my Windows system
The “cm” is Computer Modern. It’s a type family created by Donald Knuth for use with Tex. They often seem to get installed by some application–– it may even be Libre Office. The cryptic are possibly a reflection of the whimsical Tex (or rather Knuth) world. -- 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] Strange fonts on my Windows system
. . . cryptic _names_, I meant. -- 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] Strange fonts on my Windows system
On 14/02/2013 at 11:56, Séamas Ó Brógáin s...@iol.ie wrote: They often seem to get installed by some application–– it may even be Libre Office. LibreOffice does not ship any TeX fonts - Wiliam must have get them elsewhere. -- 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] Create Firefox Personas for LibreOffice 4 in LibreOffice 4
On 02/13/2013 11:31 PM, C. H. D. wrote: Hello! I did not find pixels in LibreOffice: Tools - Options - LibreOffice Draw - General - Unit of measurement That was why I used cm instead. Thanks. Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ snip https://www.getpersonas.com/en-US/demo_create This is Firefox's site that walks you through the creation of Persona designs. Since LibreOffice uses their Persona guidelines, currently, I am going by their information. They describe using a header image of 3000 pixels wide by 200 pixels high. The footer size is 3000 pixels by 100 pixels. They also have a file size limit of no more than 300KB for the images [total size of the two combined, I believe]. Now here it the sticking point. Draw seems to want you to create pages, not specific images, like Corel Draw and Inkscape. You must be able to create a specific image size, in pixels, and I do not know how to do that in Draw. I just looked - There is a Pixel definition in the File Export using the exporting to a JPG format. There you can take your design and make it the correct pixel size. All you have to do it make the image proportional to the needed pixel size. Make your page/image be in centimeters and use a box 300 by 20 cm in size for your design area. Then export it to the 3000 by 200 pixels. - - - - What I did when I created a felt texture Persona was this: I created a page wide design using all of the filters and texture-fills that Inkscape has. I played around with them till I got a background image that I liked. That was using vector graphics way of making designs, the way Inkscape and Draw does. Then I exported the design to a bitmap image that is pixel based, like photos are. I made sure it was exported to be at least 3000 pixels wide and 200 high. Then I used a package, like GIMP, Paint Shop Pro, or Photoshop, to do some editing of the image to get the final design to be EXACTLY the 3000 pixel width and the 200 and 100 pixel high required for the Firefox specifications for a Persona. At that point I tested the Persona design, to make sure it did look well and was not interfering with the header and footer menu and icons. If you want to use it for LibreOffice 4.0.x and/or Firefox, you test the design[s] and tweak them before you decide they are working well for you. At that point, currently, you can go through the posting process to get your Persona listed in the Firefox Gallery. It is a simple process. I have asked the question about the approval process and a gallery placement within a LibreOffice page, like we have fore templates and extensions. We need approval if we use the official logo[s] for LibreOffice and TDF. So, look into the Person design specifications on Firefox's page. See if there is a way to create and export an image to a specific pixel size. Since I have not learned how to use Draw properly, I do not know this process. - - - - I use Corel Draw and Inkscape for my vector graphics images and Paint Shop Pro [5] and GIMP for the bitmap/pixel editing work. I use Ubuntu/Linux for my default OS on my desktop that I do most of my work. I use Inkscape and GIMP on them. I do use a Win7 and a Win XP/pro laptop[s] that I have Corel Draw, Inkscape, Paint Shop Pro [5] and GIMP installed on them. I have been using specific packages for specific design processes. Since I have used Paint Shop Pro 5 [and other] for many year before I looked into using any Linux system, I find it easier to use it for some image editing needs. Since I now use Linux for my desktop, I have been learning how it use GIMP for these editing processes. To be honest, right now, I do not know much about Draw's abilities and how to use it properly. It seems to be a vector graphics editor. It would be nice if I learned that package well enough to use it for that, but I know other vector graphic package much better and therefore easier for me to do the needed design work. I have been using some packages since they came out in the Windows 95/98 and XP days. You use what it easier for you to use. Maybe I will take the time to learn how to use Draw as well as I know the other packages, but that is not for the near future. -- 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] Strange fonts on my Windows system
On 02/14/2013 05:33 AM, William Drago wrote: All, I have a bunch of fonts on my Windows system that have weird names like cmbx6 Regular, cmdunh10 Regular, cmsltt10 Regular... Did these come with LibreOffice and if so what are they for? Also, why such cryptic names? Thanks, Bill They are system fonts, or so I have been told. Some packages and utilities withinthe Windows system may be using them for displaying text. The Command Line could use them. Some of the windowtext menu and titles displayed may use them. If these fonts were not installed by you, but are shown in you font list, DO NOT REMOVE them. If they are used by Windows or its utilities, you may have a big problem on your hands. I accidentally removed a font that I thought I did not need from an XP system. I did not know that that font name [several fonts styles] was used by Windows. I really had some weird looking menu texts till I fixed the problem. There are a lot of fonts that are installed by Windows, or Linux, that is used only by the system and was not intended to be used as a font in a normal document created by Writer or other package. Even though all of these extra fonts are listed in the font menus, I just avoid them and not delete/uninstall them. You may never know what fonts are being used by the OS or a package. I do know that some packages install specific fonts on your Windows [and Linux] system to be used as their default font[s] in their packages in one way or another. LibreOffice has a set of fonts. When I type in LibreOffice in my Linux package manager I get fonts-opensymbol 2:102.2+LibO. . . listed in the search for LibreOffice. For me, there are many, many fonts that are listed in my font list in Writer, to choose from. Many of them were placed there by Ubuntu [or Windows] when it was installed or one of the packages I installed afterwards. These fonts are not ones I would use in my documents, but I accept that they are there and I should not delete them, no matter how weird they look or are names. I have over 400 fonts and their styles listed in my Writer font drop down option. Many are there as core fonts I use for various projects, and may were placed there when I installed Ubuntu 12.04, MATE desktop environment, and all of the various packages I installed and use. Even though it makes is a pain to go through all of these extra fonts I may never use in a document or project, I will not risk deleting them. I learned this the hard way. -- 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] Save as doc crashes LO
No problem saving a writer document as .doc (MS Word 97/2000/XP/2003, either Save or Save_As) in LO 4.0.0.3 on Ubuntu Natty. jdh On 02/13/2013 08:56 PM, steveedmonds wrote: Hi. Saving a writer document as .doc crashes my LO on OpenSuse. Could someone please try on 4.0 and if it persists I will file a bug. perf_calc_translations.odt http://nabble.documentfoundation.org/file/n4037263/perf_calc_translations.odt Cheers, Steve -- View this message in context: http://nabble.documentfoundation.org/Save-as-doc-crashes-LO-tp4037263.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: Save as doc crashes LO
Hi :) For something like 99.5% of documents it's not a problem. The op was asking if this particular odt was a problem in 4.0.0 http://nabble.documentfoundation.org/file/n4037263/perf_calc_translations.odt I've just been able to save that document as doc in 4.0.0.3 from the LibreOffice website (ie not form a ppa or any distros repo) using Ubuntu 12.04 with the Unity DE. perf_calc_translations.doc http://nabble.documentfoundation.org/file/n4037492/perf_calc_translations.doc Now i am wondering if LO crashes on the op's system when he tries to open any of the versions of doc that i have sent. Also i wonder if renaming the User Profile fixed it or if the 4.0.0.3 is a more recent version than whatever he downloaded on Launch Day. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Save-as-doc-crashes-LO-tp4037263p4037492.html Sent from the Users mailing list archive at Nabble.com. -- 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] calc: method to subdivide individual cells
On 2013-02-14 1:23 AM, Brian Barker b.m.bar...@btinternet.com wrote: At 20:14 13/02/2013 -0500, Pete Bonly wrote: Does calc have some kind of method to subdivide individual cells? Yes - but you have to think of the problem the other way about. You can select a number of cells and then *merge* them, either by going to Format | Merge Cells or using the Merge Cells button in the Formatting toolbar. By starting with multiple rows or multiple columns (or both?) and merging some of the cells you can achieve the same effect as you would by subdividing cells. If you have an existing spreadsheet, you will want to insert additional rows or columns adjacent to your problem ones in order to start this process. I trust this helps. This will 'work', but it is much more complicated than if there was the possibility to just subdivide a single cell into multiples... -- 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] Save as doc crashes LO
On 02/13/2013 02:56 PM, steveedmonds wrote: Hi. Saving a writer document as .doc crashes my LO on OpenSuse. Could someone please try on 4.0 and if it persists I will file a bug. perf_calc_translations.odt http://nabble.documentfoundation.org/file/n4037263/perf_calc_translations.odt Cheers, Steve I saved it successfully to doc format with LO 4.0.0.3 using Linux Mint 13. LO was downloaded from the website; I do not believe it is available in the repositories yet. I did notice Chinese? characters. I used the default install settings. -- Jay Lozier jsloz...@gmail.com -- 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] Calc scale formula conundrum/ logic confusion
Hi Tom, Brian, On 14/02/13 10:52, Brian Barker wrote: At 07:45 14/02/2013 +, Tom Davies wrote: Someone else asked a very similar question about a month ago ... That someone else was (not surprisingly) the same person! ... and i think someone created a neat calculation or spreadsheet to help figure it out. Now the trick is trying to find it in the archives! He probably doesn't need to ... Yes its the same person ;) I had hoped I was able to ask more than one question about a problem, I mean it is even a different subject/thread. The value required is a currency value gathered from the sums of the different IF values according to a scale. I have the replies from the previous discussion we had via the list but the same formula does not seem to work in 'reverse'? I believe I have the right formula, but I think the logic in the IF functions needs checking. Its not a 'Do my homework please', its a genuine logic oops I think. Dare I say, that perhaps you also won't spot the error and let me know about it. I am sure you would be able to spot the error though? :) Regards Hylton -- Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://e-clubhouse.org/sites/fishhoek/index.php being part of the worlds largest non profit NGO -- 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] Save as doc crashes LO
Hi :) Yes, i saw Chinese characters too and it looked like they were arranged properly. So it looks like Gnome/Cinamon/Mate are covered by Mint and Unity covered by Ubuntu. Is anyone using a KDE distro? Alternatively perhaps it's a packaging issue? Mint and Ubuntu both use the .Deb (apt-get or dpkg). Does anyone have LibreOffice installed using the yum (.Rpm) method? Redhat/CentOS/ScientificLinux anyone? Hmmm, ideal would be someone on Redhat family and using KDE of course ;) Regards from Tom :) From: Jay Lozier jsloz...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 14 February 2013, 13:50 Subject: Re: [libreoffice-users] Save as doc crashes LO On 02/13/2013 02:56 PM, steveedmonds wrote: Hi. Saving a writer document as .doc crashes my LO on OpenSuse. Could someone please try on 4.0 and if it persists I will file a bug. perf_calc_translations.odt http://nabble.documentfoundation.org/file/n4037263/perf_calc_translations.odt Cheers, Steve I saved it successfully to doc format with LO 4.0.0.3 using Linux Mint 13. LO was downloaded from the website; I do not believe it is available in the repositories yet. I did notice Chinese? characters. I used the default install settings. -- Jay Lozier jsloz...@gmail.com -- 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] calc: method to subdivide individual cells
At 08:50 14/02/2013 -0500, Nobody Noname wrote: On 2013-02-14 1:23 AM, Brian Barker wrote: At 20:14 13/02/2013 -0500, Pete Bonly wrote: Does Calc have some kind of method to subdivide individual cells? [...] By starting with multiple rows or multiple columns (or both?) and merging some of the cells you can achieve the same effect as you would by subdividing cells. This will 'work', ... I'm not sure why your inverted commas are there: this will actually work, I think, plain and simple. ... but it is much more complicated than if there was the possibility to just subdivide a single cell into multiples... OK: suppose you divide cell Xn into four cells- two vertically and two horizontally. How do you now refer to the four new cells in formulae? And which of the now four separate values gets used if you refer to plain cell Xn in a formula? Brian Barker -- 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] Re: Pivot table numeric value is hidden by the combobox
Ricardo Renovatio wrote Hi, In Pivot table if a page field is numeric, the value is hidden by the combobox I’m using LibreOffice 4.0.0.3 This is indeed a bug. In fact it is a regression from version 3.6.x You should report the bug here https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice -- View this message in context: http://nabble.documentfoundation.org/Pivot-table-numeric-value-is-hidden-by-the-combobox-tp4037429p4037518.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: Calc scale formula conundrum/ logic confusion
Hi :) Yes, of course you can ask different questions. I just thought it was exactly the same question again in which case my answer wouldn't have been so wrong. Also i really don't think we have a problem with trying to help people with their homework. Of course there are always 1 or 2 awkward people in any social group or people that got out the wrong side of bed or just having a bad hair day (or month/year/decade). I might have ethical issues if you were getting grades for our work but we really don't answer that quickly. As far as most (i suspect) of us are concerned it's just another interesting puzzle to figure out. I wonder if there is a really good Maths forum for getting help with this sort of thing. It's a bit sideways from our normal ways of thinking so we might not be much good at it. A Maths forum like that might even be good place for students or kids to get unusual but real-life questions to figure out. A chance for teachers to escape irrelevant ancient dusty text-books and get real. Of course an obvious answer is to avoid using a spreadsheet for this initially and just use the back of an envelope or scrap of paper from elsewhere. When the question states the amount of unit i have left that suggests an upper limit that can't be exceeded such that Total amount of units allowed = Used + amount left So i think i need to know which of these 2 following statements are true and which isn't (or am i completely off-track?) G2= Total amount allowed, the limit or G2 = amount left In the question it seems to be being used in both ways at different times. Well, to me anyway. Regards from Tom :) zr1hpc wrote Using Calc 3.4.5 on openSuse 11.2 I am trying to work out the currency value of the amount of electricity units I have left at the end of the month (G2). This same formula will be used for the other 11 months of the year with only the G2 reference changing to G3, G4...etc. For those who wish to stretch their grey matter as mine just ain't stretching any more. The pricing scale the energy supplier has given me is: Unit RangeValue per unit 0-150 1.1320 150.01 - 600 1.1811 600.01 - 1.4018 Therefore the first 150 units are priced at 1.132 ea. any units still available need to be calculated at the next rate of 1.1811, but only up to 449.90 units at the second rate. Anything more than that must be at the highest rate of 1.4018. Assuming my unit balance of G2 = 433 I can work out the currency value of G2 by following the following logic, and using the scale above: 433 150 therefore the initial 150 units need to be priced at 1.1320 i.e. 150* 1.132= ZAR169.80. To this the balance of the units over 150 need to be multiplied by the next rate of 1.1811 i.e. 433-150= 283. Since 283 is below the max of 449.9 units allowed for this scale, therefore 283*1.1811= ZAR334.25. The third scale is not needed as all the units have been accounted for, however it must be available should G2 exceed 600 units e.g. taking 601 units; the first 150 would be costed at 1.132, the next 449.9 costed at 1.1811 and the balance of 1.1 units costed at 1.4018 per unit. Therefore total value of 433 units is: 150*1.1320 = 169.80 + 283*1.1811 = 334.25 _ Value ZAR504.05 Values used in formulae below are: G2 = 433 available units $F$18 = 1.132 cost per unit $G$18 = 0 - 150 units $H$18 = 169.80 = value of F*G $I$18 = 1.1811 cost per unit $J$18 = 150.1 - 600 units $K$18 = 531.38 = value of I*449.90 = 600-150.1 $L$18 = 1.4018 cost per unit $M$18 = 600.01 $N$18 = 841.09 = M*L however this value is dependent on how many units over 600 column G2:g13 is. SUM(IF(G2=$G$18,$H$18,(G2-$G$18)*$F$18),IF($G$18(G2-$G$18)=$J$18,$K$18,(G2-$G$18)*$I$18),IF((G2-$G$18-$J$18)=$M$18,$N$18,(G2-$G$18-$J$18)*$L$18)) Even taking out the SUM(), and replacing 'commaIF' with '+IF's gives the incorrect answer i.e. 467.22. There must be a problem with my logic in the above formula as the answer is so close, but for the life of me I cannot see it. Asking for some 'logic'al help to work out the correct value in H2:H13 File attached via Nabble: Electricity.ods http://nabble.documentfoundation.org/file/n4037350/Electricity.ods Appreciated Hylton -- Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://e-clubhouse.org/sites/fishhoek/index.php being part of the worlds largest non profit NGO -- View this message in context: http://nabble.documentfoundation.org/Calc-scale-formula-conundrum-logic-confusion-tp4037350p4037519.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?
[libreoffice-users] LibreOffice V 3.6.5.2 (build ID: 5b93205)
Sirs I am at the moment running Microsoft Office on my desktop computer (XP) and have just purchased a new laptop (Windows 7) onto which I have downloaded the above LibreOffice. I wish to ensure that the documents I already have on the XP machine can safely be read, changed in Calc written back before I change my desktop machine to LibreOffice also. However I have 2 problems that need resolving, both to do with Macros. 1. When I load an Excel document containing macros into Calc, the macros (assigned to buttons on the worksheet) work OK, but when I make changes to the document and then save it in xls format the macros no longer work in Excel as the path to the macros seems to have been changed. I can go into the macros, change the path and make them work again but this is by no means satisfactory. Other people use my files so my changing to LibreOffice on the desktop m/c will not help them. Any clues anyone? 2. These same documents may require me to record new macros so I searched your Help files for information on how to do this and came across problem 2. The help file says to click on 'Tools/Macros/Record Macros', however when I checked this I find there is no 'Record Macros' choice, only 'Run Macros'. Is your help file wrong or am I missing something? Other than the above, I think that LibreOffice is brilliant and can't wait to install it on my desktop m/c. Regards Norman Hancock -- 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] LibreOffice V 3.6.5.2 (build ID: 5b93205)
On 14/02/2013 at 15:45, norman.hanc...@talktalk.net wrote: 2. These same documents may require me to record new macros so I searched your Help files for information on how to do this and came across problem 2. The help file says to click on 'Tools/Macros/Record Macros', however when I checked this I find there is no 'Record Macros' choice, only 'Run Macros'. Is your help file wrong or am I missing something? This is quite common question. You must first enable macro recording. Go to Tools → Options → General. (In LibreOffice 4.0.0 this is Advanced, not General). This feature is disabled by default, because macro recorder code has not been changed in a while and it is known to have very limited capabilities. If you can't live without macros, your best choice is to write them yourself. -- 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] Microfund your favourite Issue
On 02/13/2013 10:44 PM, Jean-Francois Nifenecker wrote: Le 14/02/2013 03:21, anne-ology a écrit : yes, very interesting idea. Yes, indeed. I wonder, though, how would the fixed bug integrate into the code maintained by the LibO crew. It is open to anyone, and anyone is welcome to contribute so that wouldn't be an issue. Interesting discussion happening here, please keep it alive and pass the word :-D Best 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
[libreoffice-users] Re: Calc scale formula conundrum/ logic confusion
Hi,
zr1hpc wrote
Using Calc 3.4.5 on openSuse 11.2
I am trying to work out the currency value of the amount of electricity
units I have left at the end of the month (G2).
This same formula will be used for the other 11 months of the year with
only the G2 reference changing to G3, G4...etc.
For those who wish to stretch their grey matter as mine just ain't
stretching any more.
The pricing scale the energy supplier has given me is:
Unit RangeValue per unit
0-150 1.1320
150.01 - 600 1.1811
600.01 - 1.4018
Therefore the first 150 units are priced at 1.132 ea. any units still
available need to be calculated at the next rate of 1.1811, but only up to
449.90 units at the second rate. Anything more than that must be at the
highest rate of 1.4018.
Assuming my unit balance of G2 = 433 I can work out the currency value of
G2 by following the following logic, and using the scale above:
433 150 therefore the initial 150 units need to be priced at 1.1320 i.e.
150* 1.132= ZAR169.80. To this the balance of the units over 150 need to
be multiplied by the next rate of 1.1811 i.e. 433-150= 283. Since 283 is
below the max of 449.9 units allowed for this scale, therefore 283*1.1811=
ZAR334.25. The third scale is not needed as all the units have been
accounted for, however it must be available should G2 exceed 600 units
e.g. taking 601 units; the first 150 would be costed at 1.132, the next
449.9 costed at 1.1811 and the balance of 1.1 units costed at 1.4018 per
unit.
Therefore total value of 433 units is:
150*1.1320 = 169.80
+ 283*1.1811 = 334.25
_
Value ZAR504.05
This formula will give you the result :
=SUMPRODUCT(G2{0;150;600};G2-{0;150;600};{1,132;0,0491;0,2207})
0.0491 is the difference of the cost between the cost for 150units600 and
units150
0.2207 diff between cots for units600 and 150units600
Look at this post in the forum :
http://forum.openoffice.org/en/forum/viewtopic.php?f=9t=40938
Download the file of my post (the 3rd one) to see how it works.
Gérard
--
View this message in context:
http://nabble.documentfoundation.org/Calc-scale-formula-conundrum-logic-confusion-tp4037350p4037526.html
Sent from the Users mailing list archive at Nabble.com.
--
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] LibreOffice V 3.6.5.2 (build ID: 5b93205)
Hi :) With the emphasis being on Write rather than just recording. Recording macros apparently tends to end up with mad spaghetti that is impossible to correct when it goes wonky. However it is an imperfect world so recording might be unavoidable, given time constraints. If you do have time to learn how to write good macros properly then apparently Andrew Pitonyak's guide is an invaluable resource and well worth the money. It's the bottom link on our unofficial/third party guides page; https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers Regards from Tom :) From: Mirosław Zalewski mini...@poczta.onet.pl To: users@global.libreoffice.org Sent: Thursday, 14 February 2013, 15:02 Subject: Re: [libreoffice-users] LibreOffice V 3.6.5.2 (build ID: 5b93205) On 14/02/2013 at 15:45, norman.hanc...@talktalk.net wrote: 2. These same documents may require me to record new macros so I searched your Help files for information on how to do this and came across problem 2. The help file says to click on 'Tools/Macros/Record Macros', however when I checked this I find there is no 'Record Macros' choice, only 'Run Macros'. Is your help file wrong or am I missing something? This is quite common question. You must first enable macro recording. Go to Tools → Options → General. (In LibreOffice 4.0.0 this is Advanced, not General). This feature is disabled by default, because macro recorder code has not been changed in a while and it is known to have very limited capabilities. If you can't live without macros, your best choice is to write them yourself. -- 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 -- 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] LibreOffice V 3.6.5.2 (build ID: 5b93205)
Hi :) Ahah, yes, macros are not usually able to work on both MS Office and LibreOffice. They have to be written (or recorded) on one or other and then seldom work on the other. With MS macros you may well find they don't even work in other versions of MS Office. So if your macros were written/recorded in MS Office 2007 then they may well not work in MS Office 2010 until they get converted and then you can't go back to 2007 with them. LibreOffice macros just work regardless of which version. It's worth noting that LibreOffice is free and can also be run as a portable app installed on a usb-stick or on a Cloud storage place and then run without really properly installing it on whichever machine you need to run it on. When you disconnect from the Cloud or unplug the usb-stick then that machine no longer has LibreOffice on it. There are a number of other apps (such as Firefox, Thunderbird and others) that can all be on the same usb-stick and used on any machine the usb-stick is plugged into (assuming it runs Windows) http://www.libreoffice.org/download/portable/ Another thing that people often don't consider is that it is perfectly fine to have LibreOffice installed on the same machine as MS Office, or to install MS Office onto a machine that already has LibreOffice. You don't HAVE to get rid of one in order to run the other. In fact this is often the suggested route for gradually migrating. Have both. [shrugs] Then you can open all documents from anyone in any format rather than just hoping you are not going to find one of the 0.25% of documents in MS format that doesn't work in LibreOffice. Another thing that is often down-played by MS is that most of their licenses for their office suite allows you to install it on 2-3 machines. Many people have more than 1 machine at home if you count laptops and the rest and MS finally caved in about archaic restrictions. So the main trouble is trying to get install media to get it onto the laptop but once you do that the same product key should work. I'm sure i shouldn't be saying that but i do hope you continue with LibreOffice. Good luck and regards from Tom :) From: norman.hanc...@talktalk.net norman.hanc...@talktalk.net To: users@global.libreoffice.org Sent: Thursday, 14 February 2013, 14:45 Subject: [libreoffice-users] LibreOffice V 3.6.5.2 (build ID: 5b93205) Sirs I am at the moment running Microsoft Office on my desktop computer (XP) and have just purchased a new laptop (Windows 7) onto which I have downloaded the above LibreOffice. I wish to ensure that the documents I already have on the XP machine can safely be read, changed in Calc written back before I change my desktop machine to LibreOffice also. However I have 2 problems that need resolving, both to do with Macros. 1. When I load an Excel document containing macros into Calc, the macros (assigned to buttons on the worksheet) work OK, but when I make changes to the document and then save it in xls format the macros no longer work in Excel as the path to the macros seems to have been changed. I can go into the macros, change the path and make them work again but this is by no means satisfactory. Other people use my files so my changing to LibreOffice on the desktop m/c will not help them. Any clues anyone? 2. These same documents may require me to record new macros so I searched your Help files for information on how to do this and came across problem 2. The help file says to click on 'Tools/Macros/Record Macros', however when I checked this I find there is no 'Record Macros' choice, only 'Run Macros'. Is your help file wrong or am I missing something? Other than the above, I think that LibreOffice is brilliant and can't wait to install it on my desktop m/c. Regards Norman Hancock -- 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] Microfund your favourite Issue
On Thu, 2013-02-14 at 07:16 -0800, Joel Madero wrote: On 02/13/2013 10:44 PM, Jean-Francois Nifenecker wrote: Le 14/02/2013 03:21, anne-ology a écrit : yes, very interesting idea. Yes, indeed. Yes. I wonder, though, how would the fixed bug integrate into the code maintained by the LibO crew. It is open to anyone, and anyone is welcome to contribute so that wouldn't be an issue. Interesting discussion happening here, please keep it alive and pass the word :-D I haven't seen a message in this thread from someone with an libreoffice e-mail address... is this at all 'sanctioned' by the project? Someone in the project on-board? Someone credible is vouching that www.freedomsponsors.org is legit and on-the-level? -- Adam Tauno Williams GPG D95ED383 Systems Administrator, Python Developer, LPI / NCLA -- 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] Table borders
Le 14/02/2013 10:10, PGR a écrit : The border does render fine when printing from MS Word. The border management between office suites is a mess. Also, ISTR that borders management has had several incarnations between the recent OOo/LibO versions. This was due to the fact the devs wanted to bring a better compatibility with MS Excel. If you search this list with the borders and Calc keywords, you should find some more precise information. I have an OOo 3.3 spreadsheet with borders that look awfully thick when opened under Lib0 3.5.6. Has I told before, I have a logo inside the header of my document. If I remove the logo, the table gets printed. But I can't do this because these are oficial documents that are connected to a DB. If I create a document from scratch inside LO with a logo and a table this doesn't happen, but I have to keep using existing documents. I think there's no solution yet and I have to still use MS office for a while... :( The only solution I can see it to reset the borders under LibO 4. Then it should be ok. HTH, -- 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] Share-point?
Just 'searched' and found this - http://www.youtube.com/watch?v=s12Jb5Z2xaE Seems somewhat silly since we could all benefit if we were to use DropBox - http://db.tt/v1nUSr8M On Wed, Feb 13, 2013 at 2:24 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. According to the comments under this article http://www.webupd8.org/2013/02/libreoffice-40-available-for-download.html Somewhere about 1/4 up from the bottom Алексей Бродкин • 6 days ago It seems like some of highlighted options are missing from this release. 1. Unity/Global menu integration - at least I cannot see it in action or any toggle in setting 2. SharePoint integration. From here http://tekonorma.fr/WPblogTN/2... I learnt that to have this option one needs to instal a corresponding plug-in from here http://extensions.libreoffice and you may see this link leads to This page does not seem to exist... - seems like due to legal issue plugin was removed. Sure enough the link didn't work so i got to the Extensions site another way but a quick search to find sharepoint or share point didn't reveal any relevant Extensions. 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] Find out a name of inserted image in Impress
Probably the simplest way would be to use the 'notes' within IMPRESS ;-) in this way, you could keep track of the order, the title, as well as any extraneous bits pertaining to that image. On Sun, Feb 10, 2013 at 1:11 PM, v...@ukr.net wrote: Hello! I have some problem with opening a presentation created in Impress v.3.5 with a new Impress v.4.0.0.3. Particularly, it turned out that some images are absent on the slides in 4.0 while they are present when I open the presentation on my friend's PC with LO 3.6 on it. So, I do not remember which slide contained which image or video. How can I find out the name of the inserted image or video file? Thank you! Vladimir -- 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] Share-point?
Hi :) Ahh, so is it a sort of Content Management System that can be used to hold documents centrally, like putting them on a shared folder on a Lan so that everyone can work on the same file instead of each generating different copies and then trying to compare all the different ones to incorporate all the different changes? Sort of like a wiki? Regards from Tom :) From: anne-ology lagin...@gmail.com To: Tom tomdavie...@yahoo.co.uk Cc: users@global.libreoffice.org Sent: Thursday, 14 February 2013, 16:53 Subject: Re: [libreoffice-users] Share-point? Just 'searched' and found this - http://www.youtube.com/watch?v=s12Jb5Z2xaE Seems somewhat silly since we could all benefit if we were to use DropBox - http://db.tt/v1nUSr8M On Wed, Feb 13, 2013 at 2:24 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. According to the comments under this article http://www.webupd8.org/2013/02/libreoffice-40-available-for-download.html Somewhere about 1/4 up from the bottom Алексей Бродкин • 6 days ago It seems like some of highlighted options are missing from this release. 1. Unity/Global menu integration - at least I cannot see it in action or any toggle in setting 2. SharePoint integration. From here http://tekonorma.fr/WPblogTN/2... I learnt that to have this option one needs to instal a corresponding plug-in from here http://extensions.libreoffice and you may see this link leads to This page does not seem to exist... - seems like due to legal issue plugin was removed. Sure enough the link didn't work so i got to the Extensions site another way but a quick search to find sharepoint or share point didn't reveal any relevant Extensions. 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 -- 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] icons
Hi :) Approximately page 3 of most chapters of the official guides says something like this Icons The icons used to illustrate some of the many tools available in LibreOffice may differ from the ones used in this guide. The icons in this guide have been taken from a LibreOffice installation that has been set to display the Galaxy set of icons. If you wish, you can change your LibreOffice software package to display Galaxy icons as follows: What you see may be different 1) On Linux and Windows operating systems, go to Tools Options LibreOffice View on the main menu bar to open the dialog for view options. 2) On a Mac operating system, go to LibreOffice Preferences View on the main menu bar to open the dialog for view options. 3) In User interface Icon size and style select Galaxy from the options available in the drop- down list. 4) Click OK to save your settings and close the dialog. Regards from Tom :) From: IBBoard ibbo...@gmail.com To: Malcolm Moore st-malcolm.mo...@whsg.info Cc: users@global.libreoffice.org Sent: Wednesday, 13 February 2013, 22:29 Subject: Re: [libreoffice-users] icons The ones with opensuse *are* the normal icons, so it is Libreoffice rather than Opensuse being boring. There may be extra icon sets (I've seen one article about a Faenza icon set) but they had to be used to replace an existing theme rather than added as a new one. If you want to try a different icon set then I'd try gnome-look.org or a Google search for phrases like libreoffice toolbar icon set, but I don't believe there are many as most people are presumably happy with one of the existing sets. On Feb 12, 2013 9:19 PM, Malcolm Moore st-malcolm.mo...@whsg.info wrote: Is there anywhere that does different icon sets .. sorry, but I think the ones that come with opensuse are a bit boring Ta M -- 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-users] How to convert tab-separated file to XLS from the command line
Hi :) I think the MS 95 format is still .xls and can be read and used by subsequent versions of both MSO and all versions of LO. So i think just don't worry about your 2nd point. LibreOffice can read/write tsv as well as csv but it's just not the default. I'm not sure how to force it to change from csv to tsv on the command-line. Apols and regards from Tom :) From: Brian Cottingham spiffyt...@gmail.com To: users@global.libreoffice.org Sent: Wednesday, 13 February 2013, 18:41 Subject: [libreoffice-users] How to convert tab-separated file to XLS from the command line I have a tab-separated file that I'm trying to convert to XLS from the command line. This is the command I'm using: sudo libreoffice --headless --convert-to xls filename.tsv This has two problems: 1. LibreOffice does not use a tab separator; it assumes a comma separator, so my columns aren't detected correctly 2. LibreOffice reports converting to MS Excel 5.0/95 format. How can I instruct it to convert to Excel 2003 format? -- 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] Share-point?
Content Management System ;-) ... LAN ;-) ... a wiki ;-) ??? as to these - I haven't a clue; I'll continue to stick with the KISs method ;-) But if we each sign up to use DropBox, we can each end up with 6Gb of free space to use as we wish in sharing documents - and MsFt does not have any control over this :-) On Thu, Feb 14, 2013 at 11:03 AM, Tom Davies tomdavie...@yahoo.co.ukwrote: Hi :) Ahh, so is it a sort of Content Management System that can be used to hold documents centrally, like putting them on a shared folder on a Lan so that everyone can work on the same file instead of each generating different copies and then trying to compare all the different ones to incorporate all the different changes? Sort of like a wiki? Regards from Tom :) -- *From:* anne-ology lagin...@gmail.com *To:* Tom tomdavie...@yahoo.co.uk *Cc:* users@global.libreoffice.org *Sent:* Thursday, 14 February 2013, 16:53 *Subject:* Re: [libreoffice-users] Share-point? Just 'searched' and found this - http://www.youtube.com/watch?v=s12Jb5Z2xaE Seems somewhat silly since we could all benefit if we were to use DropBox - http://db.tt/v1nUSr8M On Wed, Feb 13, 2013 at 2:24 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. According to the comments under this article http://www.webupd8.org/2013/02/libreoffice-40-available-for-download.html Somewhere about 1/4 up from the bottom Алексей Бродкин • 6 days ago It seems like some of highlighted options are missing from this release. 1. Unity/Global menu integration - at least I cannot see it in action or any toggle in setting 2. SharePoint integration. From here http://tekonorma.fr/WPblogTN/2... I learnt that to have this option one needs to instal a corresponding plug-in from here http://extensions.libreoffice and you may see this link leads to This page does not seem to exist... - seems like due to legal issue plugin was removed. Sure enough the link didn't work so i got to the Extensions site another way but a quick search to find sharepoint or share point didn't reveal any relevant Extensions. 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] Share-point?
Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable - and rightly so, since it means important documents go outside your perimeter. Instead they use a document management system (like Sharepoint or Alfresco) that they install and manage centrally. Unlike a wiki, a document management system gives full, normal document management. Unlike a CMS it is all about documents, and unlike a LAN share it does versioning and workflow. Basically, Sharepoint is something for businesses. A normal user will never need it. On Feb 14, 2013 5:28 PM, anne-ology lagin...@gmail.com wrote: Content Management System ;-) ... LAN ;-) ... a wiki ;-) ??? as to these - I haven't a clue; I'll continue to stick with the KISs method ;-) But if we each sign up to use DropBox, we can each end up with 6Gb of free space to use as we wish in sharing documents - and MsFt does not have any control over this :-) On Thu, Feb 14, 2013 at 11:03 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Ahh, so is it a sort of Content Management System that can be used to hold documents centrally, like putting them on a shared folder on a Lan so that everyone can work on the same file instead of each generating different copies and then trying to compare all the different ones to incorporate all the different changes? Sort of like a wiki? Regards from Tom :) -- *From:* anne-ology lagin...@gmail.com *To:* Tom tomdavie...@yahoo.co.uk *Cc:* users@global.libreoffice.org *Sent:* Thursday, 14 February 2013, 16:53 *Subject:* Re: [libreoffice-users] Share-point? Just 'searched' and found this - http://www.youtube.com/watch?v=s12Jb5Z2xaE Seems somewhat silly since we could all benefit if we were to use DropBox - http://db.tt/v1nUSr8M On Wed, Feb 13, 2013 at 2:24 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. According to the comments under this article http://www.webupd8.org/2013/02/libreoffice-40-available-for-download.html Somewhere about 1/4 up from the bottom Алексей Бродкин • 6 days ago It seems like some of highlighted options are missing from this release. 1. Unity/Global menu integration - at least I cannot see it in action or any toggle in setting 2. SharePoint integration. From here http://tekonorma.fr/WPblogTN/2... I learnt that to have this option one needs to instal a corresponding plug-in from here http://extensions.libreoffice and you may see this link leads to This page does not seem to exist... - seems like due to legal issue plugin was removed. Sure enough the link didn't work so i got to the Extensions site another way but a quick search to find sharepoint or share point didn't reveal any relevant Extensions. 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 -- 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] Share-point?
On 13-02-13 03:24 AM, Tom Davies wrote: Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. Sharepoint needs to be configured with CMIS support, last I heard this was not trivial. Cedric Bosdonnat would know about this, I asked on IRC and he was looking for someone with such a setup to test further. F. -- Fabián Rodríguez http://fsf.magicfab.ca -- 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] Share-point?
Hi :) Thanks :) That makes it sound more like a regular LAN with possibilities of being a fairly standard WAN. Still, even if that is all it is then it's nice to have a nice gui rather than dropping to the command-line to set people up. Just possibly i'm just being dismissive purely because it's MS. Thanks and regards from Tom :) From: Sigrid Carrera sigrid.carr...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: anne-ology lagin...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 14 February 2013, 17:32 Subject: Re: [libreoffice-users] Share-point? Hi Tom, all, we have sharepoint here at our company. It is a central server, where everyone can store files. Depending on the setup, you can have different permissions for different folders, so that not everyone can see everything. You can even set it up in such a way, that your subsidiaries in other contries can have access to it as well, but also can only see what they are allowed to see. Limitations on file sizes are also possible. You set it up on its own URL (maybe a subdomain of your existing domain), you can even use it with https, so that it is more secured. Dropbox does not work for everyone and it might not be allowed in a company setup. On 14 February 2013 18:03, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Ahh, so is it a sort of Content Management System that can be used to hold documents centrally, like putting them on a shared folder on a Lan so that everyone can work on the same file instead of each generating different copies and then trying to compare all the different ones to incorporate all the different changes? Sort of like a wiki? I think, your description describes well, what it is. :) Cheers, Sigrid -- 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] Share-point?
On Thu, 14 Feb 2013, IBBoard wrote: Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable - and rightly so, since it means important documents go outside your perimeter. Instead they use a document management system (like Sharepoint or Alfresco) that they install and manage centrally. Unlike a wiki, a document management system gives full, normal document management. Unlike a CMS it is all about documents, and unlike a LAN share it does versioning and workflow. Basically, Sharepoint is something for businesses. A normal user will never need it. I don't understand the relation between these propositions: a) Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable... b) Basically, Sharepoint is something for businesses. is the point that it is better for a business that Microsoft hold their documents than that Busybox does? just seeking clarification. (I have Busybox but don't use it for a number of reasons; I am not acquainted enough with Sharepoint.) F. On Feb 14, 2013 5:28 PM, anne-ology lagin...@gmail.com wrote: Content Management System ;-) ... LAN ;-) ... a wiki ;-) ??? as to these - I haven't a clue; I'll continue to stick with the KISs method ;-) But if we each sign up to use DropBox, we can each end up with 6Gb of free space to use as we wish in sharing documents - and MsFt does not have any control over this :-) On Thu, Feb 14, 2013 at 11:03 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Ahh, so is it a sort of Content Management System that can be used to hold documents centrally, like putting them on a shared folder on a Lan so that everyone can work on the same file instead of each generating different copies and then trying to compare all the different ones to incorporate all the different changes? Sort of like a wiki? Regards from Tom :) -- *From:* anne-ology lagin...@gmail.com *To:* Tom tomdavie...@yahoo.co.uk *Cc:* users@global.libreoffice.org *Sent:* Thursday, 14 February 2013, 16:53 *Subject:* Re: [libreoffice-users] Share-point? Just 'searched' and found this - http://www.youtube.com/watch?v=s12Jb5Z2xaE Seems somewhat silly since we could all benefit if we were to use DropBox - http://db.tt/v1nUSr8M On Wed, Feb 13, 2013 at 2:24 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. According to the comments under this article http://www.webupd8.org/2013/02/libreoffice-40-available-for-download.html Somewhere about 1/4 up from the bottom Алексей Бродкин • 6 days ago It seems like some of highlighted options are missing from this release. 1. Unity/Global menu integration - at least I cannot see it in action or any toggle in setting 2. SharePoint integration. From here http://tekonorma.fr/WPblogTN/2... I learnt that to have this option one needs to instal a corresponding plug-in from here http://extensions.libreoffice and you may see this link leads to This page does not seem to exist... - seems like due to legal issue plugin was removed. Sure enough the link didn't work so i got to the Extensions site another way but a quick search to find sharepoint or share point didn't reveal any relevant Extensions. Regards from Tom :) -- Felmon Davis Seek simplicity -- and distrust it. -- Alfred Whitehead -- 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] Share-point?
HI :) Ahah, so it's something to do with my buddy's video? http://www.youtube.com/watch?v=f2bbnyAjMeM linked to from the main website http://www.libreoffice.org/home/Discover#/Discover%20it Regards from Tom :) From: Fabian Rodriguez magic...@member.fsf.org To: users@global.libreoffice.org Sent: Thursday, 14 February 2013, 17:38 Subject: Re: [libreoffice-users] Share-point? On 13-02-13 03:24 AM, Tom Davies wrote: Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. Sharepoint needs to be configured with CMIS support, last I heard this was not trivial. Cedric Bosdonnat would know about this, I asked on IRC and he was looking for someone with such a setup to test further. F. -- Fabián Rodríguez http://fsf.magicfab.ca -- 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] Share-point?
On 14/02/2013 at 19:20, Felmon Davis dav...@union.edu wrote: is the point that it is better for a business that Microsoft hold their documents than that Busybox does? SharePoint is internal network solution. It does not exchange any information it holds with Microsoft servers. Your confidential data stays yours. This is opposite to Dropbox, Google Docs, Microsoft SkyDrive and any other cloud system, where you must share your data with system operators. -- 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] Share-point?
Sharepoint is a self-hosted solution. You are relying on a Microsoft product, but the documents are never handed over to Microsoft and none of the files never leave your network. It isn't perfect, but is generally fairly secure (as secure as your networks, anyway) and companies can use it. Dropbox is an unencrypted cloud solution. Once it is on the Dropbox severs then any of the Dropbox staff /could/ read it. Or it could be copied or otherwise lost by people who aren't your employees. Or it could be leaked as party of a wider Dropbox hack/leak. Or it could be retrieved by a foreign government (USA, I think) without your knowledge. Generally, it is out of your corporate network perimeter and hence out of your control. In general, that is *not* a good thing. That's not to say people can't use Dropbox. If you don't value your files (or have some reason to trust that nothing will happen to your unencrypted files in an unknown data centre or data centres) then that might be fine, but for a company that has to protect its ideas and business secrets then an internally hosted solution is the only sensible option, even if it is from Microsoft. On Feb 14, 2013 6:21 PM, Felmon Davis dav...@union.edu wrote: On Thu, 14 Feb 2013, IBBoard wrote: Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable - and rightly so, since it means important documents go outside your perimeter. Instead they use a document management system (like Sharepoint or Alfresco) that they install and manage centrally. Unlike a wiki, a document management system gives full, normal document management. Unlike a CMS it is all about documents, and unlike a LAN share it does versioning and workflow. Basically, Sharepoint is something for businesses. A normal user will never need it. I don't understand the relation between these propositions: a) Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable... b) Basically, Sharepoint is something for businesses. is the point that it is better for a business that Microsoft hold their documents than that Busybox does? just seeking clarification. (I have Busybox but don't use it for a number of reasons; I am not acquainted enough with Sharepoint.) F. On Feb 14, 2013 5:28 PM, anne-ology lagin...@gmail.com wrote: Content Management System ;-) ... LAN ;-) ... a wiki ;-) ??? as to these - I haven't a clue; I'll continue to stick with the KISs method ;-) But if we each sign up to use DropBox, we can each end up with 6Gb of free space to use as we wish in sharing documents - and MsFt does not have any control over this :-) On Thu, Feb 14, 2013 at 11:03 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Ahh, so is it a sort of Content Management System that can be used to hold documents centrally, like putting them on a shared folder on a Lan so that everyone can work on the same file instead of each generating different copies and then trying to compare all the different ones to incorporate all the different changes? Sort of like a wiki? Regards from Tom :) -- *From:* anne-ology lagin...@gmail.com *To:* Tom tomdavie...@yahoo.co.uk *Cc:* users@global.libreoffice.org *Sent:* Thursday, 14 February 2013, 16:53 *Subject:* Re: [libreoffice-users] Share-point? Just 'searched' and found this - http://www.youtube.com/watch?**v=s12Jb5Z2xaEhttp://www.youtube.com/watch?v=s12Jb5Z2xaE Seems somewhat silly since we could all benefit if we were to use DropBox - http://db.tt/v1nUSr8M On Wed, Feb 13, 2013 at 2:24 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. According to the comments under this article http://www.webupd8.org/2013/**02/libreoffice-40-available-** for-download.htmlhttp://www.webupd8.org/2013/02/libreoffice-40-available-for-download.html Somewhere about 1/4 up from the bottom Алексей Бродкин • 6 days ago It seems like some of highlighted options are missing from this release. 1. Unity/Global menu integration - at least I cannot see it in action or any toggle in setting 2. SharePoint integration. From here http://tekonorma.fr/WPblogTN/** 2. http://tekonorma.fr/WPblogTN/2... I learnt that to have this option one needs to instal a corresponding plug-in from here http://extensions.libreoffice.**... and you may see this link leads to This page does not seem to exist... - seems like due to legal issue plugin was removed. Sure enough the link didn't work so i got to the Extensions site another way but a quick search to find sharepoint or share
Re: [libreoffice-users] Share-point?
On Thu, 14 Feb 2013, Mirosław Zalewski wrote: On 14/02/2013 at 19:20, Felmon Davis dav...@union.edu wrote: is the point that it is better for a business that Microsoft hold their documents than that Busybox does? SharePoint is internal network solution. It does not exchange any information it holds with Microsoft servers. Your confidential data stays yours. This is opposite to Dropbox, Google Docs, Microsoft SkyDrive and any other cloud system, where you must share your data with system operators. I see; good prompt for me to do some research. I wholly agree this is far better than BusyBox for many purposes. F. -- Felmon Davis When in doubt, take all the defaults. -- 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] Share-point?
On Thu, 14 Feb 2013, IBBoard wrote: Sharepoint is a self-hosted solution. You are relying on a Microsoft product, but the documents are never handed over to Microsoft and none of the files never leave your network. It isn't perfect, but is generally fairly secure (as secure as your networks, anyway) and companies can use it. Dropbox is an unencrypted cloud solution. Once it is on the Dropbox severs then any of the Dropbox staff /could/ read it. Or it could be copied or otherwise lost by people who aren't your employees. Or it could be leaked as party of a wider Dropbox hack/leak. Or it could be retrieved by a foreign government (USA, I think) without your knowledge. Generally, it is out of your corporate network perimeter and hence out of your control. In general, that is *not* a good thing. That's not to say people can't use Dropbox. If you don't value your files (or have some reason to trust that nothing will happen to your unencrypted files in an unknown data centre or data centres) then that might be fine, but for a company that has to protect its ideas and business secrets then an internally hosted solution is the only sensible option, even if it is from Microsoft. I wholly concur that it is generally better to keep stuff 'home' to the extent possible. (just lost a local struggle here about this issue but regarding using google apps.) you could put _encrypted_ files on Busybox thus obviating that security leak, and you could maintain backups thus ensuring you don't lose the files. but better keep things at home. F. On Feb 14, 2013 6:21 PM, Felmon Davis dav...@union.edu wrote: On Thu, 14 Feb 2013, IBBoard wrote: Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable - and rightly so, since it means important documents go outside your perimeter. Instead they use a document management system (like Sharepoint or Alfresco) that they install and manage centrally. Unlike a wiki, a document management system gives full, normal document management. Unlike a CMS it is all about documents, and unlike a LAN share it does versioning and workflow. Basically, Sharepoint is something for businesses. A normal user will never need it. I don't understand the relation between these propositions: a) Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable... b) Basically, Sharepoint is something for businesses. is the point that it is better for a business that Microsoft hold their documents than that Busybox does? just seeking clarification. (I have Busybox but don't use it for a number of reasons; I am not acquainted enough with Sharepoint.) F. On Feb 14, 2013 5:28 PM, anne-ology lagin...@gmail.com wrote: Content Management System ;-) ... LAN ;-) ... a wiki ;-) ??? as to these - I haven't a clue; I'll continue to stick with the KISs method ;-) But if we each sign up to use DropBox, we can each end up with 6Gb of free space to use as we wish in sharing documents - and MsFt does not have any control over this :-) On Thu, Feb 14, 2013 at 11:03 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Ahh, so is it a sort of Content Management System that can be used to hold documents centrally, like putting them on a shared folder on a Lan so that everyone can work on the same file instead of each generating different copies and then trying to compare all the different ones to incorporate all the different changes? Sort of like a wiki? Regards from Tom :) -- *From:* anne-ology lagin...@gmail.com *To:* Tom tomdavie...@yahoo.co.uk *Cc:* users@global.libreoffice.org *Sent:* Thursday, 14 February 2013, 16:53 *Subject:* Re: [libreoffice-users] Share-point? Just 'searched' and found this - http://www.youtube.com/watch?**v=s12Jb5Z2xaEhttp://www.youtube.com/watch?v=s12Jb5Z2xaE Seems somewhat silly since we could all benefit if we were to use DropBox - http://db.tt/v1nUSr8M On Wed, Feb 13, 2013 at 2:24 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. According to the comments under this article http://www.webupd8.org/2013/**02/libreoffice-40-available-** for-download.htmlhttp://www.webupd8.org/2013/02/libreoffice-40-available-for-download.html Somewhere about 1/4 up from the bottom Алексей Бродкин • 6 days ago It seems like some of highlighted options are missing from this release. 1. Unity/Global menu integration - at least I cannot see it in action or any toggle in setting 2. SharePoint integration. From here http://tekonorma.fr/WPblogTN/** 2. http://tekonorma.fr/WPblogTN/2... I learnt that to have this option one needs to instal a corresponding plug-in from here
Re: [libreoffice-users] Share-point?
Yes, you can encrypt it first, but a) that is an extra step and b) it only gives you a semi-useful backup, not a fully versioned document store. If you want encrypted backups then I'd suggest SpiderOak instead - they encrypt it with a key they don't know, so they *can't* read it. Still, for Corporate environments, that isn't as useful as a central managed store that they can just backup once. On Feb 14, 2013 6:48 PM, Felmon Davis dav...@union.edu wrote: On Thu, 14 Feb 2013, IBBoard wrote: Sharepoint is a self-hosted solution. You are relying on a Microsoft product, but the documents are never handed over to Microsoft and none of the files never leave your network. It isn't perfect, but is generally fairly secure (as secure as your networks, anyway) and companies can use it. Dropbox is an unencrypted cloud solution. Once it is on the Dropbox severs then any of the Dropbox staff /could/ read it. Or it could be copied or otherwise lost by people who aren't your employees. Or it could be leaked as party of a wider Dropbox hack/leak. Or it could be retrieved by a foreign government (USA, I think) without your knowledge. Generally, it is out of your corporate network perimeter and hence out of your control. In general, that is *not* a good thing. That's not to say people can't use Dropbox. If you don't value your files (or have some reason to trust that nothing will happen to your unencrypted files in an unknown data centre or data centres) then that might be fine, but for a company that has to protect its ideas and business secrets then an internally hosted solution is the only sensible option, even if it is from Microsoft. I wholly concur that it is generally better to keep stuff 'home' to the extent possible. (just lost a local struggle here about this issue but regarding using google apps.) you could put _encrypted_ files on Busybox thus obviating that security leak, and you could maintain backups thus ensuring you don't lose the files. but better keep things at home. F. On Feb 14, 2013 6:21 PM, Felmon Davis dav...@union.edu wrote: On Thu, 14 Feb 2013, IBBoard wrote: Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable - and rightly so, since it means important documents go outside your perimeter. Instead they use a document management system (like Sharepoint or Alfresco) that they install and manage centrally. Unlike a wiki, a document management system gives full, normal document management. Unlike a CMS it is all about documents, and unlike a LAN share it does versioning and workflow. Basically, Sharepoint is something for businesses. A normal user will never need it. I don't understand the relation between these propositions: a) Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable... b) Basically, Sharepoint is something for businesses. is the point that it is better for a business that Microsoft hold their documents than that Busybox does? just seeking clarification. (I have Busybox but don't use it for a number of reasons; I am not acquainted enough with Sharepoint.) F. On Feb 14, 2013 5:28 PM, anne-ology lagin...@gmail.com wrote: Content Management System ;-) ... LAN ;-) ... a wiki ;-) ??? as to these - I haven't a clue; I'll continue to stick with the KISs method ;-) But if we each sign up to use DropBox, we can each end up with 6Gb of free space to use as we wish in sharing documents - and MsFt does not have any control over this :-) On Thu, Feb 14, 2013 at 11:03 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Ahh, so is it a sort of Content Management System that can be used to hold documents centrally, like putting them on a shared folder on a Lan so that everyone can work on the same file instead of each generating different copies and then trying to compare all the different ones to incorporate all the different changes? Sort of like a wiki? Regards from Tom :) -- *From:* anne-ology lagin...@gmail.com *To:* Tom tomdavie...@yahoo.co.uk *Cc:* users@global.libreoffice.org *Sent:* Thursday, 14 February 2013, 16:53 *Subject:* Re: [libreoffice-users] Share-point? Just 'searched' and found this - http://www.youtube.com/watch?v=s12Jb5Z2xaEhttp://www.youtube.com/watch?**v=s12Jb5Z2xaE http://www.**youtube.com/watch?v=**s12Jb5Z2xaEhttp://www.youtube.com/watch?v=s12Jb5Z2xaE Seems somewhat silly since we could all benefit if we were to use DropBox - http://db.tt/v1nUSr8M On Wed, Feb 13, 2013 at 2:24 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it.
Re: [libreoffice-users] Share-point?
On Thu, 14 Feb 2013, IBBoard wrote: Yes, you can encrypt it first, but a) that is an extra step and b) it only gives you a semi-useful backup, not a fully versioned document store. If you want encrypted backups then I'd suggest SpiderOak instead - they encrypt it with a key they don't know, so they *can't* read it. Still, for Corporate environments, that isn't as useful as a central managed store that they can just backup once. you're right. and thanks for the tip about SpiderOak! this thread is off-topic but I'll take advantage of it before it's cut: I would like a solution where a) individuals could upload documents to me b) they wouldn't be able to see each other's documents (unless I allowed it) c) should be either linux-based or agnostic. anyone with a tip? F. -- Felmon Davis I would give my right arm to be ambidextrous. -- 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] Share-point?
On 14/02/2013 at 19:41, Felmon Davis dav...@union.edu wrote: I wholly agree this is far better than BusyBox for many purposes. You meant Dropbox ;) . Busybox is set of minimalistic Linux command-line tools. It has completely different purpose. -- 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] Share-point?
Hi :) So is Alfresco an OpenSource alternative? If not what is? Regards from Tom :) From: Felmon Davis dav...@union.edu To: users@global.libreoffice.org Sent: Thursday, 14 February 2013, 18:20 Subject: Re: [libreoffice-users] Share-point? On Thu, 14 Feb 2013, IBBoard wrote: Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable - and rightly so, since it means important documents go outside your perimeter. Instead they use a document management system (like Sharepoint or Alfresco) that they install and manage centrally. Unlike a wiki, a document management system gives full, normal document management. Unlike a CMS it is all about documents, and unlike a LAN share it does versioning and workflow. Basically, Sharepoint is something for businesses. A normal user will never need it. I don't understand the relation between these propositions: a) Microsoft might not have control over it, but Dropbox will. For a business, that is unacceptable... b) Basically, Sharepoint is something for businesses. is the point that it is better for a business that Microsoft hold their documents than that Busybox does? just seeking clarification. (I have Busybox but don't use it for a number of reasons; I am not acquainted enough with Sharepoint.) F. On Feb 14, 2013 5:28 PM, anne-ology lagin...@gmail.com wrote: Content Management System ;-) ... LAN ;-) ... a wiki ;-) ??? as to these - I haven't a clue; I'll continue to stick with the KISs method ;-) But if we each sign up to use DropBox, we can each end up with 6Gb of free space to use as we wish in sharing documents - and MsFt does not have any control over this :-) On Thu, Feb 14, 2013 at 11:03 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Ahh, so is it a sort of Content Management System that can be used to hold documents centrally, like putting them on a shared folder on a Lan so that everyone can work on the same file instead of each generating different copies and then trying to compare all the different ones to incorporate all the different changes? Sort of like a wiki? Regards from Tom :) -- *From:* anne-ology lagin...@gmail.com *To:* Tom tomdavie...@yahoo.co.uk *Cc:* users@global.libreoffice.org *Sent:* Thursday, 14 February 2013, 16:53 *Subject:* Re: [libreoffice-users] Share-point? Just 'searched' and found this - http://www.youtube.com/watch?v=s12Jb5Z2xaE Seems somewhat silly since we could all benefit if we were to use DropBox - http://db.tt/v1nUSr8M On Wed, Feb 13, 2013 at 2:24 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Has anyone managed to get MS Sharepoint working with 4.0.0? Apparently it's one of the features that are supposed to be in the 4.0.0 although i have no idea what SharePoint is nor why anyone would use it. According to the comments under this article http://www.webupd8.org/2013/02/libreoffice-40-available-for-download.html Somewhere about 1/4 up from the bottom Алексей Бродкин • 6 days ago It seems like some of highlighted options are missing from this release. 1. Unity/Global menu integration - at least I cannot see it in action or any toggle in setting 2. SharePoint integration. From here http://tekonorma.fr/WPblogTN/2... I learnt that to have this option one needs to instal a corresponding plug-in from here http://extensions.libreoffice and you may see this link leads to This page does not seem to exist... - seems like due to legal issue plugin was removed. Sure enough the link didn't work so i got to the Extensions site another way but a quick search to find sharepoint or share point didn't reveal any relevant Extensions. Regards from Tom :) -- Felmon Davis Seek simplicity -- and distrust it. -- Alfred Whitehead -- 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] calc: method to subdivide individual cells
On 2013-02-14 9:19 AM, Brian Barker b.m.bar...@btinternet.com wrote: At 08:50 14/02/2013 -0500, Nobody Noname wrote: ... but it is much more complicated than if there was the possibility to just subdivide a single cell into multiples... OK: suppose you divide cell Xn into four cells- two vertically and two horizontally. How do you now refer to the four new cells in formulae? Initially, until some method was developed that made sense, it could just be a limitation of split cells that you can't use them in formulas. And maybe it would have to stay that way. None of the times I wanted to be able to do this was it critical that I me able to use them in formulas. And which of the now four separate values gets used if you refer to plain cell Xn in a formula? Pick one (upper left, lower right, etc). Could even be a pref. Or, as above, make it unsupported, unless/until a method is developed for supporting it that makes sense. -- 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] Share-point?
IBBoard wrote: Dropbox is an unencrypted cloud solution. Once it is on the Dropbox severs then any of the Dropbox staff/could/ read it. Or it could be copied or otherwise lost by people who aren't your employees. Or it could be leaked as party of a wider Dropbox hack/leak. Or it could be retrieved by a foreign government (USA, I think) without your knowledge. Generally, it is out of your corporate network perimeter and hence out of your control. In general, that is*not* a good thing. I haven't used Dropbox, but I have created an encrypted folder on Google Drive. I imagine the same would work with Dropbox. -- 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] Share-point?
Erm... Dropbox _claims_ to encrypt your files. Yes, the DB staff may be able to read it, it depends on the encryption method (not entirely sure, I think they said something like AES-256 or something, maybe I'm getting confused). Someone correct me if I've got my info wrong! On 14 Feb 2013 20:32, James Knott james.kn...@rogers.com wrote: IBBoard wrote: Dropbox is an unencrypted cloud solution. Once it is on the Dropbox severs then any of the Dropbox staff/could/ read it. Or it could be copied or otherwise lost by people who aren't your employees. Or it could be leaked as party of a wider Dropbox hack/leak. Or it could be retrieved by a foreign government (USA, I think) without your knowledge. Generally, it is out of your corporate network perimeter and hence out of your control. In general, that is*not* a good thing. I haven't used Dropbox, but I have created an encrypted folder on Google Drive. I imagine the same would work with Dropbox. -- 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] Save as doc crashes LO
Il 13/02/2013 20:56, steveedmonds ha scritto: Hi. Saving a writer document as .doc crashes my LO on OpenSuse. Could someone please try on 4.0 and if it persists I will file a bug. perf_calc_translations.odt http://nabble.documentfoundation.org/file/n4037263/perf_calc_translations.odt Cheers, Steve -- View this message in context: http://nabble.documentfoundation.org/Save-as-doc-crashes-LO-tp4037263.html Sent from the Users mailing list archive at Nabble.com. LO 4.0 on ubuntu seems very normal, no crash. -- www.libreoffice.org -- 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] Save as doc crashes LO
LO4.0 Fedora 18. All good - Original Message - From: Paolo Debortoli Sent: 02/15/13 09:17 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Save as doc crashes LO Il 13/02/2013 20:56, steveedmonds ha scritto: Hi. Saving a writer document as .doc crashes my LO on OpenSuse. Could someone please try on 4.0 and if it persists I will file a bug. perf_calc_translations.odt http://nabble.documentfoundation.org/file/n4037263/perf_calc_translations.odt Cheers, Steve -- View this message in context: http://nabble.documentfoundation.org/Save-as-doc-crashes-LO-tp4037263.html Sent from the Users mailing list archive at Nabble.com. LO 4.0 on ubuntu seems very normal, no crash. -- www.libreoffice.org -- 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] irritating problem 4.0
Andrew, it was the TOC I should have referred to. My bad explanation - Original Message - From: Andrew Douglas Pitonyak Sent: 02/14/13 04:57 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] irritating problem 4.0 On 02/13/2013 01:16 AM, Tim Lloyd wrote: Hi, created a FAQ for myself in Fedora 16 using LO3.6. When I upgraded to Fedora 18 I was also using 3.6. I really can't remember but I would say the version of LO came from the Fedora repository (it isn't installed by default in F18). It was for me I had to wipe and re-install one machine. I was preparing to install LO and surprise surprise, it was already there. Strange! The FAQ is a very basic ODT file. I created an index at the front using the defaults provided so index is based on defaults - Heading1 is position 1, Heading2 is position 2 Heading3 is position3, etc. Anyway, all good, the document grew as I grabbed more information. Mostly I just added lines to the end, in some cases I added a new heading which went into the index. Yesterday I downloaded the latest LO version from the official site. removed 3.6 and installed 4.0. Today, I updated the FAQ with some GIT information. So I created a new heading1 for GIT with a heading2 underneath. And a few lines of information along the way (in the format text body). When I updated the index, all lines I had typed in were added to the index. Plus a few from the page before and the page after. But not all pages! Do you mean specifically the index, or the table of contents (TOC)? if it is the TOC, then it is probably related to the paragraph style. If it is the index, then it is probably because you began typing while the cursor was inside of the index mark (poorly said by me, I know; sorry). So I reinstalled 3.6 and updated the index but the same problem persists. I have read the writer guide often enough recently to have a pretty good idea how this works but I am stumped. Any thoughts on how to sort out the index? Cheers -- 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] Re: LO 4.0: intrinsic database: relations only between primaries keys?
Dan, This is good! It is a good start on an introduction to databases for newbies. It should be put in the Base manual? Girvin Herr Dan Lewis wrote: snip Some basics about creating a database: 1) You begin with data that you want to use for some purpose or purposes. 2) Then you design the database to organize this data so that it will be useful. For example: an address database: In the beginning, the database consists of information such as names, addresses, email address, phone numbers, etc. The first thing you would want to do is to organize this data so that a name is linked to its address, its email address, its phone numbers, etc. Now you have rows of data, each one of them containing information about a single person (a relationship exists between the data for each row). Each of these pieces of information is a field. If you look at these rows, you will see that they also contain some things in common. Several rows can contain data about your friends, others are about your relatives, and others are about companies you do business with. You probably know of other possibilities. So, these rows can be organized into groups based upon what they have in common. (This too is a relationship.) The next thing you should do is to further organize these rows in each one of these groups to make them more useful. You could form a table using these as the column headings: name, address, email address, and phone number. ( Now you have a table for each group of rows. So, if you want data about a particular contact, you can go to the table that contains it. If you want to look at the data for a relative, you go to the table containing all of your relatives. This is basically how a flat database is created. Relational databases begin in the same way. At this point, each of these tables are checked to see whether they are normal or not. For example, a contact is likely to have multiple phone numbers or other possible multiple entries. Each of these have something in common (another relationship). We can remove the field containing multiple entries forming a new table. To keep the relationship between this new table with the original table, we create a primary-foreign key pair (the primary key is for the new table, and the foreign key is added to the original table in place of the fields we removed.) This is what is done to make a table first normal form. There are several levels of a table being normal: first normal form to fourth normal form and beyond. Fourth normal form is considered to be the standard against which a table should be judged. The point being that we do not create tables with their fields and then define the relationship between them. We begin the the fields that we know we will need, combine the fields based upon relationships between data, and combine the fields into tables based upon relationships between the fields. The the tables are normalized up to fourth normal form creating new tables and modifying the old ones. Primary-foreign key pairs are used to define the relationship of the new tables and the modified old table from which the new table came. Hopefully this will help some. --Dan -- 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: LO 4.0: intrinsic database: relations only between primaries keys?
Have you read Chapter 2 of the Base Guide? (Planning/Designing your database) There are 56 pages in which I used this approach for all the parts of a database. There are many questions in it designed to help a person. --Dan https://wiki.documentfoundation.org/Documentation/Publications On 02/14/2013 07:39 PM, Girvin R. Herr wrote: Dan, This is good! It is a good start on an introduction to databases for newbies. It should be put in the Base manual? Girvin Herr Dan Lewis wrote: snip Some basics about creating a database: 1) You begin with data that you want to use for some purpose or purposes. 2) Then you design the database to organize this data so that it will be useful. For example: an address database: In the beginning, the database consists of information such as names, addresses, email address, phone numbers, etc. The first thing you would want to do is to organize this data so that a name is linked to its address, its email address, its phone numbers, etc. Now you have rows of data, each one of them containing information about a single person (a relationship exists between the data for each row). Each of these pieces of information is a field. If you look at these rows, you will see that they also contain some things in common. Several rows can contain data about your friends, others are about your relatives, and others are about companies you do business with. You probably know of other possibilities. So, these rows can be organized into groups based upon what they have in common. (This too is a relationship.) The next thing you should do is to further organize these rows in each one of these groups to make them more useful. You could form a table using these as the column headings: name, address, email address, and phone number. ( Now you have a table for each group of rows. So, if you want data about a particular contact, you can go to the table that contains it. If you want to look at the data for a relative, you go to the table containing all of your relatives. This is basically how a flat database is created. Relational databases begin in the same way. At this point, each of these tables are checked to see whether they are normal or not. For example, a contact is likely to have multiple phone numbers or other possible multiple entries. Each of these have something in common (another relationship). We can remove the field containing multiple entries forming a new table. To keep the relationship between this new table with the original table, we create a primary-foreign key pair (the primary key is for the new table, and the foreign key is added to the original table in place of the fields we removed.) This is what is done to make a table first normal form. There are several levels of a table being normal: first normal form to fourth normal form and beyond. Fourth normal form is considered to be the standard against which a table should be judged. The point being that we do not create tables with their fields and then define the relationship between them. We begin the the fields that we know we will need, combine the fields based upon relationships between data, and combine the fields into tables based upon relationships between the fields. The the tables are normalized up to fourth normal form creating new tables and modifying the old ones. Primary-foreign key pairs are used to define the relationship of the new tables and the modified old table from which the new table came. Hopefully this will help some. --Dan -- 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] Look for step-by-step guide
Hi! I am new to debugging and programming. Referring to: https://bugs.freedesktop.org/show_bug.cgi?id=60710#c5 ... do you have a debug symbols build you could run valgrind in to see if there is some memory corruption there ? What documents should I consult to help me to understand what to do? Where is the step-by-step guide, especially for LibreOffice 4? (I need detailed steps.) Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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: LO 4.0: intrinsic database: relations only between primaries keys?
Dan, Chapter 2?? All I have is Chapter 1 - Introducing Base and Chapter 8 - Getting Started with Base. I see there is a draft copy of Chapter 2 and 3 now. I will read them. Thanks. Girvin Herr Dan Lewis wrote: Have you read Chapter 2 of the Base Guide? (Planning/Designing your database) There are 56 pages in which I used this approach for all the parts of a database. There are many questions in it designed to help a person. --Dan https://wiki.documentfoundation.org/Documentation/Publications On 02/14/2013 07:39 PM, Girvin R. Herr wrote: Dan, This is good! It is a good start on an introduction to databases for newbies. It should be put in the Base manual? Girvin Herr Dan Lewis wrote: snip Some basics about creating a database: 1) You begin with data that you want to use for some purpose or purposes. 2) Then you design the database to organize this data so that it will be useful. For example: an address database: In the beginning, the database consists of information such as names, addresses, email address, phone numbers, etc. The first thing you would want to do is to organize this data so that a name is linked to its address, its email address, its phone numbers, etc. Now you have rows of data, each one of them containing information about a single person (a relationship exists between the data for each row). Each of these pieces of information is a field. If you look at these rows, you will see that they also contain some things in common. Several rows can contain data about your friends, others are about your relatives, and others are about companies you do business with. You probably know of other possibilities. So, these rows can be organized into groups based upon what they have in common. (This too is a relationship.) The next thing you should do is to further organize these rows in each one of these groups to make them more useful. You could form a table using these as the column headings: name, address, email address, and phone number. ( Now you have a table for each group of rows. So, if you want data about a particular contact, you can go to the table that contains it. If you want to look at the data for a relative, you go to the table containing all of your relatives. This is basically how a flat database is created. Relational databases begin in the same way. At this point, each of these tables are checked to see whether they are normal or not. For example, a contact is likely to have multiple phone numbers or other possible multiple entries. Each of these have something in common (another relationship). We can remove the field containing multiple entries forming a new table. To keep the relationship between this new table with the original table, we create a primary-foreign key pair (the primary key is for the new table, and the foreign key is added to the original table in place of the fields we removed.) This is what is done to make a table first normal form. There are several levels of a table being normal: first normal form to fourth normal form and beyond. Fourth normal form is considered to be the standard against which a table should be judged. The point being that we do not create tables with their fields and then define the relationship between them. We begin the the fields that we know we will need, combine the fields based upon relationships between data, and combine the fields into tables based upon relationships between the fields. The the tables are normalized up to fourth normal form creating new tables and modifying the old ones. Primary-foreign key pairs are used to define the relationship of the new tables and the modified old table from which the new table came. Hopefully this will help some. --Dan -- 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] Share-point?
On 13-02-14 02:05 PM, Felmon Davis wrote: this thread is off-topic but I'll take advantage of it before it's cut: I would like a solution where a) individuals could upload documents to me b) they wouldn't be able to see each other's documents (unless I allowed it) c) should be either linux-based or agnostic. OwnCloud. Wait for version 5 though (End of February): http://owncloud.org/ Cheers, Fabian -- Fabián Rodríguez http://fsf.magicfab.ca -- 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] Share-point?
On Fri, 15 Feb 2013, Fabian Rodriguez wrote: On 13-02-14 02:05 PM, Felmon Davis wrote: this thread is off-topic but I'll take advantage of it before it's cut: I would like a solution where a) individuals could upload documents to me b) they wouldn't be able to see each other's documents (unless I allowed it) c) should be either linux-based or agnostic. OwnCloud. Wait for version 5 though (End of February): http://owncloud.org/ Cheers, Fabian thanks. this deserves more study but so far as I can see now, it doesn't suit my purpose. it allows me to access files from diverse places and devices. I can already do that on a server to which I have ssh and sshfs access. what I need is something where _others_ can upload their files for _me_ to access. think of students uploading papers for the teacher to grab. the students shouldn't see each other's work though they should see their own. (it would be great if they had permissions to modify and delete their own stuff but not essential; it is essential that Windows and Mac people can upload their files.) I'll study the owncloud page more but I'm not seeing these features so far. F. -- Felmon Davis What is wanted is not the will to believe, but the will to find out, which is the exact opposite. -- Bertrand Russell, _Sceptical_Essays_, 1928 -- 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] Share-point?
Hi :) Perhaps Moodle? I haven't looked into Moodle but keep meaning to. It's supposedly good for higher education but it might be more about just tutors and lecturers being able to place documents and text and stuff in an attractive layout that's easy for students to just read. I'm not sure how interactive it can be. Regards from Tom :) From: Felmon Davis dav...@union.edu To: users@global.libreoffice.org Sent: Friday, 15 February 2013, 6:55 Subject: Re: [libreoffice-users] Share-point? On Fri, 15 Feb 2013, Fabian Rodriguez wrote: On 13-02-14 02:05 PM, Felmon Davis wrote: this thread is off-topic but I'll take advantage of it before it's cut: I would like a solution where a) individuals could upload documents to me b) they wouldn't be able to see each other's documents (unless I allowed it) c) should be either linux-based or agnostic. OwnCloud. Wait for version 5 though (End of February): http://owncloud.org/ Cheers, Fabian thanks. this deserves more study but so far as I can see now, it doesn't suit my purpose. it allows me to access files from diverse places and devices. I can already do that on a server to which I have ssh and sshfs access. what I need is something where _others_ can upload their files for _me_ to access. think of students uploading papers for the teacher to grab. the students shouldn't see each other's work though they should see their own. (it would be great if they had permissions to modify and delete their own stuff but not essential; it is essential that Windows and Mac people can upload their files.) I'll study the owncloud page more but I'm not seeing these features so far. F. -- Felmon Davis What is wanted is not the will to believe, but the will to find out, which is the exact opposite. -- Bertrand Russell, _Sceptical_Essays_, 1928 -- 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
