64kramsystem / spreadbase Goto Github PK
View Code? Open in Web Editor NEWRuby library for accessing (R/W) OpenOffice/LibreOffice spreadsheets (ods)... because Excel IS a database 😂
License: GNU General Public License v3.0
spreadbase's Issues
`[FATAL] failed to allocate memory` error is raised when a document has a large number of trailing empty rows
Hi @saveriomiroddi ,
I tried to load a existing ODS file by using your gem but I got [FATAL] failed to allocate memory error.
I attached ODS file which I use and ruby program for reproducing.
Invoke the attached program then you will see the same error like below.
My environment:
- ruby 3.0.0p0 (2020-12-25 revision 95aff21468) [x86_64-linux]
- spreadbase v0.2.0
Cannot get any lines except for the first line from a cell having multi lines
Hi @64kramsystem ,
Cannot get any lines except for the first line from a cell having multi lines.
How to reproduce:
require 'spreadbase'
doc = SpreadBase::Document.new('test.ods')
table = doc.tables[0].data
p table[4][4]You can execute the above code then you will get the result below.
For this case, I expect the table[4][4] to be "hoge\nhoge" but the actual value is "hoge".
`rubyzip` dependency is too loose
See:
WARNING: open-ended dependency on rubyzip (>= 1.3.0) is not recommended
if rubyzip is semantically versioned, use:
add_runtime_dependency 'rubyzip', '~> 1.3', '>= 1.3.0'
Update README Ruby version reference
The README Ruby reference is obsolete, and must be updated:
The gem has been tested on Ruby 1.9.3-p125, on Linux and Mac OS X.
How do I create a column like this?
Hi, I use your library to create an ods file, but I don't know how do I create this column with one cell like this:
+-----+------+
|a|
+-----+-------+
|a1 |a2 |
+-----+-------+
Thanks in advance!
Regards,Herman
Fix build
Builds are failing, due to timezone issues, which don't happen locally.
Sample:
3) SpreadBase::Table return the data as string (:to_s)
Failure/Error: @sample_table.to_s.should == expected_string
expected: "+------------+---------------------------+---------------------------+\n| 1 | 1.1 | 1.33 |\n| 2012-04-10 | 2012-04-11 23:33:42 +0000 | 2012-04-11 23:33:42 +0200 |\n| true | a | NIL |\n+------------+---------------------------+---------------------------+\n"
got: "+------------+---------------------------+---------------------------+\n| 1 | 1.1 | 1.33 |\n| 2012-04-10 | 2012-04-11 23:33:42 +0000 | 2012-04-11 23:33:42 +0000 |\n| true | a | NIL |\n+------------+---------------------------+---------------------------+\n" (using ==)
Diff:
@@ -1,6 +1,6 @@
+------------+---------------------------+---------------------------+
| 1 | 1.1 | 1.33 |
-| 2012-04-10 | 2012-04-11 23:33:42 +0000 | 2012-04-11 23:33:42 +0200 |
+| 2012-04-10 | 2012-04-11 23:33:42 +0000 | 2012-04-11 23:33:42 +0000 |
| true | a | NIL |
+------------+---------------------------+---------------------------+
# ./spec/elements/table_spec.rb:326:in `block (2 levels) in <top (required)>'
Deprecated warnings
I've been getting these warnings lately on every instance creation. I guess we could remove the entire constant out of the module.
/home/matt/.rbenv/versions/2.6.1/lib/ruby/gems/2.6.0/gems/spreadbase-0.1.3/lib/spreadbase/helpers/helpers.rb:34: warning: constant ::Fixnum is deprecated
/home/matt/.rbenv/versions/2.6.1/lib/ruby/gems/2.6.0/gems/spreadbase-0.1.3/lib/spreadbase/codecs/open_document_12_modules/encoding.rb:178: warning: constant ::Fixnum is deprecated
Secondary updates (gems/styles)
- remove hash rockets
- upgrade all the gems
- fix rspec deprecation
- fix rspec problems related to latest version
Remove Ruby 1.8 support
Support for Ruby 1.8 adds some cruft; remove it.
Add bigdecimal into gemspec
Hi @64kramsystem ,
I got the warning below when using the spreadbase gem with Ruby 3.3.
/opt/rbenv/versions/3.3.0/lib/ruby/gems/3.3.0/gems/spreadbase-0.4.0/lib/spreadbase/codecs/open_document_12_modules/encoding.rb:3: warning: bigdecimal was loaded from the standard library, but will no longer be part of the default gems since Ruby 3.4.0. Add bigdecimal to your Gemfile or gemspec. Also contact author of spreadbase-0.4.0 to add bigdecimal into its gemspec.
To fix this warning, we need to add the bigdecimal gem to the gemspec. However there is version confliction between spreadbase gem and bigdecimal gem.
- spreadbase: ruby 2.4
Line 11 in 02b760a
- bigdecimal: ruby 2.5
Add rexml to gemspec
rexml has already been a bundled gem from Ruby 3.0.
https://stdgems.org/rexml/#as-bundled-gem
Therefore we should add rexml to gemspec.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.