[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

--- Comment #10 from supp...@think-cell.com ---
Created attachment 121954
  --> https://bugs.documentfoundation.org/attachment.cgi?id=121954=edit
pptx example file with think-cell chart and PowerPoint footer using  field

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

--- Comment #11 from supp...@think-cell.com ---
Hi,

This is Mario Vukelic from think-cell support. Thanks to Brent for bringing
this up.
We are very interested in LibreOffice displaying think-cell charts correctly,
so please let us know if we can help. We have made a note in our tracker as
#11739.
As Brent noted in comment #8, a fully functional think-cell trial version is
available at https://www.think-cell.com/trial or email us at
support(at)think-cell(dot)com.


A few fundamentals before I explain the issue:

* think-cell is a COM add-in for PowerPoint and Excel

* think-cell creates all its charts from native PowerPoint shapes and objects,
using the PowerPoint COM API. This means that PowerPoint users who do not have
think-cell installed can not only view but also edit the charts with plain
PowerPoint. The think-cell elements then appear as regular PowerPoint shapes
such as textboxes, PowerPoint shapes like rectangles or lines, and Microsoft
Graph objects.

* As far as LibreOffice is compatible with PowerPoint files, a chart created
with think-cell should therefore display the same in LibreOffice as a chart
created manually in PowerPoint by using the same objects via the UI. 

* The body of most think-cell charts (all except think-cell's Mekko and Gantt
chart types) is created with a Microsoft Graph object. To insert such a Graph
object with plain PowerPoint 2007 and later, click PowerPoint > Insert > Text >
Object > Microsoft Graph Chart. Graph was Office's standard chart engine up to
Office 2003 and is still included in current Office versions, incl. 2016. When
you doubleclick such a Graph object in plain PowerPoint 2007 and later, it asks
the "Do you want to convert this chart?" question, noted by raal in comment #6.
This is explained in think-cell KB0084 at
https://www.think-cell.com/en/support/kb/0084.shtml.
(The current think-cell v7 still uses Graph because it is the only editable
Office chart object that works in all PowerPoint versions, Office 2003 and
earlier as well as Office 2007 and later.)

* think-cell creates labels inside the Graph object where possible. In the
examples posted in this bug report these are the labels that show the correct
content in LibreOffice (though slightly off position).

* Using VBA, you can check if an object was created by think-cell as explained
in think-cell KB0073, https://www.think-cell.com/en/support/kb/0073.shtml


*** The issue observed by Brent ***

Labels that think-cell cannot create inside Graph (typically due to limitations
in Graph) are created as standalone PowerPoint textboxes containing OOXML 
fields. Plain PowerPoint itself uses  fields, e.g., for auto-updating
dates in the slide footer. To create an  field with PowerPoint:

1. Go to tab Insert, then click Text > Header & Footer.
2. In the Header & Footer dialog window, check "Date and time", choose "Update
automatically". To make the issue easy to spot, choose a format using day and
month names (not numbers).
3. Confirm with "Apply to All".
4. A footer with the date in the chosen format will appear on the slides.

I have attached an example file, created with PowerPoint 2013 (15.0.4787.1000)
and think-cell 7 (curent build 24146): "LibreOffice #97083 - think-cell
example.pptx". It contains:
1. A chart created by think-cell, plus a screenshot of how it looks in
PowerPoint (even if think-cell is not installed). 
2. An  date field as created by PowerPoint for its footer, plus a
screenshot of how it looks in PowerPoint.

In the example file, the date format chosen for the field in PowerPoint uses
day and month names.

It appears that the tested LibreOffice Version 5.0.4.2 (Build ID:
2b9802c1994aa0b7dc6079e128979269cf95bc78), does not correctly display 
fields, as all fields - including the one created by plain PowerPoint - show
the date in numbers, instead of the text that should replace it. 

 fields are described in section 21.1.2.2.4 of the Office Open XML File
Formats specification, Part 1, 4th edition (at ECMA-376 at
http://www.ecma-international.org/publications/standards/Ecma-376.htm), quote:

21.1.2.2.4 fld (Text Field)

This element specifies a text field which contains generated text that the
application should update periodically. Each piece of text when it is generated
is given a unique identification number that is used to refer to a specific
field. At the time of creation the text field indicates the kind of text that
should be used to update this field. This update type is used so that all
applications that did not create this text field can still know what kind of
text it should be updated with. Thus the new application can then attach an
update type to the text field id for continual updating.

[Example: Consider a slide within a presentation that needs to have the slide
number placed on the slide. The following DrawingML can be used to describe
such a 

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

brent.sof...@jivesoftware.com changed:

   What|Removed |Added

 Status|NEW |UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #8 from brent.sof...@jivesoftware.com ---
(In reply to raal from comment #7)
> These labels are not part of chart, just text boxes placed on the slide..

Please be advised that the end user is using Think-Cell to create these charts.
If you do not have Think-Cell installed on your test machine, this is the
reason that you are prompted to convert to a current chart type.

https://www.think-cell.com/en/  (I was able to secure a trial version by
filling out a form)

When testing on my machine, these are the steps I followed:

1. Download/Install Think-Cell
2. Open PowerPoint
3. Go to the "Insert" tab and select a "Stacked Chart" from the Think-Cell
"Elements" menu (see newly attached screenshot for reference).
4. Double-click chart to edit labels/values to whatever you want.
5. Save PPTX presentation.
6. Upload file in LibreOffice.

Once the PPTX is available for preview in LO, the issue is observable as the
labels are incorrect.

Charts created *without* Think-Cell display correctly. This issue persists only
with charts created via the steps outlined above. However, our end users employ
Think-Cell as their standard method for creating charts in PowerPoint.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

--- Comment #7 from raal  ---
These labels are not part of chart, just text boxes placed on the slide..

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

raal  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #6 from raal  ---
I can confirm with LO 5.2, win7 and powerpoint2010.
It's some kind of "old" type of chart, because when I double click on chart in
powerpoint2010, it says something like "do you want to convert chart into new
format?"  After this conversion I can see "Chart properties". But after resave
in powerpoint2010 is x and y axis still the same in LO.

Brent, is it problem only in Jive software or do you observe this also in
charts created from scratch in powerpoint?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

--- Comment #9 from brent.sof...@jivesoftware.com ---
Created attachment 121945
  --> https://bugs.documentfoundation.org/attachment.cgi?id=121945=edit
Think-Cell plugin for PowerPoint

This image is referenced in Comment 8
(https://bugs.documentfoundation.org/show_bug.cgi?id=97083#c8) and displays the
Think-Cell plugin working in PowerPoint after Think-Cell is installed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

raal  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||r...@post.cz
 Ever confirmed|0   |1

--- Comment #1 from raal  ---
Hello Brent,

Thank you for filing the bug. Please send us a sample document, as this makes
it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to
'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive
information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

--- Comment #2 from brent.sof...@jivesoftware.com ---
Created attachment 121901
  --> https://bugs.documentfoundation.org/attachment.cgi?id=121901=edit
Presentation for testing

This is a PPTX that has been created with a Think-Cell chart built into it.
Within PowerPoint, it displays correctly, but when uploaded to LibreOffice, it
previews incorrectly.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

--- Comment #3 from brent.sof...@jivesoftware.com ---
Created attachment 121902
  --> https://bugs.documentfoundation.org/attachment.cgi?id=121902=edit
TestPresentation.PPTX screenshot in PowerPoint

This is a screenshot of the test PPTX displayed correctly within PowerPoint

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

brent.sof...@jivesoftware.com changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #5 from brent.sof...@jivesoftware.com ---
I have uploaded the requested test slide deck for duplication, as well as
screenshots of my desktop as it appears in both PowerPoint and in LibreOffice.

As you can see, within PowerPoint, the labels are correct. Once previewed in
LO, some labels change to dates.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97083] Think-cell charts displayed improperly

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97083

--- Comment #4 from brent.sof...@jivesoftware.com ---
Created attachment 121903
  --> https://bugs.documentfoundation.org/attachment.cgi?id=121903=edit
TestPresentation.PPTX screenshot in LibreOffice (broken)

This is a screenshot of the Test PPTX previewed in LibreOffice with incorrect
labels.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs