[Bug]: Excel Input row numbering not intuitive
- Dominant language
- Java
- Stars
- 1.5k
- Forks
- 476
- Avg merge
- 18h 32m
- Merged PRs (30d)
- 216
Description
### Apache Hop version?
2.15
### Java version?
openjdk 17.0.16+8-LTS
### Operating system
macOS
### What happened?
*Microsoft Excel Input* starts numbering *Start row* at the index (0) while spreadsheet tools show (1) as the first row number. This for example would fail, because spreadsheet row (4) would be read, when configuring "Start row" (3):
vs.
Same goes for *Start column*, even though spreadsheet tools use letters instead of numbers. Ideally one could enter Letters as "Start column" instead.
I suggest this as a bugfix to be planned for release 3.0, as it introduces a breaking change.
### Issue Priority
Priority: 3
### Issue Component
Component: Transforms
Contributor guide
Research direction
Start with the Microsoft Excel Input transform and review how its Start row and Start column settings are interpreted. Compare their behavior with spreadsheet row numbering and column letters, then verify that the proposed indexing changes are consistent and account for the stated breaking change planned for release 3.0.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- data-engineering
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 40/100