[libreoffice-users] Insert frame - cursor jumps to document top

2013-03-25 Thread Thomas Blasejewicz
Good afternoon I am trying to put something together for Kindle (still; had formating troubles the other day, that continue). Currently I am trying to rewrite/overwrite or whatever the term may be an ODF file as a html file. The originally uploaded file hadimages + captions that appeared in the

Re: [libreoffice-users] Changing The Mouse Cursor to an HourGlass

2013-03-25 Thread mcmurchy1917-libreoffice
Hi Andrew I had read the document and had hoped this might have changed. From a professional point of view some customers dictate that a mouse pointer must be changed to a hour glass if an action cannot be completed in a pre-determined amount of time. So anyway, I've done a belts and braces

Re: [libreoffice-users] Changing The Mouse Cursor to an HourGlass

2013-03-25 Thread mcmurchy1917-libreoffice
I've now dropped the dialog and ProgressBar in favour of the status bar with REM Create a NEW status indicator oBar = document.createStatusIndicator() oBar.start(Started..., rsSUBSCRIBERS.Row() + 3) oBar.Value = 1 ' show progress bar Bar.Text = Progressing... Then each time the

Re: [libreoffice-users] Changing The Mouse Cursor to an HourGlass

2013-03-25 Thread Tom Davies
Hi :) I'm impressed.  It follows the principle of Release early and release often.  It does the job done.  After release clients may make suggestions anyway even if it was 100% exactly following their specs. I was suggesting a progress bar instead of the mouse arrow changing to a wheel not

Re: [libreoffice-users] Changing The Mouse Cursor to an HourGlass

2013-03-25 Thread Tom Davies
Hi :) That looks better to me.  I'm not a programmer and don't understand code but it looks like a lot less lines and hopefully that results in faster execution of the code.  So more cpu cycles for the actual processing and less used up in the overhead of producing the timer-indicator.  Good

Re: [libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Kracked_P_P---webmaster
On 03/24/2013 06:59 PM, Ken Springer wrote: On 3/24/13 12:55 PM, Jason Paul Joines wrote: I'm using LibreOffice 4.0.1.2 on Kubuntu 12.04.2. I'm working on a spreadsheet that I will need to send to a windows user who is not using LibreOffice. What native Linux/LibreOffice font can I use

[libreoffice-users] Page numbers in language other than english

2013-03-25 Thread miltus_31
Hello, I want to number the pages in an document. I know it can be achieved by 1. inserting default footer 2. then inserting page number field. But in this case by default the page numbers come in english. Is there any way to give the page numbers in any language ? I am actually trying to use

[libreoffice-users] Summing a cell value by a backgroud color cell style

2013-03-25 Thread Krunoslav Šebetić
Hello, I need to make a Calc table. Table is structured verticly. Tables sums number values from collums in the last row of table. Every collum stands for itself, and has nothing do do with oder collums. But values are enterd in collum by different variables. I have set different cell

[libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Ken Springer
On 3/24/13 12:55 PM, Jason Paul Joines wrote: I'm using LibreOffice 4.0.1.2 on Kubuntu 12.04.2. I'm working on a spreadsheet that I will need to send to a windows user who is not using LibreOffice. What native Linux/LibreOffice font can I use that will also be available on the windows

Re: [libreoffice-users] Page numbers in language other than english

2013-03-25 Thread Regina Henschel
Hi ???, miltus_31 schrieb: Hello, I want to number the pages in an document. I know it can be achieved by 1. inserting default footer 2. then inserting page number field. But in this case by default the page numbers come in english. Is there any way to give the page numbers in any language ?

Re: [libreoffice-users] Page numbers in language other than english

2013-03-25 Thread anne-ology
Curiously wondering, what is indic ? I've heard of Roman numerals and Arabic numerals; yet never any other ;-) This list continues to teach me, thanks to all of you. On Mon, Mar 25, 2013 at 8:55 AM, miltus_31 miltu...@gmail.com wrote: Hello, I want to number

Re: [libreoffice-users] Page numbers in language other than english

2013-03-25 Thread miltus31
On Mon, 2013-03-25 at 15:52 +0100, Regina Henschel wrote: Hi ???, You can say miltus. Use Format Page and there the tab Page. There is a drop-down list Format in section Layout settings. From that list use the item Native Numbering. I'm using LibreOffice 3.5.4.2 Build ID: 350m1(Build:2)

Re: [libreoffice-users] Page numbers in language other than english

2013-03-25 Thread Regina Henschel
Hi miltus, miltus31 schrieb: On Mon, 2013-03-25 at 15:52 +0100, Regina Henschel wrote: Hi ???, You can say miltus. Use Format Page and there the tab Page. There is a drop-down list Format in section Layout settings. From that list use the item Native Numbering. I'm using LibreOffice

Fwd: Re: [libreoffice-users] VLOOKUP for Numbers

2013-03-25 Thread Carl Paulsen
Oops, sent this to the original sender, not the list: Please clarify: I haven't had any luck figuring out a method to compare each element of a list of numbers to each element of a differently sized list of numbers. What I want would bo something very much like VLOOKUP, but instead of

Re: [libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Tom Davies
Hi :) Good point!  Thanks :)  It's something i kinda knew but didn't really think about it much let alone grok it!  I think you have just given me a big clue as to why my bosses machines don't display my documents correctly.  It could easily be formatting issues related to them having different

Re: [libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Steve Edmonds
Hi Tom. I was out 1 line every 1 or 2 pages, which in 40 pages put my layout, images, illustrations, etc. all askew. Steve On 2013-03-26 04:57, Tom Davies wrote: Hi :) Good point! Thanks :) It's something i kinda knew but didn't really think about it much let alone grok it! I think you

Re: Fwd: Re: [libreoffice-users] VLOOKUP for Numbers

2013-03-25 Thread Dave Liesse
I agree that the original question is a little confusing. What everybody seems to have forgotten in their replies, though, is that if the lookup list is sorted then a non-match will be treated as if it matched the next lower value (for example, looking up 6 in a list of odd numbers will

Re: [libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Kracked_P_P---webmaster
I may be the issue if the amount of kerneling or the amount of extra space above and below the actual letters. I have seen that change between different similar named fonts before. On 03/25/2013 12:56 PM, Steve Edmonds wrote: Hi Tom. I was out 1 line every 1 or 2 pages, which in 40 pages

Re: [libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Tom Davies
Hi :) I recently started using Anchor to paragraph instead of Anchor to page which i had previously preferred.  It's difficult to get the balance right either way tho.  Regards from Tom :)  From: Steve Edmonds steve.edmo...@ptglobal.com To: Tom Davies

[libreoffice-users] Re: Summing a cell value by a backgroud color cell style

2013-03-25 Thread Tom
Hi :) If you want to upload the file so that everyone can see it then Nabble is a good place. When you are in the right thread in Nabble click on Reply. Above where you can type in are a few buttons. The More button's top option is Upload file which works roughly the same as uploading an

[libreoffice-users] calc problem

2013-03-25 Thread Tim Lloyd
Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on the wrong table by accident and tried to

Re: [libreoffice-users] Re: Summing a cell value by a backgroud color cell style

2013-03-25 Thread Krunoslav Šebetić
On 03/25/2013 09:25 PM, Tom wrote: Hi :) If you want to upload the file so that everyone can see it then Nabble is a good place. When you are in the right thread in Nabble click on Reply. Above where you can type in are a few buttons. The More button's top option is Upload file which works

[libreoffice-users] Re: VLOOKUP for Numbers

2013-03-25 Thread Tom
Hi :) If you want to upload the file so that everyone can see it then Nabble is a good place. When you are in the right thread in Nabble click on Reply. Above where you can type in are a few buttons. The More button's top option is Upload file which works roughly the same as uploading an

Re: [libreoffice-users] calc problem

