headers
NoOp | 1 Mar 2012 04:35
Picon
Favicon

Re: increase testing to improve quality

On 02/29/2012 03:14 AM, e-letter wrote:
> On 29/02/2012, NoOp <sniprudeemailquotefrome-letter-fixyourclient> wrote:
>>> There is a web page which describes manual testing:
>>> http://wiki.documentfoundation.org/QA/Testing/Manual_Tests. Clearly,
>>> there are insufficient testers...
>>
>> Clearly:
>> <quote>
>> IMPORTANT: Obsoleted by Litmus
>>
>> Litmus is a useful tool for organizing manual tests. Please, help us to
>> migrate all these test cases there and remove them from this wiki page.
>> </quote>
>>
>> So why even point 'users' to that page?
>>
> 
> The initial purpose is to promote the existence of QA testing, both in
> terms of the history (the wiki) and the future (litmus).

And if the manual test is obsolete & LO wish to migrate everyone to the
litmus test page instead you think it's a good idea to direct users on
this list to that page? Seems a bit odd to me.

>>
>> Cool. Have you *actually* installed 3.5.1rc1 (as noted in the litmus test)?
>> Description: 	Test run for *3.5.1 RC* regression testing. Please use
>> *3.5.1 RC* build to test the cases in this run.
>>
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Alex Thurgood | 1 Mar 2012 09:11
Picon

Re: Tell me it's not true

Le 29/02/2012 18:15, Dan Lewis a écrit :

Hi Dan,

>       What would most people who are new to Base think after reading the
> negative comments about Base? Statements about how hard it is to learn
> (comparing learning at least some of it to the difficulty of learning a
> new language). No one seems to be able to give references that would
> help. (No one has so far.)

On the contrary, I think you'll find that in the past (and I'm not 
referring to this thread) we have directed people to the OOo Base forums 
because that is where people with Base questions have found (at least 
partial, if not complete) answers. If we decide to ignore the existing 
information, advice and caveats, whilst it is still available and for 
the most part relevant, I feel we are just deluding ourselves.

>       OK, I have had my say. I will likely delete any replies that come
> from this thread because I have seen people justify their actions in the
> past threads. This is suppose to be a list to help others, and their
> comments are not likely to do that. Besides, any replies to me need to
> consist of references for getting the most from Base. Other than help in
> learning more about how to use it, I don't need.

Dan, most of us who have commented here have worked, and still continue 
to work, with LO and databases in some form or another. However, we have 
learnt from much trial and error, late nights, gnashing of teeth and 
tearing of hair, some of us over a period of more than 10 years, that 
ultimately pragmatism must trump the day. Has that stopped me from 
starting the migration of the French Base FAQ to the English LO wiki ?
(Continue reading)

Permalink | Reply | 3 comments |
headers
Alex Thurgood | 1 Mar 2012 09:15
Picon

Re: Fw: [MariaDB Announce] MariaDB 5.3.5 now available!

Le 29/02/2012 23:58, Tom Davies a écrit :

Hi Tom,

Just to add to your announcement, note that there is currently an "Easy 
Hack" development request to find someone to do the work to include a 
MariaDB connector into the LO source code using C libraries provided by 
the MariaDB project.

Just putting this out here in case there are some interested 
user/developer types hanging around.

Alex

--

-- 
For unsubscribe instructions e-mail to: users+help <at> 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
Permalink | Reply | 0 comments |
headers
Fernand Vanrie | 1 Mar 2012 10:07
Picon

Re: Parameterised query

  Mark ,
so "?" works for native SQL
      ":" works for OO-SQL

Greetz

Fernand
> Hi Fernand,
>
>> ?Isssue_Num (3s) ?
>>    greetz
>> Fernand
> Thanks, but nope.  The name Issue_Num, just identifies a parameter, it
> doesn't have to match the name of any field.
>
> The problem was the wrong SQL mode.
>
> Mark Stanton
> One small step for mankind...
>
>
>

--

-- 
For unsubscribe instructions e-mail to: users+help <at> 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
(Continue reading)

Permalink | Reply | 4 comments |
headers
Mirosław Zalewski | 1 Mar 2012 13:30
Picon
Favicon

Re: How to use GTK open dialog box in LibreOffice

I do not use LightDM, but I think I have found solution:

1. Your $HOME/.xsessionrc file should have following three lines in it:

if [ -r ~/.profile ]; then
    . ~/.profile
fi

If you don't have ~/.xsessionrc file, simply create it.

(Just in case - $HOME and ~ both means your home directory, that is - in most 
cases - /home/your-username/.)

2. In your ~/.profile file, put following line:
OOO_FORCE_DESKTOP=gnome
If you don't have ~/.profile file, again - create it. If you happen to have some 
conditional statements or loops in that file, put that line at the very end of 
file.

Now log out, log in and try running LO.

Below is explanation/rationale, although you may find it a bit technical:
LightDM on login reads script set in session-wrapper in 
/etc/lightdm/lightdm.conf file. On Debian, this is /etc/X11/Xsession.

That script sets up X environment, by reading files in /etc/X11/Xsession.d 
directory. One of them sources users' XSESSIONRC file, which is ~/.xsessionrc.

In my solution, I tell to put there statement, that reads ~/.profile if it 
exists and is readable. Then I tell to put OOO_FORCE_DESKTOP in that ~/.profile
(Continue reading)

