This is strange as I also could not find the issue. I am using latest version (you may print the version number at the start too) of Aspose.Cells for Java API on Windows8, JDK1.8 in IntelliJIdea, see the screenshot on my end. sc_shot1_enviroment_Windows8_JDK1.8_IntelliJIdea.png (35.8 KB)
@konradglayer,
We have observed this issue in Mac OS X and Linux whereas this issue is not there in Windows OS. This issue is logged in database for further investigation. You will be notified here once any update is ready for sharing.
This issue is logged as: CELLSJAVA-43547 - AutoFitRow changes worksheet standard height
@konradglayer,
Please install or copy “Arial” to Mac os and linux system, then set the font with FontConfigs.SetFontFolders() or FontConfigs.SetFontFolder() methods.
Thanks, that corrected the behavior. But still the question remains - should the standardHeight (=hight of all rows without their height set individually) be modified when I only want to resize one row via autoFitRow?
Also - it seems that without that font configuration Aspose Cells modifies Workbooks in unexpected ways - are there any other steps required to make Aspose Cells work as expected?
Your concerns make sense. We have already fixed this issue. So, when you auto-fit one row only, the default row height will not be changed. We will provide you the fixed version in the next few days.
You need to install the font(s) and specify the font configurations via code at the start of your program. See the document for your reference.
In the meantime we were wondering - is there a way to provide another font as an alternative for Arial? (for licensing reasons). We considered some open source font like Liberation Sans which is metric-compatible with Arial, configured it via FontConfigs.setFontSubstitutes for Arial, or configured it as default via setDefaultFontName, but it did not fix the problem with rows height - rest of rows were still changed to 11.25 as if Arial was missing.
We will evaluate it but let the new fix comes out for testing. Hopefully, we will provide the fix in the next few days. By the way, could you try some true type font (.ttf) as substitutions if that makes any difference?
Yeah, it’s exactly what I did and tried to explain - tried using Liberation Sans ttf font (attached in a zip). It’s supposed to be metric-compatible with Arial. I used setFontSubstitutes with it but it didn’t help, so wanted to ask if it should and if so then why not…
The issues you have found earlier (filed as CELLSJAVA-43547) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi