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

2014-03-17 Thread Brian Barker
At 14:39 17/03/2014 +1100, Hedley Finger wrote: On 17/03/2014 1:43 PM, Steve Edmonds wrote: On 2014-03-17 15:29, Hedley Finger wrote: I'm sure that I could set automatic sizing of cells to fit their contents in Excel. I want them to increase in height as more text is typed into them. Does

[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

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

[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

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

[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,

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

Re: [libreoffice-users] Re: LO compatibility

2014-03-17 Thread e-letter
On 16/03/2014, Jim Seymour jseym...@linxnet.com 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

Re: [libreoffice-users] Clarification about ODF Extended

2014-03-17 Thread e-letter
On 16/03/2014, Italo Vignoli italo.vign...@gmail.com 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

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

2014-03-17 Thread e-letter
On 17/03/2014, Ernest Karlsson ernestkarls...@gmail.com 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

Re: [libreoffice-users] Re: LO compatibility

2014-03-17 Thread Tanstaafl
On 3/16/2014 12:07 PM, Jim Seymour jseym...@linxnet.com 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

[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 (the

[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

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.

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 to

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

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

[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:insert date here 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

[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:

[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 writer

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

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:insert date here separated by new lines every time. There might be over 100's of these in the file, now I want

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

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 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 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.

[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.

[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 first

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

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

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

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

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 and

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

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

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

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

[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] 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 b.m.bar...@btinternet.com wrote: At 14:39 17/03/2014 +1100, Hedley Finger wrote:

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

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

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

[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,

[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

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

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

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 Styles

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] 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

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] 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] 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

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 james.kn...@rogers.com wrote: I'm trying to fill in the info in a form provided in PDF format. While I can open it in

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 donmy...@myersfarm.com wrote: Hi Tom, In my

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 and...@andrea-re.eu wrote: Hi there, I am quite confused... I have been

[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

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:insert date here separated by new lines every time. There might be

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