Bug 149057 - incorrect formula, calculation error, non-existent function
Summary: incorrect formula, calculation error, non-existent function
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-05-12 16:15 UTC by ccoolltt45
Modified: 2022-07-14 18:57 UTC (History)
2 users (show)

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 ccoolltt45 2022-05-12 16:15:27 UTC 
I can't do this function


https://www.youtube.com/watch?v=jXS0EL5O7SU
Comment 1 Regina Henschel 2022-05-12 17:51:55 UTC 
Do you have an Excel document which uses the function in question? Or can you give us the English name of the function? I cannot understand the language in that video.
Comment 2 ccoolltt45 2022-05-13 20:39:00 UTC 
(In reply to Regina Henschel from comment #1)
> Do you have an Excel document which uses the function in question? Or can
> you give us the English name of the function? I cannot understand the
> language in that video.

The video teaches how to calculate the last five values of the table "automatically"...
Example: when entering new values in the table, the formula will always consider the last values for the calculation.
Comment 3 QA Administrators 2022-05-14 03:42:35 UTC Comment hidden (obsolete)
Comment 4 Regina Henschel 2022-05-14 23:09:16 UTC 
Please use https://ask.libreoffice.org to get help about creating such spreadsheets with LibreOffice.

And please provide the English name of the function in Excel or provide an Excel spreadsheet using this function. Otherwise I cannot determine whether this function is really missing.
Comment 5 raal 2022-07-14 18:57:32 UTC 
Closing, please follow the recommendation in comment 4