Graphs will not display.

Issues installing under the Mac OSX - X11 - Aqua

Graphs will not display.

Postby Fisha_G » Tue Feb 26, 2019 6:32 am

I have made spreadsheets on Open Office excel just last year and now they WILL NOT display if I send the file in. Please help I have an assignment due in a few days.
open office_4.1.3 on a MacBook Air
Fisha_G
 
Posts: 4
Joined: Tue Feb 26, 2019 6:24 am

Re: Graphs will not display.

Postby Zizi64 » Tue Feb 26, 2019 7:41 am

on Open Office excel

There is not such component in the AOO
The name of the Spreadsheet application is "Calc"

What a file type are you using? Always use the native, international standard ODF file formats - in this case the .ods one.
Can you upload a problematic sample file here? The file size limit is 128 KiB in this forum. You can share the larger files on a free file sharing service like the Google drive.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8147
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Graphs will not display.

Postby Fisha_G » Tue Feb 26, 2019 7:51 am

Thanks, lesson learned. To give you a short story. I have to create a graph onto a word doc. I did that but then when I sent it to myself, the graph would not appear. I do not see the option to save as ".ods" I have attached what I have. Hope you can see it.
Attachments
SSRD2.odt
(21.76 KiB) Downloaded 29 times
open office_4.1.3 on a MacBook Air
Fisha_G
 
Posts: 4
Joined: Tue Feb 26, 2019 6:24 am

Re: Graphs will not display.

Postby Zizi64 » Tue Feb 26, 2019 8:06 am

The attached .odt is not a spreadsheet file. I supposed, that you meant the Calc. The of the "word doc" component is Writer in the AOO. The .odt is a text document, but not "word doc".

The only one graph object in your sample file is appeared for me in my LO 6.1.5 and AOO 4.1.5 portable:

Graph_in_LO.png


Graph_in_AOO.png



Maybe you have uncheck (accidentally?) the option
Tools - Options - Open/LibreOffice - View - Graphics and objects
(The menu structure maybe is different on a MAC)
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8147
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Graphs will not display.

Postby Fisha_G » Tue Feb 26, 2019 8:19 am

Now it came up for you but same document would not open on my friend's computer. She has a HP. However, I tried to look for the graphics and objects button. NO LUCK. I will keep looking.
open office_4.1.3 on a MacBook Air
Fisha_G
 
Posts: 4
Joined: Tue Feb 26, 2019 6:24 am

Re: Graphs will not display.

Postby Zizi64 » Tue Feb 26, 2019 8:45 am

Now it came up for you but same document would not open on my friend's computer. She has a HP.

What a type and version of office suites has she installed (using)? How she tried to open the text document: by a click/double click on the filename/icon?
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8147
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Graphs will not display.

Postby Hagar Delest » Tue Feb 26, 2019 9:29 am

Under Windows 7 with AOO 4.1.5 portable, I can access your chart and the data (double-click it). It's a spreadsheet embedded in the text document.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).

Off-line until Aug. 31.
User avatar
Hagar Delest
Moderator
 
Posts: 28529
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Graphs will not display.

Postby Fisha_G » Wed Feb 27, 2019 1:41 am

Silly question but how do I update my current version of AOO? I have a MacBook Air
open office_4.1.3 on a MacBook Air
Fisha_G
 
Posts: 4
Joined: Tue Feb 26, 2019 6:24 am

Re: Graphs will not display.

Postby MrProgrammer » Wed Feb 27, 2019 5:11 am

Hi, and welcome to the forum.

Fisha_G wrote:how do I update my current version of AOO? I have a MacBook Air
[Tutorial] Mac FAQ Q04/A04 and Q03/A03

Zizi64 wrote:Tools - Options - Open/LibreOffice - View - Graphics and objects
(The menu structure maybe is different on a MAC)
Q00/A00

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3784
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Mac OSX

Who is online

Users browsing this forum: No registered users and 1 guest