[libreoffice-users] [calc][pyuno] How to modify borders of cell range via python

Greetings Can someone advise on how to access and modify borders of cell ranges programmatically? I've been attempting this using python macro scripts without success. I also asked at http://ask.libreoffice.org/en/question/38724/how-can-one-set-the-borders-of-a-cell-range-via-python-scripting-fr

Re: [libreoffice-users] Rotating Text

At 17:10 22/08/2014 -0400, Pikov Andropov wrote: A friend was having trouble with this in WPS Office and asked if LibreOffice could do better. He's printing some bridge table cards and he wants SOUTH upside down at the top, North rightside up at the bottom, and WEST and EAST "facing out" at the

Re: [libreoffice-users] Rotating Text

On 8/22/2014 2:10 PM, Pikov Andropov wrote: > He's printing some bridge table cards and he wants SOUTH upside down at > the top, North rightside up at the bottom, and WEST and EAST "facing > out" at the sides. That is, when each player sits at the table, he sees > (rightside up) a directional na

[libreoffice-users] LibreOffice on the Big Screen

All: Apache Open Office has https://blogs.apache.org/OOo/entry/with_special_guest_star_apache which lists some appearances of Apache Open Office on TV and movies. Questions: * Is/has anybody tracked instances of LibreOffice in movies or TV? * If so, where is that information posted? Not wonderin

Re: [libreoffice-users] Printing Checks

I did Google "LibreOffice cheque" and found nothing useful. And, incidentally, in America, "check" is the correct word. I’ll be glad to back that up with sources, but "cheque" is British. Banks use "check" and so does the Federal Reserve and the U.S. Treasury. Hal On Aug 20, 2014, at 7:46

Re: [libreoffice-users] Printing Checks

Thank you, both for the one helpful and practical suggestion in response to my request, but for not saying "cheque" is the way it should be done. (When one lives in the US and the Treasure, Fed, and all banks use "check," that pretty much makes it official…) While I didn’t find anything useful

Re: [libreoffice-users] Issue with INDEX function

The trim function did the trick.  I have been burned by this in the past, so don't know why I didn't think of it!  It is really the only thing that makes sens.gsOn 08/22/14 13:07, Mark Bourne wrote: Gregory Smith - Oracle Sparc Verification wrote:AllI have created a one dimensio

[libreoffice-users] Rotating Text

A friend was having trouble with this in WPS Office and asked if LibreOffice could do better. He's printing some bridge table cards and he wants SOUTH upside down at the top, North rightside up at the bottom, and WEST and EAST "facing out" at the sides. That is, when each player sits at the table,

Re: [libreoffice-users] Issue with INDEX function

At 09:41 22/08/2014 -0500, Gregory Smith wrote: I have created a one-dimensional array called CATEGORY. When I do this function: =Index(Category,25,0) I get the contents of that index - let's say it is the word "cats". When I do this function =if((index(category,25,0)="cats"),1,0) I get FALSE?!

Re: [libreoffice-users] Downloading Libre Office

On 22-8-2014 15:32, Megan Vanderpol wrote: Hi, I have been having trouble with LibreOffice; I had it downloaded and was using it for quite awhile and I had not updated it for a bit. 2 days ago it stopped working; would not open documents or the program itself. I have tried downloading LibreOffi

Re: [libreoffice-users] Issue with INDEX function

Gregory Smith - Oracle Sparc Verification wrote: AllI have created a one dimensional array called CATEGORY.When I do this function: =Index(Category,25,0)I get the contents of that index - lets say it is the word "cats"When I do this function =if((index(category,25,0)="cats"),1,0)I

Re: [libreoffice-users] Re: Turn Off All Automated Functions

Owen Genat wrote: TomD wrote Apparently at least many of the Autocorrect stuff is kept in a .dat file somewhere. Does anyone know where? Can it be edited? These locale-specific files are stored under share/autocorr/ in the install location. The XML files in each DAT can be extracted using an

[libreoffice-users] Issue with INDEX function

AllI have created a one dimensional array called CATEGORY.When I do this function: =Index(Category,25,0)I get the contents of that index - lets say it is the word "cats"When I do this function =if((index(category,25,0)="cats"),1,0)I get FALSE?!!Anyone have any ideas what I am doing wr

Re: [libreoffice-users] linking in data from a file

Gregory Smith - Oracle Sparc Verification wrote: All I have an analysis spreadsheet that pulls data from sheets of several other spreadsheets.Under StarOffice, the technique I used was to open both spreadsheets, do a copy of the data in the source spreadsheet, go to a blank s

Re: [libreoffice-users] Link to external data question

Jim Byrnes wrote: On 08/21/2014 03:16 PM, Mark Bourne wrote: Jim Byrnes wrote: I would like to import some stock quotes from finance.yahoo.com into a calc sheet. As a test I select cell A1 Insert-->Link to External Data and I get the External Data dialog Put http://finance.yahoo.com/d/quotes.c

[libreoffice-users] linking in data from a file

AllI have an analysis spreadsheet that pulls data from sheets of several other spreadsheets.Under StarOffice, the technique I used was to open both spreadsheets, do a copy of the data in the source spreadsheet, go to a blank sheet in the receiving spreadsheet and do a paste-

[libreoffice-users] Re: Link to external data question

Not sure about that. Have a look at comment #5 in fdo#69320 I followed along with that and was able to insert source link, and the cell(s) receive the value(s) from the external .CSV resource. -- View this message in context: http://n

[libreoffice-users] Downloading Libre Office

Hi, I have been having trouble with LibreOffice; I had it downloaded and was using it for quite awhile and I had not updated it for a bit. 2 days ago it stopped working; would not open documents or the program itself. I have tried downloading LibreOffice Fresh and Still to replace the origin

[libreoffice-users] Re: Link to external data question

Jim Byrnes wrote > On 08/21/2014 03:16 PM, Mark Bourne wrote: >> Jim Byrnes wrote: >>> Put http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a in the URL box > > The whole thing is getting complex. I just wanted to link about 10 > cells so I wouldn't have to type in the data manually. Not a big >

Re: [libreoffice-users] Re: Link to external data question

Hi :) Changing the file-ending doesn't change the format of the data itself within the file. I tried editing the url address to replace csv with ods and a file did get downloaded but it wasn't really an ods - just some sort of text file which Calc correctly identified as being like a csv and gave

[libreoffice-users] Re: Turn Off All Automated Functions

TomD wrote > Apparently at least many of the Autocorrect stuff is kept in a .dat file > somewhere. Does anyone know where? Can it be edited? These locale-specific files are stored under share/autocorr/ in the install location. The XML files in each DAT can be extracted using an archive manager a

Re: [libreoffice-users] Turn Off All Automated Functions

Hi :) This might be going off-track a bit but ... Apparently at least many of the Autocorrect stuff is kept in a .dat file somewhere. Does anyone know where? Can it be edited? Reason i'm asking is the other way around. I've just got KMail reading off the company Exchange (thanks to a huge amou