jasonrogena / jasonrogena/php-excel-reader

Text from a cell is partly truncated

Open
#98 0 comments 0 reactions 0 assignees View on GitHub
auto-migrated Priority-Medium Type-Defect
Dominant language
PHP
Stars
1
Forks
0
PR merge metrics
No merged PRs in 30d

Description

```
We accept orders from our customers in Excel format. There is a Remarks column
in the order. Sometimes (very rarely) value of the remarks cell is partly
truncated.
For example, the cell contains 'KRi3899562=00113899562001=ЖД=16 F 3-3=EEE1',
but excel reader reads this cell as '13899562001=ЖД=16 F 3-3=EEE1'. As you
can see, first part of the text is truncated.

You can download sample order here: http://uaezapchasti.com/Excel/test.xls
M145 cell contains 'KRi3899562=00113899562001=ЖД=16 F 3-3=EEE1'.

Here is the script which reads and outputs the last row with truncated remarks
value: http://uaezapchasti.com/Excel/example.php
'13899562001=ЖД=16 F 3-3=EEE1' is read from the cell.

If you need any additional information - my skype is megosuyaya, email is
register at bazanov dot net.
```

Original issue reported on code.google.com by `BEZ...@gmail.com` on 12 Nov 2010 at 11:32

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the linked example.php and test.xls, then trace how the reader parses cell M145 and produces the final-row output. Confirm the reported truncation with the sample; done means the complete Remarks value, including the leading text, is returned.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
backend
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.