Bug 42191 - Calc chart UI functionality request: Add option to Chart wizard for treat cell content as text in column captions
Summary: Calc chart UI functionality request: Add option to Chart wizard for treat cel...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version: 3.3.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-25 01:07 UTC by Edoardo Panfili
Modified: 2012-04-18 05:46 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
data as number (41.00 KB, image/jpeg)
2011-10-25 01:07 UTC, Edoardo Panfili 		Details
columns badly spaced (41.90 KB, image/jpeg)
2011-10-25 01:09 UTC, Edoardo Panfili 		Details
A demo sheet (19.47 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-04-17 23:48 UTC, Edoardo Panfili 		Details
View All

Description Edoardo Panfili 2011-10-25 01:07:12 UTC 
Created attachment 52728 [details]
data as number

If I use the date format "dd/mm/yyyy" the column labels are numbers, If Y use another date format "dd month yy" the olumns are spaced in a "time delay" way.

Please see attached photo, if can help I can post my document

I saved the file, then opened it using openoffice.org 3.3, it works as espected.
Comment 1 Edoardo Panfili 2011-10-25 01:09:53 UTC 
Created attachment 52729 [details]
columns badly spaced
Comment 2 Edoardo Panfili 2011-10-25 01:11:42 UTC 
The problem is not always reproducible, the data comes as copy from anothe sheet in the same document.
Comment 3 sasha.libreoffice 2012-04-17 02:09:08 UTC 
Thanks for bugreport
Please, attach document that demonstrates this problem
Comment 4 Edoardo Panfili 2012-04-17 23:48:22 UTC 
Created attachment 60233 [details]
A demo sheet
Comment 5 Edoardo Panfili 2012-04-17 23:50:09 UTC 
Maybe that this is a feature, if so, please close this bug.
Comment 6 sasha.libreoffice 2012-04-18 04:20:52 UTC 
Thanks for attachment
What about different distance between columns, it is feature. To disable this behaviour in attachment select cell B1, place apostrophe in beginning, for contents becomes so:
'15.07.2010
distance between columns will become equal.
IMHO bug is in another: why diagram wizard not asked, which variant of behaviour needed for us. There should be option or checkmark(on/off field) or warning text

What about date as numbers: can not reproduce. If still reproducible, please, attach another document with this bug.
Comment 7 Edoardo Panfili 2012-04-18 04:27:10 UTC 
(In reply to comment #6)
> Thanks for attachment
> What about different distance between columns, it is feature. To disable this
> behaviour in attachment select cell B1, place apostrophe in beginning, for
> contents becomes so:
> '15.07.2010
> distance between columns will become equal.
yes, at this point the dates are treated as text and all works fine.


> IMHO bug is in another: why diagram wizard not asked, which variant of
> behaviour needed for us. There should be option or checkmark(on/off field) or
> warning text
I agree.

 
> What about date as numbers: can not reproduce. If still reproducible, please,
> attach another document with this bug.
No, this is no more reproducible.
Comment 8 sasha.libreoffice 2012-04-18 05:46:09 UTC 
When meaning of cells is ambiguous, as shown in previous comments, should appear additional option in Chart wizard. Or at least warning.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.