Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Decimal numbers in xlsx sheets get converted when opening in obsidian #96

Open
An77777777 opened this issue Dec 2, 2024 · 0 comments
Open
Labels
bug Something isn't working

Comments

@An77777777
Copy link

An77777777 commented Dec 2, 2024

Describe the bug

Opening an xlsx file converts numbers like this:

  • 210.6 is converted to 210.599999999999
  • 382.2 to 382.199999999999
  • 324.9 to 324.899999999999
    I've tried changing the formatting to text or number but doesn't fix it, once you close and open the file it converts them again.
    Only other plugin I'm using is annotator and disabling it doesn't fix it.

Steps to reproduce

Open excel file with decimal number

Expected behavior

To not do that

Are you using the mobile app?

No

Obsidian debug info

SYSTEM INFO:
Obsidian version: v1.7.7
Installer version: v1.7.7
Operating system: Windows 11 Home 10.0.22631
Login status: not logged in
Language: en
Insider build toggle: off
Live preview: on
Base theme: adapt to system
Community theme: none
Snippets enabled: 0
Restricted mode: off
Plugins installed: 2
Plugins enabled: 2
1: Annotator v0.2.11
2: Univer v1.1.5

RECOMMENDATIONS:
Community plugins: for bugs, please first try updating all your plugins to latest. If still not fixed, please try to make the issue happen in the Sandbox Vault or disable community plugins.

Relevant log output

No response

@An77777777 An77777777 added the bug Something isn't working label Dec 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant