Bug 158242 - =LOG(2,1) evaluates as err:502
Summary: =LOG(2,1) evaluates as err:502
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-16 14:34 UTC by steve
Modified: 2023-11-16 17:30 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description steve 2023-11-16 14:34:48 UTC 
Description:
The log function with a specified base does not work for log(base, 1)

Version: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.8

Steps to Reproduce:
1.Enter =log(2, 1) in any cell
2.
3.

Actual Results:
Err:502



Reproducible: Always


User Profile Reset: No

Additional Info:
Log(1) works fine
Comment 1 Mike Kaganski 2023-11-16 15:01:40 UTC 
The LOG spreadsheet function [1] is defined as

  LOG(Number [; Base])

so '=log(2; 1)' is not "base-2 logarithm of 1", but "base-1 logarithm of 2".

[1] https://help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3109813
Comment 2 steve 2023-11-16 17:17:21 UTC 
sorry about that, the other values in my data were log(2, 2) and log(2, 0.5), both of which give the expected result. Two successes don't mean I have got it right.