[Solved] Formula separator in LibreOffice

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.

[Solved] Formula separator in LibreOffice

Postby kingfisher » Wed May 14, 2014 4:04 am

Hello. I am unable to install AOO so I am experimenting with LO on another system.

One problem is that the following formula is displayed with a comma instead of a semi-colon. Perhaps needless to say, the formula doesn't work. If I edit the formula by changing the comma to a semi-colon, then press ENTER, the formula again displays with a comma and still doesn't work.

Code: Select all   Expand viewCollapse view
=HYPERLINK("file:///data/sets/office/work/DataLog.ods";"Datalog")


The formula displays correctly and works in OpenOffice.
Last edited by kingfisher on Thu May 15, 2014 6:27 am, edited 1 time in total.
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Re: Formula separator in LibreOffice

Postby B Marcelly » Wed May 14, 2014 7:59 am

Hello,
This option is specific to LibreOffice.
Attachments
Ecran002.png
Formula separators
Bernard

OpenOffice.org 1.1.5 / Apache OpenOffice 4.1.1 / LibreOffice 5.0.5
MS-Windows 7 Home SP1
B Marcelly
Volunteer
 
Posts: 1160
Joined: Mon Oct 08, 2007 1:26 am
Location: France, Paris area

Re: Formula separator in LibreOffice

Postby RoryOF » Wed May 14, 2014 9:18 am

kingfisher wrote:Hello. I am unable to install AOO so I am experimenting with LO on another system.


Any error message about installing OpenOffice?
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29489
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Formula separator in LibreOffice

Postby gerard24 » Wed May 14, 2014 10:30 am

Hi,

As B. Marcelly said, Function and array column/row separator are locale dependant.
You can change this in options.

But I suspect that your problem is not related to separator or what formula display but following the Hyperlink.
If Ctrl+Click open your "Datalog" file, it is just a setting to change.

In recent versions of LibreOffice, setting "Ctrl+Click to follow hyperlink" also apply to Calc, not only Writer.
If you want to use simple click:
Menu Tools > Options > LibreOffice > Security, click on "Option" button and uncheck "Ctrl+click required to follow hyperlinks".
This box is checked by default.

Hyperlink.jpg
LibreOffice 6.2.4 on Windows 10
gerard24
Volunteer
 
Posts: 948
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Formula separator in LibreOffice

Postby kingfisher » Thu May 15, 2014 1:06 am

Thank you for the replies. I had looked at the Formula page in Options but somehow missed the relevant section.

The formula now displays correctly. I intended to post separately asking why the hyperlink still doesn't work but that question has been answered here as well.

@RoryOF : My first attempt to install AOO stalled. On the second attempt, there was an error message stating that /bin/sh is missing along with something with a four-letter name. /bin/sh is present ; it is a link to /bin/bash. I could not find in the package manager a package with the four letter name and the error message did NOT state where it is supposed to be.

In addition, the README file states that the system must have a package called glibc5. The package glibc5 is NOT in my distro's repositories ; glibc is installed. The distro does NOT support AOO.
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Re: [SOLVED] Formula separator in LibreOffice

Postby RoryOF » Thu May 15, 2014 9:10 am

For those who wish to try OpenOffice on PCLinuxOS, there is a posting at
http://www.horneker.com/pclinuxos-addsoftware.html
on installing non repository software on that OS, which may be of assistance.

On earlier versions of PCLinuxOS there used be a special file to download and install OpenOffice in the Office directory. This is mentioned at
http://www.howtoforge.com/the-perfect-desktop-pclinuxos-2010-kde-p4
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29489
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Formula separator in LibreOffice

Postby kingfisher » Sat May 17, 2014 2:39 am

Thanks RoryOF. The second article is out of date and there is no script to install AOO. Before the fork the distro used the Novell version of OpenOffice which ( I believe ) is what became LibreOffice.

I have bookmarked the other article although, at first blush, the method outlined does not circumvent the need for dependencies.

In addition there is no tar ball for AOO. A request issue was posted about that lack ( with particular reference, IIRC, to distros such as Slack which use a tar ball ). The developers have turned a deaf ear to the request.
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am


Return to LibreOffice

Who is online

Users browsing this forum: No registered users and 2 guests