Bug 153929 - CALC : The "power" function does not work.
Summary: CALC : The "power" function does not work.
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-03-02 17:19 UTC by Michel AUTEM
Modified: 2023-03-02 17:58 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 Michel AUTEM 2023-03-02 17:19:28 UTC 
Description:
The "power" function doesn't work in Calc. For example, it is impossible to calculate the square or the cube of a number.

Steps to Reproduce:
1.Put a number in a cell. Ex. "37" in B2
2.Make a reference to this cell in the next one. Ex. "=B2" in B3
3.Try to calculate the square or the cube of B3. Ex. "=B2²" in B3


Actual Results:
-> I get only a "#NAME" error message in the cell.

Expected Results:
(37² =) 1369


Reproducible: Always


User Profile Reset: No

Additional Info:
(37² =) 1369
Comment 1 ady 2023-03-02 17:58:56 UTC 
This is either
=37^2

or equivalent notation using cell address:

=A1^2

=A1^A2

or use the POWER function.

Please next time perform a web search, or go to ask.libreoffice.org.

Setting to NOTABUG.