[Solved] Type Conversion Error

[vijaymsc]

Hi am vijay,
Hi when i using following code

Integer_variable=CInt(Str)

It Shows

"Inadmissible Value or DataType : Overflow" I don know why this is happening... If possible let me clear....

Thanks...
Vijay...

[Zizi64]

Hi,

Which string (wich range of numbers) you want to convert?

Please upload an example file here...

[JohnV]

"Str" is a Basic function which converts a number to a string. Try
s = "1"
n = CInt(s)
or
n = CInt(Str(10))

[rudolfo]

Apart from the CInt() you are not really indicating the programming language that you use.
Assuming it is Basic I reference the Online Help in the section "Macros and Programming"

Integer Variables
Integer variables range from -32768 to 32767. If you assign a floating-point value to an integer variable, the decimal places are rounded to the next integer. Integer variables are rapidly calculated in procedures and are suitable for counter variables in loops. An integer variable only requires two bytes of memory. "%" is the type-declaration character.

Code: Select all

Dim nValue As Integer, theString As String
theString = "100000"
nValue = CInt(theString)    ' throws the Overflow runtime error

Use a Long variable and CLong() instead. (just the next paragraph in the online help)

But hey, normally this problem should not lead you to this forum, but instead to start debugging. All the questions with which Zizi64 came up are essential to solve the problem and can be easily answered if you use the debugger of the Basic IDE and step through your code. In the bottom third of the IDE window you can specify variables to watch for. Type [str ] in the text field, hit return and continue stepping through the code. In the section below the variable str will be shown with its current value after each processing step of the macro.
Please read the online help (F1) on the Basic IDE. All the above about debugging is not my wonderful knowledge, but you can find it in the Help of OpenOffice.

[vijaymsc]

Hi To all ,
I got cleared with your suggestions... I thank everyone who replied for my post....

Thanks...

vijay

[Tiger42]

Hello,
Same issue here in libreoffie macro

using this code

Code: Select all

Sheet = oDoc.Sheets.getByName("File_source")
Curs = Sheet.createCursor
Curs.gotoEndOfUsedArea(True)
NumRows = Curs.Rows.Count

and when I run macro getting following error

[*]Inadmissible value or data type.Overflow.

Total rows in the file is 47600 and some more so is it any issue regarding numbers of rows ?

Strange thing is that I am using above code in another macro and In that macro has not any issue but in this macro I have data till nearby 31000 rows

[Villeroy]

Get some book on Visual Basic. The chapter about data types should be right at the beginning.
In Andrew Pitonyak's book "OpenOffice Macros Explained" it is chapter 3.
http://www.pitonyak.org/oo.php