Re: [libreoffice-users] Calc scale formula conundrum/ logic confusion

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] Calc scale formula conundrum/ logic confusion

2013-02-14 Thread Brian Barker
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

RE: [libreoffice-users] Table borders

2013-02-14 Thread PGR
-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

Re: [libreoffice-users] Save as doc crashes LO

2013-02-14 Thread e-letter
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

Re: [libreoffice-users] Save as doc crashes LO

2013-02-14 Thread Tom Davies
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

[libreoffice-users] Strange fonts on my Windows system

2013-02-14 Thread William Drago
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:

Re: [libreoffice-users] Strange fonts on my Windows system

2013-02-14 Thread Séamas Ó Brógáin
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

Re: [libreoffice-users] Strange fonts on my Windows system

2013-02-14 Thread Séamas Ó Brógáin
. . . 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:

Re: [libreoffice-users] Strange fonts on my Windows system

2013-02-14 Thread Mirosław Zalewski
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

Re: [libreoffice-users] Create Firefox Personas for LibreOffice 4 in LibreOffice 4

2013-02-14 Thread webmaster-Kracked_P_P
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

Re: [libreoffice-users] Strange fonts on my Windows system

2013-02-14 Thread webmaster-Kracked_P_P
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

Re: [libreoffice-users] Save as doc crashes LO

2013-02-14 Thread John D. Herron
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

[libreoffice-users] Re: Save as doc crashes LO

2013-02-14 Thread Tom
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

Re: [libreoffice-users] calc: method to subdivide individual cells

2013-02-14 Thread Tanstaafl
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

Re: [libreoffice-users] Save as doc crashes LO

2013-02-14 Thread Jay Lozier
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

Re: [libreoffice-users] Calc scale formula conundrum/ logic confusion

2013-02-14 Thread Hylton Conacher (ZR1HPC)
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

Re: [libreoffice-users] Save as doc crashes LO

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] calc: method to subdivide individual cells

2013-02-14 Thread Brian Barker
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

[libreoffice-users] Re: Pivot table numeric value is hidden by the combobox

2013-02-14 Thread Pedro
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

[libreoffice-users] Re: Calc scale formula conundrum/ logic confusion

2013-02-14 Thread Tom
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

[libreoffice-users] LibreOffice V 3.6.5.2 (build ID: 5b93205)

2013-02-14 Thread norman.hancock
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

Re: [libreoffice-users] LibreOffice V 3.6.5.2 (build ID: 5b93205)

2013-02-14 Thread Mirosław Zalewski
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

Re: [libreoffice-users] Microfund your favourite Issue

2013-02-14 Thread Joel Madero
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

[libreoffice-users] Re: Calc scale formula conundrum/ logic confusion

2013-02-14 Thread Gérard Fargeot
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,

Re: [libreoffice-users] LibreOffice V 3.6.5.2 (build ID: 5b93205)

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] LibreOffice V 3.6.5.2 (build ID: 5b93205)

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] Microfund your favourite Issue

2013-02-14 Thread Adam Tauno Williams
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

Re: [libreoffice-users] Table borders

2013-02-14 Thread Jean-Francois Nifenecker
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread anne-ology
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

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

2013-02-14 Thread anne-ology
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] icons

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] How to convert tab-separated file to XLS from the command line

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread anne-ology
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 -

Re: [libreoffice-users] Share-point?

2013-02-14 Thread IBBoard
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.

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Fabian Rodriguez
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Felmon Davis
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Mirosław Zalewski
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread IBBoard
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.

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Felmon Davis
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Felmon Davis
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,

Re: [libreoffice-users] Share-point?

2013-02-14 Thread IBBoard
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Felmon Davis
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Mirosław Zalewski
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Tom Davies
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

Re: [libreoffice-users] calc: method to subdivide individual cells

2013-02-14 Thread Tanstaafl
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread James Knott
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Kieran Peckett
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,

Re: [libreoffice-users] Save as doc crashes LO

2013-02-14 Thread Paolo Debortoli
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,

Re: [libreoffice-users] Save as doc crashes LO

2013-02-14 Thread Tim Lloyd
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

Re: [libreoffice-users] irritating problem 4.0

2013-02-14 Thread Tim Lloyd
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

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-14 Thread Girvin R. Herr
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

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-14 Thread Dan Lewis
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

[libreoffice-users] Look for step-by-step guide

2013-02-14 Thread C. H. D.
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

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-14 Thread Girvin R. Herr
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)

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Fabian Rodriguez
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Felmon Davis
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

Re: [libreoffice-users] Share-point?

2013-02-14 Thread Tom Davies
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