Re: [libreoffice-users] New style from selection doesn't work

[Brian Barker]

At 18:22 15/11/2014 -0300, Alejo C.S. wrote:
I'm using LO 4.3 in debian amd64. I tried to make a new style from 
selection in writer, following the steps in help page. Every time 
the button is disable. I tried in new doc, opening older ones and 
always the button new style from selection is disable (grayed). Any tip?


There are five types of style: paragraph, character, frame, page, and 
list. Before you can create a new style using the New Style from 
Selection button in the Styles and Formatting window, you need to 
select what type of style you want to create - using the buttons at 
the left of the window's button bar. The only reason I know why the 
New Style from Selection button should be greyed out is that you have 
a style type selected which is inappropriate for the current 
selection or cursor position - e.g. if you have Frame Styles selected 
but no frame is selected in the document, or if you have Paragraph 
Styles selected but you have a frame (not its contents) selected in 
the document.


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: [Base] Can we connect a macro to a report?

[Andreas Säger]

Am 14.11.2014 um 23:58 schrieb Jean-Francois Nifenecker:
> Le 14/11/2014 21:22, Andreas Säger a écrit :
>>
>> It is possible to use Calc as reporting engine. Hit F4 and drag your
>> query onto a spreadsheet cell. When the database content changed, click
>> any cell in that import range and call menu:Data>Refresh.
>> The page layout is a bit tricky but with Calc's page preview you can
>> build amazing cell grid reports with sufficient formatting options,
>> calculations, conditional formattings, simple interactive filters, sort
>> orders and charts.
> 
> Thank Andreas, I know of that feature but I fail to see how, using Calc
> data range, I can impose (random) page breaks when the group column
> value changes.
> 

Having the group field in A, column labels in first row.
Remove all manual page breaks
Add a calculated field outside the print area.
X3: =$A3=$A4
Search and select all 0 results in column X.
Insert page breaks.
And yes, you can write a simple Calc macro and add it to this Calc
document or template.


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] New style from selection doesn't work

[Alejo C.S.]

Hi all, I'm using LO 4.3 in debian amd64. I tried to make a new style from
selection in writer, following the steps in help page. Every time the the
button is disable. I tried in new doc, opening older ones and always the
button new style from selection is disable (grayed). Any tip?

Thanks in advance.

C

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Writer, how to insert horizontal line

[Brian Barker]

At 11:45 15/11/2014 -0500, Alan Bonly wrote:
Method 2 [Select "Format|Paragraph", then the Borders tab, pick a 
top or bottom border, ...] suffers the same disadvantage if the 
border is specified as a bottom border. However if a top border is 
selected it is not applied to the following paragraphs.


It will be unless "Merge with next paragraph" is ticked.

Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Writer, how to insert horizontal line

[Luuk]

On 15-11-2014 17:45, Alan B wrote:

On Sat, Nov 15, 2014 at 10:57 AM, William Drago 
wrote:


I'm trying to insert a horizontal line into my LO document. The help says:

1. Click in the document where you want to insert the line.
2. Choose *Insert - Horizontal Rule*
Well, there's no Horizontal Rule under insert. So how is this done?



You're  right Bill. (At least insofar as LO 4.2 is concerned.)  Though it
works for AOO so seems this is a place where the two have diverged.

In any case to insert a horizontal rule I know of two methods...

1. Type three consecutive dashes "---" at the beginning of a line and press
enter.



this only works i delete the autocorrect of a '-', which replaces the 
'-' for a '─'


LO 4.3.4.1


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Writer, how to insert horizontal line

[Dan Lewis]

On 11/15/2014 10:57 AM, William Drago wrote:
I'm trying to insert a horizontal line into my LO document. The help 
says:


1. Click in the document where you want to insert the line.
2. Choose *Insert - Horizontal Rule*

see: https://help.libreoffice.org/Writer/Inserting_a_Horizontal_Line

Well, there's no Horizontal Rule under insert. So how is this done?

Thanks,
-Bill

  Try this:

1. Use the F11 key to open the Styles and Formation window.
2. At the bottom of this window, change "Automatic" to "All Styles."
3. Go down through the list of paragraph styles until you find 
"Horizontal line."

4. Place the cursor on the empty line where you want it to be.
5. Double click "Horizontal line" .

Dan

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Writer, how to insert horizontal line

[Alan B]

On Sat, Nov 15, 2014 at 10:57 AM, William Drago 
wrote:

> I'm trying to insert a horizontal line into my LO document. The help says:
>
> 1. Click in the document where you want to insert the line.
> 2. Choose *Insert - Horizontal Rule*
> Well, there's no Horizontal Rule under insert. So how is this done?
>

You're  right Bill. (At least insofar as LO 4.2 is concerned.)  Though it
works for AOO so seems this is a place where the two have diverged.

In any case to insert a horizontal rule I know of two methods...

