[libreoffice-users] Re: A feature, or ...?

2013-11-28 Thread pbw
Here's an earlier post from Pablo Dotro:

On 11/07/13 07:50, Virgil Arrington wrote: 
 Once you apply your style, you can clear any direct formatting by 
 selecting the text and hitting Ctrl-M. Everything should then snap 
 to the style-controlled formatting. 
 
 Virgil 
I've seen a case when this not always work. If you apply some direct 
formatting (i.e. bold something by hand), then apply some charactery 
style, then a paragraph style (with the format you really wanted in the 
first place)... what you get is a mix of applied formatting that almost 
never corresponds to the style you wanted. If you clear the direct 
formatting there, it does not reset completely. You have to also remove 
the applied character style to get the text to respond completely to the 
paragraph style. 
It's annoying, but It could be considered a feature, not a bug ;-) 
Cheers, 

-- 
Pablo M. Dotro 


That's the case I'm talking about. I've struck it as well. I suspect it
might be tied up with list style interactions, but I can't be sure. I
certainly ran into it in an imported .doc converted to .odt. (Not a very
complex document, with few styles and lots of hand formatting, spaces and
newlines.)

There is, in fact, another 'clear formatting' option.

If you open the style list pull-down, and scroll t the very top, there is a
Clear formatting option, which behaves very differently from the Clear
direct formatting ^M option. It does seem to perform a pretty radical
paragraph formatting reset. However, as I no longer have access to the
intermediate forms of the file I was working on, I can't test to see whether
it solves the problem.




--
View this message in context: 
http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085369.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: A feature, or ...?

2013-11-28 Thread Tom Davies
Hi :)
For my company's newsletter i sometimes copypaste into a text-editor
and then re-select and copypaste from there.

Fairly recently i found i could use
Shift Ctrl v
and go to the bottom of the pop-up box that gives me to Paste as
unformatted text and that usually strips away all strange formatting.
 The only thing it doesn't get rid of is when people press Enter or
Return at the end of each line.  I guess going back to the
text-editor method might be an easier way of doing that.  In the GEdit
text-editor i would search for
\n

Even though it removes the odd 1 or 2 bits of formatting that you do
want to keep i tend to find it more efficient to just get rid of the
whole lot and then reapply styles (such as Heading 3) and then maybe
open the styles pop-up to edit that style.

I used to pick little bitsbobs to unformat or chunks or maybe whole
paragraphs but it involves much more faffing around than so doing the
whole lot in one go and then sorting the headings and stuff.  It might
take a little while before you find the best work-flow for you.

Regards from
Tom :)




On 28 November 2013 13:25, pbw li...@pbw.id.au wrote:
 Here's an earlier post from Pablo Dotro:
 
 On 11/07/13 07:50, Virgil Arrington wrote:
 Once you apply your style, you can clear any direct formatting by
 selecting the text and hitting Ctrl-M. Everything should then snap
 to the style-controlled formatting.

 Virgil
 I've seen a case when this not always work. If you apply some direct
 formatting (i.e. bold something by hand), then apply some charactery
 style, then a paragraph style (with the format you really wanted in the
 first place)... what you get is a mix of applied formatting that almost
 never corresponds to the style you wanted. If you clear the direct
 formatting there, it does not reset completely. You have to also remove
 the applied character style to get the text to respond completely to the
 paragraph style.
 It's annoying, but It could be considered a feature, not a bug ;-)
 Cheers,

 --
 Pablo M. Dotro
 

 That's the case I'm talking about. I've struck it as well. I suspect it
 might be tied up with list style interactions, but I can't be sure. I
 certainly ran into it in an imported .doc converted to .odt. (Not a very
 complex document, with few styles and lots of hand formatting, spaces and
 newlines.)

 There is, in fact, another 'clear formatting' option.

 If you open the style list pull-down, and scroll t the very top, there is a
 Clear formatting option, which behaves very differently from the Clear
 direct formatting ^M option. It does seem to perform a pretty radical
 paragraph formatting reset. However, as I no longer have access to the
 intermediate forms of the file I was working on, I can't test to see whether
 it solves the problem.




 --
 View this message in context: 
 http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085369.html
 Sent from the Users mailing list archive at Nabble.com.

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


-- 
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] Re: A feature, or ...?

2013-11-28 Thread Brian Barker

At 05:25 28/11/2013 -0800, Peter West wrote:

Here's an earlier post from Pablo Dotro:
If you apply some direct formatting (i.e. bold something by hand), 
then apply some charactery style, then a paragraph style (with the 
format you really wanted in the first place)... what you get is a 
mix of applied formatting that almost never corresponds to the 
style you wanted. If you clear the direct formatting there, it does 
not reset completely. You have to also remove the applied character 
style to get the text to respond completely to the paragraph style.

It's annoying, but It could be considered a feature, not a bug ;-)


That's the case I'm talking about. I've struck it as well. I suspect 
it might be tied up with list style interactions, but I can't be 
sure. I certainly ran into it in an imported .doc converted to .odt. 
(Not a very complex document, with few styles and lots of hand 
formatting, spaces and newlines.)


There is, in fact, another 'clear formatting' option. If you open 
the style list pull-down, and scroll to the very top, there is a 
Clear formatting option, which behaves very differently from the 
Clear direct formatting ^M option. It does seem to perform a 
pretty radical paragraph formatting reset. However, as I no longer 
have access to the intermediate forms of the file I was working on, 
I can't test to see whether it solves the problem.


I still don't understand why you consider any of this a 
difficulty.  If you have a mixture of direct formatting along with 
character and paragraph styles, you may well wish to remove some 
parts of it, but not all.  So it's useful to have more than one 
facility.  Surely you would expect to need to remove the different 
parts of applied formatting separately - and delight that you were 
able to do so selectively.