2013-03-25 Thread Brad Rogers
On Tue, 26 Mar 2013 07:44:00 +1100 Tim Lloyd tim.ll...@gmx.com wrote: Hello Tim, Just click on the xls link next to Warrant Market Any comments? Yes, it locked up here too, using v3.5.4.2 in Debian, at about 50% through loading. Top showed 100% CPU usage. After a minute or so, I killed the

Re: [libreoffice-users] Summing a cell value by a background color cell style

2013-03-25 Thread Brian Barker
At 15:16 25/03/2013 +0100, Krunoslav Šebetić wrote: I need to make a Calc table. Table is structured vertically. Tables sums number values from columns in the last row of table. Every column stands for itself, and has nothing to do with other columns. But values are entered in column by

Re: [libreoffice-users] VLOOKUP for Numbers

2013-03-25 Thread Brian Barker
At 10:32 25/03/2013 -0700, Dave Liesse wrote: I agree that the original question is a little confusing. What everybody seems to have forgotten in their replies, though, ... I don't think anyone has had the chance to forget anything: you have yet to tell us exactly what you are trying to do.

Re: [libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Steve Edmonds
Yes, it is a juggle. Anchor to paragraph has the problem that you cant choose the paragraph it anchors to. There is some internal algorithm where the anchor can flick up and down between paragraphs. Steve On 2013-03-26 08:56, Tom Davies wrote: Hi :) I recently started using Anchor to

[libreoffice-users] Re: any good libreoffice/linux fonts for sharing documents with windows users

2013-03-25 Thread Ken Springer
On 3/25/13 8:19 AM, Ken Springer wrote: On 3/24/13 12:55 PM, Jason Paul Joines wrote: I'm using LibreOffice 4.0.1.2 on Kubuntu 12.04.2. I'm working on a spreadsheet that I will need to send to a windows user who is not using LibreOffice. What native Linux/LibreOffice font can I use that

Re: [libreoffice-users] calc problem

2013-03-25 Thread Jay Lozier
On 03/25/2013 04:44 PM, Tim Lloyd wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on

Re: [libreoffice-users] calc problem

2013-03-25 Thread Steve Edmonds
On 2013-03-26 09:44, Tim Lloyd wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on

Re: [libreoffice-users] calc problem

2013-03-25 Thread Tim Lloyd
Thanks Jay and Brad. I'll raise a bug report Ironically that site has language along the lines of you will need MS Excel to open these files. I was going to write to correct them on this. Best keep my mouth shut now :( Cheers On 03/26/2013 09:13 AM, Jay Lozier wrote: On 03/25/2013 04:44 PM,

[libreoffice-users] Re: Summing a cell value by a backgroud color cell style

2013-03-25 Thread Tom
Hi :) Here is the uploaded file example.ods http://nabble.documentfoundation.org/file/n4046112/example.ods I am also adding a screen-shot of how Nabble looked, with my mouse just beside the More button so you can see if IceWeasel really is misbehaving 30.png

Re: [libreoffice-users] Summing a cell value by a background color cell style

2013-03-25 Thread Krunoslav Šebetić
On 03/25/2013 11:08 PM, Brian Barker wrote: At 15:16 25/03/2013 +0100, Krunoslav Šebetić wrote: I need to make a Calc table. Table is structured vertically. Tables sums number values from columns in the last row of table. Every column stands for itself, and has nothing to do with other

Re: [libreoffice-users] Re: Summing a cell value by a backgroud color cell style

2013-03-25 Thread Krunoslav Šebetić
On 03/25/2013 11:24 PM, Tom wrote: Hi :) Here is the uploaded file example.ods http://nabble.documentfoundation.org/file/n4046112/example.ods I am also adding a screen-shot of how Nabble looked, with my mouse just beside the More button so you can see if IceWeasel really is misbehaving 30.png

Re: [libreoffice-users] Summing a cell value by a background color cell style

