SOLVED Re: [libreoffice-users] No menus for LibreOffice install on Chrubuntu

2014-03-17 Thread Don Myers
For some reason the libreofficeX.X-debian-menus file isn't running during the install. I ran that file separately in the software center and everything is working perfectly now with the Document Foundation version of LO 4.2.2.1. On 03/16/2014 10:36 PM, Tom Davies wrote: Hi :) Can you get to

Re: [libreoffice-users] Help with formatting a piece of text?

2014-03-17 Thread Ankush Mishra
On 17-03-2014 22:27, Brian Barker wrote: At 20:44 17/03/2014 +0530, Ankush Mishra wrote: I have a question on formatting a text multiple times in Writer. Here is my situation: I have a file which has a set of text like Date: separated by new lines every time. There might be over 100's of the

[libreoffice-users] Help us with UX testing and get a free lunch! - Cambridge, MA, USA - Friday, March 21st

2014-03-17 Thread Robinson Tryon
Hi all, This Friday, LibreOffice is proud to participate in the first annual SpinachCon[1] UX testing event. This is a great time for us to get in-person feedback from our users! The day before LibrePlanet[2], we'll be meeting at a geeky clubhouse called 'Industry Lab' to do some collaborative tes

Re: [libreoffice-users] alphabetical index: how do they work?

2014-03-17 Thread Tom Davies
Hi :) I think there is an external Extension/Add-on/Plug-in/package called "Zotero" or "Zoteros" that greatly improves this sort of thing in LibreOffice/OO and MS office Regards from Tom :) On 17 March 2014 20:52, Andrea wrote: > Hi there, > > I am quite confused... I have been spending all day t

Re: [libreoffice-users] No menus for LibreOffice install on Chrubuntu

2014-03-17 Thread Tom Davies
Hi :) Sounds like you just need to have another go at installing LibreOffice from the download you got from the official LibreOffice.org website There are some proper instructions somewhere. Regards from Tom :) On 17 March 2014 04:40, Don Myers wrote: > Hi Tom, > > In my conventional laptop, whe

Re: [libreoffice-users] Font size in PDF form

2014-03-17 Thread Tom Davies
Hi :) Err, Ctrl A = select all? Alternatively is each field use the same style name? Could you just modify the style? Regards from Tom :) On 17 March 2014 20:48, James Knott wrote: > I'm trying to fill in the info in a form provided in PDF format. While > I can open it in Draw and type in the

Re: [libreoffice-users] Re: Field names not being retained

2014-03-17 Thread A
Yes, you're right. I've also found that the fields can be "reset" so the data is purged from the fields by Edit > Exchange Database. I've also found that if the fields are changed in the original (now new) CSV file then this seems to be what's required: First delete the old database file regi

Re: [libreoffice-users] Copying cell contents to create phrase

2014-03-17 Thread Brian Barker
At 18:34 17/03/2014 +, Budgie Noname wrote: One last (I hope) question related to the task in hand. I have some instructions from my accountant concerning the preparation of the file before saving as .csv to import. She says:- "the data in the booking date column must not have the time.

Re: [libreoffice-users] Cannot Change Date Format in Calc

2014-03-17 Thread Brian Barker
At 21:09 17/03/2014 +, Budgie Noname wrote: Well your analysis is correct and the "date" is in text format. What is odd however is that the format changed from 12 Feb 2014 which DATEVALUE can recognise and I could have used to 12-Feb-2014 which it cannot. For what it's worth, DATEVALUE()

Re: [libreoffice-users] alphabetical index: how do they work?

2014-03-17 Thread Andrea Re
Hi Tom, thanks for that, but I must confess I am none the wiser... I have downloaded the plugin in Firefox as it doesn't seem to be available in LO (or perhaps I couln't find it). In any case, from what I have read, Zotero is not designed to create an alphabetical index, but things like a bib

Re: [libreoffice-users] No menus for LibreOffice install on Chrubuntu

2014-03-17 Thread Don C. Myers
Hi Tom, I did that, and I also tried downloading from the PPA. The same thing happened. I'm sure this has to be a Chrubuntu issue since my installs have always worked fine on other Ubuntu installs. One strange thing though. When I was purging the failed installed, I had an error message show

Re: [libreoffice-users] Font size in PDF form

2014-03-17 Thread James Knott
Tom Davies wrote: > Hi :) > Err, > Ctrl A = select all? > > Alternatively is each field use the same style name? Could you just > modify the style? > Regards from Ctl-A affects the entire document, not just the boxes I enter text into. How do you change font size in styles? I can open the Style

