search

masaccio / numbers-parser

Python module for parsing Apple Numbers .numbers files
MIT License
201 stars 14 forks source link

Text after a break line in the same cell cannot be extracted #4

Closed traceymeng closed 2 years ago

traceymeng commented 2 years ago

Steps to reproduce.

  1. Create a new Numbers file.
  2. Type "part 1" in a cell. Tap Option+Return (in MacBook) to create a new line in the same cell. Type a phrase such as "part 2" in the newly created line of the same cell.
  3. Save the Numbers file and close the file.
  4. Use numbers-parser to read the content of this cell. The word of "part 2" which is after the new line won't be recognized. Only the texts before the new line ("part 1") are picked up
  5. Note, if there are more new lines in the same cell, the value of the cell becomes None, i.e., "part 1" cannot be extracted.

Or unzip and open the attached parts.numbers.zip file parts.numbers.zip .

masaccio commented 2 years ago

Which method(s) are you using to return the data? It looks OK to me:

% cat-numbers -b /Users/jon/Downloads/parts.numbers 
,,,,,,
,Part 1 

Part 2
,,,,,
,,,,,,

This was with version 2.1.1 of numbers-parser and I used table.cell(row, col) to get the data

masaccio commented 2 years ago

@traceymeng I've added https://github.com/masaccio/numbers-parser/blob/master/tests/test_issues.py as a test so let me know if this is what you're doing.

I'll close the issue as done in a couple of weeks if there's no more activity.

Thanks for raising.

traceymeng commented 2 years ago

Thanks, Jon.

I did not get time to test it. I'll let you know if I still have issues.

Best Regards,

Tracey

On Fri, Dec 17, 2021 at 12:50 AM Jon Connell @.***> wrote:

@traceymeng https://github.com/traceymeng I've added https://github.com/masaccio/numbers-parser/blob/master/tests/test_issues.py as a test so let me know if this is what you're doing.

I'll close the issue as done in a couple of weeks if there's no more activity.

Thanks for raising.

— Reply to this email directly, view it on GitHub https://github.com/masaccio/numbers-parser/issues/4#issuecomment-996541153, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFMGNICQPLSUKYSFIW4JUHTURL2TRANCNFSM5J7L5WLQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you were mentioned.Message ID: @.***>