Permalink | Reply | 7 comments |
headers
Mark Stanton | 1 Mar 2012 15:11
Picon

Re: Parameterised query

Hi Fernand,

> so "?" works for native SQL
>       ":" works for OO-SQL

I'm not sure if you are asking me a question or making a statement.
What you are saying is not what I was saying, I'm not certain it is right, 
I don't think it is.  I may be wrong :-)

Regards
Mark Stanton
One small step for mankind...

--

-- 
For unsubscribe instructions e-mail to: users+help <at> 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
Permalink | Reply | 3 comments |
headers
Dag Wieers | 1 Mar 2012 15:20
Favicon
Gravatar

Re: Presentation conversion to/from Powerpoint - layout

On Tue, 28 Feb 2012, e-letter wrote:

> On 28/02/2012, Roger Sawkins <roger <at> sawkins.name> wrote:
>
>> I have Powerpoint on one machine and LibreOffice on another. I want to be
>> able to edit and save PowerPoints on either machine. However, when loading
>> Ppt in Presentation it does not always convert font and layout properly.
>> Occasional tabs or spaces are missing or duplicated; occasional text boxes
>> have text outside the slide, etc.
>
> Your are wasting your time. Make a cost-benefit analysis and decide
> whether to use either LO or m$; do not bother trying to use both.

Are we being rude today ?

The case Roger describes is something we all encounter when 
exporting/importing PPT documents. And while we do not control how 
(various) Microsoft products behave when using ODF, we can undoubtedly do 
a better job at making sure the import from and export to PPT (and PPTX) 
is smoother.

If in this case some problems are related to font issues, maybe the 
import filter can warn about lacking the right fonts (maybe even indicate 
which ones these are) and the rendering problems this may cause.

And if this is something Roger wants to help (waste time?) on, who are we 
to decide whether that is useful or not. Instead of providing no hope to 
users, I would prefer if we would clarify how users can help 
developers improve our product.
(Continue reading)

Permalink | Reply | 22 comments |
headers
Andreas Säger | 1 Mar 2012 16:32
Picon
Favicon

Re: Presentation conversion to/from Powerpoint - layout

Am 01.03.2012 15:20, Dag Wieers wrote:
> On Tue, 28 Feb 2012, e-letter wrote:
>
>> On 28/02/2012, Roger Sawkins <roger <at> sawkins.name> wrote:
>>
>>> I have Powerpoint on one machine and LibreOffice on another. I want
>>> to be
>>> able to edit and save PowerPoints on either machine. However, when
>>> loading
>>> Ppt in Presentation it does not always convert font and layout properly.
>>> Occasional tabs or spaces are missing or duplicated; occasional text
>>> boxes
>>> have text outside the slide, etc.
>>
>> Your are wasting your time. Make a cost-benefit analysis and decide
>> whether to use either LO or m$; do not bother trying to use both.
>
> Are we being rude today ?
>
> The case Roger describes is something we all encounter when
> exporting/importing PPT documents. And while we do not control how
> (various) Microsoft products behave when using ODF, we can undoubtedly
> do a better job at making sure the import from and export to PPT (and
> PPTX) is smoother.
>

Really? Can we realistically do a better job when millions of users want 
another set of MS features each and every day?
When downloading the Microsoft *viewers* for WinWord, Excel and 
Powerpoint, these three *viewers* cover the file formats doc(x), rtf,
(Continue reading)

Permalink | Reply | 19 comments |
headers
drew jensen | 1 Mar 2012 17:43
Picon
Gravatar

Re: Parameterised query

On Thu, 2012-03-01 at 14:11 +0000, Mark Stanton wrote:
> Hi Fernand,
> 
> > so "?" works for native SQL
> >       ":" works for OO-SQL
> 
> I'm not sure if you are asking me a question or making a statement.
> What you are saying is not what I was saying, I'm not certain it is right, 
> I don't think it is.  I may be wrong :-)

1) For all datasource types Base supports - When a query definition is
parsed by LibreOffice before being sent to the database engine, allowing
for named parameters and nested queries, the syntax is :<parameter_name>

When the LibreOffice query definition is run a dialog box will prompt
the user for the parameter value(s), displaying the string
<parameter_name>.

select * from foo where bar = :MyBar

When run will prompt the user using the string "MyBar". All input by the
user is treated as a string and then converted the appropriate data
type.

2) For all datasource types Base supports - When using a basic script
you can create a parameterized query also, by using a prepared
statement. In this case the parameters are not named and are designated
by a ? character. You can assign values to the parameters by parameter
count (or place) starting with 1. You also must use setxxx functions
appropriate for the data type.
(Continue reading)

Permalink | Reply | 1 comment |
headers
Fernand Vanrie | 1 Mar 2012 18:10
Picon

Re: Parameterised query

On 01/03/2012 15:11, Mark Stanton wrote:
> Hi Fernand,
>
>> so "?" works for native SQL
>>        ":" works for OO-SQL
> I'm not sure if you are asking me a question or making a statement.
sorry,  i just wanted to know if  ?parameter works for native SQL mode
           and                                    :parameter works when 
using OO-SQL mode
> What you are saying is not what I was saying, I'm not certain it is right,
> I don't think it is.  I may be wrong :-)
>
> Regards
> Mark Stanton
> One small step for mankind...
>
>
>

--

-- 
For unsubscribe instructions e-mail to: users+help <at> 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
Permalink | Reply | 0 comments |

Gmane