[Libreoffice-bugs] [Bug 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |

-- 
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 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

--- Comment #15 from Eike Rathke  ---
(In reply to Eike Rathke from comment #14)
> 2) such error values seem to be not treated correctly during sort;
>actually they should be sorted before other values

I messed that up, errors should be sorted to the end, after any other values
(numeric,text,...) and before blank cells.

-- 
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 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||er...@redhat.com
 Ever confirmed|0   |1

--- Comment #14 from Eike Rathke  ---
Actually this is a combination of several problems..
1) pasting formula error results as values creates an internal formula
   cell to preserve the error value (as can be seen by the "highlight"
   green value)
   1a) this does not have a leading '=' though
2) such error values seem to be not treated correctly during sort;
   actually they should be sorted before other values, just as when
   sorting the original formula range
3) when saved, due to 1a the formula is stored without the leading '='
   but cell type string, extended type error, which so far is correct
4) when loaded, this combination results in a string being set at the
   cell, which is not an error value and thus sorts differently
5) VLOOKUP may return empty cells *for display only*, but these when
   pasting as values will be pasted as 0 values and if formatted as date
   result in the null date 1899-12-30
6) similar, they are stored as an empty but 0 formatted value thus when
   reloading in this case display as null date

-- 
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 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

Ari Latvala  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #13 from Ari Latvala  ---
Problem is that sorting works differently (incorrectly) right after the "Paste
special" before Save, when those #N/A fields are still "Error: Value not
available" results (green, aligned to right) and not differentiated on the sort
from the empty cells but sorting works correctly after saving and re-opening
file, because they have changed at that point to normal text (black, aligned
left).

-- 
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 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

--- Comment #12 from Buovjaga  ---
(In reply to Ari Latvala from comment #9)
> Just tested with LO 5.2 nightly version 2.3.2016 build on Windows 7 SP1 and
> noticed interesting behaviour. Before saving sorting on the Summary tab does
> not make difference between empty and non-existing (#N/A) date information
> but once saved as ODS and re-opened, then working as expected, i.e. #N/A
> sorted last and empty dates at the beginning, existing dates in between and
> even different years seems to sort nicely.

#N/A is sorted last and empty dates at the beginning for me in attachment
121289 before saving. Is there something I'm missing? Maybe you need to provide
a clean file in addition to your "end result" file?

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.0.0.alpha1+
Build ID: cd7b306e614a938b7b39a66784899c22ee6f6c64
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on October 25th 2016

-- 
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 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

--- Comment #11 from Ari Latvala  ---
No,I am not happy. Sorting still works diffetently before and after the Save.
After Save it works as expected but before #N/A and zero values are treated
equally,

-- 
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 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|REOPENED|NEEDINFO
 CC||todven...@suomi24.fi

--- Comment #10 from Buovjaga  ---
Ari: can this be closed as WORKSFORME? You are happy?

-- 
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 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

--- Comment #9 from Ari Latvala  ---
(In reply to Elmer from comment #8)
> sorting a column by date wwworks if dates are all same year. sorting dates
> that span more than one year does not sort.
> really, people... this is a release version? and a very basic necessary
> function and it doesn't work???

Just tested with LO 5.2 nightly version 2.3.2016 build on Windows 7 SP1 and
noticed interesting behaviour. Before saving sorting on the Summary tab does
not make difference between empty and non-existing (#N/A) date information but
once saved as ODS and re-opened, then working as expected, i.e. #N/A sorted
last and empty dates at the beginning, existing dates in between and even
different years seems to sort nicely.

-- 
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 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

--- Comment #8 from Elmer  ---
sorting a column by date wwworks if dates are all same year. sorting dates that
span more than one year does not sort.
really, people... this is a release version? and a very basic necessary
function and it doesn't work???

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

[Libreoffice-bugs] [Bug 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

--- Comment #6 from m.a.riosv  ---
(In reply to Ari Latvala from comment #4)
> You were correct about that "Show zero values" but the original problem with
> the sorting is still there, i.e. #N/A and zero values are treated equally,
> which should not be the case.

How then?

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

[Libreoffice-bugs] [Bug 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

Jacques Guilleron  changed:

   What|Removed |Added

 CC||guillero...@aol.com

--- Comment #5 from Jacques Guilleron  ---
Hi Ari,

You have to first examine the way LO treats empty cells.
https://help.libreoffice.org/Calc/Handling_of_Empty_Cells

Regards

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

[Libreoffice-bugs] [Bug 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

--- Comment #7 from Ari Latvala  ---
I would prefer similar behavior than on Excel 2013. There that date sorting on
"Summary" will arrange empty dates as oldest (0.1.00), then actual dates on the
correct order, as does LibreOffice and then all those #N/A fields are a the
end.

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

[Libreoffice-bugs] [Bug 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||miguelangelrv@libreoffice.o
   ||rg
 Resolution|--- |NOTABUG

--- Comment #3 from m.a.riosv  ---
Hi,

With Win maybe you have disable the option for show zero values in
Menu/Tools/LibreOffice calc/View

>From a VLOOKUP it's not possible to get an empty cell at most you can get a
cell with an empty string.
List.B2
=IF(VLOOKUP(A2;Inventory.$A$1:$B$7;2;0);VLOOKUP(A2;Inventory.$A$1:$B$7;2;0);"")

Dates in calc are stored as integers being the zero 31/12/1899.

https://help.libreoffice.org/Calc/Date_and_Time_Functions

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

[Libreoffice-bugs] [Bug 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

--- Comment #1 from Ari Latvala  ---
Running LibreOffice 5.0.3.2 on Linux and LibreOffice 5.0.4.1 on 64-bit Windows
7.

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

[Libreoffice-bugs] [Bug 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

--- Comment #2 from Ari Latvala  ---
Now tested also under LibreOffice 4.2.8 running on Linux RHEL 6.7 64-bit, same
behavior there. 

Difference between Linux and Windows seems to be that at least on 5.0.4.1 on
Windows 7 64-bit those empty Date cells on the first sheet collected with
VLOOKUP show up correctly as empty but under Linux versions 4.2.8 and 5.0.3.2
those already show date 30.12.1899 when cell is configured as Date or 0, if
cell format is text/general.

After copy / paste special all versions have changed those empty cells
incorrectly to 0 / 30.12.1899.

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

[Libreoffice-bugs] [Bug 96475] Sorting pasted date fields incorrect

[bugzilla-daemon]

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

Ari Latvala  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|NOTABUG |---
 Ever confirmed|0   |1

--- Comment #4 from Ari Latvala  ---
You were correct about that "Show zero values" but the original problem with
the sorting is still there, i.e. #N/A and zero values are treated equally,
which should not be the case.

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