[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

Gabor Kelemen (allotropia)  changed:

   What|Removed |Added

 Depends on|155402  |
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=15
   ||5402


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=155402
[Bug 155402] FILEOPEN XLSX CELL() function gives different value compared to
Excel with filename parameter
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

Gabor Kelemen (allotropia)  changed:

   What|Removed |Added

 Depends on||155402


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=155402
[Bug 155402] FILEOPEN XLSX CELL() function gives different value compared to
Excel with filename parameter
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

Michael Warner  changed:

   What|Removed |Added

 Blocks|108827  |150900


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=150900
[Bug 150900] [META] Excel Functions
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

m.a.riosv  changed:

   What|Removed |Added

 CC||he...@live.co.uk

--- Comment #8 from m.a.riosv  ---
*** Bug 145048 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

--- Comment #7 from hardcoder  ---
Just in case they haven't read about this old problem, I'm throwing a NEW
status. Fell free to revert this once the newer comments are considered.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

--- Comment #6 from hardcoder  ---
(In reply to hardcoder from comment #4)
> [...] in Excel Online and Excel Mobile (for Windows).
(I have never used Excel for Mac or Android.)

> besides LibreOffice Help. In WPS Office, CELL function works the same way.
Works the same as MS Excel.

> Although I don't think this is the best place for such functionality, I'd be
> one more to ask for LibreOffice to implement it the way Excel did, as you
In my opinion, this behavior should be put in the very CELL function, not an
additional one.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

--- Comment #5 from hardcoder  ---
That said, it would be even better to _also_ have a function just for returning
the selected range reference -- and this time, it would expose the whole range,
not just one cell. Also it would return the reference, like some other
functions are able to use. (CELL, instead, can return the address only as a
string, not directly as reference.)

Together with that, there could be per-file options on when to recalc,
including when selection changes, and at fixed intervals. This last one already
can be done by adding a dummy data connection ("link to external data..."). I
guess it's better to leave this for a new bug report and replicate these
suggestions there.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

--- Comment #4 from hardcoder  ---
In fact Excel help isn't precise about what happens when the second parameter
isn't given. Despite not documented, Ms is aware of that behavior and didn't
change it with time; instead, it was replicated in Excel Online and Excel
Mobile (for Windows). Others are aware of the behavior too, besides LibreOffice
Help. In WPS Office, CELL function works the same way.

Although I don't think this is the best place for such functionality, I'd be
one more to ask for LibreOffice to implement it the way Excel did, as you
didn't invent the function, and you support .xls and .xslx formats.

That feature can be useful for user interaction without requiring macros.
(Functions are way more cross-platform and straightforward than macros in an
additional language, which often defeats the purpose of choosing spreadsheet.)
For example, the user can select a cell in a large table and get extra info
about that value, or via conditional formatting, similar values can be
highlighted (this works in Excel 2010 and Excel Online).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

--- Comment #3 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

Carlos  changed:

   What|Removed |Added

Summary|Add a new CELL function for |Add a new CELL() function
   |Excel compatibility |for Excel compatibility

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106151] Add a new CELL function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

Carlos  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #2 from Carlos  ---
(In reply to m.a.riosv from comment #1)
> I think LibreOffice help information it's clear
> 
> https://help.libreoffice.org/index.php?title=Calc/
> Information_Functions=en-US=WIN=5.4#bm_id3159412
> "
> Reference (list of options) is the position of the cell to be examined. If
> Reference is a range, the cell moves to the top left of the range. If
> Reference is missing, LibreOffice Calc uses the position of the cell in
> which this formula is located. Microsoft Excel uses the reference of the
> cell in which the cursor is positioned.
> "
> 
> BTW on the top it's possible select the language.

LibreOffice help is clear. But GerardF is correct that the function is not 100%
compatible with MS Excel. 

By the way the current MS Excel help 
http://web.archive.org/web/20170403173356/https://support.office.com/en-us/article/CELL-function-51BD39A5-F338-4DBE-A33F-955D67C2B2CF?ui=en-US=en-US=US
states that if the reference is missing, the CELL function uses the reference
for "the last cell that was changed".

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106151] Add a new CELL function for Excel compatibility

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106151

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #1 from m.a.riosv  ---
I think LibreOffice help information it's clear

https://help.libreoffice.org/index.php?title=Calc/Information_Functions=en-US=WIN=5.4#bm_id3159412
"
Reference (list of options) is the position of the cell to be examined. If
Reference is a range, the cell moves to the top left of the range. If Reference
is missing, LibreOffice Calc uses the position of the cell in which this
formula is located. Microsoft Excel uses the reference of the cell in which the
cursor is positioned.
"

BTW on the top it's possible select the language.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs