https://bugs.documentfoundation.org/show_bug.cgi?id=97334
Bug 97334 depends on bug 97706, which changed state.
Bug 97706 Summary: CLEAN is neither ODF nor OOXML conform
https://bugs.documentfoundation.org/show_bug.cgi?id=97706
What|Removed |Added
---
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
Dennis Roczek changed:
What|Removed |Added
Component|libetonyek |Calc
Product|Document
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #12 from osnola ---
(In reply to Dennis Roczek from comment #11)
> from my (unfinished work) in the wiki:
> https://wiki.documentfoundation.org/
> Functions_comparison_of_LibreOffice_Calc_and_Numbers#cite_ref-
> STRIPDURATION_
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #11 from Dennis Roczek ---
(In reply to osnola from comment #10)
> (In reply to Dennis Roczek from comment #6)
> > well I thought the same original. There are two parts:
> >
> > * (maybe) libetonyek import filter modification
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #10 from osnola ---
(In reply to Dennis Roczek from comment #6)
> well I thought the same original. There are two parts:
>
> * (maybe) libetonyek import filter modifications (at least for stripduration)
Hi, I'm not sure what
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
Bug 97334 depends on bug 97977, which changed state.
Bug 97977 Summary: FILEOPEN: XSLX - MODE results in wrong calculation
https://bugs.documentfoundation.org/show_bug.cgi?id=97977
What|Removed |Added
---
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
Xisco Faulí changed:
What|Removed |Added
Component|General |libetonyek
Product|libet
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #9 from Dennis Roczek ---
BIN2DEC
BIN2HEX
BIN2OCT
DEC2BIN
DEC2HEX
DEC2OCT
HEX2BIN
HEX2DEC
HEX2OCT
OCT2BIN
OCT2DEC
OCT2HEX
have a second optional parameter to add padding 0s
>From the Apple help: "convert-length: An optional v
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
Dennis Roczek changed:
What|Removed |Added
Whiteboard||needsAppleNumbers
--
You are rec
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
Dennis Roczek changed:
What|Removed |Added
See Also|https://bugs.documentfounda |
|tion.org/show
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
Dennis Roczek changed:
What|Removed |Added
See Also||https://bugs.documentfounda
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #8 from Dennis Roczek ---
Excel and Numbers both calculate =MODE(6; 6; 4; 2; 2) as "6". ODF defines 2 as
a correct value. I guess we additionally need something link MODE.XCL or
MODE_ADD for compatibility reasons, too. :-(
--
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #7 from Dennis Roczek ---
Another function which is missing: DURATION
Apple's DURATION is giving actually a duration (e.g. 1h).
>From Apple's help file:
DURATION
The DURATION function combines separate values for weeks, days,
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
Dennis Roczek changed:
What|Removed |Added
Component|General |General
Product|Docume
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #5 from Eike Rathke ---
Well, the Numbers filter part could be DLP, true.
--
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #4 from Eike Rathke ---
@raal:
Why would this be Document Liberation Project / General instead of LibreOffice
/ Calc? The functions would have to be implemented in Calc. Unless someone came
up with a really nifty idea ;-)
--
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
raal changed:
What|Removed |Added
Status|UNCONFIRMED |NEW
CC|
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #3 from Dennis Roczek ---
Ah, I found the STRIPDURATION difference in Apple's help forums.
https://discussions.apple.com/message/28878054#28878054
Examples
=STRIPDURATION(“1w”) returns 7, the equivalent of one week in days.
=
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #2 from Dennis Roczek ---
A further analysis revealed that our CONVERT_ADD is very similar to Numbers'
CONVERT, but that Apple also allows to convert to weeks.
--
You are receiving this mail because:
You are the assignee for
https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #1 from Dennis Roczek ---
https://wiki.documentfoundation.org/Functions_comparison_of_LibreOffice_Calc_and_Numbers
--
You are receiving this mail because:
You are the assignee for the bug.
20 matches
Mail list logo