As far as I can see:

o Format | Default Formatting removes both direct formatting (to 
characters or paragraphs) and formatting by character styles.


o The Apply Style drop-down applies paragraph styles, so you'd expect 
Clear formatting there to reset the paragraph style to Default - 
and it does.  But it also does the same as Format | Default Formatting as well.


I suspect that at least part of the problem here is that it is 
sometimes difficult to see - especially with an inherited document - 
exactly how formatting has been applied and consequently how it might 
be removed.


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] Re: A feature, or ...?

2013-11-28 Thread Brian Barker

At 15:34 28/11/2013 +, Tom Davies wrote:
The only thing it doesn't get rid of is when people press Enter or 
Return at the end of each line.


There is a workaround for that, too: select the text and go to Format 
| AutoCorrect  | Apply.  Amongst other reformatting, this combines 
single line paragraphs if their length is sufficient.  Since it makes 
other changes, you may wish to do this before performing other 
editing.  Alternatively, you can use Format | AutoCorrect  | Apply 
and Edit Changes, which makes the same changes but allows you to 
accept them or reject them.  You could accept all the Combine 
paragraphs changes (sort by Comment and select multiple actions to 
make this easier) and reject all the rest.  This technique also 
applies Text Body paragraph style, but it is a simple task to change 
this afterwards if required.


For this technique to work, you need to have ticked Tools | 
AutoCorrect Options... | Options | Combine single line paragraphs if 
length greater than nn%.  You may need to modify the percentage - 
which you can do by selecting the option and clicking the Edit... button.


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] Re: A feature, or ...?

2013-11-28 Thread A


On 11/28/2013 10:44 AM, Brian Barker wrote:


As far as I can see:

o Format | Default Formatting removes both direct formatting (to 
characters or paragraphs) and formatting by character styles.
o The Apply Style drop-down applies paragraph styles, so you'd expect 
Clear formatting there to reset the paragraph style to Default - and 
it does.  But it also does the same as Format | Default Formatting as 
well.


For me at least, there's just too much to remember.  (You're in a maze 
of twisty little passages.  You're in a twisty maze of little passages.  
Now you're in a twisty little passage with a maze.)  It's enough to make 
me lose my mind.  I can't keep track of all these various intracacies.  
It sure would be nice to have some tool tips.


Also, if Apply Style applies paragraph styles and only paragraph 
styles, why not have it say Apply Paragraph Style so as to make it 
obvious and avoid the obscurity.


Default Formatting could either have a tool tip, or perhaps broken up 
into separate functions that do one thing each.

i.e. 1) Remove formatting to characters.
2) Remove formatting to paragraphs.
3) Remove formatting by character styles.

That would provide more control.  I don't know if there's an advantage 
to it - other than knowing precisely what function is being performed.


In addition, I do NOT expect Clear formatting to reset the paragraph 
style to default.  I expect it to do 1,2,3 above.  i.e. Clear the 
formatting just as it implies.  I would expect Reset Paragraph Style to 
Default to reset the paragraph style to default.  There's far too much 
guesswork and intimate knowledge required here.  It's all quite 
NON-obvious.  Sure, if one works with it all the time one can learn 
these things - but I shouldn't have to be an expert - it should be 
intuitive and if it's not intuitive it should be spelled out in a tool tip.


I suspect that at least part of the problem here is that it is 
sometimes difficult to see - especially with an inherited document - 
exactly how formatting has been applied and consequently how it might 
be removed.


Oh yes and that hits the nail on the head.  Now that the problem has 
been defined, the solution becomes easy.  Provide a way to SEE exactly 
how the formatting has been applied - and a quick link shortcut to 
removing it!  Formatting/styles are - in my mind - similar to field 
codes.  They're hidden formulas and such that could be turned on and off 
for viewing at will.


Just my opinions of course.


--
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: A feature, or ...?

2013-11-28 Thread Peter West
 Oh yes and that hits the nail on the head.  Now that the problem has 
 been defined, the solution becomes easy.  Provide a way to SEE exactly 
 how the formatting has been applied - and a quick link shortcut to 
 removing it!  Formatting/styles are - in my mind - similar to field 
 codes.  They're hidden formulas and such that could be turned on and off 
 for viewing at will. 
 

That would be very useful.

Peter West

...he saw a poor widow put in two copper coins.

On 29 Nov 2013, at 7:00 am, A [via Document Foundation Mail Archive] 
ml-node+s969070n4085467...@n3.nabble.com wrote:

 
 On 11/28/2013 10:44 AM, Brian Barker wrote:
 
  
  As far as I can see: 
  
  o Format | Default Formatting removes both direct formatting (to 
  characters or paragraphs) and formatting by character styles. 
  o The Apply Style drop-down applies paragraph styles, so you'd expect 
  Clear formatting there to reset the paragraph style to Default - and 
  it does.  But it also does the same as Format | Default Formatting as 
  well. 
 
 For me at least, there's just too much to remember.  (You're in a maze 
 of twisty little passages.  You're in a twisty maze of little passages.   
 Now you're in a twisty little passage with a maze.)  It's enough to make 
 me lose my mind.  I can't keep track of all these various intracacies.   
 It sure would be nice to have some tool tips. 
 
 Also, if Apply Style applies paragraph styles and only paragraph 
 styles, why not have it say Apply Paragraph Style so as to make it 
 obvious and avoid the obscurity. 
 
 Default Formatting could either have a tool tip, or perhaps broken up 
 into separate functions that do one thing each. 
 i.e. 1) Remove formatting to characters. 
 2) Remove formatting to paragraphs. 
 3) Remove formatting by character styles. 
 
 That would provide more control.  I don't know if there's an advantage 
 to it - other than knowing precisely what function is being performed. 
 
 In addition, I do NOT expect Clear formatting to reset the paragraph 
 style to default.  I expect it to do 1,2,3 above.  i.e. Clear the 
 formatting just as it implies.  I would expect Reset Paragraph Style to 
 Default to reset the paragraph style to default.  There's far too much 
 guesswork and intimate knowledge required here.  It's all quite 
 NON-obvious.  Sure, if one works with it all the time one can learn 
 these things - but I shouldn't have to be an expert - it should be 
 intuitive and if it's not intuitive it should be spelled out in a tool tip. 
 
  I suspect that at least part of the problem here is that it is 
  sometimes difficult to see - especially with an inherited document - 
  exactly how formatting has been applied and consequently how it might 
  be removed. 
  
 Oh yes and that hits the nail on the head.  Now that the problem has 
 been defined, the solution becomes easy.  Provide a way to SEE exactly 
 how the formatting has been applied - and a quick link shortcut to 
 removing it!  Formatting/styles are - in my mind - similar to field 
 codes.  They're hidden formulas and such that could be turned on and off 
 for viewing at will. 
 
 Just my opinions of course. 
 
 
 -- 
 To unsubscribe e-mail to: [hidden email] 
 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 
 
 
 
 If you reply to this email, your message will be added to the discussion 
 below:
 http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085467.html
 To unsubscribe from A feature, or ...?, click here.
 NAML


-- 
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] Re: A feature, or ...?

2013-11-28 Thread Tom Davies
Hi :)
It's amazing that people have to learn how to drive and pass a test.
There are so few controls.  Usually a wheel or handle-bar or joystick
to make the vehicle turn.  Something to make it faster or slower.
Maybe something to make it go up or down.

So at most it's about 3 controls right?

Surely that should be even more intuitive or at least easier to spot
which control does what.  So why all the lessons?  It's crazy right?
Regards from
Tom :)




On 28 November 2013 20:59, A publicf...@bak.rr.com wrote:

 On 11/28/2013 10:44 AM, Brian Barker wrote:


 As far as I can see:

 o Format | Default Formatting removes both direct formatting (to
 characters or paragraphs) and formatting by character styles.
 o The Apply Style drop-down applies paragraph styles, so you'd expect
 Clear formatting there to reset the paragraph style to Default - and it
 does.  But it also does the same as Format | Default Formatting as well.

 For me at least, there's just too much to remember.  (You're in a maze of
 twisty little passages.  You're in a twisty maze of little passages.  Now
 you're in a twisty little passage with a maze.)  It's enough to make me lose
 my mind.  I can't keep track of all these various intracacies.  It sure
 would be nice to have some tool tips.

 Also, if Apply Style applies paragraph styles and only paragraph styles,
 why not have it say Apply Paragraph Style so as to make it obvious and
 avoid the obscurity.

 Default Formatting could either have a tool tip, or perhaps broken up into
 separate functions that do one thing each.
 i.e. 1) Remove formatting to characters.
 2) Remove formatting to paragraphs.
 3) Remove formatting by character styles.

 That would provide more control.  I don't know if there's an advantage to it
 - other than knowing precisely what function is being performed.

 In addition, I do NOT expect Clear formatting to reset the paragraph style
 to default.  I expect it to do 1,2,3 above.  i.e. Clear the formatting just
 as it implies.  I would expect Reset Paragraph Style to Default to reset
 the paragraph style to default.  There's far too much guesswork and intimate
 knowledge required here.  It's all quite NON-obvious.  Sure, if one works
 with it all the time one can learn these things - but I shouldn't have to be
 an expert - it should be intuitive and if it's not intuitive it should be
 spelled out in a tool tip.


 I suspect that at least part of the problem here is that it is sometimes
 difficult to see - especially with an inherited document - exactly how
 formatting has been applied and consequently how it might be removed.

 Oh yes and that hits the nail on the head.  Now that the problem has been
 defined, the solution becomes easy.  Provide a way to SEE exactly how the
 formatting has been applied - and a quick link shortcut to removing it!
 Formatting/styles are - in my mind - similar to field codes.  They're hidden
 formulas and such that could be turned on and off for viewing at will.

 Just my opinions of course.



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


-- 
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: A feature, or ...?

2013-11-27 Thread pbw
It's a bug, or, if you prefer, a missing vital feature.

The problem:

If you have a document filled with paragraph formatting which has been
applied directly using a paragraph style menu, any styles you define and
apply as a style will be overridden by the direct formatting previously
applied.  There is no way that I have found to remove it, except by a manual
change using the paragraph style menu.  That fixes my problem, but passes
the same problem on to the next person who wants to change the paragraph
styling.

I have just had to do this.  The document was an imported Word .doc, but the
principle seems to apply everywhere.

How to fix it:
Add Format menu items Clear all paragraph/character(/list?) formatting. It
doesn't actually remove all formatting, but applies a default format which
clear all the problem formats and allows a style to be cleanly applied.

List formatting is such a delicate matter that I don't know whether a clear
all list formatting operation would cause more trouble than it's worth.





--
View this message in context: 
http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085301.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: A feature, or ...?

2013-11-27 Thread A
Would Select All (CTRL-A), Menu-Format-Clear Direct Formatting 
(CTRL-M) not work for you?


On 11/27/2013 05:45 PM, pbw wrote:

It's a bug, or, if you prefer, a missing vital feature.

The problem:

If you have a document filled with paragraph formatting which has been
applied directly using a paragraph style menu, any styles you define and
apply as a style will be overridden by the direct formatting previously
applied.  There is no way that I have found to remove it, except by a manual
change using the paragraph style menu.  That fixes my problem, but passes
the same problem on to the next person who wants to change the paragraph
styling.

I have just had to do this.  The document was an imported Word .doc, but the
principle seems to apply everywhere.

How to fix it:
Add Format menu items Clear all paragraph/character(/list?) formatting. It
doesn't actually remove all formatting, but applies a default format which
clear all the problem formats and allows a style to be cleanly applied.

List formatting is such a delicate matter that I don't know whether a clear
all list formatting operation would cause more trouble than it's worth.





--
View this message in context: 
http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085301.html
Sent from the Users mailing list archive at Nabble.com.




--
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: A feature, or ...?

2013-11-27 Thread pbw
I don't know, because there were elements whose particular formatting I needed. 
But I know that that sequence on individual paragraphs does not work, for the 
reasons explained by others in earlier posts in this discussion.

Peter West

...he saw a poor widow put in two copper coins.

On 28 Nov 2013, at 2:07 pm, A [via Document Foundation Mail Archive] 
ml-node+s969070n4085305...@n3.nabble.com wrote:

 Would Select All (CTRL-A), Menu-Format-Clear Direct Formatting 
 (CTRL-M) not work for you? 
 
 On 11/27/2013 05:45 PM, pbw wrote:
 
  It's a bug, or, if you prefer, a missing vital feature. 
  
  The problem: 
  
  If you have a document filled with paragraph formatting which has been 
  applied directly using a paragraph style menu, any styles you define and 
  apply as a style will be overridden by the direct formatting previously 
  applied.  There is no way that I have found to remove it, except by a 
  manual 
  change using the paragraph style menu.  That fixes my problem, but passes 
  the same problem on to the next person who wants to change the paragraph 
  styling. 
  
  I have just had to do this.  The document was an imported Word .doc, but 
  the 
  principle seems to apply everywhere. 
  
  How to fix it: 
  Add Format menu items Clear all paragraph/character(/list?) formatting. 
  It 
  doesn't actually remove all formatting, but applies a default format which 
  clear all the problem formats and allows a style to be cleanly applied. 
  
  List formatting is such a delicate matter that I don't know whether a clear 
  all list formatting operation would cause more trouble than it's worth. 
  
  
  
  
  
  -- 
  View this message in context: 
  http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085301.html
  Sent from the Users mailing list archive at Nabble.com. 
 
 
 
 -- 
 To unsubscribe e-mail to: [hidden email] 
 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 
 
 
 
 If you reply to this email, your message will be added to the discussion 
 below:
 http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085305.html
 To unsubscribe from A feature, or ...?, click here.
 NAML





--
View this message in context: 
http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085306.html
Sent from the Users mailing list archive at Nabble.com.
-- 
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] Re: A feature, or ...?

2013-11-27 Thread A

Interesting... yours is the only post I've seen so far.


On 11/27/2013 08:29 PM, pbw wrote:

I don't know, because there were elements whose particular formatting I needed. 
But I know that that sequence on individual paragraphs does not work, for the 
reasons explained by others in earlier posts in this discussion.

Peter West

...he saw a poor widow put in two copper coins.

On 28 Nov 2013, at 2:07 pm, A [via Document Foundation Mail Archive] 
ml-node+s969070n4085305...@n3.nabble.com wrote:


Would Select All (CTRL-A), Menu-Format-Clear Direct Formatting
(CTRL-M) not work for you?

On 11/27/2013 05:45 PM, pbw wrote:


It's a bug, or, if you prefer, a missing vital feature.

The problem:

If you have a document filled with paragraph formatting which has been
applied directly using a paragraph style menu, any styles you define and
apply as a style will be overridden by the direct formatting previously
applied.  There is no way that I have found to remove it, except by a manual
change using the paragraph style menu.  That fixes my problem, but passes
the same problem on to the next person who wants to change the paragraph
styling.

I have just had to do this.  The document was an imported Word .doc, but the
principle seems to apply everywhere.

How to fix it:
Add Format menu items Clear all paragraph/character(/list?) formatting. It
doesn't actually remove all formatting, but applies a default format which
clear all the problem formats and allows a style to be cleanly applied.

List formatting is such a delicate matter that I don't know whether a clear
all list formatting operation would cause more trouble than it's worth.





--
View this message in context: 
http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085301.html
Sent from the Users mailing list archive at Nabble.com.



--
To unsubscribe e-mail to: [hidden email]
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



If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085305.html
To unsubscribe from A feature, or ...?, click here.
NAML





--
View this message in context: 
http://nabble.documentfoundation.org/A-feature-or-tp4064910p4085306.html
Sent from the Users mailing list archive at Nabble.com.



--
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] Re: A feature, or ...?

2013-11-27 Thread Brian Barker

At 17:45 27/11/2013 -0800, Peter West wrote:

It's a bug, or, if you prefer, a missing vital feature.


It's a feature - and I don't think it's missing, in fact.

The problem: If you have a document filled with paragraph formatting 
which has been applied directly using a paragraph style menu, any 
styles you define and apply as a style will be overridden by the 
direct formatting previously applied.  There is no way that I have 
found to remove it, except by a manual change using the paragraph 
style menu.  That fixes my problem, but passes the same problem on 
to the next person who wants to change the paragraph styling.


I fear that paragraph is somewhat confused.  There is direct 
character formatting, character style formatting, paragraph 
formatting, and paragraph style formatting - all different.  To 
confuse things further, you can apply character formatting or 
character style formatting to an entire paragraph.  If you really do 
solve your problem using a new paragraph style (and I'm not clear why 
you would call this a manual change), I think you have left your 
document in an ideal state for later modification by yourself or others.


How to fix it: Add Format menu items Clear all 
paragraph/character(/list?) formatting. It doesn't actually remove 
all formatting, but applies a default format which clear all the 
problem formats and allows a style to be cleanly applied.


You don't need to clear any style formatting, as any modifications to 
these styles or replacements by other styles will simply supersede 
existing effects.  What can be a problem is any local (direct) 
character formatting which may have been applied - perhaps even 
(confusingly) to complete paragraphs.  (This is the way that a 
beginner will format his or her documents.)  But no-one needs to add 
any menu items: what you need is already there, at Format | Default 
Formatting (or right-click | Default Formatting or Ctrl+M).  If you 
invoke this and then apply your new styles, everything should be hunky-dory.


List formatting is such a delicate matter that I don't know whether 
a clear all list formatting operation would cause more trouble than it's worth.


Any proper list formatting (applied using styles) should survive the 
application of Default Formatting, which is what you would want.


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: Math feature request

2011-11-02 Thread daddo

eskroni wrote:
 
 I think, what you are asking for is way outside the scope of an
 office suite. 
 
 You might want to look at computer algebra systems, like Maple or
 Maxima. You can get some more information here:
 http://en.wikipedia.org/wiki/Maxima_(software)
 
 Sigrid
 


 I did not ask for calculation with values (numbers). I asked an easy to way
insert the same formula (a=bc and b=a/c are the same...) again and again. If
i want to write a book, i use LaTex, if i want to solve exercises, i can use
Maple or Maxima you suggested, but i need only an easy way to insert
formulas to text documents to show, *how* i solved an exercise.



--
View this message in context: 
http://nabble.documentfoundation.org/Math-feature-request-tp3472100p3474354.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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: strikethrough feature

2011-08-27 Thread Twayne
In news:cado7t4fptxqvhz5bnkswhgdgapffcznrro43phwsb1bs52h...@mail.gmail.com,
Johnny Rosenberg gurus.knu...@gmail.com typed:
 2011/8/25 Maria Rechnitzer rrrah...@gmail.com:
 Dear Support,

 This is the LibreOffice users' list. It's not a real
 support. We are
 just users who help each other out. You can ask questions
 and you can
 reply to other people's question if you like.

I'm well aware of maling lists, forums and newsgroups etc.. I use NNTP 
instead of the mailing list for what are normally obvious reasons to most, 
not the least of which is not getting a mass of unrelated to anything I care 
about from a mailing list. A mailing list can be great for a newbie just 
trying to pull as much info as they can about as many subjects as they can, 
but you can't beat NNTP for its conciseness and ablity to easly pick 
responsed to a post almost instantly. Mailinig lists can quickly become 
irritating. Add to that the management capabilities and no gui waste as with 
forums, and you have what I still consder the best listing tool around. As 
long as the list vs newsgroup processes to work, it's the best of all worlds 
due to the many displays possible in a group reader.

 If you plan to write here again, you should subscribe to
 the list.

That's fine for you, but realize that what you like isn't necessarly 
anyonre/everyone else's cup of tea.
 Then you will get all the replies to your questions
 directly in your
 inbox, also from those who didn't added your email
 address in the
 bTo:b field manually, like I just didb You will also
 get other peoples questions, but that is how email lists
 work. Some people, who are
 subscribed to many email lists, like myself, have a
 special email
 account for email lists only. That's probably not
 necessary in most
 cases, I just mentioned it as a tipb

No, not for me. I have more to do than scan mailing lists looking for my 
post responses when I can have them pointed out to me automatically and all 
grouped together. When I have a question, I DO NOT CARE to see other 
answers; I might if  I were a newbie and had lots of time avalable, but I 
don't.

This is only my opinion, but some of the advice you gave leaves a little to 
be desired.


 when word processing in microsoft office (doc or xls)
 there is a strikethrough feature that allows you to mark
 words that you want to delete but stIll keep them in the
 text, e.g. strikethrough.
 I was not able to find this feature in Libre Office
 (also not in former Open Office). Is there such a
 feature? If not I suggest to add it next to the bold,
 italic and underline feature.

 You can do that yourself. Here is how:

As  I said in my prevous posting, you can underline, overline, 
strike-thru,double-strike-thru, use colors with them and so on in Writer at 
the program's location I  gave.

Also note how clunky your post looks below because I only read posts in 
Plain Text and nothing else. I respectfully advise that you should post and 
e-mail also in Plain Text unless there is some compelling reason not to. 
It's even a good idea to have anything that's 8-bit dropped to the floor 
just to prevent any type of unintended code execution in the body of an 
e-mail.
   With Plain Text, you don't get the Unicode or Mime problems that go along 
with 8-bit e-mails.

HTH,

Twayne`



 Tools b Customizeb b Toolbars.
 LibreOffice Writer Toolbars b Toolbar: Select
 bFormattingb
 In the bCommandsb list, scroll down to bUnderlineb
 and highlight it. Click the bAddbb button.
 In the bCategoryb list of the bAdd Commandsb
 dialogue, select bFormatb. In the bCommandsb list of
 the bAdd Commandsb dialogue, scroll down and select
 bStrikethroughb (they are listed in alphabetic order,
 so it's
 easy to find).
 Click the Add button b the bAdd Commandsb dialogue is
 closed.
 In the Customize dialogue, bStrikethroughb is now
 available and
 checked (b). You can move it up and down with the b,
 and b, buttons at the right of the bCommandsb list if
 it's not in the brightb place.
 Click OK.
 You now have a strike through button available in your
 Formatting toolbar.

 In the Customize dialogue you can also customise your
 menues and
 keyboard shortcuts, and you can assign macros to
 different events,
 such as Open Document, Save Document and more.


 Kind regards

 Johnny Rosenberg
 c8c'c cc;c-ccc3ccc0


 THANKS FOR PROVIDING THIS SEVICE!

 I kindly ask you to let me know if the strikethrough
 feature exists in Libre Office.

 Yes it does, and in quite a few places.

 Best regards,
 Maria





-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: strikethrough feature

2011-08-27 Thread Johnny Rosenberg
2011/8/27 NoOp gl...@sbcglobal.net:
 On 08/26/2011 04:03 PM, Johnny Rosenberg wrote:
 ...
 You can do that yourself. Here is how:

 Tools → Customize… → Toolbars.
 LibreOffice Writer Toolbars – Toolbar: Select ”Formatting”
 In the ”Commands” list, scroll down to ”Underline” and highlight it.
 Click the ”Add…” button.
 In the ”Category” list of the ”Add Commands” dialogue, select ”Format”.
 In the ”Commands” list of the ”Add Commands” dialogue, scroll down and
 select ”Strikethrough” (they are listed in alphabetic order, so it's
 easy to find).
 Click the Add button → the ”Add Commands” dialogue is closed.
 In the Customize dialogue, ”Strikethrough” is now available and
 checked (☒). You can move it up and down with the ⬆ and ⬇ buttons at
 the right of the ”Commands” list if it's not in the ”right” place.
 Click OK.
 You now have a strike through button available in your Formatting toolbar.

 In the Customize dialogue you can also customise your menues and
 keyboard shortcuts, and you can assign macros to different events,
 such as Open Document, Save Document and more.
 ...

 Johnny, your replicating Brian Barker's already clear instructions on
 how to do exactly that.

Yes I did, sorry. Somehow I missed Brian's post, don't know why.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


 quote
 You can do this yourself:
 o  Click the down-arrow at the right end of the Formatting toolbar
 and select Customize toolbar... | Toolbars.
 o  Under Toolbar Content, click Add... .
 o  Under Category select Format, under Commands select Strikethrough,
 and click Add and Close.
 o  Click the up and down arrows to move your new button to where you
 want it - apparently below Underline.
 o  Click OK.

 I trust this helps.

 Brian Barker
 /quote



 --
 For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: strikethrough feature

2011-08-27 Thread Johnny Rosenberg
2011/8/27 Twayne twa...@twaynesdomain.com:
 In news:cado7t4fptxqvhz5bnkswhgdgapffcznrro43phwsb1bs52h...@mail.gmail.com,
 Johnny Rosenberg gurus.knu...@gmail.com typed:
 2011/8/25 Maria Rechnitzer rrrah...@gmail.com:
 Dear Support,

 This is the LibreOffice users' list. It's not a real
 support. We are
 just users who help each other out. You can ask questions
 and you can
 reply to other people's question if you like.

 I'm well aware of maling lists, forums and newsgroups etc.. I use NNTP
 instead of the mailing list for what are normally obvious reasons to most,
 not the least of which is not getting a mass of unrelated to anything I care
 about from a mailing list. A mailing list can be great for a newbie just
 trying to pull as much info as they can about as many subjects as they can,
 but you can't beat NNTP for its conciseness and ablity to easly pick
 responsed to a post almost instantly. Mailinig lists can quickly become
 irritating. Add to that the management capabilities and no gui waste as with
 forums, and you have what I still consder the best listing tool around. As
 long as the list vs newsgroup processes to work, it's the best of all worlds
 due to the many displays possible in a group reader.

Well, I don't think my comment was meant for you, but maybe I totally
misunderstand what you are saying here (English is of course not my
native language, that's why it look very strange sometimes).


 If you plan to write here again, you should subscribe to
 the list.

 That's fine for you, but realize that what you like isn't necessarly
 anyonre/everyone else's cup of tea.

I guess I should have written ”could” instead of ”should” or
something, I don't know.
Anyway, I have always said that if someone is not subscribed it's not
my problem that he or she doesn't receive my replies. People didn't
like that kind of attitude, so now I changed that; I even added that
address to the ”To:” field, to make sure that my reply would reach the
right person.
I guess I now need to find a third way of doing it, but I'm not sure
what's left. Well, I know one thing: Not replying at all. That's quick
and easy and doesn't annoy anyone. I think I'll go with that until I
find something better. Thanks for your advice.

 Then you will get all the replies to your questions
 directly in your
 inbox, also from those who didn't added your email
 address in the
 b To:b  field manually, like I just didb You will also
 get other peoples questions, but that is how email lists
 work. Some people, who are
 subscribed to many email lists, like myself, have a
 special email
 account for email lists only. That's probably not
 necessary in most
 cases, I just mentioned it as a tipb

 No, not for me. I have more to do than scan mailing lists looking for my
 post responses when I can have them pointed out to me automatically and all
 grouped together. When I have a question, I DO NOT CARE to see other
 answers; I might if  I were a newbie and had lots of time avalable, but I
 don't.
 This is only my opinion, but some of the advice you gave leaves a little to
 be desired.

I'm not even sure it's right to call it advice. I just throw my crap
at the nearest place, obviously.


 when word processing in microsoft office (doc or xls)
 there is a strikethrough feature that allows you to mark
 words that you want to delete but stIll keep them in the
 text, e.g. strikethrough.
 I was not able to find this feature in Libre Office
 (also not in former Open Office). Is there such a
 feature? If not I suggest to add it next to the bold,
 italic and underline feature.

 You can do that yourself. Here is how:

 As  I said in my prevous posting, you can underline, overline,
 strike-thru,double-strike-thru, use colors with them and so on in Writer at
 the program's location I  gave.

 Also note how clunky your post looks below because I only read posts in
 Plain Text and nothing else. I respectfully advise that you should post and
 e-mail also in Plain Text unless there is some compelling reason not to.
 It's even a good idea to have anything that's 8-bit dropped to the floor
 just to prevent any type of unintended code execution in the body of an
 e-mail.

I guess I totally misunderstood what's ”plain text”. I thought it was
the same as ”not formatted” text. Only enter text, not formatted in
any way. Everything I type is plain UTF-8 text, which is 8 bits in the
most common cases, but a lot of characters requires two or even three
bytes. Are you really suggesting to use 7-bit text? In that case you
can only write in English, so what about when I write to the
LibreOffice mailing list in my language? Three of our letters in our
alphabet doesn't exist in 7-bit text, and they are VERY commonly used
in my language. And with 7 bits none of the eastern Asian countries,
like China, Japan and more, could write to a mailing list. For me it
is UTF-8 or nothing, so I guess I just have to unsubscribe to all
mailing lists then. Well, I could do that. It might 

[libreoffice-users] Re: strikethrough feature

2011-08-26 Thread Twayne
In news:caff6mpdc8kjigozyktqtbxhqwgv4x9fyxpk+xufkp6srh6w...@mail.gmail.com,
Maria Rechnitzer rrrah...@gmail.com typed:
 Dear Support,
 when word processing in microsoft office (doc or xls)
 there is a strikethrough feature that allows you to mark
 words that you want to delete but stIll keep them in the
 text, e.g. strikethrough.
 I was not able to find this feature in Libre Office (also
 not in former Open Office). Is there such a feature? If
 not I suggest to add it next to the bold, italic and
 underline feature.

 THANKS FOR PROVIDING THIS SEVICE!

 I kindly ask you to let me know if the strikethrough
 feature exists in Libre Office.
 Best regards,
 Maria

 --
 Maria E. Rechnitzer, Mag. phil.
 Email: rrrah...@gmail.com

 - Reduce Reuse Recycle Now
 - 
 Change habits, and the environment changes with you.

You didn't mention an OS or LO version so I'll be general, too. On mine, 
it's at Format, character in the top menu bar. Select the word you want to 
cross out, click Format; Character and choose from the 
single/double/over/under etc. lines available there. Lots more than MS 
offered. LO s NOT Word, so some things are more logically located.

HTH,

Twayne`




