apache / apache/hop

[Bug]: Excel Input row numbering not intuitive

Open
#5,915 1 comment 0 reactions 0 assignees View on GitHub
awaiting triage P3 Transforms
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):

Image


vs.


Image

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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.