Bug 108901 - enhancement: when logarithmic axis, additional number format 10^1...
Summary: enhancement: when logarithmic axis, additional number format 10^1...
Status: RESOLVED DUPLICATE of bug 39052
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: https://de.mathworks.com/matlabcentra...
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2017-07-02 14:37 UTC by lur78tbfhpw
Modified: 2017-12-26 23:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description lur78tbfhpw 2017-07-02 14:37:24 UTC
Description:
in calc-> chart -> edit -> format axis -> numbers
additional Category/Format, similar to scientific but with actual superscripted exponent

That would be neat!!
Thank you :)

Actual Results:  
-

Expected Results:
-


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:54.0) Gecko/20100101 Firefox/54.0
Comment 1 Xisco Faulí 2017-12-26 07:17:25 UTC
I guess we can close this as a dupe of bug 39052 as the ideal solution would be to add the whole formatting dialog.
For the time being, there's a workaround for your problem: https://ask.libreoffice.org/en/question/72370/how-can-i-add-superscriptsubscript-in-chart-calc/

*** This bug has been marked as a duplicate of bug 39052 ***
Comment 2 Francisco 2017-12-26 23:54:23 UTC
(In reply to Xisco Faulí from comment #1)
> I guess we can close this as a dupe of bug 39052 as the ideal solution would
> be to add the whole formatting dialog.
> For the time being, there's a workaround for your problem:
> https://ask.libreoffice.org/en/question/72370/how-can-i-add-
> superscriptsubscript-in-chart-calc/
> 
> *** This bug has been marked as a duplicate of bug 39052 ***

Xisco:

I doubt that what Lur is asking it's actually not possible. He's talking about the numeric formatting of the axis number, which is different from the character formatting of the chart and axis titles.

As far as I understand he's talking about the real formatting of an exponential number: 1×10^3 instead of 1E3.
That isn't actually an available formatting for cell numbers (maybe with a complex custom numeric format which I haven't been able to do yet).
So, what he asks is that, with a log scale, the axis number should pass from:

1E0	1E1	1E2	1E3

to

1	10	10^2	10^3

that is a completely different from the individual character formatting of the axis and chart titles.

I really suggest to eliminate the duplicate label in this case.