-- 
For unsubscribe instructions e-mail to: users+h...@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: strikethrough feature

2011-08-26 Thread NoOp
On 08/26/2011 04:03 PM, Johnny Rosenberg wrote:
...
 You can do that yourself. Here is how:
 
 Tools → Customize… → Toolbars.
 LibreOffice Writer Toolbars – Toolbar: Select ”Formatting”
 In the ”Commands” list, scroll down to ”Underline” and highlight it.
 Click the ”Add…” button.
 In the ”Category” list of the ”Add Commands” dialogue, select ”Format”.
 In the ”Commands” list of the ”Add Commands” dialogue, scroll down and
 select ”Strikethrough” (they are listed in alphabetic order, so it's
 easy to find).
 Click the Add button → the ”Add Commands” dialogue is closed.
 In the Customize dialogue, ”Strikethrough” is now available and
 checked (☒). You can move it up and down with the ⬆ and ⬇ buttons at
 the right of the ”Commands” list if it's not in the ”right” place.
 Click OK.
 You now have a strike through button available in your Formatting toolbar.
 
 In the Customize dialogue you can also customise your menues and
 keyboard shortcuts, and you can assign macros to different events,
 such as Open Document, Save Document and more.
...

Johnny, your replicating Brian Barker's already clear instructions on
how to do exactly that.

quote
 You can do this yourself:
 o  Click the down-arrow at the right end of the Formatting toolbar 
 and select Customize toolbar... | Toolbars.
 o  Under Toolbar Content, click Add... .
 o  Under Category select Format, under Commands select Strikethrough, 
 and click Add and Close.
 o  Click the up and down arrows to move your new button to where you 
 want it - apparently below Underline.
 o  Click OK.
 
 I trust this helps.
 
 Brian Barker
/quote



-- 
For unsubscribe instructions e-mail to: users+h...@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: Re: Feature request: native BibTeX support

2011-07-12 Thread Zak McKracken

Am 12.07.2011, 01:17 Uhr, schrieb planas jsloz...@gmail.com:

An alternative is to use Base. I have been thinking on these lines so I
will look into it more.


