[libreoffice-users] Schema in Calc

2014-07-30 Thread Pat Brown
Hi, In a relationall DB there is a facility to display all the tables and this also shows how the tables are related and also which fields are related and how they are related. This is extremely useful to get an overall pcture of how things fit together and, importantly in this case, what the

Re: [libreoffice-users] Text in an IF function

2014-07-30 Thread Brian Barker
At 20:31 29/07/2014 -0700, Joe Conner wrote: Did you try inserting quots which will become =IF(H44=AUG,Paid.D21,) perhaps? I hope he didn't, as then he'd get the text Paid.D21 itself as the formula result, instead of a copy of cell D21 from the sheet named Paid - which is presumably what he

Re: [libreoffice-users] Schema in Calc

2014-07-30 Thread Tom Davies
Hi :) I seriously doubt it! It is database functionality. It would be like expecting a word-processor to have DTP functionality, or a text-editor to do the same things as a word-processor. One option might be to get Base to read the tables as it's external back-ends. That would get you to the

Re: [libreoffice-users] Schema in Calc

2014-07-30 Thread Andrew Douglas Pitonyak
The most of which I am aware is the ability to see which cells reference the current cell, and, even then, you won't see the cells if they are not visible on screen. It requires a macro to turn on and off. It is rather obscure; I think it is meant for debugging. On 07/30/2014 02:37 AM,

Re: [libreoffice-users] Schema in Calc

2014-07-30 Thread Paul
While what Tom said about databases versus spreadsheets is largely true, it is also true that a lot of people use spreadsheets as a sort of report, without the database bit. This is often easier to put together, especially for people that don't have the know-how to develop a database application

[libreoffice-users] MAC: 4.3.0.4 Info.plist version confusion

2014-07-30 Thread Markus Jansen
Hello there, I just wanted to check out the new libreOffice with a Mac and found out that in the Info.plist - file the key CFBundleShortVersionString is 4.3.4 in contrast to the CFBundleGetInfoString which is 4.3.0.4 (see the third digit: zero). Why is this? Just the shorten the version

Re: [libreoffice-users] Hyphen Printing Problem in Writer??

2014-07-30 Thread foberle
Hi Joel: Thanks much for the response. I decided this morning to take a little time and reproduce the hyphen problem I discussed step-by-step so that I could file a usable bug report. Here's how things went, and why I've decided to abandon that quest. I started LibreOffice in the normal

[libreoffice-users] LO Writer: Highlighting; setting page properties; some more nitpicking

2014-07-30 Thread Jon Harringdon
I am reposting this message as the first never did show up. Sorry if some of you see it twice. original message From: Jon Harringdon jonathan.harring...@virgin.net Date: Wed, 30 Jul 2014 12:24:22 +0100 Subj: LO Writer: Highlighting; setting page properties; some more nitpicking Hi, I've

Re: [libreoffice-users] Re: Bug check - 4.2.4, editing Input fields is broken?

2014-07-30 Thread Tanstaafl
On 7/5/2014 3:08 PM, Tanstaafl tansta...@libertytrek.org wrote: On 7/3/2014 11:09 AM, Tom Davies tomc...@gmail.com wrote: Hi:) Good timing! Errr, is it still in the new branch 4.3.0? Any chance of checking? Just checked... bug is still there. :( So... I haven't had time to test yet -

Re: [libreoffice-users] Re: Bug check - 4.2.4, editing Input fields is broken?

2014-07-30 Thread Sophie
Hi Charles, Le 30/07/2014 16:46, Tanstaafl a écrit : On 7/5/2014 3:08 PM, Tanstaafl tansta...@libertytrek.org wrote: On 7/3/2014 11:09 AM, Tom Davies tomc...@gmail.com wrote: Hi:) Good timing! Errr, is it still in the new branch 4.3.0? Any chance of checking? Just checked... bug is still