1. Type three consecutive dashes "---" at the beginning of a line and press
enter.
2. Select "Format|Paragraph", then the Borders tab, pick a top or bottom
border, a line style width and color and click OK.

Method 1 has the disadvantage that every subsequent paragraph gets
underlined and so the format must be disabled on subsequent paragraphs.

Method 2 suffers the same disadvantage if the border is specified as a
bottom border. However if a top border is selected it is not applied to the
following paragraphs.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Writer, how to insert horizontal line

[Brian Barker]

At 10:57 15/11/2014 -0500, William Drago wrote:

I'm trying to insert a horizontal line into my LO document. The help says:

1. Click in the document where you want to insert the line.
2. Choose *Insert - Horizontal Rule*

see: https://help.libreoffice.org/Writer/Inserting_a_Horizontal_Line

Well, there's no Horizontal Rule under insert.


This seems to have been removed in version 4.0.0.3 (or earlier?).
See https://bugassistant.libreoffice.org/show_bug.cgi?id=60858 .


So how is this done?


Recommended workarounds:

o Apply a top or bottom border to an existing paragraph or to an 
empty paragraph inserted for the purpose. You can apply this on the 
Borders tab of either the paragraph or paragraph style dialogues.


o Go to View | Toolbars > | Drawing to switch on the Drawing toolbar 
(by default at the bottom of the window). Click the Line icon at the 
left of the new toolbar and drag a line where required. Hold down 
Shift as you release the mouse to achieve an exactly horizontal line. 
Right-click the line and go to Line... to adjust its properties.


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Using LO Writer to edit HTML

[Virgil Arrington]

On 11/15/2014 9:54 AM, Brian Barker wrote:

At 08:44 15/11/2014 -0500, Virgil Arrington wrote:
What is needed is a simple system where a writer can write and edit 
his content once, then press something like "F1" for print (PDF) 
output and "F2" for screen (HTML) output and get excellent and 
intended results with both.


And the way to achieve that, of course, is to move away from the 
WYSIWYG presentation that software is so fond of and towards an 
editing screen that shows instead the structure of the document.


Absolutely, Brian.

Unfortunately, there remain two different approaches to that concept.

For print output, nothing can beat LaTeX with a LyX frontend for easy 
text input.


For screen output, there's HTML/CSS with MarkDown as the editor frontend.

Each system approaches structure differently with LaTeX having such tags 
as \section{} and \textit{} and HTML having   and  with or # 
or *emph* shorthand in MarkDown.


Now, if someone could devise a unified structure shorthand notation for 
both excellent print and screen output so that a writer could write 
without having to decide ahead of time where his work will end up, i.e., 
in print or on screen.


Virgil


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] LO Writer, how to insert horizontal line

[William Drago]

I'm trying to insert a horizontal line into my LO document. 
The help says:


1. Click in the document where you want to insert the line.
2. Choose *Insert - Horizontal Rule*

see: 
https://help.libreoffice.org/Writer/Inserting_a_Horizontal_Line


Well, there's no Horizontal Rule under insert. So how is 
this done?


Thanks,
-Bill



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Using LO Writer to edit HTML

[Brian Barker]

At 08:44 15/11/2014 -0500, Virgil Arrington wrote:
What is needed is a simple system where a writer can write and edit 
his content once, then press something like "F1" for print (PDF) 
output and "F2" for screen (HTML) output and get excellent and 
intended results with both.


And the way to achieve that, of course, is to move away from the 
WYSIWYG presentation that software is so fond of and towards an 
editing screen that shows instead the structure of the document.


Brian Barker 



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Using LO Writer to edit HTML

[Virgil Arrington]

On 11/14/2014 9:55 PM, Tom Davies wrote:

It's interesting to see this thread has forked in 2 directions.  There are
these sorts of answers on how to write good, reliable code to be used
directly and the other fork is about how to make it look pretty for print.



Perhaps the two directions are a reflection of the divergent ways that 
writers now work. Back in the early days of personal computers, all 
writing was still directed at the printed page. But, with the web and, 
now e-books, writers must create content that looks proper on *both* 
paper and computer screen.


Problem is, few writing tools are good at both.

Word processors (and even LaTeX) are still designed primarily for 
creating documents for paper. When they are used to create HTML content, 
they load the file with all sorts of complex (and probably unnecessary) 
code.


MarkDown editors do a decent job of creating clean, simple HTML code for 
onscreen viewing, but their print output can be iffy, and there are so 
many MarkDown flavors that a document created by one editor doesn't 
parse well in another.


What is needed is a simple system where a writer can write and edit his 
content once, then press something like "F1" for print (PDF) output and 
"F2" for screen (HTML) output and get excellent and intended results 
with both. So, far, my own obsessive search has failed to find it.


Virgil

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Using LO Writer to edit HTML

