OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Calc dates wrong?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
TaurusOoo
General User
General User


Joined: 23 Feb 2012
Posts: 5

PostPosted: Fri Jun 08, 2012 12:19 pm    Post subject: Calc dates wrong? Reply with quote

Here is the problem, I'll use pictures to describe it:





Data range for dates is B4 to M4. There are 12 different dates total. But when I check the Chart for this data, there are dates that I have not inserted, for example 06.06.2012. Can anyone help?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Jun 09, 2012 1:01 am    Post subject: Reply with quote

I doubt that you can build a proper chart from this cross-table layout. This is too complex to process. Use a most simple table such as:

Date | Name | Value

which allows you to use dozends of tools for data analysis and charting.
For instance Calc can generate a cross-table from this list and show calculation results by weeks, months, quarters, years, names.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
TaurusOoo
General User
General User


Joined: 23 Feb 2012
Posts: 5

PostPosted: Thu Jun 14, 2012 8:00 am    Post subject: Reply with quote

Little update to this problem:

This happens with OO 3.4 but with OO build 3.3 the chart dates are right.

So back to 3.3 it is then.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Fri Jun 15, 2012 6:20 am    Post subject: Reply with quote

And the developers don't have any chance to fix the problem unless YOU don't report anything.
https://issues.apache.org/ooo/
register, report new issue, attach a simple file demonstrating the issue.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
TaurusOoo
General User
General User


Joined: 23 Feb 2012
Posts: 5

PostPosted: Fri Jun 15, 2012 10:57 am    Post subject: Reply with quote

Villeroy wrote:
And the developers don't have any chance to fix the problem unless YOU don't report anything.
https://issues.apache.org/ooo/
register, report new issue, attach a simple file demonstrating the issue.

Thanks, reported!
Back to top
View user's profile Send private message
regina
General User
General User


Joined: 24 Jul 2005
Posts: 17

PostPosted: Fri Jun 15, 2012 11:15 am    Post subject: Reply with quote

Set the scale type for the x-Axis to "Text".
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group