I also posted it here:
https://www.libreoffice.org/get-help/bug/
--
View this message in context:
http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3993952.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe i
Okay for anyone who's interested I submitted the bug here:
http://bugs.mysql.com/bug.php?id=65832&thanks=sub
Enjoy!
--
View this message in context:
http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3993950.html
Sent from the Users mailing
Regina, thanks for your answer.
But can you tell me how to call Calc functions inside the macro?
I searched in docs and in the Google and don't found any clue.
By the way, just now I tought the possibility to rewrite math functions
using "string" to encode the number to avoid error because I reme
On 06/07/12 05:26, nvrk wrote:
On Thu, Jul 5, 2012 at 3:06 AM, Simon Cropper <
simoncrop...@fossworkflowguides.com> wrote:
Yeah, I have thought of both these things. Have hacked a standard file
before, particularly in MS Word. Easily done assuming it is a text file and
not a binary file.
The
Hi,
alex sato schrieb:
Hi,
I have a problem with functions I made.
Let's say I create the function:
Function Test (n)
dim r(3)
r(0)=int(n)
r(1)=n-r(0)
r(2)=r(1)*100
r(3)=int(r(2))
Test = r
End Function
Then, in a empty spreadsheet take the following steps:
-select A1:D1
-press [F2]
-Insert t
There is no problem using formula in a cell to make the calculation. The
problem occurs only in a macro (using ooBasic). I used the Test macro just
to show my problem.
I don't know if it was expected or if it is a bug.
If it is not a bug I wish to understand why and what I could do to get what
I ex
What I found interesting was that Calc (in LO 3.3.2) did not have that problem:
Have A1 hold 11.18
Then A2 = INT(100*(A1-INT(A1)))
works just fine.
I think it would be safest to do
A3 = ROUND(100*(A1-INT(A1)))
though.
-Original Message-
From: Steve Edmonds [mailto:steve.edmo..
Hi.
In fact if I change your function
r(3)=(r(2)-18)*10
Test = r(3)
the result is -2.8421709430404E-005
showing that 17 would be correct.
For these situations I often add my own tolerance to limit sensitivity
r(3)=int(r(2)+1e-9)
steve
On 5/07/12 1:50 PM, alex sato wrote:
Hi,
I have a
Hi.
I tried your function but made the last line Test = r(3).
It does return 17.
My guess is that by the completion of r(2)=r(1)*100 the value is very
slightly less than 18 and int then produces 17.
steve
On 5/07/12 1:50 PM, alex sato wrote:
Hi,
I have a problem with functions I made.
Let'
On Thu, Jul 5, 2012 at 3:06 AM, Simon Cropper <
simoncrop...@fossworkflowguides.com> wrote:
>
> Yeah, I have thought of both these things. Have hacked a standard file
> before, particularly in MS Word. Easily done assuming it is a text file and
> not a binary file.
>
> The problem is the binomial.
On 07/05/2012 01:39 PM, Regina Henschel wrote:
Hi,
Pastel Painter schrieb:
When I print my documents, they are printing about 1/8 of the original
(letter) size, and are being rotated to landscape mode. When I check the
document in print preview, the document looks like I expect it to -
taking
Hmm, disappointing though. I cannot see how these kinds of things can be
avoided if you are editing a manuscript, and I never had such problems in
the past with OO in 2002, with a book that certainly went through just as
many revisions.
I am clueless anymore how to fix it. If I fix one, another on
Hi,
Pastel Painter schrieb:
When I print my documents, they are printing about 1/8 of the original
(letter) size, and are being rotated to landscape mode. When I check the
document in print preview, the document looks like I expect it to - taking
up the full page, etc. I have no idea as to why
Rogier ,
Its not worth a issue, its user related due to serial direct formating,
spaces folowd by spaces etc..When checking the underlying XML you can
sea lots of unused tags and sometimes the PDF-creator is confused :-)
The solution and the probable cause...
In the end, this problem was fixa
When I print my documents, they are printing about 1/8 of the original
(letter) size, and are being rotated to landscape mode. When I check the
document in print preview, the document looks like I expect it to - taking
up the full page, etc. I have no idea as to why it is doing this or what to
cal
On 7/5/12 2:41 AM, Andreas Säger wrote:
All this had been written hundreds of times for dozends of spreadsheets
applications in books, web-pages, mailing lists and forums. People don't
read this.
I know, but I have a hard time blaming X percent of them. I run into
many users who have no cl
With the word list system for LO's dictionaries, I have found no info
regards how to used a two word combo.
All I have been able to do is have a word list in a .dic file withing an
.oxt file.
Having a term with two parts, like your example, is something I have not
found how to do.
As for
The solution and the probable cause...
In the end, this problem was fixable, by using 'clear direct formatting' in
the areas affected. (Could not do whole doc lest we wipe out italics and
such).
The amazing fact was that the problem did not manifest in a PDF at the
subdocument level, it just show
Am 05.07.2012 03:34, Andrew Douglas Pitonyak wrote:
You made me smile today when I read your post:
Just wanted to mention it...
Thanks for your smile. Very much appreciated.
:)
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.
Tom,
Yeah, I have thought of both these things. Have hacked a standard file
before, particularly in MS Word. Easily done assuming it is a text file
and not a binary file.
The problem is the binomial. I also thought of the concatenation string
but most of the single characters have been used
Am 05.07.2012 11:43, Andreas Säger wrote:
E1: input value
A1: =INT($E1)
B1: =$E1-$A1
C1: =$B1*100
D1: =INT($C1)
This is how it works in all spreadsheet applications. It applies to any
other row where you copy the formulas to.
You may even save this simple calculation in xls(x) format and it wil
Am 05.07.2012 03:50, alex sato wrote:
Hi,
I have a problem with functions I made.
Let's say I create the function:
Function Test (n)
dim r(3)
r(0)=int(n)
r(1)=n-r(0)
r(2)=r(1)*100
r(3)=int(r(2))
Test = r
End Function
Then, in a empty spreadsheet take the following steps:
-select A1:D1
-press
Am 04.07.2012 17:42, Ken Springer wrote:
For the ordinary user, not only does LO need to explain the basics by
using "=FUNCTION(number ; text ; range ; vector )" and "=FUNCTION(
function_number(x) ; function_text(x) ; function_range(x) ;
function_vector(x) )" with explanations, you need examples
Hi :)
+1
The same problem happens in Excel too. I tend to make those buffer-zones
quite small so they help emphasise the totals rows or columns.
Regards from
Tom :)
--- On Thu, 5/7/12, Dennis E. Hamilton wrote:
From: Dennis E. Hamilton
Subject: RE: [libreoffice-users] Re: CALC - How to
Hi :)
I think i would create a new specialist list and add 2 or 3 words to it. Then
look for the file to see what format it uses and then copy&paste tons of words
in at a time. For combined words i would add a - in the middle, eg
"Eucalyptus-vulgaris" but i think that is a bit of a kludge.
25 matches
Mail list logo
