[libreoffice-users] [CALC] row_only and column_only cell references

2013-10-12 Thread Ady
software. If there is a better place (mailing list, irc, forum,...) to ask this question, please let me know. TIA, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more

[libreoffice-users] Retrieve a specific message from the ML

2013-10-13 Thread Ady
to retrieve, but have not received an answer. If the msg number would be, say, 12345, is users+get-12...@global.libreoffice.org the correct address? Or, am I doing something wrong? TIA, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Re: Retrieve a specific message from the ML

2013-10-13 Thread Ady
Am 13.10.2013 20:24, schrieb Ady: Hello, I am trying to retrieve a specific message from the mailing list (so to reply to it), by sending an empty message to users+ge...@global.libreoffice.org as per the help from users+h...@global.libreoffice.org . I have already sent

Re: [libreoffice-users] [CALC] row_only and column_only cell references

2013-10-14 Thread Ady
On 10/12/2013 07:55 AM, Ady wrote: Hello, I've been having problems with certain type of *references* in Calc. For example, the formula sum(1:2) works correctly in other spreadsheet software, but it errors in Calc. I was not aware that you could do that in any product

Re: [libreoffice-users] [CALC] row_only and column_only cell references

2013-10-14 Thread Ady
it. Of course there might be technical / development reasons, but this is a *users* mailing list :). So, I left with several questions here. Hopefully, someone has some answer(s) or can point into the right direction? TIA, Ady. -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Retrieve a specific message from the ML

2013-10-14 Thread Ady
On 13/10/2013, Ady ady...@hotmail.com wrote: Hello, I am trying to retrieve a specific message from the mailing list (so to reply to it), by sending an empty message to users+ge...@global.libreoffice.org as per the help from users+h...@global.libreoffice.org . I have

Re: [libreoffice-users] LO 4.1.2 Hebrew parentheses bug

2013-10-16 Thread Ady
to HE-HE, OK. I am not sure which behavior should be exactly the adequate one, specially when I see that changing the CTL settings between Visual and logical doesn't seem to affect the result. In any case, this seems to be a bug and should be reported. Regards, Ady. -- To unsubscribe e-mail

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

2013-10-20 Thread Ady
Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global

Re: [libreoffice-users] Calc - avoiding circular references

2013-10-22 Thread Ady
references too (e.g. =A2+1 ; =A3+1; ... ) Whether case B would also copy the entire first cell (including formatting) into the rest of the selected range would be something to consider if/when such shortcut gets to be considered for development in Calc. Regards, Ady. -- To unsubscribe e-mail

Re: [libreoffice-users] [CALC] Detective Trace inadequate display

2013-10-26 Thread Ady
behaviors because it is already crippled anyway). Thank you and Best Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] [CALC] Detective Trace inadequate display

2013-10-27 Thread Ady
Dnia 2013-10-26, o godz. 12:42:10 Ady ady...@hotmail.com napisal(a): Bug report #70886 opened: https://bugs.freedesktop.org/show_bug.cgi?id=70886 Confirmed, added bibisect log. It's now up to developers to pick up challenge and fix that issue. I disagree. The Detective feature

Re: [libreoffice-users] Open odt file in Internet Explorer

2013-11-05 Thread Ady
Hi, I'm in a Citrix environment. When a user clicks an odt link file in IE9 he gets an error message saying that the option -Embedded was not found. The file is stored on a local drive. However when it's a .docx file Swriter.exe opens correctly. One other strange thing if I change the file

Re: [libreoffice-users] font drop-down menu list issue.

2013-11-08 Thread Ady
only the first letter of the font name and wait; the field will be empty again after approximately one second). Hopefully this procedure helps to replicate the issue. Thanks and Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
/ automatic way. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
this simple conversion more complicated than necessary. I wonder if this should be reported as a bug / enhancement, so the behavior is changed / improved. Any comment from Calc developers would be really appreciated. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
mark. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users

Re: [libreoffice-users] CALC convert text to numbers

2013-11-10 Thread Ady
with paste special? To be clear, I'm not complaining, just posting my thoughts. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Engaging users: initial results of the survey

