Spreadsheet-Read
Spreadsheet-Read copied to clipboard
Tux
t/604_dates.t, t/605_perc.t and t/607_merged.t fail
Some tests fail if an xlsx parser is available. See https://www.cpantesters.org/cpan/report/a5996a58-54da-11f0-9e28-b50d6e8775ea for a sample fail report.
I will need to investigate:
t/630_xlsx.t ...... # Parser: Excel::ValueReader::XLSX-1.17
t/630_xlsx.t ...... ok
t/631_clr.t ....... ok
t/632_fmt.t ....... ok
t/633_misc.t ...... ok
t/634_dates.t ..... ok
t/635_perc.t ...... ok
t/637_merged.t .... ok
Linux 6.15.3-1-default [openSUSE Tumbleweed 20250626] This is perl 5, version 40, subversion 2 (v5.40.2) built for x86_64-linux-thread-multi-quadmath
A Devel::TraceUse for t/604 (xx.pl is t/604 without Test::NoWarnings`, as that eats the trace)
Modules used from xx.pl:
190. Config_heavy.pl, Config.pm line 80
191. Config_git.pl, Config_heavy.pl line 1460 [Config]
58. Spreadsheet::Read 0.93, xx.pl line 9 [main]
65. Log::Agent, Storable.pm line 49 (FAILED)
185. Spreadsheet::Gnumeric::Base 0.2, parent.pm line 17
71. Encode::ConfigLocal, Encode.pm line 70 (FAILED)
89. Text::CSV_XS 1.60, Spreadsheet/Read.pm line 119 (eval 10)
90. Spreadsheet::ParseODS 0.39, Spreadsheet/Read.pm line 119 (eval 11)
91. Archive::Zip 1.68, Spreadsheet/ParseODS.pm line 6
95. Archive::Zip::Archive 1.68, Archive/Zip.pm line 316
99. Archive::Zip::Member 1.68, Archive/Zip.pm line 317
101. Archive::Zip::FileMember 1.68, Archive/Zip.pm line 318
102. Archive::Zip::DirectoryMember 1.68, Archive/Zip.pm line 319
103. Archive::Zip::ZipFileMember 1.68, Archive/Zip.pm line 320
104. Archive::Zip::NewFileMember 1.68, Archive/Zip.pm line 321
105. Archive::Zip::StringMember 1.68, Archive/Zip.pm line 322
106. Moo 2.005005, Spreadsheet/ParseODS.pm line 7
107. Moo::_Utils, Moo.pm line 17
109. Moo::HandleMoose::_TypeMap, Moo/_Utils.pm line 284
145. Class::XSAccessor 1.19, Moo/_Utils.pm line 113
146. Class::XSAccessor::Heavy 1.19, Class/XSAccessor.pm line 6
110. Moo::sification, Moo.pm line 32
111. Moo::Object, Moo.pm line 72
140. Method::Generate::Constructor, Moo.pm line 205
141. Sub::Quote 2.006008, Method/Generate/Constructor.pm line 5
142. Sub::Defer 2.006008, Sub/Quote.pm line 11
143. XString 0.005, Sub/Quote.pm line 50
144. Method::Generate::Accessor, Moo.pm line 193
112. XML::Twig::XPath 0.02, Spreadsheet/ParseODS.pm line 8
113. XML::Twig 3.54, XML/Twig/XPath.pm line 5
116. XML::Parser 2.47, XML/Twig.pm line 148
117. XML::Parser::Expat 2.47, XML/Parser.pm line 18
119. XML::XPathEngine 0.14, XML/Twig.pm line 1291 (eval 18)
120. XML::XPathEngine::Step, XML/XPathEngine.pm line 26
121. XML::XPathEngine::Expr, XML/XPathEngine.pm line 27
122. XML::XPathEngine::Boolean, XML/XPathEngine/Expr.pm line 217
123. XML::XPathEngine::Number, XML/XPathEngine/Boolean.pm line 4
124. XML::XPathEngine::Literal, XML/XPathEngine/Number.pm line 5
125. XML::XPathEngine::Function, XML/XPathEngine.pm line 28
126. XML::XPathEngine::NodeSet, XML/XPathEngine/Function.pm line 7
127. XML::XPathEngine::LocationPath, XML/XPathEngine.pm line 29
128. XML::XPathEngine::Root, XML/XPathEngine/LocationPath.pm line 4
129. XML::XPathEngine::Variable, XML/XPathEngine.pm line 30
227. URI 5.32, XML/Twig.pm line 1291 (eval 82)
228. URI::Escape 5.32, URI.pm line 41
131. XML::Twig::Elt, base.pm line 137 (FAILED)
132. Filter::signatures 0.19, Spreadsheet/ParseODS.pm line 15
137. PerlX::Maybe 1.202, Spreadsheet/ParseODS.pm line 18
138. PerlX::Maybe::XS, PerlX/Maybe.pm line 56 (eval 21) (FAILED)
139. Spreadsheet::ParseODS::Workbook 0.39, Spreadsheet/ParseODS.pm line 21
147. Spreadsheet::ParseODS::Worksheet 0.39, Spreadsheet/ParseODS.pm line 22
148. Spreadsheet::ParseODS::Cell 0.39, Spreadsheet/ParseODS.pm line 23
149. Spreadsheet::ParseODS::Styles 0.39, Spreadsheet/ParseODS.pm line 24
150. Spreadsheet::ParseODS::Settings 0.39, Spreadsheet/ParseODS.pm line 25
151. Spreadsheet::ParseExcel 0.66, Spreadsheet/Read.pm line 119 (eval 34)
152. OLE::Storage_Lite 0.22, Spreadsheet/ParseExcel.pm line 21
155. Crypt::RC4 2.02, Spreadsheet/ParseExcel.pm line 26
156. Digest::Perl::MD5 1.9, Spreadsheet/ParseExcel.pm line 27
157. Spreadsheet::ParseExcel::Workbook 0.66, Spreadsheet/ParseExcel.pm line 31
158. Spreadsheet::ParseExcel::Worksheet 0.66, Spreadsheet/ParseExcel.pm line 32
159. Spreadsheet::ParseExcel::Font 0.66, Spreadsheet/ParseExcel.pm line 33
160. Spreadsheet::ParseExcel::Format 0.66, Spreadsheet/ParseExcel.pm line 34
161. Spreadsheet::ParseExcel::Cell 0.66, Spreadsheet/ParseExcel.pm line 35
162. Spreadsheet::ParseExcel::FmtDefault 0.66, Spreadsheet/ParseExcel.pm line 36
163. Spreadsheet::ParseExcel::Utility 0.66, Spreadsheet/ParseExcel/FmtDefault.pm line 22
164. Spreadsheet::ParseXLSX 0.36, Spreadsheet/Read.pm line 119 (eval 37)
165. Graphics::ColorUtils 0.17, Spreadsheet/ParseXLSX.pm line 12
166. Spreadsheet::ParseXLSX::Decryptor 0.36, Spreadsheet/ParseXLSX.pm line 17
167. Crypt::Mode::CBC 0.087, Spreadsheet/ParseXLSX/Decryptor.pm line 10
168. Crypt::Cipher 0.087, Crypt/Mode/CBC.pm line 9
169. CryptX 0.087, Crypt/Cipher.pm line 9
170. JSON 4.10, CryptX.pm line 14
171. JSON::XS 4.39, JSON.pm line 274 (eval 38)
173. Crypt::Mode::ECB 0.087, Spreadsheet/ParseXLSX/Decryptor.pm line 11
177. Spreadsheet::ParseXLSX::Decryptor::Standard 0.36, Spreadsheet/ParseXLSX/Decryptor.pm line 18
178. Spreadsheet::ParseXLSX::Decryptor::Agile 0.36, Spreadsheet/ParseXLSX/Decryptor.pm line 19
179. Spreadsheet::ParseXLSX::Worksheet 0.36, Spreadsheet/ParseXLSX.pm line 18
180. Spreadsheet::ParseXLSX::Cell 0.36, Spreadsheet/ParseXLSX.pm line 19
181. Spreadsheet::ReadGnumeric 0.4, Spreadsheet/Read.pm line 119 (eval 42)
182. XML::Parser::Lite 0.722, Spreadsheet/ReadGnumeric.pm line 18
184. Spreadsheet::Gnumeric::StyleRegion 0.2, Spreadsheet/ReadGnumeric.pm line 19
186. Z30::Just::For::Testing, Spreadsheet/Read.pm line 119 (eval 46) (FAILED)
187. IO::Scalar 2.113, Spreadsheet/Read.pm line 119 (eval 47)
188. IO::WrapTie 2.113, IO/Scalar.pm line 19
189. Data::Peek 0.53, Spreadsheet/Read.pm line 119 (eval 58)
192. Perl::Tidy 20250616, Data/Peek.pm line 24
195. Perl::Tidy::Debugger 20250616, Perl/Tidy.pm line 69
196. Perl::Tidy::Diagnostics 20250616, Perl/Tidy.pm line 70
197. Perl::Tidy::FileWriter 20250616, Perl/Tidy.pm line 71
198. Perl::Tidy::Formatter 20250616, Perl/Tidy.pm line 72
199. Perl::Tidy::HtmlWriter 20250616, Perl/Tidy.pm line 73
200. HTML::Entities 3.83, Perl/Tidy/HtmlWriter.pm line 50
201. HTML::Parser 3.83, HTML/Entities.pm line 151
217. Perl::Tidy::IOScalar 20250616, Perl/Tidy.pm line 74
218. Perl::Tidy::IOScalarArray 20250616, Perl/Tidy.pm line 75
219. Perl::Tidy::IndentationItem 20250616, Perl/Tidy.pm line 76
220. Perl::Tidy::Logger 20250616, Perl/Tidy.pm line 77
221. Perl::Tidy::Tokenizer 20250616, Perl/Tidy.pm line 78
222. Perl::Tidy::VerticalAligner 20250616, Perl/Tidy.pm line 79
223. Perl::Tidy::VerticalAligner::Alignment 20250616, Perl/Tidy/VerticalAligner.pm line 11
224. Perl::Tidy::VerticalAligner::Line 20250616, Perl/Tidy/VerticalAligner.pm line 12
Modules used, but not reported:
Z10/Just/For/Testing.pm
Z20/Just/For/Testing.pm
Possible proxies:
8 Spreadsheet/Read.pm line 119, sub Devel::TraceUse::__ANON__[/pro/lib/perl5/site_perl/5.40.2/Devel/TraceUse.pm:22]
3 Test2/API/Context.pm line 20, sub Devel::TraceUse::__ANON__[/pro/lib/perl5/site_perl/5.40.2/Devel/TraceUse.pm:22]
2 parent.pm line 17, sub parent::import
2 XML/Twig.pm line 1291, sub XML::Twig::_use
As I have everything installed, it finds all of it to enable making decisions. Maybe one of those causes a conflict
My smoker proceeded installing more modules, and now I cannot reproduce it anymore. However it again fails if explicitly hiding some modules:
/opt/perl-5.42.0-RC2/bin/perl -MDevel::Hide=Spreadsheet::ParseXLSX,Spreadsheet::XLSX -Mblib t/604_dates.t
Do 757339f32cd61816cdd138bc541ae7a7ead0ec9a + 2a8d2f571822431635c67ddf011fa95d1b6ad419 + bb12b980342cfa269bf0a98d84492f8df7402d6d fix that for you?
I tried 757339f32cd61816cdd138bc541ae7a7ead0ec9a with the oneliner above and it is skipping a lot because of Excel::ValueReader::XLSX 1.17, and finally was successful.