Re: [libreoffice-users] LO Writer: Highlighting; setting page properties; some more nitpicking

2014-07-30 Thread Brian Barker
At 15:40 30/07/2014 +0100, Jon Harringdon wrote: I often highlight some text and have to un-highlight it a little later. This should work like setting/resetting italic or bold attributes: pressing the highlight icon does highlight the marked text and pressing it again (with the same text

[libreoffice-users] No database option

2014-07-30 Thread Jim Byrnes
Using LibreOffice 3.5.7.2 on Ubuntu 12.04. I am working with a ooBasic tutorial. It says to choose File--New--Database to create a new database. The problem is there is no Database item on that drop down menu. Also, on the opening screen the Database entry is grayed out. I actually have a

Re: [libreoffice-users] No database option

2014-07-30 Thread Tom Davies
Hi :) You might need to install Base. I think it's the only module that can be installed separately on GnuLinux systems. So something like sudo apt-get install libreoffice-base should do the trick on a distro from the debian-family. Please let us know how this goes! Good luck and regards form

Re: [libreoffice-users] Hyphen Printing Problem in Writer??

2014-07-30 Thread Tom Davies
Hi :) I think you'd be amazed how much easier it is to report a 2nd bug. The first time there is stuff such as registering on the bug-tracker website and a bit of faffing around plus the whole idea is a bit unfamiliar and there are unexpected things to distract you. The 2nd time you don't need

[libreoffice-users] Re: No database option

2014-07-30 Thread Jim Byrnes
On 07/30/2014 11:51 AM, Tom Davies wrote: Hi :) You might need to install Base. I think it's the only module that can be installed separately on GnuLinux systems. So something like sudo apt-get install libreoffice-base should do the trick on a distro from the debian-family. Please let us

Re: [libreoffice-users] LO Writer: Highlighting; setting page properties; some more nitpicking

2014-07-30 Thread Jon Harringdon
Jon Harringdon jonathan.harring...@virgin.net wrote: Second, I want to set the page size (FormatPagePage) to 0.5cm on all sides. I enter 0.5cm in the first box and then press Ctrl-A/Ctrl-C to then copy that into the other three boxes. After pressing Ctrl-C, Writer completely hangs for three,

Re: [libreoffice-users] Re: No database option

2014-07-30 Thread Tom Davies
Hi :) Yeh, it surprised me too. In Windows i think the whole suite gets installed but in GnuLinux it's a bit more fine-grained. I think the Windows version really needs to keep it all as simple as possible but in GnuLinux it's more likely that users are a bit more expert at using computers and

Re: [libreoffice-users] Re: Bug check - 4.2.4, editing Input fields is broken?

2014-07-30 Thread Tanstaafl
On 7/30/2014 11:01 AM, Sophie gautier.sop...@gmail.com wrote: Hi Charles, Le 30/07/2014 16:46, Tanstaafl a écrit : And I'm still dealing with the ridiculous fact that Libreoffice is completely and totally incapable of printing to Tabloid sized paper on Windows. Could you provide the bug

[libreoffice-users] Re: Hyphen Printing Problem in Writer??

2014-07-30 Thread CVAlkan
Hi Tom: I thought the I recently installed Version: 4.3.0.3 Build ID: 08ebe52789a201dd7d38ef653ef7a48925e7f9f7 on 64 bit Ubuntu 14.04 covered that. I thought I was just responding to Joel, and that was in the original post, so assumed he knew that. Regards, Frank -- View this message in

[libreoffice-users] LO 4.3.0.4 Crashing

2014-07-30 Thread Scott Jones
Anyone else having constant startup crashing? 32-bit System the problem causes LO to crash constantly when starting soffice.exe which is what runs when quickstart.exe is run. Can intermittently get soffice.exe and swriter.exe etc to run. 64-bit System the problem is that I can run

[libreoffice-users] Re: No database option

