Error opening sheet with graphics made with PlanMaker LINUX in Windows Excel

Post your questions, bug reports and suggestions here for PlanMaker 2018 for Linux.

Moderator: SoftMaker Team

Post Reply
PRafael
Posts: 4
Joined: Sat Dec 08, 2018 6:34 pm

Error opening sheet with graphics made with PlanMaker LINUX in Windows Excel

Post by PRafael » Thu Sep 26, 2019 1:08 pm

Hi.

I'm working with PlanMaker Linux on a Brasilian Ubuntu based distro with last version and patches of Plan Maker Linux (Office 2018). I made some graphics in it and when I open the file in Windows Excel (version 2013), it gives the following errors (files attached) and wipes out all the graphics.

Please, feel free to ask if this isn't self explained. I'll try later to send a picture with the graphics

Edited: If I save the file as XLS the graphics are preserved and I can open them in Excel.

Regards

Paulo
Attachments
opening file.PNG
after response on opening file.PNG
Matriz de Documentos e sua Importância - TRABALHO.xlsx
(12.8 KiB) Downloaded 2 times

miguel-c
SoftMaker Team
SoftMaker Team
Posts: 325
Joined: Wed Jun 05, 2019 12:02 pm

Re: Error opening sheet with graphics made with PlanMaker LINUX in Windows Excel

Post by miguel-c » Sat Sep 28, 2019 5:49 pm

Hi, I opened the file you sent us in Excel (Windows) and PlanMaker (Ubuntu) and I didn't receive any warnings.
I also wasn't able to see any charts or drawings... Could you please send us the file with the issues?
Thanks,

PRafael
Posts: 4
Joined: Sat Dec 08, 2018 6:34 pm

Re: Error opening sheet with graphics made with PlanMaker LINUX in Windows Excel

Post by PRafael » Mon Sep 30, 2019 1:20 pm

Hi miguel-c.

Thank you for your replay. Attached you will find the file.

Regards

Paulo Rafael
Attachments
Matriz de Documentos e sua Importância - TRABALHO.xls
(167.5 KiB) Downloaded 1 time

miguel-c
SoftMaker Team
SoftMaker Team
Posts: 325
Joined: Wed Jun 05, 2019 12:02 pm

Re: Error opening sheet with graphics made with PlanMaker LINUX in Windows Excel

Post by miguel-c » Wed Oct 02, 2019 10:22 pm

Hi, on my Excel 2019 I get a warning: "You’ll get a warning: The reference is not valid. References for titles, values, sizes, or data labels must be a single cell, row, or column."
However, the graphics are displayed.

PRafael
Posts: 4
Joined: Sat Dec 08, 2018 6:34 pm

Re: Error opening sheet with graphics made with PlanMaker LINUX in Windows Excel

Post by PRafael » Thu Oct 03, 2019 12:40 pm

Thank you miguel-c for your information.

However as stated in the post I'm working with Excel 2013 and not Excel 2019. So, the problem remains...

Because I'm using a paid version, I should ask...what softmaker will do regarding the resolution of this issue?

Regards

Paulo Rafael

miguel-c
SoftMaker Team
SoftMaker Team
Posts: 325
Joined: Wed Jun 05, 2019 12:02 pm

Re: Error opening sheet with graphics made with PlanMaker LINUX in Windows Excel

Post by miguel-c » Thu Oct 03, 2019 12:51 pm

On the 'Graficos' sheet the third chart, starting at A45, edit the 'certificados' series has the source area ='Resumo Perguntas'!$J$2:$AO$11.
When we changed the reference to ='Resumo Perguntas'!$J$2:$J$11 then Excel doesn't complain about this chart any more.

Post Reply

Return to “PlanMaker 2018 for Linux”