1. Forum
  2. Usenet
  3. ALT.OS.LINUX.UBUNTU

  • Ubuntu/LibreOffice Calc - Data->Sort->Descending

    From Adam@21:1/5 to All on Mon Aug 2 13:44:30 2021
    Is there some bug about Data->Sort->Descending ?

    When I select ALL columns and then do Data->Sort->Descending then select
    the column to sort by, it seems like the entire row does not stay
    together. My data/numbers are changing.

    Any ideas ?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mike Easter@21:1/5 to Adam on Mon Aug 2 14:25:28 2021
    Adam wrote:
    When I select ALL columns and then do Data->Sort->Descending then select
    the column to sort by, it seems like the entire row does not stay together.

    I don't understand how/why you would select all columns to sort. How
    could it do that?

    It seems you would select the column to sort by, then descending.

    --
    Mike Easter

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Adam@21:1/5 to Adam on Mon Aug 2 14:30:05 2021
    On 08/02/2021 01:44 PM, Adam wrote:

    Is there some bug about Data->Sort->Descending ?

    When I select ALL columns and then do Data->Sort->Descending then select
    the column to sort by, it seems like the entire row does not stay
    together. My data/numbers are changing.

    Any ideas ?

    Found one problem cell...

    =(G15-E16)

    should be...

    =(G16-E16)

    Nasty one !! :-)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Adam@21:1/5 to Mike Easter on Mon Aug 2 14:40:35 2021
    On 08/02/2021 02:25 PM, Mike Easter wrote:
    Adam wrote:
    When I select ALL columns and then do Data->Sort->Descending then
    select the column to sort by, it seems like the entire row does not
    stay together.

    I don't understand how/why you would select all columns to sort. How
    could it do that?

    It seems you would select the column to sort by, then descending.


    To keep the entire row together. Without selecting ALL data,
    only the column is sorted, right ? That's my understanding.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Adam@21:1/5 to Adam on Mon Aug 2 16:13:32 2021
    On 08/02/2021 02:30 PM, Adam wrote:
    On 08/02/2021 01:44 PM, Adam wrote:

    Is there some bug about Data->Sort->Descending ?

    When I select ALL columns and then do Data->Sort->Descending then select
    the column to sort by, it seems like the entire row does not stay
    together. My data/numbers are changing.

    Any ideas ?

    Found one problem cell...

    =(G15-E16)

    should be...

    =(G16-E16)

    Nasty one !! :-)


    Is there an easier way to check for errors like this than going through
    and looking at each cell ?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Paul@21:1/5 to Adam on Mon Aug 2 19:59:07 2021
    Adam wrote:
    On 08/02/2021 02:30 PM, Adam wrote:
    On 08/02/2021 01:44 PM, Adam wrote:

    Is there some bug about Data->Sort->Descending ?

    When I select ALL columns and then do Data->Sort->Descending then select >>> the column to sort by, it seems like the entire row does not stay
    together. My data/numbers are changing.

    Any ideas ?

    Found one problem cell...

    =(G15-E16)

    should be...

    =(G16-E16)

    Nasty one !! :-)


    Is there an easier way to check for errors like this than going through
    and looking at each cell ?

    If you place limits on how you use a tool, it
    reduces the chances of errors like that to zero.

    For example, I load all the tabular data first.
    I look at it, decide to sort it. After that, I start
    adding extra columns to the right, with my calculations
    in the columns.

    The cell references can be relative or absolute. And
    that behavior is selectable on a given axis. Presumably
    one of these choices is better for this, than the other.

    https://support.microsoft.com/en-us/office/switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9

    Paul

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)