Bug 76829 - libvisio: Numbers are "calculated" incorrectly (formatting)
Summary: libvisio: Numbers are "calculated" incorrectly (formatting)
Status: NEW
Alias: None
Product: Document Liberation Project
Classification: Unclassified
Component: libvisio (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:visio
Depends on:
Blocks: Visio
  Show dependency treegraph
 
Reported: 2014-03-31 11:23 UTC by Dennis Roczek
Modified: 2019-12-03 10:28 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
This is the display comparison between Microsoft's Visio Viewer and LibreOffice Draw (53.83 KB, image/png)
2014-03-31 11:24 UTC, Dennis Roczek
Details
"broken" vsd file (75.50 KB, application/visio.drawing)
2014-03-31 11:25 UTC, Dennis Roczek
Details
Dates are in wrong timeformat (157.50 KB, application/visio.drawing)
2014-04-08 10:27 UTC, Dennis Roczek
Details
Timeline.vsd comparison from Visio viewer and LibreOffice 6.2 (364.00 KB, image/png)
2019-07-01 17:50 UTC, Bartosz
Details
Timeline.vsd after conversion to .vdx. (777.69 KB, application/vnd.ms-visio.viewer)
2019-07-04 09:14 UTC, Bartosz
Details
Timeline with different datetime formats and screenshots (456.72 KB, application/zip)
2019-07-04 09:27 UTC, Bartosz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Roczek 2014-03-31 11:23:16 UTC
The attached Visio file (vsd) was downloaded from Microsoft including ~20 example Visio files. ( http://www.microsoft.com/en-us/download/details.aspx?id=24023 )

This file includes a page number in the "footer" of the page. In Draw it is displayed as 1.000 and 2.000 (German local settings), but it should be rendered as 1 and 2.

The Microsoft Visio Viewer from Microsoft displays it correctly (see next image upload in a few minutes).
Comment 1 Dennis Roczek 2014-03-31 11:24:31 UTC
Created attachment 96651 [details]
This is the display comparison between Microsoft's Visio Viewer and LibreOffice Draw
Comment 2 Dennis Roczek 2014-03-31 11:25:53 UTC
Created attachment 96652 [details]
"broken" vsd file

mmmh, bugzilla didn't uploaded the VSD file in the initial post.
Comment 3 Dennis Roczek 2014-04-03 08:57:00 UTC
The file https://bugs.freedesktop.org/attachment.cgi?id=96829 contains two times the problem:

a) page 1 of 1 
and b) direct left of that "MASSSTAB 1.000:1.000" --> should be "MASSSTAB 1:1"
Comment 4 Jorendc 2014-04-07 21:31:38 UTC
Reproducible, tested using Linux Mint 16 x64 with LibreOffice Version: 4.3.0.0.alpha0+
Build ID: d06cc9b52d3023f7b5aacb50bd48b06b9ffefbd3

Kind regards,
Joren
Comment 5 Dennis Roczek 2014-04-08 10:27:24 UTC
Created attachment 97068 [details]
Dates are in wrong timeformat

The dates (e.g.) 06/01/03 are displayed in my Visio Viewer as 01.06.2003. My localization is the latter one. 

Moreover many dates aren't displayed (also not under any other layer) direclty under the timeline. (new bug report?)
Comment 6 QA Administrators 2015-06-08 14:43:05 UTC Comment hidden (obsolete)
Comment 7 Dennis Roczek 2015-06-09 13:29:02 UTC
same problems, unchanged situation with LibO

Version: 4.4.3.2
Build-ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Gebietsschema: de_DE
Comment 8 Fridrich Strba 2016-01-15 11:41:36 UTC
All these numbers are Microsoft fields. They are either numeric or text fields. When they are text fields, we just output the text. For the numeric ones, we check whether they are dates/times and those we approximate with one of 3 ways to express date/time. For other numeric values, we just output them as doubles.
If someone has the time, we can accept patches for the function libvisio::VSDNumericField::getString in VSDFieldList.cpp:65 and following. It could be possible to approximate the different time-strings closer and then also output the different other numeric fields in the right numeric type.
Comment 9 Bartosz 2019-06-25 13:06:18 UTC
@Fridrich Strba
Do you know where I could find decription of the formats?
It will be very useful.
I found something like this:
https://blog.bvisual.net/2015/07/24/formatting-shape-data-in-visio/
but I don't know if it is relevant.

The Merge Request with the fix for this issue is available at:
https://gerrit.libreoffice.org/#/c/74677/
Comment 10 Bartosz 2019-06-30 07:59:12 UTC
It seems that for dates that doesn't appear, the issue is with default vaules are not displayed (0xffff):
  if (m_format == 0xffff)
    return librevenge::RVNGString();

After removing it, it is working correctly.

@dennisroczek Czould you please convert these examples to VSDX format?
Comment 11 Dennis Roczek 2019-06-30 15:04:21 UTC
Hi Bartosz,

I have a new computer and sadly no longer Visio. I will ask a colleague next week. Hopefully he still has access.

Best,

Dennis
Comment 12 Bartosz 2019-07-01 17:50:26 UTC
Created attachment 152491 [details]
Timeline.vsd comparison from Visio viewer and LibreOffice 6.2
Comment 13 Bartosz 2019-07-04 09:14:50 UTC
Created attachment 152553 [details]
Timeline.vsd after conversion to .vdx.
Comment 14 Bartosz 2019-07-04 09:27:02 UTC
Created attachment 152554 [details]
Timeline with different datetime formats and screenshots
Comment 16 Xisco Faulí 2019-12-03 10:28:59 UTC
Dear Bartosz,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assign it back to yourself if you're still working on this.