Fatal error Vector<T> too long

Discuss the spreadsheet application

Fatal error Vector<T> too long

Postby Halley70 » Tue Dec 31, 2013 12:09 am

I am using Open Office 4.0.1 on Windows 8.1 since half december. Before I used 3.x on Vista. I was always very happy with Open Office.
I especially use Calc a lot. Now I am using Calc to create a 80 pages book with data about cycling.
At the moment there are no formules except SUM and I removed the three pictures in it.
When I add new lines every other time the program hangs. When it comes back after several minutes I can use the program again until I save. Then I get:
vector<T> too long fatal error in Open Office 4.0.1.

The file gets restored. I can work again, but several minutes later the same happens and again and again.

Should I return to 3.2?

Ctrl+End brings me to O2299
The file size is 864kb.

Anyone has an idea?
Open Office 4.0.1
Windows 8.1
Halley70
 
Posts: 3
Joined: Mon Dec 30, 2013 11:52 pm

Re: Fatal error Vector<T> too long

Postby RoryOF » Tue Dec 31, 2013 12:15 am

I'm not a Calc expert, but are you aware that the inbuilt paragraph limit in OpenOffice is 64KB? If line feeds (Ctrl Enter) are being used in place of Enter, which happens sometimes with bad habits brought forward from older editors, this limit can be reached.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29552
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Fatal error Vector<T> too long

Postby Halley70 » Tue Dec 31, 2013 12:32 am

I was not aware of that 64kb limit. But I am not using paragraphs that way. Sometimes I merge a cell, but usually I make lists of riders etc. not too much text at all.
Open Office 4.0.1
Windows 8.1
Halley70
 
Posts: 3
Joined: Mon Dec 30, 2013 11:52 pm

Re: Fatal error Vector<T> too long

Postby acknak » Tue Dec 31, 2013 1:05 am

Maybe someone else has an idea but I think I would need to look at a copy of your document to find out what the problem is.

You can use the "Upload Attachment" link (below the message entry area after you click "POST REPLY"). For tips on posting large or confidential documents, see: [Forum] How to attach a document here
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Fatal error Vector<T> too long

Postby RoryOF » Tue Dec 31, 2013 2:09 am

One point on which I'd like clarification: You say "using Calc to create a 80 pages book". Why? How? Why not Writer?
As acknak says, we really need to see a copy of the file.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29552
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Fatal error Vector<T> too long

Postby Halley70 » Tue Dec 31, 2013 2:21 pm

When I upload this file: who can see it?
Open Office 4.0.1
Windows 8.1
Halley70
 
Posts: 3
Joined: Mon Dec 30, 2013 11:52 pm

Re: Fatal error Vector<T> too long

Postby RoryOF » Tue Dec 31, 2013 2:32 pm

If you upload the file, it is public. This posting suggests methods of removing confidential data before uploading
https://forum.openoffice.org/en/forum/viewtopic.php?p=59232#p59232
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29552
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Fatal error Vector<T> too long

Postby acknak » Tue Dec 31, 2013 4:19 pm

Alternatively, you can use the email button at the right side of any post to send a private email message to that forum user.

Click the button to email me and I'll reply with a private email address that accepts attachments.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Fatal error Vector<T> too long

Postby CMorrison » Sat Jan 31, 2015 8:56 pm

This error has to do with Total Editing Time which is shown in the Properties of your spreadsheet.
Vector <T> is too long - Fatal Error occurs when the Total Editing Time reaches 365 days.

I am working through the steps to clear this, as I believe it will require resetting the Property Data and saving it with out applying the User Data first.
Once I am sure of the fix, I'll post again. Here's a view:

Approaching Max Vector-T time 365 days.jpg
Here's a view of the Total Editing Time just before the Fatal Error
AOO V4.0.1 - vector<T> too long - Fatal Error which occurs when Total Editing Time has exceeded 365 days.
Charles "Charlie" Morrison
OpenOffice V4.0.1 / Windows 7
CMorrison
 
Posts: 2
Joined: Sat Jan 31, 2015 8:22 pm

Re: Fatal error Vector<T> too long

Postby CMorrison » Sun Feb 01, 2015 3:06 am

I've not come to a solution, so I spent a few minutes on a work-around. I don't consider this a resolution to resetting
a Calc spreadsheet that has been edited for 366 days, but it does allow one to work around it:

Create a new spreadsheet, assign a new filename to the new spreadsheet. Copy each sheet from your original file or
from a recovered spreadsheet into the new file.

< I'll leave it up to the moderator to make this SOLVED, if he considers this SOLVED or not.>
Attachments
Work-around Vector-T too long Resolution.jpg
Work around: Vector<T> too long - Fatal error >>
Create a new spreadsheet, assign a new filename to the new spreadsheet. Copy each sheet from your original file or from a recovered spreadsheet.
from a recovered spreadsheet to the new file.
Charles "Charlie" Morrison
OpenOffice V4.0.1 / Windows 7
CMorrison
 
Posts: 2
Joined: Sat Jan 31, 2015 8:22 pm

Re: Fatal error Vector<T> too long

Postby jwvdvuurst » Tue Feb 10, 2015 1:54 pm

Hi,

I suddenly also got this error.

Running on RHEL 6.5 (Linux Red Hat Enterprise Linux), with AOO version 4.1.1.

Procedure to reproduce:

Add a new sheet to an automatically generated excel formatted spreadsheet.
Type some text
Add "=" to a cell and move to the other tab for reference
Bang... I get the error "Fatal error Vector::reserve". Which I think is the equivalent of the "Vector<T> too long".

John
John van der Vuurst - Apache Open Office 4.1.1 - running on RHEL 6.5
jwvdvuurst
 
Posts: 1
Joined: Tue Feb 10, 2015 1:47 pm

Re: Fatal error Vector<T> too long

Postby White Phoenix » Sat Jan 02, 2016 12:51 pm

I am getting this error as well, but in 4.1.2 and after only less than 2 hours editing time. Everything was fine until just a little while ago when AOO suddenly closed. I am trying to enter the value of a cell from another sheet. I type the equal sign then as soon as I try to switch to the other page, the error box pops up with the fatal error “Vector <T> too long”. As soon as I close the box, OpenOffice crashes. I am working in real Windows 7 64-bit now. I gave up on the virtual machine. I just reinstalled everything and am still in the process of setting everything the way I had it. The only Java on the system is the latest version.

My Linux has access to the same file. I will close Windows and try the Linux Mint OS to see what happens.

Well, I didn’t get that far. On a hunch I rebooted back into Windows 7 and opened the file again. This is a newly installed OpenOffice. I had transferred the settings from my settings folder in Linux. It had a bad history list so I cleared it. So AOO had nothing in the history at all. I guess because it kept crashing it never had a chance to save the entry of the spreadsheet. So I saved and closed without doing anything. I opened it up. It had an entry for the file in the history and it’s fine now. At least for the time being.

11:47 am
It came back. I was working along okay for awhile. I filled up one column of the table and was experimenting. I hadn’t saved my work. Then I couldn’t paste into a cell. OpenOffice was not allowing me to paste. I tried hitting the paste command a couple of times in a row and then OpenOffice just disappeared. When it came back everything I had done was gone, of course, but when I started over the error had returned. I restarted AOO and instead of trying anything I just closed the spreadsheet. It was still on the history so I opened it up. The error still persisted. I had to recover, then close the file and exit out of AOO and restart it for the error to be gone.

I attached the file.
Attachments
Device Sizes.ODS
(16.48 KiB) Downloaded 130 times
Apache OpenOffice 4.1.5
User avatar
White Phoenix
 
Posts: 205
Joined: Tue Jan 01, 2008 7:10 am

Re: Fatal error Vector<T> too long

Postby datadog42 » Wed Feb 10, 2016 3:16 am

I am consistently experiencing the same "vector" problem switching to another sheet while editing a cell formula. OO 4.1.2 on Windows 7 64 bit.

The same spreadsheet works fine with OO 4.0.1 on OSX Yosemite 10.10.5.

Brought it back to the Windows/4.1.2 machine and it crashes again.


The "Total editing time" is 1,851 days. It only started having these problems recently.

I created a new spreadsheet with a different filename; copied all the sheets from the bad file into this one and it immediately crashed when I tried to switch to a different sheet while editing a cell formula.

wonder if I can go back to an earlier OO version?
OpenOffice 4.1.2 on Windows 7 and 4.0.1 on OS X
datadog42
 
Posts: 3
Joined: Thu Oct 23, 2014 12:47 am

Re: Fatal error Vector<T> too long

Postby White Phoenix » Wed Feb 10, 2016 4:25 am

I never thought of that. I keep all of my old versions of programs just in case I need to roll back. I can install 4.1.1 on my Windows 7 and keep Linux at 4.1.2. This will work (I think) until the problem in the latest AOO version is solved.
Apache OpenOffice 4.1.5
User avatar
White Phoenix
 
Posts: 205
Joined: Tue Jan 01, 2008 7:10 am

Re: Fatal error Vector<T> too long

Postby Martin.Flynn » Wed Feb 10, 2016 7:55 am

I've had this problem too. https://forum.openoffice.org/en/forum/v ... =9&t=76315
I'm now using Libre Office, mostly, and haven't experienced the same problem as yet.
Rip Van Apache Open Office 4.1.3 / Libre office 5.3.5.2 on Ms Windows 10
Martin.Flynn
Volunteer
 
Posts: 96
Joined: Wed Nov 28, 2007 7:52 pm
Location: Moray

Re: Fatal error Vector<T> too long

Postby drakebrimstone » Tue Mar 12, 2019 7:03 pm

I get this error on my Tablet (Surface Go) but not on my desktop (home built gaming PC). I can literally copy the file from the tablet to the desktop, do whatever I want with no crashes and transfer it back to my tablet and it will work fine unless I try to add a new cross sheet reference by clicking a tab while editing a cell.

I CAN add a cross sheet reference by manually typing the sheet name then the cell location. (Example: sheet2.A1)

I have tried coping all the sheets into a new file and get the same error.

I have reset my user profile

I get one of two errors each time this happens. Either the "Fatal error Vector<T> too long" error or an allocation error.
OpenOffice 4.1.5 on Windows 10 Home (Desktop) / OpenOffice 4.1.5 on Windows 10 Home (Surface Go)
drakebrimstone
 
Posts: 1
Joined: Tue Mar 12, 2019 6:56 pm


Return to Calc

Who is online

Users browsing this forum: KirkWard and 13 guests