https://bugs.documentfoundation.org/show_bug.cgi?id=147854
Bug ID: 147854
Summary: New @ function callsign for Calc
Product: LibreOffice
Version: 7.3.1.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dihox76...@toudrum.com
Description:
#### User experience, initial report:
1. I realize that many people have an initial difficulty using Calc. This
problem would be solved if we could bring Calc closer to Excel. I know that
this statement can be strange when you are a person who uses 100% free stuff
like LibreOffice.
2. In my case, I really like LibreOffice and I think it's more complete than
Microsoft Office. That's my brief opinion for now - but I can always change my
mind! I talked about this because I don't want this to be my initial
"justification" to be based on "Improve LibreOffice Calc". There are other
points of view I want to report. For example, this case here:
- I feel that some people I come in contact with are not used to using Calc,
perhaps because most of these people don't have a good knowledge of Calc or
don't have information available today and it's easy to help these people to
use Calc the best way. Again here, this is something I've noticed for years, so
I put it here to see if you have this same user experience that I'm reporting
here. That's not a justification yet, it's just an empirical observation.
3. I apologize to everyone if I'm wrong, and I could be wrong. The world is
very complex in terms of usability and user experience. Each person may have
different user experiences and usability in terms of software as in the case I
report here - in my case for LibreOffice, specifically with the Calc program
which is an alternative to Excel that I consider good and valid.
4. One of the initial problems that I notice is the indicator of a function
that is not equal to Excel in Calc.
5. After this brief introduction of my Calc user experience, here I will
describe some initial assumptions that are the basis of my "thesis",
"justification".
Steps to Reproduce:
#### The brief justification, these are my assumptions:
1. "To improve the experience of new LibreOffice users with the Calc program",
we must use the same Excel function indicator in Calc. This would be done as
follows: both the @ symbol and the = symbol are used to call or better indicate
Calc functions.
2. Using the same function indicator allows the user to have the same
experience of using Excel or Calc. Which facilitates or can facilitate the
migration of the same partially or completely from Excel to Calc, as well as
from Calc to Excel.
3. Some believe that Calc is an Excel alternative, and if this is true, to be
an Excel alternative "it, the user would have to have an Excel-like user
experience".
4. Users may have knowledge to use Calc and not necessarily Excel, just as they
may have knowledge to use Excel and not necessarily Calc, in this sense, if you
have similar experience with the 2 software: Calc and Excel, it happens that
you do not differentiate the experience of using one software (Excel) for
another software (Calc), that is, in the end it is so easy that the user makes
the decision to find which is the best software for his particular use.
5. The difference between Calc and Excel is pretty small, but if it were "Calc
is closer to Excel", these differences in usage or user experience would be
none.
#### sample
@sum(A1:B5), @media(D4:E10) or =sum(A1:B5), =media(D4:E10)
### excel vs calc
excel: @sum(A1:B5), @media(D4:E10) or =sum(A1:B5), =media(D4:E10)
calc: =sum(A1:B5), =media(D4:E10)
### before, after
excel: @sum(A1:B5), @media(D4:E10) or =sum(A1:B5), =media(D4:E10)
calc: @sum(A1:B5), @media(D4:E10) or =sum(A1:B5), =media(D4:E10)
Actual Results:
1. This has not yet been implemented, so there are no current results.
2. @sum(A1:B5), @media(D4:E10) or =sum(A1:B5), =media(D4:E10)
Expected Results:
1. People could easily migrate from Excel to Calc easily.
2. There would be no difference between Excel and Calc, which makes the user
experience very easy and common.
3. A small difference between one software(Excel) and other software(Calc)
could be fixed, improved.
Reproducible: Always
User Profile Reset: No
Additional Info:
References:
-
https://wiki.openoffice.org/wiki/Documentation/UserGuide/Migration_Guide/Calc_and_Excel
-
https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_Microsoft_Office
-
https://www.quora.com/What-exactly-can-Excel-do-that-LibreOffice-Calc-cannot-do
-
https://www.openoffice.org/documentation/manuals/oooauthors/SpreadsheetDifferences.pdf
-
https://www.strategicsourceror.com/2014/01/can-libre-calc-replace-microsoft-office.html
-
https://www.reddit.com/r/linux/comments/9yjwyf/is_libreoffice_calc_truly_a_worthy_replacement/
-
https://openoffice.en.softonic.com/articles/5-key-differences-between-excel-and-openoffice-calc
--
You are receiving this mail because:
You are the assignee for the bug.
