void TestInformationFunctions::initTestCase()
{
FunctionModuleRegistry::instance()->loadFunctionModules();
m_map = new Map(0 /* no Doc */);
m_map->addNewSheet();
Sheet* sheet = m_map->sheet(0);
sheet->setSheetName("Sheet1");
CellStorage* storage = sheet->cellStorage();
//
// Test case data set
//
// A19:A31
storage->setValue(1,19, Value( 1 ) );
storage->setValue(1,20, Value( 2 ) );
storage->setValue(1,21, Value( 4 ) );
storage->setValue(1,22, Value( 8 ) );
storage->setValue(1,23, Value( 16 ) );
storage->setValue(1,24, Value( 32 ) );
storage->setValue(1,25, Value( 64 ) );
storage->setValue(1,26, Value( 128 ) );
storage->setValue(1,27, Value( 256 ) );
storage->setValue(1,28, Value( 512 ) );
storage->setValue(1,29, Value( 1024 ) );
storage->setValue(1,30, Value( 2048 ) );
storage->setValue(1,31, Value( 4096 ) );
// B1:B2
Formula formula(sheet);
formula.setExpression("=SUM(A19:A31)");
storage->setFormula(2,1, formula);
storage->setFormula(2,2, Formula::empty());
// B3:B17
storage->setValue(2, 3, Value("7"));
storage->setValue(2, 4, Value(2));
storage->setValue(2, 5, Value(3));
storage->setValue(2, 6, Value(true));
storage->setValue(2, 7, Value("Hello"));
// B8 leave empty
storage->setValue(2, 9, Value::errorDIV0());
storage->setValue(2, 10, Value(0));
// storage->setValue(2,11, Value( 3 ) );
// storage->setValue(2,12, Value( 4 ) );
// storage->setValue(2,13, Value( "2005-0131T01:00:00" ));
// storage->setValue(2,14, Value( 1 ) );
// storage->setValue(2,15, Value( 2 ) );
// storage->setValue(2,16, Value( 3 ) );
// storage->setValue(2,17, Value( 4 ) );
//
//
// // C4:C7
storage->setValue(3, 4, Value(4));
storage->setValue(3, 5, Value(5));
// storage->setValue(3, 6, Value( 7 ) );
storage->setValue(3, 7, Value("2005-01-31"));
// C11:C17
storage->setValue(3,11, Value( 5 ) );
storage->setValue(3,12, Value( 6 ) );
storage->setValue(3,13, Value( 8 ) );
storage->setValue(3,14, Value( 4 ) );
storage->setValue(3,15, Value( 3 ) );
storage->setValue(3,16, Value( 2 ) );
storage->setValue(3,17, Value( 1 ) );
// // C19:C31
// storage->setValue(3,19, Value( 0 ) );
// storage->setValue(3,20, Value( 5 ) );
// storage->setValue(3,21, Value( 2 ) );
// storage->setValue(3,22, Value( 5 ) );
// storage->setValue(3,23, Value( 3 ) );
// storage->setValue(3,24, Value( 4 ) );
// storage->setValue(3,25, Value( 4 ) );
// storage->setValue(3,26, Value( 0 ) );
// storage->setValue(3,27, Value( 8 ) );
// storage->setValue(3,28, Value( 1 ) );
// storage->setValue(3,29, Value( 9 ) );
// storage->setValue(3,30, Value( 6 ) );
// storage->setValue(3,31, Value( 2 ) );
// // C51:C57
// storage->setValue(3,51, Value( 7 ) );
// storage->setValue(3,52, Value( 9 ) );
// storage->setValue(3,53, Value( 11 ) );
// storage->setValue(3,54, Value( 12 ) );
// storage->setValue(3,55, Value( 15 ) );
// storage->setValue(3,56, Value( 17 ) );
// storage->setValue(3,57, Value( 19 ) );
//
// // D51:D57
// storage->setValue(4,51, Value( 100 ) );
// storage->setValue(4,52, Value( 105 ) );
// storage->setValue(4,53, Value( 104 ) );
// storage->setValue(4,54, Value( 108 ) );
// storage->setValue(4,55, Value( 111 ) );
// storage->setValue(4,56, Value( 120 ) );
// storage->setValue(4,57, Value( 133 ) );
//
//
// // F51:F60
// storage->setValue(6,51, Value( 3 ) );
// storage->setValue(6,52, Value( 4 ) );
// storage->setValue(6,53, Value( 5 ) );
// storage->setValue(6,54, Value( 2 ) );
// storage->setValue(6,55, Value( 3 ) );
// storage->setValue(6,56, Value( 4 ) );
// storage->setValue(6,57, Value( 5 ) );
// storage->setValue(6,58, Value( 6 ) );
// storage->setValue(6,59, Value( 4 ) );
// storage->setValue(6,60, Value( 7 ) );
//
//
// // G51:G60
// storage->setValue(7,51, Value( 23 ) );
// storage->setValue(7,52, Value( 24 ) );
// storage->setValue(7,53, Value( 25 ) );
// storage->setValue(7,54, Value( 22 ) );
// storage->setValue(7,55, Value( 23 ) );
// storage->setValue(7,56, Value( 24 ) );
// storage->setValue(7,57, Value( 25 ) );
// storage->setValue(7,58, Value( 26 ) );
// storage->setValue(7,59, Value( 24 ) );
// storage->setValue(7,60, Value( 27 ) );
// A1000:G1000
storage->setValue(1, 1000, Value("abc"));
storage->setValue(2, 1000, Value("def"));
storage->setValue(3, 1000, Value("efoob"));
storage->setValue(4, 1000, Value("flka"));
storage->setValue(5, 1000, Value("kde"));
storage->setValue(6, 1000, Value("kde"));
storage->setValue(7, 1000, Value("xxx"));
// Z19:Z23
storage->setValue(26,19, Value( 16 ) );
storage->setValue(26,20, Value( 8 ) );
storage->setValue(26,21, Value( 4 ) );
storage->setValue(26,22, Value( 2 ) );
storage->setValue(26,23, Value( 1 ) );
// Add the second sheet
m_map->addNewSheet();
sheet = m_map->sheet(1);
sheet->setSheetName("Sheet2");
storage = sheet->cellStorage();
// B1:B2
Formula formula2(sheet);
formula2.setExpression("=SUM(Sheet1!A19:Sheet1!A31)");
storage->setFormula(2,1, formula2);
storage->setFormula(2,2, Formula::empty());
// Add the third sheet
m_map->addNewSheet();
sheet = m_map->sheet(2);
sheet->setSheetName("Sheet3");
storage = sheet->cellStorage();
// A1:A2
storage->setValue(1,1, Value( 1.1 ) );
storage->setValue(1,2, Value( 2.2 ) );
}
/*!
* \internal
*/
bool DataValidation::saveToXml(QXmlStreamWriter &writer) const
{
static QMap<DataValidation::ValidationType, QString> typeMap;
static QMap<DataValidation::ValidationOperator, QString> opMap;
static QMap<DataValidation::ErrorStyle, QString> esMap;
if (typeMap.isEmpty()) {
typeMap.insert(DataValidation::None, QStringLiteral("none"));
typeMap.insert(DataValidation::Whole, QStringLiteral("whole"));
typeMap.insert(DataValidation::Decimal, QStringLiteral("decimal"));
typeMap.insert(DataValidation::List, QStringLiteral("list"));
typeMap.insert(DataValidation::Date, QStringLiteral("date"));
typeMap.insert(DataValidation::Time, QStringLiteral("time"));
typeMap.insert(DataValidation::TextLength, QStringLiteral("textLength"));
typeMap.insert(DataValidation::Custom, QStringLiteral("custom"));
opMap.insert(DataValidation::Between, QStringLiteral("between"));
opMap.insert(DataValidation::NotBetween, QStringLiteral("notBetween"));
opMap.insert(DataValidation::Equal, QStringLiteral("equal"));
opMap.insert(DataValidation::NotEqual, QStringLiteral("notEqual"));
opMap.insert(DataValidation::LessThan, QStringLiteral("lessThan"));
opMap.insert(DataValidation::LessThanOrEqual, QStringLiteral("lessThanOrEqual"));
opMap.insert(DataValidation::GreaterThan, QStringLiteral("greaterThan"));
opMap.insert(DataValidation::GreaterThanOrEqual, QStringLiteral("greaterThanOrEqual"));
esMap.insert(DataValidation::Stop, QStringLiteral("stop"));
esMap.insert(DataValidation::Warning, QStringLiteral("warning"));
esMap.insert(DataValidation::Information, QStringLiteral("information"));
}
writer.writeStartElement(QStringLiteral("dataValidation"));
if (validationType() != DataValidation::None)
writer.writeAttribute(QStringLiteral("type"), typeMap[validationType()]);
if (errorStyle() != DataValidation::Stop)
writer.writeAttribute(QStringLiteral("errorStyle"), esMap[errorStyle()]);
if (validationOperator() != DataValidation::Between)
writer.writeAttribute(QStringLiteral("operator"), opMap[validationOperator()]);
if (allowBlank())
writer.writeAttribute(QStringLiteral("allowBlank"), QStringLiteral("1"));
// if (dropDownVisible())
// writer.writeAttribute(QStringLiteral("showDropDown"), QStringLiteral("1"));
if (isPromptMessageVisible())
writer.writeAttribute(QStringLiteral("showInputMessage"), QStringLiteral("1"));
if (isErrorMessageVisible())
writer.writeAttribute(QStringLiteral("showErrorMessage"), QStringLiteral("1"));
if (!errorMessageTitle().isEmpty())
writer.writeAttribute(QStringLiteral("errorTitle"), errorMessageTitle());
if (!errorMessage().isEmpty())
writer.writeAttribute(QStringLiteral("error"), errorMessage());
if (!promptMessageTitle().isEmpty())
writer.writeAttribute(QStringLiteral("promptTitle"), promptMessageTitle());
if (!promptMessage().isEmpty())
writer.writeAttribute(QStringLiteral("prompt"), promptMessage());
QStringList sqref;
foreach (CellRange range, ranges())
sqref.append(range.toString());
writer.writeAttribute(QStringLiteral("sqref"), sqref.join(QLatin1Char(' ')));
if (!formula1().isEmpty())
writer.writeTextElement(QStringLiteral("formula1"), formula1());
if (!formula2().isEmpty())
writer.writeTextElement(QStringLiteral("formula2"), formula2());
writer.writeEndElement(); //dataValidation
return true;
}
