[Libreoffice-bugs] [Bug 48765] New: Remote ref to cells in LibO-Calc spreadsheet denied in tool (function)

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=48765

             Bug #: 48765
           Summary: Remote ref to cells in LibO-Calc spreadsheet denied in
                    tool (function)
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.4.6 release
          Platform: x86-64 (AMD64)
        OS/Version: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Libreoffice
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: ptjr at elisanet.fi


Created attachment 60055
  --> https://bugs.freedesktop.org/attachment.cgi?id=60055
LibreOffice-Calc v.3.4.6 spreadsheet

There is a very interesting an useful tool in LibreO-Calc 'Data/Multiple
operations', the same toll is also in OpenO-Calc; in MSExcel it is called
DataTable.
Some 3-4 years ago I had with that tool created a calculating process in
OpenO-Calc and when I recently recreated the calculation in LibO I noticed that
a flexible feature had vanished.
In the 'new' Calc the first cells of both "row input" variable G8 (of G8, H8,
H9,..etc.) and "column input" variable F9 (of F9, F10, F11, ..etc.) in the
tool's calculation area require a manually inserted value -- the next variables
(increasing or decreasing by a difference) can be values calculated by a
formula from the value in cell previous cell.

In the "old" calculation these first cells (G8 and F9) could refer to remote
cells (values or formulas) which increases the flexibility and the usability of
the tool remarkably.

In that same spreadsheet, outside the tool's calculation area, all cells accept
remote references in a normal way.
See enclosed attachment.

I cannot think that that negative change has been done deliberately. 

My computers are (a) PC(AMD)-Win7Prof/32bit and Laptop(Intel)-Win7Prem/64bit;
LibO3.4.6 in the PC and LibO3.4.5 in the laptop.

Can I myself do anything to go around the issue?

Please, answer by mail soonest.
Best regards
Pertti Rönnberg (Finland)

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.