[Tim---Kracked_P_P---webmaster]

Here is the list of languages that Bluefish's page states it has 
language definitions for.
Yes there are a lot, but it seems to me that this package is more than a 
HTML creation/modification page editor.


Ada
ASP .NET and VBS
C/C++
CSS
CFML
Clojure
D
gettext PO
Google Go
HTML, XHTML and HTML5
Java and JSP
JavaScript and jQuery
Lua
Octave/MATLAB
MediaWiki
NSIS
Pascal
Perl
PHP
Python
R
Ruby
Shell
Scheme
SQL
SVG
Vala
Wordpress
XML





On 11/14/2014 09:55 PM, Tom Davies wrote:

Hi :)
I think the coding is to be published in a book / manual / guide.  Perhaps
teaching people the basics or giving appropriate examples.

I think Ian was looking for some method to use coding in a document in much
the same way that Math is used to write equations for documents so that the
equation can be seen.  We have been trying to push him into using the
equivalent of Calc to give the correct answer when he's really looking for
something to show the equation in all it's intriguing beauty.

Bluefish is often recommended and i gather it's a bit like Dreamweaver in
having a wysiwyg alongside a coding window/pane.  I only had a brief go at
both those but they made me feel really uncomfortable.  Real world
web-browsers have their own quirks and i'm not sure how faithfully a
wysiwyg editor reproduces their errors.  So, i tend to have at least 1
web-browser open to see the real-world effect of code that i write (well,
mostly copy&paste & modify tbh) in a text-editor.


It's interesting to see this thread has forked in 2 directions.  There are
these sorts of answers on how to write good, reliable code to be used
directly and the other fork is about how to make it look pretty for print.

Regards from
Tom :)





On 15 November 2014 00:27, Tim---Kracked_P_P---webmaster <
webmas...@krackedpress.com> wrote:


I use to "hand code" everything and then check my work in a browser.  Now
with more complex pages, it can be very hard to keep one edited without
using a WYSIWYG editor.  Yes, I use text editors for some things, but there
are a lot of things that need the editing while viewing the page, and not
just the code.





On 11/14/2014 06:18 PM, Felmon Davis wrote:


On Fri, 14 Nov 2014, Tim---Kracked_P_P---webmaster wrote:



Yes, a text editor helps for some editing of an HTML file.  Yet, for
some work I need a WYSIWYG editor for the look and feel of the web document.

I use Kate [Ubuntu based Linux Mint] for the text editor.  I use it for
the Find/Replace option to change 91 links from [say] "4.3.3.2_" to
"4.3.4.1_".  That takes too much time in a WYSIWYG editor, or at least the
ones I have used.

Currently I use Kompozer, but when I upgrade from Mint 16 to 17 [14.04
based] and beyond, the graphical display methods do not like the upgraded
version that Ubuntu 14.04/14.10 now uses.  So I will be looking for a
different DEDICATED web page editor.

Yes, Writer can do the HTML editing, but I would prefer a WYSIWYG editor
that was created specifically for web page editing and hopefully with error
checking options.


I haven't followed the thread with great care so I may have overlooked a
reference to 'bluefish'. 

I haven't used it in quite a spell so this isn't a 'recommendation', just
a reference to a tool which might be of use.

it is not, I think, wysiwyg as such but it will open your browser for
inspection of results. (looking at the website it seems it may open your
page within bluefish but I'm skimming too fast to be sure.)

see what you think.

(apologies if this has already been considered.)

F.

  >



On 11/13/2014 07:29 AM, Virgil Arrington wrote:


On 11/13/2014 06:39 AM, Ian Whitfield wrote:


Hi Kolbjoern

Thanks for the reply.

The document already exists - so I'm selecting 'File Open', I change
the File Type to 'HTML Document (Writer)' and select my file. It then opens
in "view" mode - So how do I get to the code to edit it??



I just tried it again, and I think I see your problem. I did exactly as
you did, and the "HTML source" option did not appear on the View menu. I
think the problem is that, when opening the file, you are changing the File
Type to "HTML Document (Writer)." When you do that, all you get is a
WYSIWYG display along with no HTML source option. So, I tried it again, but
instead of changing the file type to "HTML Document (Writer)" I kept it at
"All types." Then when I opened an HTML file, I saw the source code instead
of the WYSIWYG display.

Not sure if this is intended behavior or a bug.

(All this said, I agree with Tom that I would use a regular text editor
to edit HTML code. Gedit works nicely on my Ubuntu machine.)

Virgil


  On 11/13/2014 01:18 PM, Kolbjørn Stuestøl wrote:

When saving your document, select "HTML Document (Writer) (.html)" in
the "File type:" drop down list in the Save dialog.
Kolbjoern


Den 13.11.2014 11:18, skreiv Ian Whi

Re: [libreoffice-users] Using LO Writer to edit HTML

[Tom Davies]

Hi :)
I think the coding is to be published in a book / manual / guide.  Perhaps
teaching people the basics or giving appropriate examples.

I think Ian was looking for some method to use coding in a document in much
the same way that Math is used to write equations for documents so that the
equation can be seen.  We have been trying to push him into using the
equivalent of Calc to give the correct answer when he's really looking for
something to show the equation in all it's intriguing beauty.

Bluefish is often recommended and i gather it's a bit like Dreamweaver in
having a wysiwyg alongside a coding window/pane.  I only had a brief go at
both those but they made me feel really uncomfortable.  Real world
web-browsers have their own quirks and i'm not sure how faithfully a
wysiwyg editor reproduces their errors.  So, i tend to have at least 1
web-browser open to see the real-world effect of code that i write (well,
mostly copy&paste & modify tbh) in a text-editor.


It's interesting to see this thread has forked in 2 directions.  There are
these sorts of answers on how to write good, reliable code to be used
directly and the other fork is about how to make it look pretty for print.

Regards from
Tom :)





On 15 November 2014 00:27, Tim---Kracked_P_P---webmaster <
webmas...@krackedpress.com> wrote:

>
> I use to "hand code" everything and then check my work in a browser.  Now
> with more complex pages, it can be very hard to keep one edited without
> using a WYSIWYG editor.  Yes, I use text editors for some things, but there
> are a lot of things that need the editing while viewing the page, and not
> just the code.
>
>
>
>
>
> On 11/14/2014 06:18 PM, Felmon Davis wrote:
>
>> On Fri, 14 Nov 2014, Tim---Kracked_P_P---webmaster wrote:
>>
>>
>>> Yes, a text editor helps for some editing of an HTML file.  Yet, for
>>> some work I need a WYSIWYG editor for the look and feel of the web document.
>>>
>>> I use Kate [Ubuntu based Linux Mint] for the text editor.  I use it for
>>> the Find/Replace option to change 91 links from [say] "4.3.3.2_" to
>>> "4.3.4.1_".  That takes too much time in a WYSIWYG editor, or at least the
>>> ones I have used.
>>>
>>> Currently I use Kompozer, but when I upgrade from Mint 16 to 17 [14.04
>>> based] and beyond, the graphical display methods do not like the upgraded
>>> version that Ubuntu 14.04/14.10 now uses.  So I will be looking for a
>>> different DEDICATED web page editor.
>>>
>>> Yes, Writer can do the HTML editing, but I would prefer a WYSIWYG editor
>>> that was created specifically for web page editing and hopefully with error
>>> checking options.
>>>
>>
>> I haven't followed the thread with great care so I may have overlooked a
>> reference to 'bluefish'. 
>>
>> I haven't used it in quite a spell so this isn't a 'recommendation', just
>> a reference to a tool which might be of use.
>>
>> it is not, I think, wysiwyg as such but it will open your browser for
>> inspection of results. (looking at the website it seems it may open your
>> page within bluefish but I'm skimming too fast to be sure.)
>>
>> see what you think.
>>
>> (apologies if this has already been considered.)
>>
>> F.
>>
>>  >
>>
>>>
>>>
>>> On 11/13/2014 07:29 AM, Virgil Arrington wrote:
>>>

 On 11/13/2014 06:39 AM, Ian Whitfield wrote:

> Hi Kolbjoern
>
> Thanks for the reply.
>
> The document already exists - so I'm selecting 'File Open', I change
> the File Type to 'HTML Document (Writer)' and select my file. It then 
> opens
> in "view" mode - So how do I get to the code to edit it??
>
>
 I just tried it again, and I think I see your problem. I did exactly as
 you did, and the "HTML source" option did not appear on the View menu. I
 think the problem is that, when opening the file, you are changing the File
 Type to "HTML Document (Writer)." When you do that, all you get is a
 WYSIWYG display along with no HTML source option. So, I tried it again, but
 instead of changing the file type to "HTML Document (Writer)" I kept it at
 "All types." Then when I opened an HTML file, I saw the source code instead
 of the WYSIWYG display.

 Not sure if this is intended behavior or a bug.

 (All this said, I agree with Tom that I would use a regular text editor
 to edit HTML code. Gedit works nicely on my Ubuntu machine.)

 Virgil


  On 11/13/2014 01:18 PM, Kolbjørn Stuestøl wrote:
>
>> When saving your document, select "HTML Document (Writer) (.html)" in
>> the "File type:" drop down list in the Save dialog.
>> Kolbjoern
>>
>>
>> Den 13.11.2014 11:18, skreiv Ian Whitfield:
>>
>>> Hi All
>>>
>>> Can I get some help on this please??
>>>
>>> I have read about, and looked-up, the possibility of editing HTML
>>> documents in Writer but can not get it to work!!
>>> No matter what I do I can