Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.0.0 RC
    • Fix Version/s: 3.5.0
    • Component/s: ZSS Component
    • Labels:
      None

      Description

      Problem Description:

      According to http://www.zkoss.org/product/zkspreadsheet (under "Functionality Highlights), Spreadsheet supports "named range" feature.
      But I found I cannot create a named range within Spreadsheet.

      Reproducing Steps:

      1. select a range of cells
      2. click address, try to enter a name to name the range.

      Expected:
      I can enter a name

      Actual:

      The address input box doesn't accept any input except deletion.

        Activity

        Hide
        henrichen henrichen added a comment - - edited

        Fixed. Now support create Name range on book scope at model API level.

        Show
        henrichen henrichen added a comment - - edited Fixed. Now support create Name range on book scope at model API level.
        Hide
        henrichen henrichen added a comment -

        Should clear evaluation cache of those dependents that have referred to the later created Name.
        https://github.com/zkoss/zkspreadsheet/commit/582ac376665bc5302f82e289f8047af47834f825

        Show
        henrichen henrichen added a comment - Should clear evaluation cache of those dependents that have referred to the later created Name. https://github.com/zkoss/zkspreadsheet/commit/582ac376665bc5302f82e289f8047af47834f825
        Hide
        henrichen henrichen added a comment -

        ZSS-294: The test code SHOULD NOT use a valid Cell address (MYA1 is a valid cell address in xlsx) as the name of the Name. However, shall handle name validation when createName(See issue ZSS-660)
        https://github.com/zkoss/zkspreadsheet/commit/62ff0dcbee86aa48bbdad7060b2015ef5801adac

        Show
        henrichen henrichen added a comment - ZSS-294 : The test code SHOULD NOT use a valid Cell address (MYA1 is a valid cell address in xlsx) as the name of the Name. However, shall handle name validation when createName(See issue ZSS-660 ) https://github.com/zkoss/zkspreadsheet/commit/62ff0dcbee86aa48bbdad7060b2015ef5801adac
        Hide
        hawk hawk added a comment - - edited

        A formula that references the dynamically-created named range (e.g. =sum(mya1) ) doesn't get correct result.
        please use the manual test case in project "zss.test" /issue3/294-createNamedRange.zul.
        I have written test steps on the zul file.

        Show
        hawk hawk added a comment - - edited A formula that references the dynamically-created named range (e.g. =sum(mya1) ) doesn't get correct result. please use the manual test case in project "zss.test" /issue3/294-createNamedRange.zul. I have written test steps on the zul file.
        Show
        henrichen henrichen added a comment - Test Code https://github.com/zkoss/zkspreadsheet/commit/163b8d06033bcb83818dd9ab807fdea2e4a56e2b
        Show
        henrichen henrichen added a comment - - edited fine tune https://github.com/zkoss/zkspreadsheet/commit/62cdbb2ce48c1779aeae4d8902e746bf89d8130d
        Show
        henrichen henrichen added a comment - - edited 1st implementation https://github.com/zkoss/zkspreadsheet/commit/91e5b4cc0a00de3f8e8586f7720af0e566795f2f

          People

          • Assignee:
            dennis dennis
            Reporter:
            hawk hawk
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: