Bug 154391 - missing (?) formulae
Summary: missing (?) formulae
Status: RESOLVED DUPLICATE of bug 151000
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: xlsx-aggressive-competitors
Blocks:
  Show dependency treegraph
 
Reported: 2023-03-25 15:48 UTC by Michael Meeks
Modified: 2023-03-28 11:16 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Meeks 2023-03-25 15:48:29 UTC
The competition talk about having implemented this set of (presumably new) formulae:

TEXTBEFORE
WRAPROWS
TEXTSPLIT
TAKE
TEXTAFTER
VSTACK
HSTACK
TOROW
TOCOL
WRAPCOLS
DROP
CHOOSEROWS
CHOOSECOLS

Not sure if we have a duplicate of these; most look somewhat simple to implement.
Comment 1 m_a_riosv 2023-03-26 02:53:43 UTC
We do not have any of these functions.

There are enhancements request for all of them:

CHOOSECOLS tdf#151000
CHOOSEROWS tdf#150999
DROP       tdf#150998
HSTACK     tdf#150868
TAKE       tdf#150997
TEXTAFTER  tdf#150865
TEXTBEFORE tdf#150864
TEXTSPLIT  tdf#150866
TOCOL      tdf#150879
TOROW      tdf#150878
VSTACK     tdf#150867
WRAPCOLS   tdf#150881
WRAPROWS   tdf#150880
Comment 2 Roman Kuznetsov 2023-03-26 10:07:21 UTC
Michael, could we close this one as duplicate because we already have the reports as Miguel said or Collabora wants to implement it and you want to have all info in one place?
Comment 3 Michael Meeks 2023-03-27 08:19:46 UTC
Oh - sure - can close - I don't want to foul up bugzilla; glad the reports are there - I was just interested in tracking them here somehow on the xlsx-aggressive-competitors ticket.
Comment 4 Roman Kuznetsov 2023-03-27 09:04:47 UTC
(In reply to Michael Meeks from comment #3)
> Oh - sure - can close - I don't want to foul up bugzilla; glad the reports
> are there - I was just interested in tracking them here somehow on the
> xlsx-aggressive-competitors ticket.

We can add the META xlsx-aggressive-competitors for all these reports if you want =)

*** This bug has been marked as a duplicate of bug 151000 ***
Comment 5 Roman Kuznetsov 2023-03-28 11:16:46 UTC
(In reply to Roman Kuznetsov from comment #4)

> We can add the META xlsx-aggressive-competitors for all these reports if you
> want =)
> 
> *** This bug has been marked as a duplicate of bug 151000 ***

Michael, from another side these reports all already have META - Excel functions (bug 15900)