Re: [sc-dev] color of tabs
Hello Kohei! Am 11.02.2009 16:48 schrieb Kohei Yoshida: But as I wrote I hope that in a future version (3.2?) tabs will have the same color like the heads of columns and rows. Can I ask why you want that color? Assuming that you are in GNOME (since you use Ubuntu), the color of the column/row headers are actually lighter than the color of the current unselected tabs. That makes it even harder to distinguish the selected and unselected tabs. For the record I had considered using that color first, but realized it was not the right solution because of that reason. Actually selected Tabs are white. But IMO these should have the same color as selected row/column headers resp. unselected tabs should have the same color as like as unselected row/column headers. For consistence. And for a better difference. And these colors come from the theme of the OS. Greetings, Mathias -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-8·-· - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] color of tabs
Am 05.02.2009 15:02 schrieb Kohei Yoshida: About the color difference between marked and unmarked sheet tabs, I did something for that not too long ago. http://www.openoffice.org/issues/show_bug.cgi?id=94452 The fix will appear in 3.1. I only did it for GTK themes because it was worse in GNOME while in KDE and Windows (not sure about Mac since I don't have one) marked and unmarked sheet tabs were easy to make out, at least to my eye. Yes I can see a little difference with m40. (Ubuntu 8.10) But as I wrote I hope that in a future version (3.2?) tabs will have the same color like the heads of columns and rows. Thank you! Mathias -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-8·-· - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
[sc-dev] color of tabs
Hello! I know that there is work to have tabs with different colors in calc. But i don't know if with this the big problem will be solved that it is difficult to see the difference between marked and unmarked sheets. In my opinion a marked tab should have the same colouring then the heads of marked columns and rows have. Could this be a (easy?) change for OOo 3.1? Greetings, Mathias -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-8·-· - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
[sc-dev] label and array formula
Hello! Should using labels work also in a array formula? Today it doesn't. E. g. having a column labelled 'Result'. =SUM('Result') works. But {=SUM('Result'0)} doesn't work. The results (error or 0) differs, if i insert label ranges (Insert\Names\Labels...) or not. Should i file a issue? I haven't find any related to this. Greetings Mathias -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-8·-· - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] New features about Data Filter
Hello! Am 07.12.2007 10:42 schrieb Thomas Benisch: 1.3 Change to AutoFilter popup list Let me annotate something to the wanted change of the autofilter behavior so it would work like in excel. http://specs.openoffice.org/calc/ease-of-use/AutoFilter_Behavior.odt Imagine that you have a big table with many columns and data rows. Now you set a autofilter in 3 or 5 columns. Which was the first that you have set? OK, you can remember it. But if you save the file and a other person want to work with it? The person must reset all autofilter columns to get all data visible. A other little example, only with 2 filter criteria. First you select Hamburg and want to get all data rows for Lehmann. OK. At second you want select all Hempel in Dresden. But there is no Hempel in Hamburg ... And now imagine, that you want to do this with many more columns ... It isn't a good idea always to have Excel as the only guide ... Greetings Mathias -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-8·-· - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] New features about Data Filter
Hello! Am 12.12.2007 20:59 schrieb Leonard Mada: 1.) I do not have a strong opinion on this. Somehow, I find autofiltering very limited and useful only in very simple situations, not on really big tables. (See my issue http://www.openoffice.org/issues/show_bug.cgi?id=66588 for a better solution. Thats why I basically have switched to MS Visual FoxPro for such situations - not an ideal solution.) Calc isn't and shouldn't be a RDBMS. So you have find out by yourself that a database is the better solution for you. So you can switch from FoxPro to Base. I don't know if Base supports FoxPro but any other type of database. What if the filter data that is not found, is grayed instead of hiding it completely? It's a possibility. But I prefer to see all values. The behaviour like Excel is good for users which knows the result before filtering. All other users don't know, why there are values hidden. If there is a empty result after the n-th autofilter, then *this* is the result. This is logical, and it is more logical then values that go missing. In my opinion it must be independent if one would find Hans and Meyer in New York and lives in a yellow house or all yellow houses in New York with a lodger Meyer, Hans. Simple users don't understand why they can't select New York if there are many Hans Meyer but no Hans *or* no Meyer in New York, especially if there are many Hans and many Meyer in New York but no Hans *and* Meyer. 2.) A big problem for autofilter are big tables, like with 50,000 rows. The user might have 10,000 entries and it becomes very impractical to search a value in the autofilter within this big list of entries. Some brainstorming is needed to solve this one (I am aggressively pointing to my previous issue). In my opinion your issue and autofilter are two different things. Another little example, only with 2 filter criteria. First you select Hamburg and want to get all data rows for Lehmann. OK. At second you want select all Hempel in Dresden. But there is no Hempel in Hamburg ... To make my point of view clear: Think about if there also no Lehmann in Hamburg ... This is a problem that many users have with Excel. And there is no way to reset *all* autofilter columns at once, or is there any (except to delete the autofilter)? There are many users which will not find any Hempel in Dresden if they got the sheet with active autofilter from anyone. Greetings Mathias -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-8·-· - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]