Lera Goncharuk | 28 Mar 17:17 2015
Picon

the Error type of variables in LO Basic

Hi,

There are two types of variables in LibreOffice Basic, which are not
described in the
help and the documentation.
The Byte type is clear. It is positive integers from 0 to 255.
The Error type is not clear. I suppose that this type is useful when working
with errors in a code. But, I do not understand how it can be used.
Could anyone explain this type of the variable to me, please? I will also be
grateful for references and examples on this issue.
Thank you in advance.

Lera

Pertti Rönnberg | 28 Mar 15:32 2015
Picon

Re: LibreOffice Sort Bug ?

Brian,

Thanks for your reply and for the articles you linked to – especially 
the last one is very interesting. I have been aware of that but not so 
well explained.

As I think you are very cunny both on spreadsheets and how to use them 
and also the mathematics, I am not able to argue.

But I am sure you know what I meant when I said that a spreadsheet is 
‘totally’ worthless if you cannot trust it, if it -- the program, its 
features or functions -- does not work (behave) as supposed.

As an engineer I have been working with MSExcel since late 1980 and have 
since 10 years successively began to use OO/LO.

I’ve always tried to crosscheck important calculations and with 
calculation processes start with some few (random or logical) sample 
data and/or manual calcs to be sure that the formulas (& combinations 
of) work OK.

Whatever people say about Microsoft, I must say that I have never 
experienced any problems caused by the program MSExcel itself (perhaps 
I’ve been lucky) – all my problems have been caused by my typos or my 
bad planning of the calculation process.

But, especially with LibreOffice/Calc I have experienced issues that 
clearly depend on LO as a program and have caused me a lot of extra 
doings – the last couple of years LO has become better.

(Continue reading)

Michael Tiernan | 27 Mar 10:46 2015
Picon

Request for resoure suggestions.

I'm working on improving my formatting skills. I'm using a ~10pg
document as my test.

My first problem is to figure out a specific part of styles. I can
format the document to have a heading (specifically heading 2) at the
start of each section. Looks nice. Copied the existing style, made a few
mods, very pleased.

NOW, I want to try to add a number to each section and I'm having
trouble understanding the correct route for this.

I have already gotten:

 John
 George
 Paul
 Ringo

and it worked fine. Now I want to change the style to be like:

   I John
  II George
 III Paul
  IV Ringo

So, I can't tell if I should be trying to modify the "Heading 2" style
or if I should be trying to add a "List" format to the mix.

I'm looking for suggestions on where I can read about the uses of each
and learn the differences.
(Continue reading)

hw | 27 Mar 10:13 2015
Picon

how to put images into a report

Hi,

how can I put images into a report?

I have a query on a database that, amongst others, has a field with the 
file name of an image.  All images are stored in a particular directory, 
so the relevant table in the database holds the file name of the image, 
for example "abc.jpg".  I need the image that has the particular file 
name displayed in the report.

The images are of different sizes, and in the first step, I'd like to 
have them scaled to fit into the report, and their aspect ratio must not 
be changed.  In a second step, I might use some external tool to make 
all images the same size eventually.

--

-- 
To unsubscribe e-mail to: users+unsubscribe <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
libreoffice-ml.mbourne | 26 Mar 21:43 2015

Test - Please ignore

Testing with alternative client and name in To: header.

Mark.

--

-- 
To unsubscribe e-mail to: users+unsubscribe <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
libreoffice-ml.mbourne | 26 Mar 20:50 2015

Test - Please ignore

My emails to the list are being rejected.
- Trying an alternative client worked.
- Trying original again didn't.
- Trying original client with a different SMTP server failed.
- Now trying original client without name against To address...

Mark.

--

-- 
To unsubscribe e-mail to: users+unsubscribe <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
libreoffice-ml.mbourne | 26 Mar 20:22 2015

Test - Please ignore

My emails to the list are being rejected. Trying an alternative client...

Mark.

--

-- 
To unsubscribe e-mail to: users+unsubscribe <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
Richard VINCK | 26 Mar 01:57 2015
Picon

FEATURE REQUEST -- for the Sort options in Calc

For logical and safety reasons, and for compatibility with Microsoft 
Excel, I suggest that:
     * The Sort Option "Range contains column labels" be_unticked by 
default_.
     * Allow the sort options to be customized (optional).

It is good that LibreOffice has this option, but a beginner don't know 
that option and will sort what he/she has selected, and it is 
frustrating to see that the first column is not sorted at all, thinking 
it's a bug (like I did).

Thank you!
Cheers

--

-- 
To unsubscribe e-mail to: users+unsubscribe <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
Tim Lloyd | 26 Mar 01:12 2015
Picon

Re: LibreOffice Sort Bug ?

Hi,

while LO does allow a certain amount of customisation, at this point in 
the game this particular menu option can not be changed.

This then becomes a feature request, either

  * change the default
  * allow the sort options to be customised

Once a feature request is submitted it is really up to a (unpaid) 
programmer to step forward and take on the action. I can't see this 
being high on the programmer's list of priorities but it may be deemed 
an "easy hack" which an aspiring young person could field.

Cheers

On 26/03/15 10:58, Richard VINCK wrote:
> Tim Lloyd
> Thank you for pointing this. Indeed, unticking it works then correctly.
> But it should be the default, and should remain unticked. (and should 
> be more visible, as it is hidden in the Option tab)
> Can we make it as default?
>
> On 2015-03-26 00:42, Tim Lloyd wrote:
>> A quick look at the doco reveals...
>>
>> Range contains column/row labels
>> – omits the first row or the first column in the selection from the sort
>>
(Continue reading)

Richard VINCK | 25 Mar 23:42 2015
Picon

LibreOffice Sort Bug ?

Hello at the nice people at LibreOffice! (especially you :-) )

I'm using LibreOffice version 4.4.1.2

I was very surprised to see a bug (?!) in the internal SORT function of 
Calc.

Please fill the following cells with a simple letter:
L17=Z
L18=B
L19=Y
L20=R
L21=Q
L22=P

Now select those 6 cells and click on the Down/Up arrow in the toolbar 
(Sort), select Sort Key 1 : Z, Ascending, then click OK. Expected result 
was B-P-Q-R-Y-Z, but the Z did not move at all ! =-O

This is undoubtedly a serious bug... and nobody has detected this 
before? How strange.

Hopefully I could be of help making the software still better!
Cheers
Richard

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
(Continue reading)

Paul D. Mirowsky | 25 Mar 16:27 2015

LibreOffice in the browser, revealed in 2011, finally close to reality The long-promised Android version hasn't been forgotten, either.

On Ars Technica today.

http://arstechnica.com/information-technology/2015/03/libreoffice-in-the-browser-revealed-in-2011-finally-close-to-reality/

--

-- 
To unsubscribe e-mail to: users+unsubscribe <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

Gmane