OpenOffice.org (and its successor, LibreOffice) aims to be compatible with Microsoft Office formats, but there might be occasional differences in behavior. Here are a few suggestions from https://calculadoradeiva.mx/:
Check OpenOffice.org Version: Ensure that you are using the latest version of OpenOffice.org. Bugs and compatibility issues are often addressed in newer releases. Alternative Formulas: If the wildcard issue persists, you might try alternative formulas or functions in OpenOffice.org that achieve a similar result. For example, you could use regular expressions in combination with other functions. Documentation and Support: Check the official documentation and user forums for OpenOffice.org. There might be specific information about handling wildcard characters or workarounds suggested by the community. Consider LibreOffice: LibreOffice is a fork of OpenOffice.org and may have different or improved features. If the issue persists, you might want to try LibreOffice to see if it behaves differently. Report the Issue: If the problem is a bug in OpenOffice.org, consider reporting it to the developers. They may be able to address it in future releases. Look for a bug tracker or support forum on the OpenOffice.org website. Remember that while both OpenOffice.org and Microsoft Excel aim for compatibility, there may be differences in how certain features are implemented. In some cases, adjustments to formulas or functions may be necessary when transitioning between the two. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/183700 Title: Cannot calculate wildcards in MS excel sheets Status in OpenOffice: In Progress Status in libreoffice package in Ubuntu: Invalid Status in openoffice.org package in Ubuntu: Won't Fix Bug description: Binary package hint: openoffice.org When opening an MS excel sheet with wildcards used in an IF statement the Microsoft version recognises it and uses it in the calculation, but OpenOffice.org doesn't, with the result the value been set to 0. Here's an example: In row 2 we've got a number of cells with codes in it, let's say B2...L2. In an other cell there's the formula =(COUNTIF(B2:L2;"A")). When OpenOffice sees the V in a cell in the list, the cell is counted as it should be. But when the formula is modified with wildcards in it: =(COUNTIF(B2:L2;"*A*")) the V will not be recognised in the cell, and MS Office sees every V listed in it, also when the cell contains information like AW, the A will be regognised in a cell with the formula =(COUNTIF(B2:L2;"*A*")) and the W will be regognised in an other cell with =(COUNTIF(B2:L2;"*W*")) in it. This is very important that when a cell is marked with both characters that they should be extracted to both formulas, so the ASAP jobs (A) and the Waiting for new parts (W) will be calculated. This bug also includes the =(COUNTIF(B2:L2;"?A?")) question mark method when a cell always contains 3 characters and the middle character is being recognised as an A. This will also result in miscalculation. BTW as far as i'm well informed, the wildcards and question signs are undocumented features of MS Office. An example sheet is listed here: http://www.snertwerk.com/members/laurens/tmp/spreadsheet.ods To get OpenOffice more compatible with importing MS Office documents these options should be implemented. To manage notifications about this bug go to: https://bugs.launchpad.net/openoffice/+bug/183700/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
