bug found while converting

[RevDave]

I attempted to convert an xls document to a text file. I opened the file in neooffice.
I went to file/wizards/document converter and received the error message
"Inadmissible value or data type. Index out of defined range."

The specific code involved is
Sub GetApplResourceArray(StartResIndex as Integer, Count as Integer, BigArray())
Dim i as Integer
Dim a as Integer
a = 0
For i = StartResIndex To StartResIndex + Count-1
BigArray(a) = GetResText(i)
a = a + 1
Next
End Sub
With the line "BigArray(a) = GetResText(i)" flagged.

All I was looking for was an easy way to take an xls document and convert it to text so it could be saved as rtf for user friendly reading, I could convert the spreadsheet to text but it was in a text box which I could not use. I couldn't get rid of the four pointed cursor, select all of the text, etc.

At least the bug needs to be fixed.
I searched forums for hints. Program help was useless. [/b]

[pluby]

This was already reported in Bugzilla here many months ago and has already been fixed in the NeoOffice 2.2.1 Early Access release.

Patrick

[Lorinda]

Welcome to the forums at trinity.

There are several solutions to your delimma, depending on what you need:
-As Patrick mentioned, upgrade to Neo 2.2.1 EA
-Save the file as Text/csv (in the Save dialog, scroll down through the available format types in the drop down menu below the file picker). In the Finder, change the extension from .csv to txt. You can then open it in Writer and save as you wish. You will lose bold, italics, etc. this way.
-Copy the relevant range in the xls document, and "Paste Special" into a Writer document. See this wiki article for more detailed instructions on this process. (rtf is an option with paste special)

In my experience, it is always better to use the Save functions when possible instead of the document converter. (I have used the document converter to batch convert a group of documents, but I've never tried it with an open document.).

Lorinda

[RevDave]

Patrick & Lorinda
Thanks for the help. I am confused about version 2.2.1 ea. I am running 2.1 Patch 7 on the Mac and I thought that was the most current version. Neooffice told me to download patch 7 just this week. I'll go in search of.

Dave

[jgd]

You can find instructions for downloading NeoOffice 2.2.1 EA on this page.
To get it now, you have to make a little donation: without donations NeoOffice can't live. Starting on August 27 you'll be able to download NeoOffice 2.2.1 for free.

Jacqueline