Re: [libreoffice-users] Cannot Change Date Format in Calc

2014-03-17 Thread Brian Barker
At 20:30 17/03/2014 +, Budgie Noname wrote: I have an .ods file and a column with dates in it resists all my attempts to change the format. The column was created when I opened a .csv file in Calc and the dates were shown as, for example, 12 Feb 2014. At some time during the editing of this

Re: [libreoffice-users] Cannot Change Date Format in Calc

2014-03-17 Thread Budgie
On 17/03/14 20:51, Tom Davies wrote: Hi :) That is what i was thinking of but now i re-read the original post in this thread i think that has already been tried. Maybe just use Brian's advice but instead of making it a text-field just keep it as a normal number-field or (if it does allow you (wh

[libreoffice-users] alphabetical index: how do they work?

2014-03-17 Thread Andrea
Hi there, I am quite confused... I have been spending all day trying to understand how to create an alphabetical index for an ebook I am working on. I have read this: https://wiki.documentfoundation.org/images/7/7a/0212WG34-TOCsIndexesBiblios.pdf but I am still at a loss... For example I would al

Re: [libreoffice-users] Cannot Change Date Format in Calc

2014-03-17 Thread Tom Davies
Hi :) That is what i was thinking of but now i re-read the original post in this thread i think that has already been tried. Maybe just use Brian's advice but instead of making it a text-field just keep it as a normal number-field or (if it does allow you (which i doubt)) as a date field. In the

[libreoffice-users] Font size in PDF form

2014-03-17 Thread James Knott
I'm trying to fill in the info in a form provided in PDF format. While I can open it in Draw and type in the info, the font is too large for the area. Is there any way that I can change the overall font size, instead of having to do it in each field? I have tried the Format > Character method, b

Re: [libreoffice-users] Cannot Change Date Format in Calc

2014-03-17 Thread Tom Davies
Hi :) Is this related to the thread being handled by Brian? If so the problem might be that you are trying to store the date as a text-field. It should be reasonably easy to change the text-format to a date one though. I think the date has to be stored as a numerical value in order to be read in

Re: [libreoffice-users] Cannot Change Date Format in Calc

2014-03-17 Thread Jay Lozier
On 03/17/2014 04:30 PM, Budgie wrote: I have an .ods file and a column with dates in it resists all my attempts to change the format. The column was created when I opened a .csv file in Calc and the dates were shown as, for example, 12 Feb 2014. At some time during the editing of this file the

Re: [libreoffice-users] Cannot Change Date Format in Calc

2014-03-17 Thread Budgie
On 17/03/14 20:38, Tom Davies wrote: Hi :) Is this related to the thread being handled by Brian? If so the problem might be that you are trying to store the date as a text-field. It should be reasonably easy to change the text-format to a date one though. I think the date has to be stored as a

Re: [libreoffice-users] Calc: Automatically sizing cells vertically to fit contents

2014-03-17 Thread James E Lang
Have you tried Alt+O, R, O which sets row height to fit the content. I think it continues to fit increased needs such as added lines as well as larger font size. On March 16, 2014 11:57:44 PM PDT, Brian Barker wrote: > At 14:39 17/03/2014 +1100, Hedley Finger wrote: > >On 17/03/2014 1:43 PM, S

[libreoffice-users] Cannot Change Date Format in Calc

2014-03-17 Thread Budgie
I have an .ods file and a column with dates in it resists all my attempts to change the format. The column was created when I opened a .csv file in Calc and the dates were shown as, for example, 12 Feb 2014. At some time during the editing of this file the dates became shown as 12-Feb-14 but I

Re: [libreoffice-users] OT: Windows, sort text file, can I use LibO maybe?

2014-03-17 Thread Tanstaafl
Paul, Many, many thanks! Works perfectly, and this will make finding the right computer so much easier! Thanks to the others who replied, but I did need a command line tool, and I'm sure the GNU tools will come in handy for other things too... Thanks again Paul! Charles On 3/17/2014 3:41

Re: [libreoffice-users] need CONFIRMATION about images linked to a http location

2014-03-17 Thread Fernand Vanrie
Dries , all, Thanks, ist a bug , found it myself now , only when using the option "Use LibreOffice Dialogs" the bug is happening , when using System dialogs , the Http locations can been used i fill a issue Greetz Fernandnd Fernand, I just tried this in 4.2.2.1 as well, and this works ju

