Re: [libreoffice-users] calc sort

2012-01-07 Thread Johnny Rosenberg
2012/1/7 James bjloc...@lockie.ca: I made a simple sheet in calc that just contained 'Tue' and 'Wed'. Both cells are a date format but I tried to sort them and they won't change order. 3.5 I don't know about other people on this list, but I certainly need a some more information about this.

[libreoffice-users] Names of output filters? Name of HTML output filter?

2012-01-07 Thread filtered
Running soffice --convert-to allows me to specify a custom output filter name. Where can I full list of output filter names? In particular I am looking for the name of the HTML output filter used for the HTML export used through the UI. This filter is different from the one used when running with

[libreoffice-users] Re: 1 Column Header (Chapter Heading) Across 2 Column Page?

2012-01-07 Thread jpatterson
Thank you for your reply. I understand creating a section, as I said in my original post, and that you make it two column, but as I said, if I fill it up with content, it just bleeds onto the next page, inside of one of the columns on the pages where I do have a 2 column page setup - I have to

Re: [libreoffice-users] Create Index with clickable links in Writer?

2012-01-07 Thread Gabriel Risterucci
In the index properties (when adding it, or after with right click-edit index) on the second tab are found the format used for each index entries. If you use the hyperlink button when placing your cursor before and then after the entry title, it will create an hyperlink (button's name might not

Re: [libreoffice-users] 1 Column Header (Chapter Heading) Across 2 Column Page?

2012-01-07 Thread Dan Lewis
On Thu, 2012-01-05 at 19:58 -0800, jpatterson wrote: Hello, I have been having trouble with this and would appreciate any help. I read in the documentation but it doesn't work, that you can create a single column section that goes across an 8.5x11 page, and then after that, you can set the

Re: [libreoffice-users] CALC - current row/column highlight

2012-01-07 Thread alex sato
Hi Miguel, Thank you! It worked. By the way, wouldn't be great if it was a native feature? ;-) regards Alex Mitsio Sato On Sat, Jan 7, 2012 at 5:36 AM, MiguelAngel mari...@miguelangel.mobiwrote: El 07/01/12 8:16, alex sato escribió: Hi! I have a question about the CALC. There is a

[libreoffice-users] Calc - comments / macro

2012-01-07 Thread alex sato
Hi! I wish to know how to change the size of the box where the cells comments is displayed using macro. Is it possible? Thanks in advance Alex Mitsio Sato -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Create Index with clickable links in Writer?

2012-01-07 Thread Tom Davies
Hi :) Chapter 12 of the Writer Guide might be useful too. http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide Also the dialogue-box itself helps a bit but it takes a bit of experimentation before it really makes sense.  It's a bit weird at first so it helps to

Re: [libreoffice-users] CALC - current row/column highlight

2012-01-07 Thread alex sato
It was too close to be good. It change all visible cells backcolor to No fill when you select another cell instead to change to prior value. Not good when you have a sheet filled with backcolored cells. :-( It isn't the feature that just me wish, friends and coworkers told me that wished such

[libreoffice-users] Re: CALC - current row/column highlight

2012-01-07 Thread Andreas Säger
http://user.services.openoffice.org/en/forum/viewtopic.php?f=20t=43531 Contrary to the macro from the Spanish user forum, this one modifies the hard attribute CellBackColor and resets the same attribute back to the current style so your own formatting is not modified if you use styles (how could

Re: [libreoffice-users] calc sort

2012-01-07 Thread James
On 01/07/12 03:48, Johnny Rosenberg wrote: 2012/1/7 James bjloc...@lockie.ca: I made a simple sheet in calc that just contained 'Tue' and 'Wed'. Both cells are a date format but I tried to sort them and they won't change order. 3.5 I don't know about other people on this list, but I

[libreoffice-users] Impress Slide Sorter

2012-01-07 Thread Blake Hannaford
Does anyone know if there is progress in fixing the slide sorter bug(known issue) on Impress?   That's a pretty serious one. Blake -- Blake Hannaford                         Dept. of Electrical Engineering Voice:   1 206 543 2197                     University of Washington Fax:       1 206 221

Re: [libreoffice-users] calc sort

2012-01-07 Thread Jay Lozier
On 01/07/2012 12:32 PM, James wrote: On 01/07/12 03:48, Johnny Rosenberg wrote: 2012/1/7 Jamesbjloc...@lockie.ca: I made a simple sheet in calc that just contained 'Tue' and 'Wed'. Both cells are a date format but I tried to sort them and they won't change order. 3.5 I don't know about other

[libreoffice-users] Re: calc sort

2012-01-07 Thread Andreas Säger
Make sure that your list of text is in ToolsOptionsCalcSortLists DataSort... [Options] Custom order your list A defined database range (DataDefine...) will remember all the options for sorting and filtering. Number formatting applies to numbers. Mon is a text of 3 characters. You can display any

Re: [libreoffice-users] Calc - comments / macro

2012-01-07 Thread Cor Nouws
Hi Alex, alex sato wrote (07-01-12 13:27) I wish to know how to change the size of the box where the cells comments is displayed using macro. Is it possible? Probably. I have done some simple things with notes (comments). See some code lines below. oSheet =

Re: [libreoffice-users] Create Index with clickable links in Writer?

2012-01-07 Thread .
Thanks for help but it doesn't work.I followed these directions; Hyperlinking an entry To change the defaultStructureline so that the chapter number and the entry text form a hyperlink, follow these steps: * On theStructureline,

Re: [libreoffice-users] Create Index with clickable links in Writer?

2012-01-07 Thread .
Tom, Nuts. It didn't work. Truly, I think the problem is caused by my misunderstanding of levels. Yes, I understand that there are level numbers in a column that appear in the Entry tab. Levels and styles are something I've never understood. Oh well. Thanks anyway. On 01/07/2012 07:45

Re: [libreoffice-users] Create Index with clickable links in Writer?

2012-01-07 Thread .
Well, somehow I created a TOC with the underlined Entry names. Butwhenever I try to do the ctrl-click on the TOC entry nothing happens. Also, the TOC entry doesn't have the ctrl-click on the name of the TOC entry pop up that occurs with a functional link. Any ideas? On 01/07/2012 09:45 PM,

[libreoffice-users] Re: Create Index with clickable links in Writer?

2012-01-07 Thread Tom
Hi :) I think we are ready for Cley's answer now! I have only done this for a Table of Contents and i think the tags are a bit different. Cley says to change _E#_E_T_#_ to _E#_DH_E_FH_T_#_ but in the ToC the tags are LE instead of DH and LS instead of FH, i think. Also placing the tags only