2013-03-25 Thread Steve Edmonds
On 2013-03-26 11:30, Krunoslav Šebetić wrote: On 03/25/2013 11:08 PM, Brian Barker wrote: At 15:16 25/03/2013 +0100, Krunoslav Šebetić wrote: I need to make a Calc table. Table is structured vertically. Tables sums number values from columns in the last row of table. Every column stands for

[libreoffice-users] Re: calc problem

2013-03-25 Thread Tinkerer
It opens OK in the Mac, LO 4.0.1.2 version. 114 Rows by 13 columns. -- View this message in context: http://nabble.documentfoundation.org/calc-problem-tp4046080p4046119.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Re: calc problem

2013-03-25 Thread Tom Davies
Hi :) It opens fine in Gnumeric but not LibreOffice 4.0.0 on Ubuntu 12.04.  So far it only seems to open on a Mac.  Regards from Tom :)  From: Tinkerer j_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Monday, 25 March 2013, 22:57 Subject:

Re: [libreoffice-users] Summing a cell value by a background color cell style

2013-03-25 Thread Steve Edmonds
On 2013-03-26 12:32, Krunoslav Šebetić wrote: On 03/25/2013 11:55 PM, Steve Edmonds wrote: On 2013-03-26 11:30, Krunoslav Šebetić wrote: On 03/25/2013 11:08 PM, Brian Barker wrote: At 15:16 25/03/2013 +0100, Krunoslav Šebetić wrote: I need to make a Calc table. Table is structured

Re: [libreoffice-users] Summing a cell value by a background color cell style

2013-03-25 Thread Krunoslav Šebetić
On 03/25/2013 11:55 PM, Steve Edmonds wrote: On 2013-03-26 11:30, Krunoslav Šebetić wrote: On 03/25/2013 11:08 PM, Brian Barker wrote: At 15:16 25/03/2013 +0100, Krunoslav Šebetić wrote: I need to make a Calc table. Table is structured vertically. Tables sums number values from columns in

Re: [libreoffice-users] calc problem

2013-03-25 Thread TomW
On 2013-03-25 16:44, Tim Lloyd wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on the

Re: [libreoffice-users] calc problem

2013-03-25 Thread Jay Lozier
On 03/25/2013 09:30 PM, TomW wrote: On 2013-03-25 16:44, Tim Lloyd wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz.

Re: [libreoffice-users] Summing a cell value by a background color cell style

2013-03-25 Thread Brian Barker
At 23:30 25/03/2013 +0100, Krunoslav Šebetic wrote: Let's say I am collecting weather temperature (but I'm not) values ... So let's not say that, then! Why not tell us what you are doing - or just call them values? ... and I'm doing it five time a day. Let's say that every time (of five)

Re: [libreoffice-users] calc problem

2013-03-25 Thread Tim Lloyd
Hi Michael, looks like this one didn't make it to the list. And it is very interesting. In light of all the XML reports I think the first step is to ask the site why XML docs are masquerading as XLS. It would be good to know the version of MSO you are using so I can quote this to them. FYI I

Re: [libreoffice-users] VLOOKUP for Numbers

2013-03-25 Thread Jason C. Wells
OK. Take two. Since VLOOKUP for numbers with an inequality is not meaningful, what I precisely hope to do is this. I hope that the preformatted columns survive the mailer software. Give the following columns: A B C D --- --- --- --- 1.1 eqn 3 0.10

RE: [libreoffice-users] calc problem

2013-03-25 Thread Dennis E. Hamilton
It is not an .xlsx file. .xlsx files are a kind of Zip package, similar to how .ods is a special Zip package. Rename it to .xml. Try opening it, in LibreOffice, as Microsoft Excel 2003 XML. Also, Excel should be able to open it as an XML file unless it has been damaged. There are some data

Re: [libreoffice-users] VLOOKUP for Numbers

2013-03-25 Thread Brian Barker
At 21:17 25/03/2013 -0700, Jason C. Wells wrote: OK. Take two. Since VLOOKUP for numbers with an inequality is not meaningful, ... It will do what you require, I think. ... what I precisely hope to do is this. I hope that the preformatted columns survive the mailer software. Give the