Re: [libreoffice-users] OT: Windows, sort text file, can I use LibO maybe?

2014-03-17 Thread Tanstaafl
Hi Paul, Actually, I *think* that will work perfectly, thanks! If anyone cares, what this if for is... I use a really cool little free PortableApp called 'RemoteControl' (based on the old 'GenControl' app), that allows me to connect to and remotely control any PC in our network (only works in

Re: [libreoffice-users] Problem with formulas between Excel and LO

2014-03-17 Thread Steve Edmonds
On 2014-03-17 21:19, Ernest Karlsson wrote: Hi, We run Ubuntu at our school, Mellansels Folk High School, but our principal creates lots of excel files that need to work in both environments. Our time reporting file stopped working in the 4.0> LO update. We were unable to figure out were the pr

Re: [libreoffice-users] need CONFIRMATION about images linked to a http location

2014-03-17 Thread Mark Bourne
Fernand Vanrie wrote: With 4.2.2.1 windows Pictures in Writer and Html documents linked to a http location no longer opens and can no longer been inserted what makes the use of images in a HTML doc imposible A picture "linked" to "http://pmg.pmgroup.be/enews/idb/grafiek9.jpg"; can been opened a

Re: [libreoffice-users] OT: Windows, sort text file, can I use LibO maybe?

2014-03-17 Thread Dave Liesse
Actually, this can be done more easily in Writer. You have to select the text to be sorted, then choose Tools...Sort. The trick is to adjust the sort parameters in the dialog window. For Key1 you want to select column 2 (default is 1), then choose the Character radio button, click on the elli

Re: [libreoffice-users] Re: LO compatibility

2014-03-17 Thread Toki Kantoor
On March 17, 2014 3:41:24 AM PDT, e-letter wrote: >It's a worry that some users prefer new "features" over standards compliance >and quality control. It is extremely rare for features to have a negative impact on standards compliance. It is not uncommon for features to enhance standards compl

Re: [libreoffice-users] OT: Windows, sort text file, can I use LibO maybe?

2014-03-17 Thread Paul
Hi Charles, There are a few ways of doing this that I can think of. First, you could use the linux sort utility, that does let one sort by columns, so the second column in your case. There are two different ports of that to win32 here: http://gnuwin32.sourceforge.net/packages/coreutils.htm http:/

Re: [libreoffice-users] OT: Windows, sort text file, can I use LibO maybe?

2014-03-17 Thread Jay Lozier
On 03/17/2014 02:32 PM, Tanstaafl wrote: Hi all, I'm working on a little problem that I'd really like to resolve. It doesn't really have anything to do with Libreoffice, other than I thought I might be able to use Calc to do the sort... I have a text file. Each line is one record. I can us

[libreoffice-users] Re: Field names not being retained

2014-03-17 Thread Mark Bourne
A wrote: Interestingly, the field names seem to have changed seemingly for the better. Whereas before it was inserting things something like filename.databasename.sheetname.fieldname, now I get "fieldname". Unfortunately, after running the mailmerge, it seems to have made the values in the firs

Re: [libreoffice-users] Copying cell contents to create phrase

2014-03-17 Thread Budgie
On 17/03/14 18:02, Brian Barker wrote: At 17:48 17/03/2014 +, Budgie Noname wrote: On 17/03/14 13:25, Brian Barker wrote: At 11:43 17/03/2014 +, Budgie Noname wrote: In short I am having to "massage" a .csv file exported from one system before importing it into an accounting system. T

[libreoffice-users] OT: Windows, sort text file, can I use LibO maybe?

2014-03-17 Thread Tanstaafl
Hi all, I'm working on a little problem that I'd really like to resolve. It doesn't really have anything to do with Libreoffice, other than I thought I might be able to use Calc to do the sort... I have a text file. Each line is one record. I can use the raw windows Sort command to sort the

Re: [libreoffice-users] Copying cell contents to create phrase

2014-03-17 Thread Budgie
On 17/03/14 18:02, Brian Barker wrote: At 17:48 17/03/2014 +, Budgie Noname wrote: On 17/03/14 13:25, Brian Barker wrote: At 11:43 17/03/2014 +, Budgie Noname wrote: In short I am having to "massage" a .csv file exported from one system before importing it into an accounting system. T

Re: [libreoffice-users] Copying cell contents to create phrase

2014-03-17 Thread Brian Barker
At 17:48 17/03/2014 +, Budgie Noname wrote: On 17/03/14 13:25, Brian Barker wrote: At 11:43 17/03/2014 +, Budgie Noname wrote: In short I am having to "massage" a .csv file exported from one system before importing it into an accounting system. The accountant wants a "Comment" column

Re: [libreoffice-users] Copying cell contents to create phrase

2014-03-17 Thread Brian Barker
At 13:53 17/03/2014 +, Budgie Noname wrote: On 17/03/14 13:25, Brian Barker wrote: At 11:43 17/03/2014 +, Budgie Noname wrote: In short I am having to "massage" a .csv file exported from one system before importing it into an accounting system. The accountant wants a "Comment" column

Re: [libreoffice-users] Copying cell contents to create phrase

2014-03-17 Thread Budgie
On 17/03/14 13:25, Brian Barker wrote: At 11:43 17/03/2014 +, Budgie Noname wrote: In short I am having to "massage" a .csv file exported from one system before importing it into an accounting system. The accountant wants a "Comment" column added before importing the file which summarises i

Re: [libreoffice-users] Help with formatting a piece of text?

2014-03-17 Thread Brian Barker
At 20:44 17/03/2014 +0530, Ankush Mishra wrote: I have a question on formatting a text multiple times in Writer. Here is my situation: I have a file which has a set of text like Date: separated by new lines every time. There might be over 100's of these in the file, now I want to format them

Re: [libreoffice-users] need CONFIRMATION about images linked to a http location

2014-03-17 Thread Dries Feys
Fernand, I just tried this in 4.2.2.1 as well, and this works just fine: I created a new file and inserted an image through insert image from file. Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV Brabant

[libreoffice-users] need CONFIRMATION about images linked to a http location

2014-03-17 Thread Fernand Vanrie
With 4.2.2.1 windows Pictures in Writer and Html documents linked to a http location no longer opens and can no longer been inserted what makes the use of images in a HTML doc imposible A picture "linked" to "http://pmg.pmgroup.be/enews/idb/grafiek9.jpg"; can been opened and viewed in a writ

[libreoffice-users] [QA] Bug Tracker Feature Request

2014-03-17 Thread Joel Madero
Hi All, So we're getting really into the planning stages of our own instance of bugzilla. That being said we are compiling a list of requests that could improve how users/devs/and QA interact with it. If you have any ideas feel free to add: https://wiki.documentfoundation.org/QA/Projects/Ideas/Sel

[libreoffice-users] Help with formatting a piece of text?

2014-03-17 Thread Ankush Mishra
I have a question on formatting a text multiple times in Writer. Here is my situation: I have a file which has a set of text like Date: seperated by new lines every time. There might be over 100's of these in the file, now I want to format them to Headings, would there be an easy way

Re: [libreoffice-users] Re: LO compatibility

2014-03-17 Thread Italo Vignoli
On 17/03/14 11:41, e-letter wrote: > It's a worry that some users prefer new "features" over standards > compliance and quality control. Please do not see new software features as changes to the document format. Over 99% of new features do not have any impact on the document format, which is the

Re: [libreoffice-users] Copying cell contents to create phrase

2014-03-17 Thread Budgie
On 17/03/14 13:25, Brian Barker wrote: At 11:43 17/03/2014 +, Budgie Noname wrote: In short I am having to "massage" a .csv file exported from one system before importing it into an accounting system. The accountant wants a "Comment" column added before importing the file which summarises i

Re: [libreoffice-users] Clarification about ODF Extended

2014-03-17 Thread Italo Vignoli
On 17/03/14 11:53, e-letter wrote: > Thanks for this information. The difference between extended and > strict allows for confusion to occur. In the option > "load/save,general", there is no option "strict standard", only 10/11, > 12, 12extended. ODF 1.2 is the standard, and I have used "strict"

Re: [libreoffice-users] Copying cell contents to create phrase

2014-03-17 Thread Brian Barker
At 11:43 17/03/2014 +, Budgie Noname wrote: In short I am having to "massage" a .csv file exported from one system before importing it into an accounting system. The accountant wants a "Comment" column added before importing the file which summarises information held in four other columns.

[libreoffice-users] Copying cell contents to create phrase

2014-03-17 Thread Budgie
In short I am having to "massage" a .csv file exported from one system before importing it into an accounting system. The accountant wants a "Comment" column added before importing the file which summarises information held in four other columns. Two columns contain names and do not present a

[libreoffice-users] Re: Problem with formulas between Excel and LO

2014-03-17 Thread Pedro
Ernest Karlsson wrote > The file is in Swedish but I believe that the formulas will be in English > on a English system. To unlock the hidden columns and rows use the > password: Mellansel (I have permission to pass this on) I unlocked the cells and didn't notice any difference under LO 3.6.7.2 (t

Re: [libreoffice-users] Re: LO compatibility

2014-03-17 Thread Tanstaafl
On 3/16/2014 12:07 PM, Jim Seymour wrote: Once again: Putting the cart before the horse. LO does not "define" the standard. OASIS or ISO (depending upon one's perspective, I suppose) defines the standard. LO's responsibility is to faithfully *implement* the standard. As the *leading* 'user

Re: [libreoffice-users] Re: Date Patterns

2014-03-17 Thread Tanstaafl
On 3/16/2014 9:59 AM, Luuk wrote: It's really strange that the format '1st quarter 14' is supported and that '16th day of march' is NOT supported Please, someone, file a bug about this?!! Ummm... if it is important to you, maybe do it yourself? Do you want someone to make your breakfast for

Re: [libreoffice-users] Problem with formulas between Excel and LO

2014-03-17 Thread e-letter
On 17/03/2014, Ernest Karlsson wrote: > Hi, > > We run Ubuntu at our school, Mellansels Folk High School, but our principal > creates lots of excel files that need to work in both environments. Our > time reporting file stopped working in the 4.0> LO update. We were unable > to figure out were the

Re: [libreoffice-users] Clarification about ODF Extended

2014-03-17 Thread e-letter
On 16/03/2014, Italo Vignoli wrote: > ODF as implemented by OpenOffice and then LibreOffice has always been > the "extended" version, and not the "strict standard" version, although > it has always been possible to choose the latter. ODF become a standard > in 2006, based on OOo 2.0 (2005) file fo

Re: [libreoffice-users] Re: LO compatibility

2014-03-17 Thread e-letter
On 16/03/2014, Jim Seymour wrote: > > Practical implementations of a proposed standard are wonderful, but, > before it's part of the standard, documents written with such > extensions are, _by definition_, non-standard formats. > It's a worry that some users prefer new "features" over standards c

Field names not being retained (was Re: [libreoffice-users] LO crashes on restart; continually.)

2014-03-17 Thread A
Deleting the user profile seems to resolve the issue mentioned below. Interestingly, the field names seem to have changed seemingly for the better. Whereas before it was inserting things something like filename.databasename.sheetname.fieldname, now I get "fieldname". Unfortunately, after run

[libreoffice-users] LO crashes on restart; continually.

2014-03-17 Thread A
ubuntu 12.04 While fooling with mail merge, I decided to clean up my databases... I deleted them all and recreated the one I needed with a new name. That was a major mistake from which I was unable to recover, as now my fields don't match the database. At the same time, I added a few fields,

Re: [libreoffice-users] Re: Problems with mail merge

2014-03-17 Thread A
.doc format seems to be the culprit. Thank you - Andrew On 03/17/14 00:50, Alex Thurgood wrote: Le 16/03/2014 23:33, A a écrit : Hi Andrew, I can think of a few things that might (but then again, might not) be the cause : - using DOC format for your mailmerge instead of ODT - as I've never

[libreoffice-users] Problem with formulas between Excel and LO

2014-03-17 Thread Ernest Karlsson
Hi, We run Ubuntu at our school, Mellansels Folk High School, but our principal creates lots of excel files that need to work in both environments. Our time reporting file stopped working in the 4.0> LO update. We were unable to figure out were the problem was. The problem arises after the first d

Re: [libreoffice-users] No menus for LibreOffice install on Chrubuntu

2014-03-17 Thread Tom Davies
Hi :) Can you get to a command-line and open LibreOffice from there? Ctrl Alt t should open a terminal console. Then the command soffice should open LIbreOffice. If it doesn't (or maybe even if it does) then hopefully the command-line should show some error messages which might give some clue abo

[libreoffice-users] Re: Problems with mail merge

2014-03-17 Thread Alex Thurgood
Le 16/03/2014 23:33, A a écrit : Hi Andrew, I can think of a few things that might (but then again, might not) be the cause : - using DOC format for your mailmerge instead of ODT - as I've never tried mailmerge in LO with a DOC formatted file (I always use ODT), I can't say ; - using fields wi