I am using base for my literature database, but it has serious drawbacks.  
You can use the built-in LO literature database (which isn't portable), or  
you can set up a new one, which will let you include stuff you think is  
useful but not conetained in the original. You can register that as a data  
source and start using it, but as soon as you want to edit any entry from  
within writer, it will tell you that it can't associate the db entries  
with the properties the literature module expects. So what I did was copy  
the existing db, add a few more fields and work with that, but I still had  
to re-asiciate all the db categories anew. And even though I stored it in  
the same directory as the document I used it for, if I copy that directory  
elswehere, the game starts anew.
If I change one of the entries in the db, I have to remove the citation  
from the document and re-insert it before it updates in the literature  
index. If you have cited it multiple times and you misclick once, be  
prepared for additional fun.


Ok, so aside from ranting about stuff I haven't done myself and should be  
thankful for instead of criticizing:
What should be doable (I speculate) is to construct something that will  
import bibtex into the OO-database, maybe even link the database to a  
bitex file (or several)? So if you change your bibtex file, the db will  
update, including establishing new categories, properties and the like.
What should also be done is improve the literature workflow. There is  
certainly something to improve there.


I do not use a plugin for citations because I prefer to have all done  
within one program (actually If I restarted my current project right now,  
I'd probably use a plugin, but now most of the stuff is in LO's database,  
and I won't undo that), and would welcome not having to copy/paste bibtex  
entries into the literature DB by hand. I'll also welcome any improvement  
of LO's bibliography module.



 Zak


--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
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: Bug\feature in LO Base master\slave form linking

2011-06-26 Thread Vladimir Drobyshevsky
Have a nice day, Jay!


planas jslozier at gmail.com writes:

 
 Hi Vladimir,
 
 ...

  Is it possible to change the way of LO making relation's query or to
  find an another way to solve my problem?
  
  Thank you in advance!
  
  P.S. I have no subscription to this mailing list so send your answers
  to my address too, please!
  
  -- 
  Sincerelly yours,
  Vladimir G. Drobyshevsky
  Wanna call me? Do it right now: +7 912 2473415
  
 
 My limited experience with SQL suggests you should qualify the typeID
 fields to remove any ambiguity. I have had this problem when working
 directly the outside database and developing queries for it. If one did
 properly qualify the ambiguous fields you get a similar error message.
 

Thank you for answer!

You absolutelly right in your sugesstion, but WHERE clause is changed
automatically (by adding 'AND typeID = :link_from_ProductID' ) by LO, as I
wrote above. I would be very grateful if you can show me solution to change it.

-- 
Sincerelly yours,
Vladimir G. Drobyshevsky
Wanna call me? Do it right now: +7 912 2473415


-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
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: Bug\feature in LO Base master\slave form linking

2011-06-26 Thread Alexander Thurgood
Le 26/06/11 11:36, Vladimir Drobyshevsky a écrit :

Hi Vladimir,

 
 Is it possible to change the way of LO making relation's query or to
 find an another way to solve my problem?
 

The only thing I can think of is by turning off ESCAPE PROCESSING.
This may be possible in the advanced connection parameters. What you
must know is that you might have found one of the known bugs in the SQL
parser that incorrectly removes parts of the query when you switch from
the graphical tools to direct SQL.


Alex


-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
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] Re: Bug\feature in LO Base master\slave form linking

2011-06-26 Thread planas
Vladimir,

On Sun, 2011-06-26 at 16:57 +, Vladimir Drobyshevsky wrote:

 Have a nice day, Jay!
 
 
 planas jslozier at gmail.com writes:
 
  
  Hi Vladimir,
  
  ...
 
   Is it possible to change the way of LO making relation's query or to
   find an another way to solve my problem?
   
   Thank you in advance!
   
   P.S. I have no subscription to this mailing list so send your answers
   to my address too, please!
   
   -- 
   Sincerelly yours,
   Vladimir G. Drobyshevsky
   Wanna call me? Do it right now: +7 912 2473415
   
  
  My limited experience with SQL suggests you should qualify the typeID
  fields to remove any ambiguity. I have had this problem when working
  directly the outside database and developing queries for it. If one did
  properly qualify the ambiguous fields you get a similar error message.
  
 
 Thank you for answer!
 
 You absolutelly right in your sugesstion, but WHERE clause is changed
 automatically (by adding 'AND typeID = :link_from_ProductID' ) by LO, as I
 wrote above. I would be very grateful if you can show me solution to change 
 it.
 
 -- 
 Sincerelly yours,
 Vladimir G. Drobyshevsky
 Wanna call me? Do it right now: +7 912 2473415
 
 


I will show my limited experience I would not use . The dialect I am
most familiar with does not normally use them. So my query would be
written:

SELECT invTypes.typeName AS Name,
invTypes.description AS Description,
invTypeMaterials.quantity AS Qty,
invTypeMaterials.typeID
FROM EDB.public.invTypes AS invTypes,
EDB.public.invTypeMaterials AS invTypeMaterials
WHERE invTypes.typeID = invTypeMaterials.materialTypeID

I am not sure if another dialect SQL requires the .  I am looking at my
reference book SQL Server. I would think the dialects would not very
that much but I have surprised before.
-- 
Jay Lozier
jsloz...@gmail.com

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
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: Editing feature: Spike

2011-03-18 Thread Twayne
In news:1300455381.1472.60.camel@PGU-Home-Desktop,
Peter G. Underwood pgunderw...@wol.co.za typed:
:: A useful addition to LibreOffice would be a spike
:: clipboard, that allows one to store a sequence of items to
:: be pasted, from which one can select the particular item
:: needed. MS-Word offers such a feature and it has proved
:: most useful whilst editing long texts. --
:: 
:: Peter G. Underwood tel/fax: +27 21 761 8463
:: 4 Brentwood Close  cell:+27 84 650 3091
:: 11C Indian RoadSkype:pgunderwood
:: KENILWORTH
:: 7708  pgunderw...@wol.co.za
:: Cape Town
:: South Africa
:: 
::
::
::
::
::
:: --
:: Unsubscribe instructions: E-mail to
:: users+h...@libreoffice.org
:: List archive:
:: http://listarchives.libreoffice.org/www/users/ *** All
:: posts to this list are publicly archived for eternity ***

Good point. I do miss that now  then. It's just a multi-object clipboard. 
I don't care whether it looks like MS's implementation or not; it's the 
feature that's important. OTOH not a lot of people use it other than 
technical writers.

HTH,

Twayne`




-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***



Re: [libreoffice-users] Re: Editing feature: Spike

2011-03-18 Thread Andy Brown

Twayne wrote:

In news:1300455381.1472.60.camel@PGU-Home-Desktop,
Peter G. Underwoodpgunderw...@wol.co.za  typed:
:: A useful addition to LibreOffice would be a spike
:: clipboard, that allows one to store a sequence of items to
:: be pasted, from which one can select the particular item
:: needed. MS-Word offers such a feature and it has proved
:: most useful whilst editing long texts. --

Good point. I do miss that now  then. It's just a multi-object clipboard.
I don't care whether it looks like MS's implementation or not; it's the
feature that's important. OTOH not a lot of people use it other than
technical writers.

HTH,

Twayne`



Maybe something that would work as an extension.


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***