Bug 42191 - Add option to Chart wizard to treat cell content as text in column captions
Summary: Add option to Chart wizard to treat cell content as text in column captions
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
3.3.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Wizard
  Show dependency tree / graph
 
Reported: 2011-10-25 01:07 UTC by Edoardo Panfili
Modified: 2024-09-10 07:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

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 Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.
Comment 9 Buovjaga 2021-02-11 08:18:07 UTC 
(In reply to sasha.libreoffice from comment #6)
> 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


(In reply to sasha.libreoffice from comment #8)
> When meaning of cells is ambiguous, as shown in previous comments, should
> appear additional option in Chart wizard. Or at least warning.

Asking design team to evaluate this and think about concrete implementation.
Comment 10 Heiko Tietze 2021-02-11 11:13:34 UTC 
Don't see any ambiguity here. If cells are text, the chart will use sequential numbers for the axis. Date is a representation of a number and large steps between produce gaps. => NAB
Comment 11 Milton Wall 2024-09-10 06:51:21 UTC 
I don't see any room for doubt here. The chart's axis will be consecutive numbers if any of the cells include text. A date is a numerical representation with significant steps in between creating gaps. => NAB ( https://solarsmash.co )