[libreoffice-users] Solver kills LiberOffice under Mac OS X.10
Hello: With LibreOffice 4.3.5.2 Spreadhseet under OS X.10.1, Tool -> Solver kills LibreOffice, reporting, "LibreOffice quit unexpectedly. Click Reopen to open the application again.” I get this in an empty spreadsheet and spreadsheets with serious optimization problems solved by Solver handily under Windows. Suggestions? Thanks, Spencer Graves p.s. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [libreoffice-marketing] LinuxQuestions Annual Member's Choice Awards: Vote LibreOffice for Office Suite of the Year!
Hi :) Thought a few people here might be interested in what is going on over on LinuxQuestions.org as reported by Robinson below Regards from Tom :) On 16 January 2015 at 19:58, Robinson Tryon > Hello, people of marketing and outreach! > > For those of you who are members of LinuxQuestions.org, or who know > how to use a browser and a mouse, the annual Member's Choice Awards > are currently under way: > http://www.linuxquestions.org/questions/2014-linuxquestions-org-members-choice-awards-113/ > > Here's the direct link to the Office Suite of the Year thread: > http://www.linuxquestions.org/questions/2014-linuxquestions-org-members-choice-awards-113/office-suite-of-the-year-4175528385/ > > There are lots of different polls open, so jump in there and let your > voice be heard! > > Cheers, > --R > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Support options
@Urmas, * Don't know that I'd call signature useless--and there are instances where they are legally required. But probably not necessary here. But hey, to each their own. Just need to recognize them for what they are, and ignore them otherwise. Stuart -- View this message in context: http://nabble.documentfoundation.org/Support-options-tp4136133p4136346.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Support options
"jonathon": -BEGIN PGP SIGNATURE- Please do not add massive amounts of useless text in your list messages. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base: Questions From Potential New User
On Fri, 16 Jan 2015, Alex Thurgood wrote: You don't say whether your users will be just reading, or reading from and writing to the database. Alex, Reading and writing. Also be aware that SQLite timestamps and datetime data are incorrectly handled by Base as far as I recall. That's interesting. Will have to look for problems. The easiest way to do this might be to set up an empty ODB that connects to your SQlite file via a driver, then after loading the ODF file use Tools > SQL and copy in your DDL statement into the SQL window. That copying is what I was hoping to avoid. I'll create the sqlite db, then see if I can connect to it via a sqlite-odbc driver. Should be one that will work. Thanks, Rich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base: Questions From Potential New User
Le 16/01/2015 17:00, Rich Shepard a écrit : Hi Rich, > > The schema has 18 tables (including many-to-many intermediate tables) and > numerous foreign key references; more may be added. Will Base handle this > many tables? > You don't say whether your users will be just reading, or reading from and writing to the database. I imagine that reading should be alright, you might have issues with multiple cascading table updates, that would depend on the SQLite driver no doubt. Also be aware that SQLite timestamps and datetime data are incorrectly handled by Base as far as I recall. > The DDL text file (using sqlite syntax) is approximately 200 lines. Can > this be imported into Base so I do not need to re-key each line to create > the tables and relationships? The easiest way to do this might be to set up an empty ODB that connects to your SQlite file via a driver, then after loading the ODF file use Tools > SQL and copy in your DDL statement into the SQL window. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base: Questions From Potential New User
On Fri, 16 Jan 2015, Fernand Vanrie wrote: Florian is pointing in to the good direction, just connect LO base tot SQLite, google for "Openoffice and SLQLite" for some starting points Fernand, Thank you, I'll do that. I did not see sqlite mentioned as supported in the handbook. Of course, the handbook is probably out of date. Regards, Rich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base: Questions From Potential New User
Rich , Florian is pointing in to the good direction, just connect LO base tot SQLite, google for "Openoffice and SLQLite" for some starting points Greetz Fernand On Fri, 16 Jan 2015, Florian Reisinger wrote: From Base you can connect to your DB.. So no need to recreate anything. Base can be used to access the data in e.g. MySQL Florian, Yes, I read that. However, I do not see support for SQLite which is most appropriate for this application as it's a single-user, embedded rdbms. If I wanted a multi-user client-server rdbms I'd use postgres. Rich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base: Questions From Potential New User
On Fri, 16 Jan 2015, Florian Reisinger wrote: From Base you can connect to your DB.. So no need to recreate anything. Base can be used to access the data in e.g. MySQL Florian, Yes, I read that. However, I do not see support for SQLite which is most appropriate for this application as it's a single-user, embedded rdbms. If I wanted a multi-user client-server rdbms I'd use postgres. Rich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base: Questions From Potential New User
Hi, From Base you can connect to your DB.. So no need to recreate anything. Base can be used to access the data in e.g. MySQL Liebe Grüße / Yours, Florian Reisinger > Am 16.01.2015 um 17:00 schrieb Rich Shepard : > > Running LO-4.3.5 on Slackware-14.1. I am developing a database application > to be used by unsophisticated users, all running some flavor of Windows. > I've not before used Base so if I can it will make distribution easier than > writing it in Python/wxPython and SQLite. I've read the Base handbook and > have two questions for which I've not found answers. > > The schema has 18 tables (including many-to-many intermediate tables) and > numerous foreign key references; more may be added. Will Base handle this > many tables? > > The DDL text file (using sqlite syntax) is approximately 200 lines. Can > this be imported into Base so I do not need to re-key each line to create > the tables and relationships? > > TIA, > > Rich > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Base: Questions From Potential New User
Running LO-4.3.5 on Slackware-14.1. I am developing a database application to be used by unsophisticated users, all running some flavor of Windows. I've not before used Base so if I can it will make distribution easier than writing it in Python/wxPython and SQLite. I've read the Base handbook and have two questions for which I've not found answers. The schema has 18 tables (including many-to-many intermediate tables) and numerous foreign key references; more may be added. Will Base handle this many tables? The DDL text file (using sqlite syntax) is approximately 200 lines. Can this be imported into Base so I do not need to re-key each line to create the tables and relationships? TIA, Rich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Font color based on value
Thanks! For others, I've screen captured one set of conditions to show what I did. I had to set the lower limit to include ABOVE 1 so that empty cells wouldn't turn red. I also set a style for normal entries to ensure they didn't change color somehow. On 16/01/15 01:12 AM, Brian Barker wrote: At 22:37 15/01/2015 -0700, Emil Payne wrote: I'm a home user without a lot of spreadsheet experience. No worries! I have a graph with several lines. I'd like line 1 set so that when I enter a value in the box, that value would stay black if between an upper and lower limit (e.g. 50-100) and to change to a red font if outside that limit. Then line 2 would have a different set of limits as would line 3. Is this possible to automate? At 22:40 15/01/2015 -0700, Emil Payne wrote: Sorry, I meant to insert an image. The red at the top is just a reminder to me of what the limits are. At 22:46 15/01/2015 -0700, Emil Payne wrote: I might as well add the chart too. You can see the mean average of the red graph at 184 (currently). Your first image is of a range of cells but you start by referring to a chart. If you are talking about setting the colour of lines on a chart, I don't see any way to automate that. But I'm guessing that you want the values you enter in cells (not "boxes") to assume different text colours depending on their values. That's possible. o Select each range of cells to which you want this aspect to apply and go to Format | Conditional Formatting... . "Color scale" will give you background colours, but for text colours you probably need Condition. o Set the required conditions for data values. o Select cell styles appropriately - either from existing styles or using the New Style facility to create them on the fly. Text colour is selected on the Font Effects tab of the Cell Style dialogue. Note that - as you require - you can set different conditions for different ranges of data cells, reusing existing cell styles or creating new ones as preferred. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Support options
Am 15.01.2015 um 19:07 schrieb dave boland:
> The problem with gmane.org is that I can't seem to append to a thread.
> I can follow the thread, so it is somewhat helpful.
>
In this aera of spam and fraud you need to subscribe to a mailing list
in order to send messages. There is a switch ("nomail" or something)
which excludes you from the mail distribution so you can view this list
via gmane and send your messages using the same mail account you used
for registration.
>
> So if the LO team can make facebook easy to find relevant info, quick to
> use, intuitive, no passwords or registration, then go for it. If on the
> other hand they are just following the latest thing, then forget it. In
> the end, the support solution needs to fit the users needs, not just be
> cool.
>
As far as content matters,
> https://forum.openoffice.org/en/forum/index.php
is the major resource of user knowledge for both OpenOffice and
LibreOffice users. This mailing list is somewhat disappointing.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Support options
On Thu, Jan 15, 2015 at 1:07 PM, dave boland wrote: > What is easy and convenient? I thought I answered that. Quick to do, > no reistration, no passwords, able to see the appends in a thred like > Yes, you did say that before. I'm not familiar with a forum like that (esp the "no registration, no passwords" part). The description seemed like a requirements spec for a product design. I thought you may have specific forum in mind or examples. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Support options
At 08:29 16/01/2015 +, Tom Davies wrote: When websites ask for my DoB i use a fake one. I try to use the same fake one for all websites to make it easier to remember. Similarly with other bits of private information. So you mean that you give them the information that you are prepared to be dishonest? I should have thought that you would want to keep that information even more private! ;^) Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Support options
Hi :) When websites ask for my DoB i use a fake one. I try to use the same fake one for all websites to make it easier to remember. Similarly with other bits of private information. Regards from Tom :) On 15 January 2015 at 18:35, Rob Jasper wrote: > Please keep the 'old' stuff also. I am worried about privacy and therefore I > do not have a facebook account (and in fact I almost don't have any accounts > on more or less public things like that). > > So, fully changing to whatever new things is in my opinion not a good idea. > > Any system which requires information that has nothing to do with the service > they provide (e.g. birth date, place of birth, address, etc.) is a privacy > hazard.. > > Op 15 jan. 2015, om 19:07 heeft dave boland het volgende geschreven: > >> The problem with gmane.org is that I can't seem to append to a thread. >> I can follow the thread, so it is somewhat helpful. >> >> What is easy and convenient? I thought I answered that. Quick to do, >> no reistration, no passwords, able to see the appends in a thred like >> newsgroups do, the abbility to append to a thread. I have lost track of >> all the user id's and passwords for support web sites. I just won't use >> them any longer. >> >> So if the LO team can make facebook easy to find relevant info, quick to >> use, intuitive, no passwords or registration, then go for it. If on the >> other hand they are just following the latest thing, then forget it. In >> the end, the support solution needs to fit the users needs, not just be >> cool. >> >> Dave, >> >> On Thu, Jan 15, 2015, at 02:44 AM, Charles-H. Schulz wrote: >>> -BEGIN PGP SIGNED MESSAGE- >>> Hash: SHA1 >>> >>> Hi, >>> >>> Le Thu, 15 Jan 2015 03:40:03 +, >>> jonathon a écrit : >>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/01/15 21:49, dave boland wrote: > Can't we find a way to offer support that is easy and convenient? What do you consider to be _easy_ and _convenient_? > that new groups are considered old fashioned, but they work very > well, If "new groups" is a typo for newsgroups, then gmane.org is what you are looking for. If "new groups" means something else, then clarify what is meant. >>> >>> Just to be abundantly clear: this list alongside other lists of >>> LibreOffice.org are available as newsgroups on gmane.org >>> >>> Best, >>> >>> - -- >>> Charles-H. Schulz >>> Co-founder, The Document Foundation, >>> Kurfürstendamm 188, 10707 Berlin >>> Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts >>> Legal details: http://www.documentfoundation.org/imprint >>> Mobile Number: +33 (0)6 98 65 54 24. >>> -BEGIN PGP SIGNATURE- >>> Version: GnuPG v2 >>> >>> iQIVAwUBVLdvw36ia1m3mLTjAQLkIQ/+O1ngQJv8A8GXcKI2dhFvPhfJz+eqR5Aq >>> klmRqGApOxZbt/sLf9sY8DHz7G5TbYilaISaW6nUaX3YqMg4GJynh67wk9qutFew >>> sLT8kXFzaHX4uWkhygKyKm647lZwbGZm5nRXfIy6wQXqz9RDQxyVN/V018fad6eG >>> fSrOORTKmQLHv1K6xLZiEKG6IDjITJ3RyW7r7ia8ApjsOjtzvqoI20isn38tNCFm >>> LC0Mu6E3i1jV6QVSiq+TJmZoh0lnFw9IjG+Kk7BHcuzPdZb9Py/wi15VkpHN7SXV >>> dWdeJY8vE+6fCIWK+U2ngGKiUGuF6ZLaRt7Wi63Ea1BKodv2HBRre8QCrPqwu8tv >>> jnC2LR+qHjRBLFkYXd/+lYkhWf7kbvYpJNsWaKCu6cQql3cn5f7Sv2/tYooe8DN4 >>> pfdEG/5ZcMU9tymHXDhYTZYw/5/fFYQtA50CDg/GDeBxkYJefjfQdsKxqELsw3x7 >>> q5YOMDKZjbtOV1D/RXLV9ZWfNCamtcG4vH3b/8R3QQqEvrnFDxrTH1s+BmuiR03K >>> WIQZIiVgc1KT4weSMb+0LpBu3MOxZL2D350nOZn8gfv2lBlv2420ABlLdgJu4Pc1 >>> uTSLtp+H5vz/av/qrqY30CMl2Sh0ffCVZdUhpdPFY3ioB+uwNXNWDmZ0BDl1UCnL >>> Xwp/KuNtzjI= >>> =byES >>> -END PGP SIGNATURE- >>> >>> -- >>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >>> Problems? >>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >>> List archive: http://listarchives.libreoffice.org/global/users/ >>> All messages sent to this list will be publicly archived and cannot be >>> deleted >> -- >> dave boland >> dbola...@fastmail.fm >> >> -- >> http://www.fastmail.com - Access all of your messages and folders >> wherever you are >> >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >> List archive: http://listarchives.libreoffice.org/global/users/ >> All messages sent to this list will be publicly archived and cannot be >> deleted >> > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libre
[libreoffice-users] Re: What is the current best ODF editing Android Package?
Le 15/01/2015 15:49, Tim---Kracked_P_P---webmaster a écrit : Tim, > > For non-ODF editing [ .doc and .docx ] . . . Which Android app would you > use? I do not want Cloud computing since most of the time the tablet > will not have access to the Net. > In my experience, so far, nothing is perfect. If your Android device is a tablet running Kitkat 4.4, then you should be able to use Microsoft's own, free, Word/Excel/Powerpoint Preview apps, which are currently in generalized beta testing. I have tried, WPS Office, Textmaker/Planmaker/Presentations Mobile (paid app), DocsToGo (paid app), QuickOffice, Olive Office Premium (IMO the worst of the lot so far), all with varying degrees of success. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Support options
Le 15/01/2015 20:11, Jim Byrnes a écrit : > What are you using to access gmane? It probably relates more to what > you are using to access gmane than gmane itself. > > I use Thunderbird. Once I subscribe to a group on gmane it asks me how > many messages to download and marks the remaining as read. Once > downloaded I can choose what I want to view, all msgs, just unread msgs > or threads with unread msgs, plus some others I don't use. If I want to > respond to a msg I can choose "followup" which sends the reply to the > group or "replY" which sends it to the message's author. > Yep, same here. Gmane threads show up just fine in Thunderbird. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Font color based on value
Le 16/01/2015 06:40, Emil Payne a écrit : Hi Emil, > > The red at the top is just a reminder to me of what the limits are. > Sounds like you want conditional formatting : https://help.libreoffice.org/Calc/Applying_Conditional_Formatting http://www.techrepublic.com/blog/diy-it-guy/diy-conditional-formatting-in-libreoffice-calc/ Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
