spreadsheet red lines in rows

[Jmadero]

I am using Ubuntu Gutsy Gibbon and have found a very odd problem in Open Office Spreadsheet. I think the problem is only happening when I am working on some of my larger spreadsheets for work (1-10k rows + 10-30 columns). The problem is that red lines appear in some rows despite there not being a strike through or anything like that. I check the same exact file in OpenOffice Windows release and MS Office in XP and there are no lines. Furthermore when I print the rows no red line appears. Here is a screenshot of what I am talking about:

http://i130.photobucket.com/albums/p247/jmadero/openofficecalcproblem.jpg?t=1202714535

I am using the newest release of OO that came from the repositories.

[Chris Cheney (ccheney)]

Is there version of openoffice.org that you are using 1:2.3.0-1ubuntu5.3 available through gutsy-updates? Also can you attach an example document with the problem and/or generate one that shows the problem that does not have any private information in it?

Thanks,

Chris Cheney

[Jmadero (jmadero)]

I have version 2.3.0 installed right now (went to writer and about open office). As far as I know this is the latest version you can get through any of the common (and some not so common) repos that I have on my computer. As far as uploading a file, unfortunately I can't do this without permissions as I do research for a university that may not want me to upload data sets in full. The best I can do are small screenshots like the one above. I tried to alter the file that came from to upload it and in the process found some very interesting patterns:

1. If I delete enough rows the red lines dissapear (data set I currently have that has the red lines has 5400 rows, columns A-CN)
2. If I delete enough columns the same thing happens
3. When I unhide columns the red lines dissapear

The last one has actually made this less of an annoying issue as I can unhide and then rehide and it seems to fix the problem....but none the less the issue exists. Thanks for the hard work with Open Office and all other open source software.