2013-11-10 Thread Ady
of these changes would be the most effective use of man-power, so I'm not going to call these recommendations. These might be potential considerations for potential improvements. Whether they are _effective_ use of man-power, I don't really know. Thank you and Best Regards, Ady. -- To unsubscribe e-mail

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-13 Thread Ady
copy the numbers from the cells with the formulas it works fine. So now I'm confused, if this *does* work, why was Ady complaining about it not working? -- Well, the procedure I mentioned involves copying one cell only, which means it is a faster method, as oppose to having to copy perhaps

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Ady
term would be for this case). When other issues regarding paste (and/or paste special) get to be resolved, perhaps then this issue will get improved too. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Ady
a few seconds and _less_ than 10 clicks. Regarding including the extension as standard, I hope the devs are using their valuable time to take care of features that _really_ have _no alternative_ in Calc. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Ady
Hi Ady, On Thu, 14 Nov 2013 15:45:33 +0200 Ady ady...@hotmail.com wrote: On one hand, this method is effective, efficient and well-known in several other spreadsheet programs, and for users that already know it, it seems at least strange that LO Calc doesn't support it. I'm still

Re: [libreoffice-users] Re: [Calc] Relative references behavior for worksheets

2015-04-22 Thread Ady
the other way around. I hope I am explaining my point clearer now. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

[libreoffice-users] [Calc] Relative references behavior for worksheets

2015-04-22 Thread Ady
/ scenarios / OSes. Other comments are also welcome, of course. The following is the text of the bug report I was about to file in. Apologies for its length; I have seen too many of these problems already and I want to explain the problem (and its solution) as clear as possible. TIA, Ady

Re: [libreoffice-users] Re: [Calc] Relative references behavior for worksheets

2015-04-22 Thread Ady
to formula wizards / assistance and mouse (click, drag, select, fill...). For some users, this is especially relevant when using complex long formulas involving multiple sheets, multiple ranges of cells, or multiple cells, as it reduces the chances of typos. Regards, Ady. -- To unsubscribe e-mail

Re: [libreoffice-users] Re: [Calc] Relative references behavior for worksheets

2015-04-22 Thread Ady
, it is an inadequate default behavior, but it is not a complete bug, but close to it :). Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Re: [Calc] Relative references behavior for worksheets

2015-04-22 Thread Ady
seeing, I would really appreciate receiving feedback about it, because it would mean that I could change the default behavior in my own setup, without waiting for developers to do anything. Thank you in advance, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

[libreoffice-users] Measure speed of formulas in Calc

2023-01-03 Thread ady
of (ranges of) formulas for usage in Calc, perhaps a developer might be willing to review some of the methods / code that has been posted for years for excel and check what makes it fail in Calc, or perhaps develop something new for Calc. TIA, Ady. -- To unsubscribe e-mail to: user

Re: [libreoffice-users] Limits in Calc

2023-01-12 Thread ady
See this faq: https://wiki.documentfoundation.org/Faq/Calc/022 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] Add word to the dictionnary/corrector

2023-03-10 Thread ady
See: https://wiki.documentfoundation.org/Development/Dictionaries On Thu, Mar 9, 2023 at 11:52 AM Scriptance wrote: > > Hi > > I'm trying to add words to the global dictionnary and the spell checker but I > can only add to my own version of LibreOffice despite I try to add them to > all the

Re: [libreoffice-users] Function acting on range

2023-03-16 Thread ady
out as described, in multiple sheets. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: ht

Re: [libreoffice-users] Function acting on range

2023-03-16 Thread ady
to use ABS() in each sheet (as normal or as CSE), and then you can use AVERAGE() as a 3D formula, whether with [ENTER] alone or with CSE, depending on the specific case. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.or

Re: [libreoffice-users] Function acting on range

2023-03-17 Thread ady
ame as array formulas. _ There are alternative ways to resolve this, but *with the layout as presented*, Steve's initial assumption was correct. ABS() expects one cell (or value) as argument, while AVERAGE() can be used as intended. My apologies again for adding to the confusion. Best regards, Ady. -- To unsubsc

Re: [libreoffice-users] LibreOffice 7.3.7.2

2023-03-16 Thread ady
In Writer, go to menu Tools > Options > Language Settings > Writing Aids. Is the dictionary of the specific language listed and checked "on"? In the same Language Settings dialog, are the relevant options checked "on"? "How to install extra dictionaries?"

Re: [libreoffice-users] Function acting on range

2023-03-18 Thread ady
rksheets should not be used by inexperienced users, and it should only be used for specific purposes, not as a norm. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelin

Re: [libreoffice-users] Libre Office version 7.4.5.1 (x64)

2023-02-23 Thread ady
I would suggest "installing" the portable package, version 7.4.3. You close LibreOffice, download the aforementioned portable package to some folder and "install" it in some easy directory/folder. Please note that the "install" directory must be different than the folder where you downloaded the

Re: [libreoffice-users] [libreoffice] Tool Bar Changed

