[Bug 61851] New: Add copy cell feature

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 61851] New: Add copy cell feature

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61851

            Bug ID: 61851
           Summary: Add copy cell feature
           Product: POI
           Version: 3.17-FINAL
          Hardware: PC
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: SS Common
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Add a function that copies a cell value from another cell, and if the source
cell contains a formula, shifts that formula. Currently POI only contains
methods to copy entire rows (XSSFSheet.copyRows).

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61851] Add copy cell feature

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61851

Javen O'Neal <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #1 from Javen O'Neal <[hidden email]> ---
What APIs do you need?

Copy cell to (row, column)
Copy cell to (sheet, row, column)
Copy cell to (workbook, sheet, row, column)
Copy cell to (cell range)
Copy cell to (sheet, cell range)

Shift formula(formula string, number of rows, number of columns, collection of
case-insensitive sheet names that are being shifted, whether absolute row and
column references should be shifted (copy vs move mode)

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61851] Add copy cell feature

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61851

--- Comment #2 from Luca <[hidden email]> ---
I'm opening this request after your very suggestion, so you have more insight
on what is missing than I do. Maybe some instance method sourceCell.copyTo(Cell
destinationCell) or destinationCell.copyFrom(Cell sourceCell)? Or some static
method Cell.copyCell(Cell source, Cell dest) on the same lines of
XSSFSheet.copyrows?

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61851] Add copy cell feature

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61851

--- Comment #3 from Javen O'Neal <[hidden email]> ---
What I am trying to figure out is whether you are copying cells on the same
sheet, copying cells between sheets, or copying cells between workbooks.

The implementation effort increases significant between workbooks, so I won't
implement that if it's not needed.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61851] Add copy cell feature

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61851

Javen O'Neal <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61851] Add copy cell feature

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61851

--- Comment #4 from Luca <[hidden email]> ---
I need to copy between sheets on same workbook. Also regarding the
implementation of XSSFSheet.copyRows if it doesn't allow it yet. Thanks very
much.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61851] Add copy cell feature

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61851

Luca <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]