different ways.
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://listarchives.libreoffice.o
?
<https://wiki.documentfoundation.org/ReleaseNotes/24.2#New_line_break_algorithm_for_interoperability>
I admit I don't know how to probe (nor how to prove) whether it is related.
HTH,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-h
opened
(by LO or by any other program). Mixing these operations just
increases the chances of file corruption, especially when a removable
device is involved.
HTH,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/maili
> In writer the same odt file presents different horizontal character
> spacing between different PCs.
Just a semi-random possibility...
Open (a backup of) your ODT file -> menu Tools -> Options ->
LibreOffice Writer -> Compatibility
Compare those settings in both instal
should rather avoid _simultaneously_ launching / running more than one
version at a time.
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:
ifference of space characters.
Using the colon characters, the replacement is performed precisely as
desired, whether there are space characters adjacent to the words or
not.
HTH,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help
after step 5 is an "en dash" instead of "em dash".
This is all with the "AutoCorrect > While typing" option enabled, and
without having changed any of the default "Replace" related options.
HTH,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.l
ka "Fresh") points
to version 24.2.5.
* "...mature previous release..." (aka "Still") points to version 7.6.7.
When the next 24.8 branch will get out on August (the eighth month of
year 2024), then the current "24.2" branch will be the new "Still".
t;
<https://help.libreoffice.org/latest/en-US/text/scalc/01/0613.html?&DbPAR=CALC>
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 +
eoffice.org/latest/cs/text/shared/05/new_help.html>
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: http
.2 release. In the Release Notes for LO 24.2
you can see a screenshot of how it looks. You can also assign some
customized keyboard shortcut to toggle it. ATM I don’t recall whether
the color is configurable (maybe in the advance/experimental
settings(?)).
Have a nice day,
Ady.
--
To unsubscribe e-
; "Column/Row Highlighting"
My apologies again for the previous incorrect info.
Have a nice day,
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://wi
when I actually select a range of cells I
already see them highlighted, so I am not sure what else would you
need, or what might be different in your system.
HTH,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mail
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).
HTH
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
the applications
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
pos
er "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:/
> 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? http
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
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/mailing
> 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? https://www.libreo
references for
worksheets 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-unsubscri
the same 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 rega
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
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
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?"
https://wiki.documentfoundation.org/Faq/G
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 ver
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 i
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 lin
> 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 ev
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 fi
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 arc
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
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
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
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
On Wed, Sep 16, 2015 at 10:53 PM,
wrote:
> Simos Xenitellis wrote:
>>
>> (obviously we are off-topic)
>>
>> On Wed, Sep 16, 2015 at 8:46 PM,
>> wrote:
>>
>>> Tom Williams wrote:
>>>
>>>> On 09/15/2015 01:43 PM, l
else) 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
ormula, or edit "by hand".
Some users are used 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
frequent use of relative or absolute references
for sheets, we probably cannot really know. And yet, since it is easier
to correct (in case the user really needs such correction) from
absolute to relative references to sheets than the other way around,
the suggested change in default behavior make
ere) is different than other users here in the list, I would like
to know about it. If the tests / steps I have presented in this email
thread cannot be replicated by others, or if the default behavior seen
by others is different than what I am seeing, I would really appreciate
receiving feedback a
tually needed by a user,
the correction is easier from absolute to relative notation than 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-hel
tions / 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
#3.2.
IMHO, Only if the expected supposed behavior is really incorrect for
that specific procedure, then perhaps it deserves some attention; if
not, "do no harm".
Regards,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libre
ase, take a look at
https://wiki.documentfoundation.org/Documentation/Publications
which includes guides for Calc and Base.
Regards,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe
> Hi Ady,
>
> On Thu, 14 Nov 2013 15:45:33 +0200
> Ady 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 do
oo complex" solutions you are
referring to take 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.
lable so to get the desired result using
LO Calc, I am slightly reticent to actually report this as a bug (or
as a potential enhancement, whichever the adequate term would be for
this case). When other issues regarding paste (and/or paste special)
get to be resolved, perhaps th
n the text
> when multiplying by 1.
>
> > As a side note, I was not able to use the method of copy -- paste
> > multiplying by one.
> How do you mean? When is the multiply done? If I copy the numbers from
> the cells with the formulas it works fine.
>
> So now I
ese "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 to: users+unsubscr...@global.libreoffice.org
Problems? http://www
uld be invested to make Calc work "as expected" 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/mai
would prefer the "'paste
special'+multiply by 1" method to work.
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.docu
ausible in
Calc, just as it is in other spreadsheet tools.
There are workarounds, like using the 'VALUE' function in an
auxiliary column and then copy+paste back; yet I still wonder about
this hidden (annoying) single quotation mark.
Regards,
Ady.
--
To unsubscribe e-mail to: users+
adsheet tools and usually is fast enough. The more
important matter is that LO Calc is making 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
'import' procedure. This task is simple enough if the numbers are
already located under the same "column" in the csv / text file that
you use as source to import the data into Calc.
All the above comments are relevant only if you don't need to do the
conversion in a repea
't see the "flickering" in the list.
When the text or selected cells use more than one Font, the
probability to see the "flickering" is higher.
The "flickering" seems to be "easier" to see when I perform the Font
selection "slower" rather than
> 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 th
> Dnia 2013-10-26, o godz. 12:42:10
> Ady 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.
>
>
the feature). If anything, IMHO the
"Detective" feature should be very much improved (not left with
inadequate 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:/
ement should not even happen,
specially with "AutoRefresh" (traces) set on, but I guess this is why
the "Refresh Traces" action exists(?).
Is this happening just in my system?
TIA,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http:
of:
A1 => 1965 [Enter]
B1:AX1 => formula(=A1+1) [Control+Enter]
in Calc you do:
A1 => 1965 [Enter]
B1:AX1 => formula(=A1+1) [Alt+Enter]
BTW, there is a _very limited_ document regarding LibreOffice and
MSOffice (including Calc and Excel):
[url]
https://wiki.documentfoundation.or
ell (as oppose to copying the
first "cell"; or
B_ copying the first formula while respecting relative 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
such basic stuff that it doesn't seem to be documented.
>
> Dave
A common possible method in Calc would be:
A1 => 1965 [Enter]
B1 => formula(=A1+1) [Enter]
B1 => copy
C1:AX1 => paste
So, more steps than in Excel; simpler than an array formula.
I don't remember whet
> Hi,
>
> Entering a formula into the Function Wizard in Calc shows up two
> different answers in the 'Result' and 'Function Result' answer box.
>
> If the editing cursor is placed in a certain section of the formula,
> only the 'Function Result' answer box holds the correct answer i.e.
> 75
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 to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/m
> On 13/10/2013, Ady 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 fro
;t know how to do it by himself, it is
common to find such solution expressed in the context of other
spreadsheet software (typically, Excel).
>From a final user's perspective, I don't see a reason not to support
it. Of course there might be technical / development reasons, but
> 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 Ca
> 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 "
> >
> > a
pecific msg number I
want 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.
saying that row-only (or column-only) references
are better in any way. I'm just trying to make them work as in (a.k.a
"compatible with") other spreadsheet software.
If there is a better place (mailing list, irc, forum,...) to ask this
question, please let me know.
TIA,
Ady.
-
nything I can do so to workaround this issue? Am I doing
something wrong? Is there any setting I should change?
BTW, I am currently using LibreOffice 4.0.3.3 under Windows, but from
the aforementioned bug report I am assuming that this problem has
been present for a long time (at least a year) an
72 matches
Mail list logo