2023-03-31 Thread ady
> Under View .. I dont those options. > Which menu are you under? You are probably not looking at the menu but at the toolbar. The _menu_ named "View" has the User Interface options to choose from. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Possible formatting but in calc.

2023-02-10 Thread ady
On Fri, Feb 10, 2023 at 1:47 PM Johnny Rosenberg wrote: > > should be reported as a bug. > I think it should. Then it's up to the developers to decide whether or not > to do something about it. Maybe it could be set to low priority, though. I agree. I already opened a new bug report for it. I

Re: [libreoffice-users] Possible formatting but in calc.

2023-02-07 Thread ady
If there is at least one space character _after_ the AND function, then each edition of the formula adds one space character _before_ AND. After several editions, you end up with the same one space character after AND, but several space characters before it. This behavior happens even when the

Re: [libreoffice-users] Possible formatting but in calc.

2023-02-10 Thread ady
> If there is at least one space character _after_ the AND function, > then each edition of the formula adds one space character _before_ > AND. > > After several editions, you end up with the same one space character > after AND, but several space characters before it. > > This behavior happens

Re: [libreoffice-users] LibreCalc error found, need help

2023-12-25 Thread ady
with current versions. Now, if you want to _delete_ the contents of those non-adjacent rows, or the rows themselves, then those actions are indeed possible. HTH, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mail

Re: [libreoffice-users] Problem with using mouse scroll wheel on Mac

2024-01-09 Thread ady
I guess that: https://bugs.documentfoundation.org/show_bug.cgi?id=155266 describes something of that sort (ATM set as fixed and verified). I would suggest trying with LO 7.5.9, or 7.6.4, or with the newest pre-release. HTH, Ady. -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Problem with using mouse scroll wheel on Mac

2024-01-09 Thread ady
> I would suggest trying with LO 7.5.9, or 7.6.4, or with the newest > pre-release. Although you already tried with the first two of those versions, I posted those versions as described by the bug report. YMMV. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Autocorrect not working

2024-03-02 Thread ady
at other "shortcuts" are already there. HTH, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https:/

Re: [libreoffice-users] Libre Office bugs (Windows 10 pro PC)

2024-03-26 Thread ady
ations 2. On the same "Personalization > Colors" window, on the right side you should see the link to High Contrast configuration. Within High Contrast, there are several "Themes" available. LibreOffice might react differently to each combination of all the poss

Re: [libreoffice-users] Can't open new version of LO

2024-04-02 Thread ady
ase share your results in the users mailing list. HTH, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archi

Re: [libreoffice-users] I am searching Libreoffice portable in Czech language

2024-04-21 Thread ady
For MS Windows, at: <https://www.libreoffice.org/download/portable-versions/> look for the link(s) to "Portable MultilingualAll". Usually there are 2 links (Fresh and Still) for "All" (languages) and 2 links (Fresh and Still) for "Standard" (languages).

Re: [libreoffice-users] OS hangs while visiting a LO wiki page

2015-09-16 Thread Ady Ady
>> Tom Williams wrote: >>> >>>> On 09/15/2015 01:43 PM, libreoffice-ml.mbou...@spamgourmet.com wrote: >>>> >>>>> Ady Ady wrote: >>>>> >>>>>> Hello Users of LibreOffice, >>>>>> >>>>>&g

[libreoffice-users] OS hangs while visiting a LO wiki page

2015-09-15 Thread Ady Ady
se) pushed me to at least comment on it. TIA, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://li

[libreoffice-users] welcome screen keyboard shortcuts strange behavior

2016-05-13 Thread Ady Ady
e replicated by other users? 3_ Is it present under other OS? 4_ Is there some new option that might have changed the prior behavior? Perhaps the specific key's combinations have changed in some way? 5_ Is it still present in newer versions (such as the 5.1.x branch)? 6_ Is there a bug

Re: [libreoffice-users] Re: welcome screen keyboard shortcuts strange behavior

2016-05-14 Thread Ady Ady
antage from the users' perspective to not have these shortcuts working from the start. Comments about this matter would be very welcome. I hope users can attempt these simple tests and report their results, including the OS and version information, so a potential bug report / request for enhancement would

Re: [libreoffice-users] Re: welcome screen keyboard shortcuts strange behavior

2016-05-14 Thread Ady Ady
On Fri, May 13, 2016 at 7:48 PM, V Stuart Foote > @Ady, * > > I just did a clean /a admin install of LO 5.0.6.3 x64 on Windows 8.1 > > While in the StartCenter -- icon bar on left or in the thumbnail preview > pane-- with this new user profile the .UI accelerators for the Start