Author Topic: OpenOffice Spreadsheet charts  (Read 1135 times)

Neil Waldhauer

  • Hero Member
  • *****
  • Thank You
  • -Given: 14
  • -Receive: 57
  • Posts: 728
  • Karma: +13/-0
    • View Profile
    • Blonde Guy
OpenOffice Spreadsheet charts
« on: January 17, 2021, 06:01:02 pm »
Starting with version 4.1.8, charts seem to vanish in the following scenario.

1. Edit the chart
2. Save the spreadsheet in .ODS format
3. Close Open Office
4. Open the spreadsheet; the chart is gone

A potential workaround is to save in .XLS format instead

I opened a bug report as described in the readme. Thanks to all who helped me get an account to report this.

https://bz.apache.org/ooo/show_bug.cgi?id=128427
« Last Edit: February 04, 2021, 03:29:40 am by Neil Waldhauer »
Expert consulting for ArcaOS, OS/2 and eComStation
http://www.blondeguy.com

Doug Bissett

  • Hero Member
  • *****
  • Thank You
  • -Given: 1
  • -Receive: 62
  • Posts: 1459
  • Karma: +2/-2
    • View Profile
Re: OpenOffice Spreadsheet charts
« Reply #1 on: January 17, 2021, 06:48:45 pm »
Quote
Starting with version 4.1.8, charts seem to vanish in the following scenario.

I see that too. I did some research, and found that the OS/2 version fails to save the chart. If I do exactly the same thing in windows AOO 4.1.8, it does what it is supposed to do. I can then open the sheet in OS/2, and the chart is there. If I then close, with save, and open it again, it is gone. Actually that isn't quite right, because there is a small blank spot where the chart should be. The chart is gone in windows too.

I haven't had the time to try to report this. I do remember reporting something a couple of years ago, and it took hours to work through the reporting procedure. FWIW, there is a report that describes the problem. It was dismissed as being an invalid chart setup (obviously wrong, but I haven't looked recently so there may be more).

Never thought about saving as .XLS. I will try that. At least it is a work around. Thanks...

Ian Manners

  • Global Moderator
  • Sr. Member
  • *****
  • Thank You
  • -Given: 51
  • -Receive: 32
  • Posts: 410
  • Karma: +5/-0
  • I am the computer, it is me.
    • View Profile
    • ComKal Networks Australia
Re: OpenOffice Spreadsheet charts
« Reply #2 on: January 18, 2021, 11:26:49 am »
Have not used the spreadsheets since upgrading AOO to v4.1.8, just opened up my spam stats, no changes made to the charts or the chart data but I did add a note to a separate column, saved the spreadsheet, exited, then opened that spreadsheet again and the charts are gone, just a blank space on each page.
So.. the problem is easy to verify.

Glad everything is backed up!
« Last Edit: January 18, 2021, 11:28:24 am by Ian Manners »
Cheers
Ian B Manners

Neil Waldhauer

  • Hero Member
  • *****
  • Thank You
  • -Given: 14
  • -Receive: 57
  • Posts: 728
  • Karma: +13/-0
    • View Profile
    • Blonde Guy
Re: OpenOffice Spreadsheet charts
« Reply #3 on: February 04, 2021, 03:29:59 am »
I opened a bug report as described in the readme. Thanks to all who helped me get an account to report this.

https://bz.apache.org/ooo/show_bug.cgi?id=128427
Expert consulting for ArcaOS, OS/2 and eComStation
http://www.blondeguy.com

Matthias Seidel

  • Newbie
  • *
  • Thank You
  • -Given: 2
  • -Receive: 0
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: OpenOffice Spreadsheet charts
« Reply #4 on: February 04, 2021, 10:56:30 pm »
Hi Neil,

Thank you for the report!

Could you please have a look at:
https://bz.apache.org/ooo/show_bug.cgi?id=128426

Although this is for macOS it sounds similar.
Fortunately it could be solved with a rebuild on macOS, so maybe Yuri can do some tests with the (soon to be released on Windows, macOS, Linux) version 4.1.9 of Apache OpenOffice.

Neil Waldhauer

  • Hero Member
  • *****
  • Thank You
  • -Given: 14
  • -Receive: 57
  • Posts: 728
  • Karma: +13/-0
    • View Profile
    • Blonde Guy
Re: OpenOffice Spreadsheet charts
« Reply #5 on: February 05, 2021, 05:02:27 am »
I don't have a Mac available to test, but the description seems to match the problem I see on ArcaOS.
Expert consulting for ArcaOS, OS/2 and eComStation
http://www.blondeguy.com

Matthias Seidel

  • Newbie
  • *
  • Thank You
  • -Given: 2
  • -Receive: 0
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: OpenOffice Spreadsheet charts
« Reply #6 on: February 08, 2021, 05:54:21 pm »
Hi Neil,

Yes, it sounds similar.

Fortunately, this issue could be fixed with a rebuild and didn't need code changes.
Maybe Yuri can try different compiler switches? AOO 4.1.9 was released yesterday.

Regards,
   Matthias

David McKenna

  • Sr. Member
  • ****
  • Thank You
  • -Given: 13
  • -Receive: 26
  • Posts: 349
  • Karma: +15/-0
    • View Profile
Re: OpenOffice Spreadsheet charts
« Reply #7 on: February 08, 2021, 07:55:30 pm »
 I recently updated libicu to version 68 (to try the QTWebtest browser) and am now getting crashes in OpenOffice 4.1.8 - anyone else see this? The Quickstart almost always crashes at boot, and going to 'Tools->Options' always crashes...

TeLLie

  • Full Member
  • ***
  • Thank You
  • -Given: 0
  • -Receive: 10
  • Posts: 116
  • Karma: +3/-0
    • View Profile
Re: OpenOffice Spreadsheet charts
« Reply #8 on: February 08, 2021, 08:31:24 pm »
Hi David,
Yes i had this to.
I did some debugging with Silvan about this.
Seems the i18npool.dll is the cullpit

But when you copy the dll's from v65 back to the OO /program dir, the crashes are gone.
Or go back to v0.65


David McKenna

  • Sr. Member
  • ****
  • Thank You
  • -Given: 13
  • -Receive: 26
  • Posts: 349
  • Karma: +15/-0
    • View Profile
Re: OpenOffice Spreadsheet charts
« Reply #9 on: February 08, 2021, 09:54:58 pm »
 Hi Tellie

  OK, then it's not just my system. I was going to report it, but I guess Silvan already knows. I have gone back to version 65 and it works fine that way, thanks.

Regards,
« Last Edit: February 09, 2021, 12:20:04 am by David McKenna »