2014-07-30 Thread Alexander Thurgood
Le 30/07/2014 19:34, Jim Byrnes a écrit : Hi Jim, Just checked with Ubuntu's package manager and Base was in fact not installed. Used it to install Base and now the option appears so I should be able to proceed. Sort of surprised as I thought the entire suite had been installed. Ubuntu,

[libreoffice-users] Re: Schema in Calc

2014-07-30 Thread Alexander Thurgood
Le 30/07/2014 08:37, Pat Brown a écrit : Short answer : no. As Tom has pointed out, this is db design functionality, and not Calc, although nothing is stopping anyone from developing, say, an Addon or Extension that might be able to what you are looking for - certainly not trivial though, given

[libreoffice-users] Re: Schema in Calc

2014-07-30 Thread Alexander Thurgood
Le 30/07/2014 14:39, Paul a écrit : Unfortunately not trivial to implement because it relies on the driver and the underlying db to tell the truth about what it actually supports, in terms of relations, integrity constraints, etc. As this is problematic for many drivers at the best of times,

Re: [libreoffice-users] Re: Schema in Calc

2014-07-30 Thread Paul
Just out of interest, why would a db driver come into play? This is a spreadsheet we're talking about. The mention of db schema was merely to ask why Calc doesn't have something like it. And I do understand that a schema for calc would be nigh impossible, spreadsheets don't have to follow any

[libreoffice-users] Re: No database option

2014-07-30 Thread Jim Byrnes
On 07/30/2014 03:42 PM, Alexander Thurgood wrote: Le 30/07/2014 19:34, Jim Byrnes a écrit : Hi Jim, Just checked with Ubuntu's package manager and Base was in fact not installed. Used it to install Base and now the option appears so I should be able to proceed. Sort of surprised as I

[libreoffice-users]

2014-07-30 Thread Wanda Moore
I have tried to email questions, but they have never been responded to. I have been getting everyone else's emails, which is in the hundreds. I don't know why I haven't gotten through about my questions . . . . Please let me know how I can do this. Thank you. I no longer want to receive

Re: [libreoffice-users] [Getting replies]

2014-07-30 Thread Brian Barker
At 19:34 30/07/2014 -0700, Wanda Moore wrote: I have tried to email questions, but they have never been responded to. This seems to be untrue: o Your message of 25 May 2012 (Documents do strange things) resulted in thirteen list replies, and you must have seen these, as one reply was from

Re: [libreoffice-users] [Getting replies]

2014-07-30 Thread Steve Edmonds
Hi Brian. On 2014-07-31 16:04, Brian Barker wrote: At 19:34 30/07/2014 -0700, Wanda Moore wrote: I have tried to email questions, but they have never been responded to. This seems to be untrue: o Your message of 25 May 2012 (Documents do strange things) resulted in thirteen list replies, and

[libreoffice-users] LibreOffice Still?

2014-07-30 Thread NoOp
While we're on 'nitpicking'... OK I give... the download page/link is confusing enough with the 'Download' link going directly to http://www.libreoffice.org/download/libreoffice-fresh/ 'LibreOffice Fresh', but now I see that 'LibreOffice Stable' has changed to 'LibreOffice Still'

Re: [libreoffice-users] LO Writer: Highlighting; setting page properties; some more nitpicking

2014-07-30 Thread Tom Davies
Hi :) Is the hanging only happening with 'large' files of 2Mb or more? Have you massively bumped up the memory settings in Tools - Options - Memory (or something like that) I think those are still set for machines that only have 125Mb Ram or something like that and with most of ram just

Re: [libreoffice-users] LO 4.3.0.4 Crashing

2014-07-30 Thread Tom Davies
Hi :) Constant crashing used to indicate the presence of Java in the system. Do you need Java or not sure? I tried going without it for a month and then realised i never seemed to ever need it soi i uninstalled it from all 'my' machines. Regards from Tom :) On 30 July 2014 20:20, Scott Jones