View previous topic :: View next topic |
Author |
Message |
RevDave Blue Pill
Joined: Jan 08, 2007 Posts: 2
|
Posted: Sat Aug 04, 2007 7:40 am Post subject: bug found while converting |
|
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] |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Sat Aug 04, 2007 7:50 am Post subject: |
|
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 |
|
Back to top |
|
|
Lorinda Captain Mifune
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
|
Posted: Sat Aug 04, 2007 10:08 am Post subject: |
|
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 |
|
Back to top |
|
|
RevDave Blue Pill
Joined: Jan 08, 2007 Posts: 2
|
Posted: Sat Aug 04, 2007 12:22 pm Post subject: |
|
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 |
|
Back to top |
|
|
jgd Agent Smith
Joined: Feb 27, 2005 Posts: 1531 Location: France
|
Posted: Sat Aug 04, 2007 12:32 pm Post subject: |
|
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 |
|
Back to top |
|
|
|