inactive plots in calc are very badly visible (ultrabright white with light yellow letters/lines) when one works with dark background and bright grids and text (reverse constrast)... :(
try giving them colors similar to the colors used for active plots when one works with dark background and bright grid and text
Can you please attach a sample document so we can reproduce this behaviour? Looks like no one from the QA team ever did mark this bug as NEW. As far I know this bug report lacks some information.
Is this bug still reproducible with more recent versions of LibreOffice?
Created attachment 104902 [details]
overly bright default chart over dark background
here's a screen shot.
libre office Version: 18.104.22.168
so the problem is still there on aug.19th 2014
thanks for looking into this! :)
attachment 104902 [details] did not attach properly.
Please also attach a LibreOffice document with the problem.
Created attachment 110062 [details]
calc file with example
see attached calc file
Created attachment 110063 [details]
screen shot with example
Tools - Options - LibreOffice - Appearance:
General - Document bg: Black, Font color: Yellow
Spreadsheet - Grid lines: Yellow
With the above settings, the chart font does not turn yellow for me.
Setting to UNCONFIRMED.
Win 7 64-bit Version: 22.214.171.124.alpha0+
Build ID: b144f0ac8695dd62a2053b4e88212d0b109c9a41
TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-25_00:14:54
Ubuntu 14.10 64-bit Version: 126.96.36.199.alpha0+
Build ID: 6b219f012edbe069c461f4e0746898e33fa1dd49
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-25_21:56:46
the prob is the bright default color of the chart's background/etc colors that's too bright and defeats having chosen a dark working environment for the spreadsheet in general.
the ideal default is to let charts assume the background/etc working colors chosen for the spreadsheet (but have a "print" default with white background/dark letters/etc to avoid wasting ink/toner).
and the default should allow one to import charts into "impress" presentations in the colors chosen for the working environment of spreadsheet w/o additional steps.
(In reply to marc from comment #8)
> the prob is the bright default color of the chart's background/etc colors
> that's too bright and defeats having chosen a dark working environment for
> the spreadsheet in general.
> the ideal default is to let charts assume the background/etc working colors
> chosen for the spreadsheet (but have a "print" default with white
> background/dark letters/etc to avoid wasting ink/toner).
> and the default should allow one to import charts into "impress"
> presentations in the colors chosen for the working environment of
> spreadsheet w/o additional steps.
Would implementing the enhancement request that is bug 62925 "add "chart styles" to the styles of Calc" be enough for you? This way you could very fast apply dark styles to your charts or have dark as default. If yes, you can set this as RESOLVED DUPLICATE of said enhancement reqeust.
why not offer a "dark" switch that switches all LibreOffice applications to "dark mode", i.e., dark background, dark background non-work surfaces, bright characters, bright line-borders, etc?
that's how wXP and w7 do it but for the whole win session: e.g., you switch the wXP OS session to "dark theme" and then all applications switch to "dark" mode (night work= work in dark room).
now firefox in win7 also switches to adapt to a running "dark" win7 session...
this is super useful for night work (work in a dark room) and protects eyes and health (lowers cancer risk mediated by hormonal disruption caused by long exposure to bright light at night).
Ok, how about this scenario:
1) feature gets added for chart styling
2) the "choose themes" feature gets an overhaul as discussed in bug 77569 and bug 85998
This way you could have a pre-defined dark theme (currently selectable from View - Toolbars - Tools - Choose theme) and it would include a style for charts.
Try the example attachment 109080 [details] to see, how the themes work now.
that sounds great! :)
PS. below are some additional excel features that would be great to have in calc.
please consider implementing them.
- click on a chart to perimeter-highlight the data cells that are
plotted in that chart (calc does it already but...).
- drag the highlighted perimeter to an identically shaped range of
cells (which calc cannot do yet).
- click on a set of specific points in a chart (e.g., x,y scatter) to
so allow one to
i) perimeter-highlight the involved range(s) of data cells and
ii) drag the perimeter (or a subset therein, e.g., only the cells
with the X values) to another range of the same shape.
- allow clicking on an element of a chart (e.g., X axis) in order to
edit it via say "cntrl + 1" and/or via double-clicking to open the
edit menu for that specific chart element.
Created attachment 110221 [details]
screen shot with chart after changing theme
Ok, good. I'm closing this as RESOLVED INVALID (for lack of a better status :)). I hope you don't mind.
You might want to add yourself to the CC list of bug 62925, bug 77569 and bug 85998 so you will be notified of progress.
Note that German and Swiss cities and institutions are funding the development of the chart style feature as mentioned in bug 62925.
Please create separate enhancement requests for your Excel-style feature suggestions.
You could first do a review of chart-related enhancement request to see, if there are any duplicates to your suggestions: https://bugs.freedesktop.org/buglist.cgi?bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bug_status=NEEDINFO&component=Chart&f1=bug_severity&list_id=499478&o1=substring&product=LibreOffice&query_format=advanced&v1=enhancement
Created attachment 110223 [details]
chart after choosing dark theme....
sorry but my last posting mis-fired:
i tried your "View - Toolbars - Tools - Choose theme" solution" but is does not work:
the chart remains bright with any theme i tried and does not adapt to dark ones... :(
see two previous attachments before this
(In reply to marc from comment #16)
> sorry but my last posting mis-fired:
> i tried your "View - Toolbars - Tools - Choose theme" solution" but is does
> not work:
> the chart remains bright with any theme i tried and does not adapt to dark
> ones... :(
It's not a solution that works currently. It would work in conjunction with the enhancement that will allow styles to be applied to charts. The "choose theme" feature itself is in need of a total rewrite from Basic to C++ as can be read from the report.
I'm just trying to not grow the mountain of feature requests too much (over 2000 currently) - if your wish could be achieved with the two enhancements I linked to, we would not have to add a third one to the pile. I know that the underlying implementation is different: you started with a request related to the display style and I'm offering a solution that would style the document itself.
If my suggestion is not satisfactory, you can set this report to UNCONFIRMED and adjust the title based on what you said in comment 10. I can then ping the design team so we will know what they think about it.
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.
For more information about our NEEDINFO policy please read the wiki located here:
If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
This NEEDINFO message was generated on: 2015-09-03
problem remains identical. I am still changing manually the bright background to a darker one each time i insert a new chart from scratch and i am working with a dark background at night. (actually i stopped working non-dark during the day since the switch is a terrible hassle) :(
excel2003 switches all the default elements of the chart to adapt to the working theme's darkness: if you switch winXP to dark theme all black lines/numbers/etc in excel2003 become white and if the theme switches back to bright then all white lines/numbers/etc become black...
(In reply to marc from comment #19)
> problem remains identical. I am still changing manually the bright
> background to a darker one each time i insert a new chart from scratch and i
> am working with a dark background at night. (actually i stopped working
> non-dark during the day since the switch is a terrible hassle) :(
> excel2003 switches all the default elements of the chart to adapt to the
> working theme's darkness: if you switch winXP to dark theme all black
> lines/numbers/etc in excel2003 become white and if the theme switches back
> to bright then all white lines/numbers/etc become black...
Please respond to my comment 17.
yes, please pass the request to the design team that they come up with a switch to set the whole of a libreoffice session to dark mode to protect the health of people who work at night or in dark rooms.
PS. it would be nice if the whole xubuntu/linux/etc session could be switched to dark mode as macOS, winXP and later, allow one to do for night work.
What say you, ux guys?
Themes belong to the OS. LO should respect the user settings and not override it. That means I'd rather provide system colors like clBackGround, clBtnForm, clWindow etc. than toggeling sessions between something not well defined.
However, it's a different discussion when we talk about chart styles. In the next release we will get the cell styles in Calc. So why not style charts?
Yes by default libreoffice should look similar to the operating system it is run on, but we should also provide some application theme presets that users can choose from which would work better than the firefox personas.
so which is the final status of this issue? NEW or not?
(In reply to tommy27 from comment #25)
> so which is the final status of this issue? NEW or not?
If we want to assign this bug to be linked to the GSoC application themes proposal, then definitely it can be set to NEW and the title should be changed to something like 'LibreOffice UI themes'.
The ability to set the UI theme should be in Tools > Options > Personalization.
let's do it that way then.
*** Bug 103668 has been marked as a duplicate of this bug. ***
*** Bug 116035 has been marked as a duplicate of this bug. ***